Zymonic Toolkit Data

This page contains all of the options for: sudo zymonic_toolkit.pl Data

See the manual page for the data toolkit for further details.

=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, or all tables if left empty. sudo zymonic_toolkit.pl Data check_db_for_valid_characters --table ZNAME 



Field ZName
The ZName of the field, or all fields present on each table if left empty. sudo zymonic_toolkit.pl Data check_db_for_valid_characters --field ZNAME 



System
The system to be inspected. This parameter 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 parameter 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 '*' for all tables. This parameter is required for the command to work. sudo zymonic_toolkit.pl Data check_db_for_valid_characters --tables ZNAME1,ZNAME2,ZNAME3 </li>



Username
The name of the user with which to get auth for sql database changes. This parameter is required for the command to work. sudo zymonic_toolkit.pl Data check_db_for_valid_characters --user USERNAME </li>



Password
The password of the user with which to get auth for sql database changes. Use '!' to capture from standard input instead without displaying the password in the shell. This parameter is required for the command to work. sudo zymonic_toolkit.pl Data check_db_for_valid_characters --password PASSWORD </li>



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 </li>



Remove Autocreated Records
Whether to remove autocreated records: y/n sudo zymonic_toolkit.pl Data check_db_for_valid_characters --remove_autocreated ARGUMENT </li>



Remove Deleted Records
Whether to remove deleted records: y/n sudo zymonic_toolkit.pl Data check_db_for_valid_characters --remove_deleted ARGUMENT </li> </ul>

=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 Data help

 

Command
The specific command to show help for. If not set then shows help for all commands. sudo zymonic_toolkit.pl Data help --command COMMAND </li> </ul>