mORMot Open Source

Ok. Thanks a lot

:-)
The first thing I thought was that there will surely be a direct method avoiding the passage via Json... :-)

Hi Ab.
Thanks, It works.
Although it took some time to understand that it was the cookie that should return empty :-)
However I take advantage of a small oversight: in .GetUserInfo, .userPrincipalName is always empty in out Info: LdapUser.
Thanks a lot for help :-)

Hi Arnoud,
I use mORMot 2.
When I create an ORM object, and assign some fields but I don't assign that date field (TDateTime).
(It seems it have value of 0 (30/12/1899) )
The statement in Postgres have an exception on a empty string value.
The problem is only present on RestServerDb.BatchSend(tmpBatch) with multirecords updates.
Thanks in advance

Ok, I will try.
I'm only missing a "Map" function for change "text" into  "json" when field is variant on a table creation. Or a way for "force" it. Please tell me a direction.
Embedding some big tables, big only on number of fields, included within a master record, can be a better solution with "destructured" data forms, but I need to change "TEXT" to Json, so we are sure to use SQL also on embedded json.
Thank you so much for your patience!

Ok, AB,
we have no choice. :-) Thanks.
But I need those fields to be filterable or searchable on the database anyway. So I thought that using the json functions it is possible to query and extract the data contained in the variant in the "where" clause of the fillprepare or .Execute.
But the variant fields are created as "text", while instead, to be managed directly through Db they must be of type Json. I'm talking about PostgreSql.
Is it possible to force the creation of "Json" fields type instead of "Text" ones for the variant fields of "TOrm"?
Thank you so much!

HI AB,

>>  You can try to change TMyOrmClass.OrmProps.SimpleFieldsBits[ooInsert]  and  [ooUpdate].

It seems that it works, from my few tests

Thanks a lot

Hi AB,

thank you;

I have solved with

tmpBits := tmpObj.OrmProps.FieldBitsFromExcludingCsv('field01, field02');

ServerMormot.RestServerDb.Add(tmpObj, tmpBits, true, true);

Thanks a lot;

Question: there is a way for set those TFieldBits "permanently" at ORM level   (for select, insert, update) ?

Thanks in advance!

Hi Ab,
I have read your text, but I don't find EngineAddForcedID in documentation.

I will try to find some information in code.

Thanks a lot

It seems that only  aForceAjax=false by default don't works.
Instead with TRestServer.NoAjaxJson := true it works well. Thanks a lot!

A different serialization:
There is a way for obtain a direct serialization for a  JSON with "[DontStoreVoid]" option for a
IRestOrm.RetrieveDocVariantArray() (or other Retrieve...)? I don't find this capability natively.
Naturally the fastest way possible...

Thanks in advance!

TSynDBdataset (on client) with SynDBRemote is the best and fastest  way to "remotize" SQL. I'm curious to know how many concurrent accesses it could handle, with the direct provider to PostgresQL.
Without touching the ORM world.
Is SynDB not yet available in mormot 2?
The performances are outstanding.

Hi Esteban,
I don't understand your answer :-)
I would like to known if TSynRestdataset is multiplatform about Android and Ios (osx), not linux....
Anyway, TsynRestdataset with mormot is almost 2,5 time faster than standard rest client + RestResponseDatasetAdapter + Fdmemtable (with the same mormot server, MongoDb, 100,000 little records fetched in a grid).

Stefano

Ok, Esteban.
With latest release works.
But I have a "invalid parameter" error on Applyupdates on some pc clients... (other works well...)
What I do wrong? :-)
Thanks in advance;
(wonderful component, the best is if it can be visual in IDE for assign fields to Db components, especially on forms with a lot of editors...)
Stefano

Hi Esteban,
SynRestDataset don't works with Mongo at backend?
( I have 404 resource not found....)

Thanks,
Stefano

Hi Thanks,
but how to use ondownload features (or onprogress)  for show a progressbar on client, if I use TSQLRestClient and a remote GETfile service?
How use the  TWinHttpAPI events using TSQLRestClient ?
(I am new to mormot, a fantastic product)
Thanks in advance!
Stefano

Ok,
I will looking for Adapter properties and methods.
Thanks :-)
Stefano

Hi,
I use Firedac with Firebird as backend... but now I ask about only ORM (TSQLRecord) approach.
I need to Known if there is a way for acquire the client DELTA operations on a Objectlist of Tsqlrecord, so I can apply updates into backend  with batch operation (I like a lot your Mongodb direct implementation).
I want adopt Mormot for all new applications (very powerful and perfect for my needs) and I need to migrate to Tsqlrecord concept, so I can obtain the same result but only with ORM (also on the client) and without datasets, locally or remote (REST).
Thanks in advance for help!
Stefano