Zymonic Toolkit Data: Difference between revisions
(Added data) |
No edit summary |
||
Line 14: | Line 14: | ||
<li> |
<li> |
||
==Table ZName== |
==Table ZName== |
||
The ZName of the table. |
The ZName of the table, or all tables if left empty. |
||
<pre> |
<pre> |
||
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --table ZNAME |
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --table ZNAME |
||
Line 22: | Line 22: | ||
<li> |
<li> |
||
==Field ZName== |
==Field ZName== |
||
The ZName of the field. |
The ZName of the field, or all fields present on each table if left empty. |
||
<pre> |
<pre> |
||
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --field ZNAME |
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --field ZNAME |
||
Line 30: | Line 30: | ||
<li> |
<li> |
||
==System== |
==System== |
||
The system to be inspected. This is required for the command to work. |
The system to be inspected. This parameter is required for the command to work. |
||
<pre> |
<pre> |
||
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --system SYSTEM |
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --system SYSTEM |
||
Line 38: | Line 38: | ||
<li> |
<li> |
||
==End Page== |
==End Page== |
||
Last page to process (50 records per page) |
Last page to process (50 records per page). |
||
<pre> |
<pre> |
||
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --end_page PAGE |
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --end_page PAGE |
||
Line 46: | Line 46: | ||
<li> |
<li> |
||
==Start Page== |
==Start Page== |
||
First page to process (50 records per page) |
First page to process (50 records per page). |
||
<pre> |
<pre> |
||
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --start_page PAGE |
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --start_page PAGE |
||
Line 63: | Line 63: | ||
<li> |
<li> |
||
==System== |
==System== |
||
The system to be inspected. This is required for the command to work. |
The system to be inspected. This parameter is required for the command to work. |
||
<pre> |
<pre> |
||
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --system SYSTEM |
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --system SYSTEM |
||
Line 71: | Line 71: | ||
<li> |
<li> |
||
==Table ZNames== |
==Table ZNames== |
||
Comma separated list of ZNames of the tables, or all tables |
Comma separated list of ZNames of the tables, or '*' for all tables. This parameter is required for the command to work. |
||
<pre> |
<pre> |
||
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --tables ZNAME1,ZNAME2,ZNAME3 |
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --tables ZNAME1,ZNAME2,ZNAME3 |
||
Line 79: | Line 79: | ||
<li> |
<li> |
||
==Username== |
==Username== |
||
The name of the user with which to get auth for sql database changes |
The name of the user with which to get auth for sql database changes. This parameter is required for the command to work. |
||
<pre> |
<pre> |
||
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --user USERNAME |
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --user USERNAME |
||
</pre> |
|||
</li> |
|||
<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. |
|||
<pre> |
|||
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --password PASSWORD |
|||
</pre> |
</pre> |
||
</li> |
</li> |
||
Line 87: | Line 95: | ||
<li> |
<li> |
||
==Orphan Record Action== |
==Orphan Record Action== |
||
Action to take on orphan records: i (ignore), d (delete), m (mark as deleted or n (create new parent) |
Action to take on orphan records: i (ignore), d (delete), m (mark as deleted) or n (create new parent). |
||
<pre> |
<pre> |
||
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --orphan_record_action ARGUMENT |
sudo zymonic_toolkit.pl Data check_db_for_valid_characters --orphan_record_action ARGUMENT |
||
Line 114: | Line 122: | ||
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. |
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. |
||
<pre> |
<pre> |
||
sudo zymonic_toolkit.pl |
sudo zymonic_toolkit.pl Data help |
||
</pre> |
</pre> |
||
Line 122: | Line 130: | ||
The specific command to show help for. If not set then shows help for all commands. |
The specific command to show help for. If not set then shows help for all commands. |
||
<pre> |
<pre> |
||
sudo zymonic_toolkit.pl |
sudo zymonic_toolkit.pl Data help --command COMMAND |
||
</pre> |
</pre> |
||
</li> |
</li> |
Revision as of 10:40, 3 January 2019
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, 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
-
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
-
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
-
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 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