SYSTEM DOCUMENTS
DATABASE QUERIES
CREATE DATABASE
CREATE-BASE->BASE_NAME
The "BASE_NAME" parameter specifies the name of the database to be created
DELETE DATABASE
DEL-BASE->BASE_NAME
The "BASE_NAME" parameter specifies the name of the database to be deleted
BACKUP DATABASE
BACKUP-BASE->[BASE_NAME]
The "BASE_NAME" parameter specifies the name of the database to be backup
LOAD BACKUP
LOAD-BASE->[BASE_NAME]
The 'BASE_NAME' parameter specifies the name of the database to be restored.
TABLE QUERIES
CREATE TABLE
CREATE-TABLE->
[
BASE-NAME->BASE_NAME
TABLE-NAME->TABLE_NAME
CREATE-DATASTR->DATASTR_NAME
CREATE-DATASTR->DATASTR_NAME
]
"BASE_NAME" specifies which database the table will be created in
"TABLE_NAME" specifies the name of the table
"CREATE-DATASTR->" is optional (can be repeated or omitted). This creates a datastr named "DATASTR_NAME"
DELETE TABLE
DEL-TABLE->[BASE_NAME,TABLE_NAME]
"BASE_NAME" specifies which database the table belongs to
"TABLE_NAME" specifies the name of the table to be deleted
DATASTR QUERIES
CREATE DATASTR
CREATE-DATASTR->[BASE_NAME,TABLE_NAME,DATASTR_NAME,DATA_TYPE]
"BASE_NAME" specifies which database the datastr will belong to
"TABLE_NAME" specifies which table the datastr will be in
"DATASTR_NAME" specifies the name of the datastr
"DATA_TYPE" specifies the data type that the datastr will hold
DELETE DATASTR
DEL-DATASTR->[BASE_NAME,TABLE_NAME,DATASTR_NAME]
"BASE_NAME" specifies the database the datastr belongs to
"TABLE_NAME" specifies the table the datastr belongs to
"DATASTR_NAME" specifies the name of the datastr to be deleted
DATA MANAGEMENT QUERIES
INSERT DATA
INSERT-DATA->[BASE_NAME,TABLE_NAME,DATASTR_NAME,DATA]
"BASE_NAME" specifies the database where the data will be inserted
"TABLE_NAME" specifies the table where the data will be inserted
"DATASTR_NAME" specifies the datastr where the data will be inserted
"DATA" specifies the data to be inserted
DELETE DATA
DEL-DATA->[BASE_NAME,TABLE_NAME,DATASTR_NAME,DATA_SECTION_METHODS]
"BASE_NAME" specifies the database the data belongs to
"TABLE_NAME" specifies the table the data belongs to
"DATASTR_NAME" specifies the datastr the data belongs to
"DATA_SECTION_METHODS" specifies the method used to delete the data
SELECT DATA
SELECT-DATA->[BASE_NAME,TABLE_NAME,DATASTR_NAME,DATA_SECTION_METHODS]
"BASE_NAME" specifies the database the data belongs to
"TABLE_NAME" specifies the table the data belongs to
"DATASTR_NAME" specifies the datastr the data belongs to
"DATA_SECTION_METHODS" specifies the method used to select the data
DATA TYPE AND USAGE
DATA TYPES
For BOOL type use "10*"
For INT type use "I*"
For CHAR type use "'*"
For STRING type use "~*"
The example below inserts 12 (INT) into a datastr named TEST_DATASTR
INSERT-DATA->[TEST_BASE,TEST_TABLE,TEST_DATASTR,*I12]
Data type indicators (10*, I*, '*, ~*) are only used in insert queries. They are not needed in other types of queries.
DATA READING METHODS AND USAGE
READING METHODS
Reading by INDEX number "INDEX#INDEX_VALUE
Reading by first match "FIRST-MATCH#DATA"
Reading by all matches "MATCH#DATA"
The example below deletes all values in TEST_DATASTR that match the string "hello system"
DEL-DATA->[TEST_BASE,TEST_TABLE,TEST_DATASTR,MATCH#hello system]
The example below selects the first value matching "true" (bool) in TEST_DATASTR
SELECT-DATA->[TEST_BASE,TEST_TABLE,TEST_DATASTR,FIRST-MATCH#true]
The example below deletes the first value (INDEX 0) in TEST_DATASTR
DEL-DATA->[TEST_BASE,TEST_TABLE,TEST_DATASTR,INDEX#0]
Data type indicators (10*, I*, '*, ~*) are only used in insert queries. They are not needed in other types of queries.