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_3DC8_294.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

    # JSON data can also be passed as a path to a .json file
    
    oint sqlite CreateTable \
     --table "test1" \
     --cols "{'id':'INTEGER PRIMARY KEY','[An obscure column]':'TEXT'}" \
     --db "/tmp/1q3umrdj.x1r.sqlite"

CMD/Bat

    :: JSON data can also be passed as a path to a .json file
    
    oint sqlite CreateTable ^
     --table "test1" ^
     --cols "{'id':'INTEGER PRIMARY KEY','[An obscure column]':'TEXT'}" ^
     --db "/tmp/1q3umrdj.x1r.sqlite"

Result

{
 "result": true
}