Zymonic Toolkit Data
This page contains all of the options for:
sudo zymonic_toolkit.pl Data
Check Database for Valid Characters
Checks tables and fields for invalid characters - if no table or field are specified the command will process the whole DB or table.
sudo zymonic_toolkit.pl Data check_db_for_valid_characters
-
Table ZName
The ZName of the table.
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --table ZNAME
-
Field ZName
The ZName of the field.
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --field ZNAME
-
System
The system to be inspected. This is required for the command to work.
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --system SYSTEM
-
End Page
Last page to process (50 records per page)
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --end_page PAGE
-
Start Page
First page to process (50 records per page)
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --start_page PAGE
Clean Database
Removes autocreated records, deleted records and handles orphan records from tables in system.
sudo zymonic_toolkit.pl Data db_clean
-
System
The system to be inspected. This is required for the command to work.
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --system SYSTEM
-
Table ZNames
Comma separated list of ZNames of the tables, or all tables in DB if left empty
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --tables ZNAME1,ZNAME2,ZNAME3
-
Username
The name of the user with which to get auth for sql database changes
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --user USERNAME
-
Orphan Record Action
Action to take on orphan records: i (ignore), d (delete), m (mark as deleted or n (create new parent)
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --orphan_record_action ARGUMENT
-
Remove Autocreated Records
Whether to remove autocreated records: y/n
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --remove_autocreated ARGUMENT
-
Remove Deleted Records
Whether to remove deleted records: y/n
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --remove_deleted ARGUMENT
Help
When using a terminal to run zymonic_toolkit.pl the user will see prompts that contain the same information that is found within this manual.
sudo zymonic_toolkit.pl Installer help
-
Command
The specific command to show help for. If not set then shows help for all commands.
sudo zymonic_toolkit.pl Installer help --command COMMAND