To SQLite3

Celso · 2015-02-01 22:30:49

Good night.
I saw that there is a function RowsToSQLite3.
How do I export JSON or ClientDataset for SQLite3?

ab · 2015-02-02 10:18:10

There is no direct method AFAIR, outside the scope of the ORM.
You have to write your low level code.
The easiest is to use TSQLTableJSON for reading the JSON content.
It would be then easy to fill the SQlite3 DB with it.

Celso · 2015-02-03 12:24:33

Thank you by return.
In my case, the data are sent by the server and comes in JSON.
I would like to use the functions ready for ORM. JSON for TSQLTable I have no problems in doing so. Can You give me an example of how I export for SQLite3?

ab · 2015-02-03 13:16:33

1. Create the TSQLRecord descendant corresponding to your table layout.
I will call it TSQLMyData below.

2. Define a model with this TSQLMyData and a SQlite3 ORM server - i.e. TSQLRestServerDB.
Fill the TSQLMyData table as in the SQlite3 DB from JSON:

var rec: TSQLMyData;
    batch: TSQLRestBatch;

batch := TSQLRestBach.Create(aServer,TSQLMyData,10000);
rec := TSQLMyData.CreateAndFillPrepare(aJSONFromClient);
try
  while rec.FillOne do
    batch.add(rec,true); // may be (rec,true,true) if you want to have the same IDs
  aServer.BatchSend(batch);
finally
  batch.Free;
  rec.Free;
end;

Celso · 2015-02-03 17:38:26

Thank you for your assistance.
My last question. As I transform my JSON in a ISQLDBRows?

ab · 2015-02-04 10:04:49

I do not understand your question, sorry.
Do you mean ISQLDBRows.FetchAllAsJSON method?

Celso · 2015-02-04 17:27:27

Exemple:

Rows, Rows2: ISQLDBRows;
fJSONBuffer: RawUTF8;

Rows := Props.Execute(SQL,[],nil,True);
fJSONBuffer := Rows.FetchAllAsJSON(false);
Rows.free;

----> How do I to fJSONBuffer to Rows again?
----> like this -> Rows2 := JSONToRows(fJSONBuffer);

ab · 2015-02-05 16:40:11

There is no built-in method for creating directly a ISQLDBRows.
But you can use the TSQLTableJSON to access the JSON by row.

ruth · 2015-02-08 12:48:47

If you don't want to code it, it may be helpful to first convert the JSON data to CSV by using a tool like https://json-csv.com

Last edited by ruth (2015-02-08 12:49:02)

ab · 2015-02-08 16:30:30

?????? CSV converted online ????
There is already a JSON to CSV fast conversion in TSQLTableJson.

mORMot Open Source

#1 2015-02-01 22:30:49

To SQLite3

#2 2015-02-02 10:18:10

Re: To SQLite3

#3 2015-02-03 12:24:33

Re: To SQLite3

#4 2015-02-03 13:16:33

Re: To SQLite3

#5 2015-02-03 17:38:26

Re: To SQLite3

#6 2015-02-04 10:04:49

Re: To SQLite3

#7 2015-02-04 17:27:27

Re: To SQLite3

#8 2015-02-05 16:40:11

Re: To SQLite3

#9 2015-02-08 12:48:47

Re: To SQLite3

#10 2015-02-08 16:30:30

Re: To SQLite3

Board footer