You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
49 lines
2.3 KiB
49 lines
2.3 KiB
-- |
|
-- Comment Meta Language Constructs: |
|
-- |
|
-- #IfNotTable |
|
-- argument: table_name |
|
-- behavior: if the table_name does not exist, the block will be executed |
|
|
|
-- #IfTable |
|
-- argument: table_name |
|
-- behavior: if the table_name does exist, the block will be executed |
|
|
|
-- #IfMissingColumn |
|
-- arguments: table_name colname |
|
-- behavior: if the colname in the table_name table does not exist, the block will be executed |
|
|
|
-- #IfNotColumnType |
|
-- arguments: table_name colname value |
|
-- behavior: If the table table_name does not have a column colname with a data type equal to value, then the block will be executed |
|
|
|
-- #IfNotRow |
|
-- arguments: table_name colname value |
|
-- behavior: If the table table_name does not have a row where colname = value, the block will be executed. |
|
|
|
-- #IfNotRow2D |
|
-- arguments: table_name colname value colname2 value2 |
|
-- behavior: If the table table_name does not have a row where colname = value AND colname2 = value2, the block will be executed. |
|
|
|
-- #IfNotRow3D |
|
-- arguments: table_name colname value colname2 value2 colname3 value3 |
|
-- behavior: If the table table_name does not have a row where colname = value AND colname2 = value2 AND colname3 = value3, the block will be executed. |
|
|
|
-- #IfNotRow4D |
|
-- arguments: table_name colname value colname2 value2 colname3 value3 colname4 value4 |
|
-- behavior: If the table table_name does not have a row where colname = value AND colname2 = value2 AND colname3 = value3 AND colname4 = value4, the block will be executed. |
|
|
|
-- #IfNotRow2Dx2 |
|
-- desc: This is a very specialized function to allow adding items to the list_options table to avoid both redundant option_id and title in each element. |
|
-- arguments: table_name colname value colname2 value2 colname3 value3 |
|
-- behavior: The block will be executed if both statements below are true: |
|
-- 1) The table table_name does not have a row where colname = value AND colname2 = value2. |
|
-- 2) The table table_name does not have a row where colname = value AND colname3 = value3. |
|
|
|
-- #IfNotIndex |
|
-- desc: This function will allow adding of indexes/keys. |
|
-- arguments: table_name colname |
|
-- behavior: If the index does not exist, it will be created |
|
|
|
-- #EndIf |
|
-- all blocks are terminated with and #EndIf statement.
|
|
|