mORMot Open Source

Should I use a transaction for every table passing the table as parameter on each or can I just do something like

rest.TransactionBegin(TSQLRecord, 1);
try
  update table1
  ...
  update tablen
  rest.commit(1)
exception
  rest.rollback(1);
end;

What is the proper way?

Thanks!

I seldom get this error on my IDE when using a direct sql (service is on per thread) and TSQLJSONTable

  tableResult := TSQLTableJSON.Create(sql, fSQLServiceEFD.Execute(sql, true, false));
  try
    while tableResult.Step(False, @r) do
    (...)

raised exception class ESQLite3Exception with message 'Error SQLITE_MISUSE (21) [bind_text] using 3.29.0 - not an error, extended_errcode=0'

I've also seen extended_errcode = 100

doesn't happen on single thread execution (I'm using a Parallel.ForEach from omnithread)

I got a table with a 1:1 reference to another and when retrieving values, when the Id is too high, I'm getting an AV, what should I do ? The ID is over $100000 and this messes up the ORM

on the TSQLRecord:
    property reg : TReg0200 read fReg write fReg; //this is another TSQLRecord

loading data:

...
  RetrieveList<TAgrupamentoConsistencia>('', []);
...
  for obj in list do
    obj.reg := TReg0200.Create(Server, obj.reg.Id);

also tried obj.reg , obj.reg.AsTSQLRecord

I got an interface with a ping command among others

(interface was already defined with fPipeClient.ServiceDefine)
service := fPipeClient.Services[fServiceName];
if service <> nil then
  if service.Get(I) then
    result := I.ping;

I need this I.ping to be  quick, like, if no answer in 10 millisecs just return false, I have not found a timeout property.

Thanks.

I've been searching for it but I couldn't find an answer, would it be possible to store it as JSON instead of BLOB?

from what I've read, TObjectList would store it as json, but would add a class: property that I don't want, and i've never worked with Collections, TDocVariant would be problematic for me since I like the type-safety.

If I can't do with an array what would be the best way to have it type safe while storing it as a json?

Thanks

I've been using mormot for some interface based services for a while, and there's a new project I have to do that I just don't know how I should be doing it,

I'd like to have a server controlling a lot of different databases, the database would be in the URL, example :

localhost:8080/root/db1/customers
localhost:8080/root/db2/customers
localhost:8080/root/db3/customers

...

The problem is that I don't know the names of those dbs, if they don't exist they should be created at runtime.

Idea would be an interface,

ISampleFunctions = interface ...
TSampleFunctionsService = class(ISampleFunctions) ...

What could be done? Override Process, and then create the TRest/TSQL at run time ? but how could I then redirect it?

Thank you.