Create table
Creates an empty table in the database
Function CreateTable(Val Table, Val ColoumnsStruct, Val Connection = "") Export
Parameter | CLI option | Type | Required | Description |
---|---|---|---|---|
Table | --table | String | ✔ | Table name |
ColoumnsStruct | --cols | Structure Of KeyAndValue | ✔ | Column structure: Key > Name, Value > Data type |
Connection | --db | String, Arbitrary | ✖ | Existing connection or database path |
Returns: Map Of KeyAndValue - Result of query execution
1C:Enterprise/OneScript code example
Base = "C:\Users\bayse\AppData\Local\Temp\v8_BA4A_324.sqlite";
Table = "test";
ColoumnsStruct = New Structure;
ColoumnsStruct.Insert("id" , "INTEGER PRIMARY KEY");
ColoumnsStruct.Insert("name" , "TEXT");
ColoumnsStruct.Insert("age" , "INTEGER");
ColoumnsStruct.Insert("salary" , "REAL");
ColoumnsStruct.Insert("is_active" , "BOOLEAN");
ColoumnsStruct.Insert("created_at", "DATETIME");
ColoumnsStruct.Insert("data" , "BLOB");
Result = OPI_SQLite.CreateTable(Table, ColoumnsStruct, Base);
- Bash
- CMD/Bat
oint sqlite CreateTable \
--table "test1" \
--cols "{'id':'INTEGER PRIMARY KEY','[An obscure column]':'TEXT'}" \
--db "/tmp/pvrrdds2.dxl.sqlite"
oint sqlite CreateTable ^
--table "test1" ^
--cols "{'id':'INTEGER PRIMARY KEY','[An obscure column]':'TEXT'}" ^
--db "/tmp/pvrrdds2.dxl.sqlite"
Result
{
"result": true
}