Create table

Creates an empty table in the database

Parameters

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

Advanced call ?

Parameter	Description
addin_mode	Manual selection of external component connection mode (for 1C): Isolated, NotIsolated
dontwait	Creates a background job and returns its data (for 1C and OneScript only)

1C:Enterprise/OneScript code example

    Base  = "/tmp/vnnmoosn.qqb.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/v3fibjxn.cs0.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/v3fibjxn.cs0.sqlite"

Result

{
 "result": true
}