mORMot Open Source

:) I beg your pardon for my english!

I try to simplify my request:

TSQLTableName1 = Class(TSQLRecord)
TSQLTableName2 = Class(TSQLRecord)
...
TMethodName1   = Class(TInterfacedObject,...)
TMethodName2   = Class(TInterfacedObject,...)
...

aServer.ServiceRegister(TMethodName2,...)

POST /ModelRoot/TableName1/ID/MethodName2 <- {"create a new TableName2 record with TableName1 ID reference"}

It's correct!? I'm trying to "simulate" a resource only REST URL.

Thanks,
Mauro

> No, it is not possible as this.

OK!

>You'll have to search for all the Childs with Parents=ParentID in the share WHERE clause.
>There is no direct REST routing for such requests.

It's possible to have just a little example about this (MainDemo doesn't explain exactly this situation)?

Sorry, I don't understand! Parents=ParentID is on client or server?

When I request a Parent from the client:

  GET /ModelRoot/TableParents    ->    {"ID":1,"ID":2,...}

  GET /ModelRoot/TableParents/1    ->     {"ParentDescription":"This is a parent",{???}}

How mORMot expose multiple TableChild ID in the body of the response?

To add a new Child with a reference to the Parent what I need to do:

  POST /ModelRoot/TableChilds&ParentID=1    -> {"ChildDescription":"This is a child"}

  POST /ModelRoot/TableChilds        -> {"ParentID":1,"ChildDescription":"This is a child"}

Do you need it for some AJAX properties?

I'm just trying to simplyfing the client logic: as I don't understand the server side too!
I don't need a Delphi client, just remote apps (Javascript/PHP/Python/Ruby/etc.)  that talks with a mORMot server and viceversa.

> I do not remember that such a REST routing is standard - is it?

I've read about this in a lot of docs, this is an example:

REST API Design Rulebook - O'Reilly:
http://books.google.it/books?id=eABpzyT … &q&f=false

Ruby on Rails implement this.

But I just want to go in the mORMot way, if I'll find it!

Thanks for your help!
Mauro

It's a CONSOLE application so when you compile it with the second VirtualTableRegister activated the program crash and close the window.
The exact error message is:

Project Project1.exe raised exception class C0000005 with message 'access violation at 0x00403dba: read of address 0xbaadf00d'.
Process stopped. Use Step or Run to continue.

Here the test source I'm using:

------------------------Project1.dpr----------------------

program Project1;

{$APPTYPE CONSOLE}

uses
  SysUtils,
  SynCommons,
  SynOleDB,
  SynDB,
  SQLite3Commons,
  SQLite3,
  SQLite3DB,
  SQLite3HttpServer,
  Unit1 in 'Unit1.pas';

Var
  aModel : TSQLModel;
  aServer : TSQLRestServerDB;
  Server: TSQLite3HttpServer;
begin
  aModel := CreateMyModel;

  // The program compile and run correctly if you
  // comment out one of these lines
  aModel.VirtualTableRegister(TSQLA, TSQLVirtualTableJSON);
  aModel.VirtualTableRegister(TSQLB, TSQLVirtualTableJSON);

  aServer := TSQLRestServerDB.Create(aModel,'database.db3',false);

  aServer.CreateMissingTables();

  Server := TSQLite3HttpServer.Create('8080',[aServer]);
  WriteLn('Press ENTER to Exit');
  ReadLn;
end.

-----------------Unit1.pas-----------------------
unit Unit1;

interface

uses
  SynCommons,
  SQLite3Commons;

type
  TSQLA = class(TSQLRecord)
  private
    fFirstField : Integer;
    fSecondField: RawUTF8;
  published
    property FirstField: Integer  read fFirstField  write fFirstField;
    property SecondField: RawUTF8 read fSecondField write fSecondField;
  end;

type
  TSQLB = class(TSQLRecord)
  private
    fThirdField : Integer;
    fFourthField: RawUTF8;
  published
    property ThirdField: Integer  read fThirdField  write fThirdField;
    property FourthField: RawUTF8 read fFourthField write fFourthField;
  end;

function CreateMyModel: TSQLModel;

implementation

function CreateMyModel: TSQLModel;
begin
  result := TSQLModel.Create([TSQLA, TSQLB]);
end;

end.

OK!
as for Version 1.16
-- added authentication to the remote process

In the client I see this login/pwd: User / synopse

but from RESTclient using Basic Authentication I'm facing the same error...

How can I disable aHandleUserAuthentication in the server just to test the connection?