Get records

Gets records from the selected table

Function GetRecords(Val Table, Val Fields = "*", Val Filters = "", Val Sort = "", Val Count = "", Val Connection = "") Export

Parameter	CLI option	Type	Required	Description
Table	--table	String	✔	Table name
Fields	--fields	Array Of String	✖	Fields for selection
Filters	--filter	Array of Structure	✖	Filters array. See GetRecordsFilterStrucutre
Sort	--order	Structure Of KeyAndValue	✖	Sorting: Key > field name, Value > direction (ASC, DESC)
Count	--limit	Number	✖	Limiting the number of received strings
Connection	--db	String, Arbitrary	✖	Existing connection or database path

Returns: Structure Of KeyAndValue, String - Result of query execution

tip

Values of the Binary data type (BLOB) are returned as {'blob':Base64 string}

1C:Enterprise/OneScript code example

    Base  = "C:\Users\Administrator\AppData\Local\Temp\v8_E607_1d.sqlite";
    Table = "test";

    Fields = New Array;
    Fields.Add("name");
    Fields.Add("salary");

    Filters = New Array;

    FilterStructure1 = New Structure;

    FilterStructure1.Insert("field", "name");
    FilterStructure1.Insert("type" , "=");
    FilterStructure1.Insert("value", "Vitaly");
    FilterStructure1.Insert("union", "AND");
    FilterStructure1.Insert("raw"  , False);

    FilterStructure2 = New Structure;

    FilterStructure2.Insert("field", "age");
    FilterStructure2.Insert("type" , "BETWEEN");
    FilterStructure2.Insert("value", "20 AND 30");
    FilterStructure2.Insert("raw"  , True);

    Filters.Add(FilterStructure1);
    Filters.Add(FilterStructure2);

    Sort  = New Structure("created_at", "DESC");
    Count = 1;

    Result = OPI_SQLite.GetRecords(Table, Fields, Filters, Sort, Count, Base);

Bash

    oint sqlite GetRecords \
     --table "test" \
     --db "C:\Users\Administrator\AppData\Local\Temp\3pbdgv5r4nm.sqlite"

CMD/Bat

    oint sqlite GetRecords ^
     --table "test" ^
     --db "C:\Users\Administrator\AppData\Local\Temp\3pbdgv5r4nm.sqlite"

Result

{
 "data": [
  {
   "name": "Vitaly",
   "salary": 1000.12
  }
 ],
 "result": true
}