mORMot Open Source

Can I be corrected for this code ?
I definitely miss Mormot2 documentation

function TUtilisateursService.GetUtilisateur(aID: TID): RawJSON;
var
  obj: TOrmUtilisateurs;
begin
  if not fClientDB.Retrieve(aID, obj, false) then
  begin
    raise ERestException.Create('404 - Utilisateur non trouvé');
  end;
  try
    Result := JsonEncode(obj);
  finally
    obj.Free;
  end;
end;

Hi ab,

I'm about to start a new n-Tiers project, and I need to make a definitive choice this week about the framework/tools.
My background:
Delphi, ICS/Midware, RemObjects/custom ORM, RO/DA, Intraweb, .
HTML, a few CSS, and basic understanding of Javascript.

My project is a management application in a LAN.
One desktop rich client with word processing, file up/download, reporting...
3 web clients (pc and tablets) for display and some data input.
About 40 tables, up to 3-4 master/detail levels.

I've been reading a lot and testing a few about DDD and SOLID design for a few weeks.
I really see the mid/long term value in this new way out of RAD.
For the moment I plan to go: SQLite, ORM, Delphi client + SmartMS
BUT, I need to make sure I'll be able to be productive, or at least save equivalent time compared to debugging RAD!

- I'm going to investigate mORMotUI wich seem really flexible:
- is there a dedicated demo?
- Some support for simple record data input?
Another aspect:
- What is the recommended way to manage changes in object definition (ie. renaming or changing a field type)?

Thank for your inputs!

Hi,

May be you'll find it trivial, but I ended up creating several select services before finding out (as suspected)
that I could retrieve records simply by sending a WHERE parameter to the default REST engine.

Seems the complete list is stated nowhere else than in mormot.pas.
And dealing with strings in the WHERE clause was not so obvious.

May I suggest enhancing the documentation with a few non trivial examples as below?
http://localhost:8080/root/SampleRecord/?SELECT=id,name
http://localhost:8080/root/SampleRecord/?SELECT=id,name,time&STARTINDEX=2&RESULTS=4
http://localhost:8080/root/SampleRecord/?SELECT=id,name,time&WHERE=(name)=:("james"):or(name)like:("T%"):
http://localhost:8080/root/SampleRecord/?SELECT=id,name,time&SORT=name&DIR=desc

Also, a non trivial sample of service (ie returning rows via ORM) would be very helpful.

Thanks for this great framework,
I'm just scratching the surface! :-)

-
Didier

Hi,

I need some help to use mORMot with FPC/Windows 8.1

Using
CodeTyphon32 5.1 / FPC 2.71 / mORMot 1.18
sqlite3fpc.7z (fpc-win32)  -> mormot dir
sqlite3obj.7z  (obj) -> mormot/sqlite3 dir
sqlite3.dll  -> output dir  and system32

Compilation error:
SynCommons.pas(9438,14) Error: function header doesn't match the previous declaration "SetProperty(var tvardata;const AnsiString;const tvardata):Boolean;"

----

Using
Lazarus 1.26 32bit / FPC 2.64 / mORMot 1.18
Lazarus 1.26 32/64bit / FPC 2.64 / mORMot 1.18
Same SQLite3 deployment.

Compilation: OK
But execution error:
TestSQL3 project has raised a class exception: 'External: ?'   At address: 75262F71

----

Thank you for your help.
We've tried on 3 different computers.