mORMot Open Source

Hi all. We already have an Oracle database since ten years ago, and until now our Delphi applications are client/server. Now we want to build a REST server using Mormot, but we have a problem.
In Oracle we have four schemas, and each one have its one tables... How can we model that scenario using Mormot?
Maybe creating four connection (aProps[1] := TSQLDBOracleConnectionProperties.Create() ... aProps[4] := TSQLDBOracleConnectionProperties.Create), and eventually four Models for every connection (aModel[1] := CreateModel1 ... aModel[4] := CreateModel1), using VirtualTableExternalRegisterAll() with each pair? What about REST server where only one model we can use (TSQLRestServerDB.Create(model,...)) ?

I appreciate the help you could give us.

Regards,
   Sergio

Hi all. I'm new using Mormot and we're testing it. We would like the "GET" command to return all or some fields and not just the "ID" field. For example:

...
  TTemporada = class(TSQLRecord)
  private
    fCode : string;
  published
   property Code : string index 30 read fCode write fCode;
  end;
...

Request: GET http://localhost:8080/root/temporada

Result:
[
    {
        "ID": 1
    },
    {
        "ID": 2
    }
]

And we'd like to get the following:

[
  {
     "ID": 1,
     "CODIGO": "Cod1"
  },
  {
     "ID": 2,
     "CODIGO": "Cod2"
  }
]

Regards,
    Sergio