Skip to main content

Add rows

Adds new rows to the table

Function AddRecords(Val Table, Val DataArray, Val Transaction = True, Val Connection = "") Export

ParameterCLI optionTypeRequiredDescription
Table--tableStringTable name
DataArray--rowsArray of StructureAn array of string data structures: Key > field, Value > field value
Transaction--trnBooleanTrue > adding records to transactions with rollback on error
Connection--dbString, ArbitraryExisting connection or database path

Returns: Map Of KeyAndValue - Result of query execution


tip

Binary data can also be transferred as a structure {'blob':File path}


1C:Enterprise/OneScript code example
    Image = "https://hut.openintegrations.dev/test_data/picture.jpg";
OPI_TypeConversion.GetBinaryData(Image); // Image - Type: BinaryData

PictureFile = GetTempFileName("png");
Image.Write(PictureFile); // PictureFile - File to disk

Base = "C:\Users\bayse\AppData\Local\Temp\v8_BA4A_324.sqlite";
Table = "test";

DataArray = New Array;

RowStructure2 = New Structure;
RowStructure2.Insert("name" , "Vitaly"); // TEXT
RowStructure2.Insert("age" , 25); // INTEGER
RowStructure2.Insert("salary" , 1000.12); // REAL
RowStructure2.Insert("is_active" , True); // BOOL
RowStructure2.Insert("created_at", OPI_Tools.GetCurrentDate()); // DATETIME
RowStructure2.Insert("data" , New Structure("blob", Image)); // BLOB

RowStrucutre1 = New Structure;
RowStrucutre1.Insert("name" , "Lesha"); // TEXT
RowStrucutre1.Insert("age" , 20); // INTEGER
RowStrucutre1.Insert("salary" , 200.20); // REAL
RowStrucutre1.Insert("is_active" , False); // BOOL
RowStrucutre1.Insert("created_at", OPI_Tools.GetCurrentDate()); // DATETIME
RowStrucutre1.Insert("data" , New Structure("blob", PictureFile)); // BLOB

DataArray.Add(RowStructure2);
DataArray.Add(RowStrucutre1);

Result = OPI_SQLite.AddRecords(Table, DataArray, , Base);
    oint sqlite AddRecords \
--table "test1" \
--rows "{'[An obscure column]':'yo'}" \
--db "/tmp/pvrrdds2.dxl.sqlite"
Result
{
"commit": {
"result": true
},
"result": true,
"rows": 2,
"errors": []
}