mORMot Open Source

Hi;

I newbie mormot and dephi.
I try to make a service based application.
I neeed to check parameters type and rules before processing
if parameters type is not compactible type send to client some error message instead of 406
if parameters check is pass process requested function?

for example ;

type
  TServiceCalculator = class(TInterfacedObject, ICalculator)
  public
    function Add(n1,n2: integer): integer;
  end;

function TServiceCalculator.Add(n1, n2: integer): integer;
begin
  result := n1+n2;
end;

if a client call add function with string type I want to return to client some text about error.
  But a clent call add function with integer params execute add function and function return result.

How can I do this. Does any body have any idea to solve this problem ?

thanks for all.

Hi;

Firstly thanks to Arnaud and other contributors of mormot framework. It is a greate and very nice framework.

I will make an integration system to another program so I deciced to make of this using with http basic Rest interface based service.

I started with point an example (Samples\ThirdPartyDemos\George\REST-tester).

But I need to retrive and send some records to client. I used connecting the server ZeosDBO.
Zeosbo Query component is enought for retriving data from Sql Server

Which methods or function usefull  I can use for converting JSON and sending  record/records to clients?

PS: Sory for my bad and poor english.

Hi;

I am new bee mormot and delphi.
When I was reading a datetime value from MSSQL 2008 R2 database ;
I have got an error
   " ... 0.42936 is not valid timestamp"

But WhenI was execute same SQL statement via SME I saw the datetime value is "2017-07-16 00:00:00"
I am using this code blok like this: (I am verry sorry for big capital . But I am using big capital when I was writing code.)

   XQSIPLIST : TSynDBSQLDataSet;
   XLIST : TSTRINGLIST;
   ..
   XSQLSTR:='Select INCKEYNO, TARIH, NAME from MYtable';
   XQSIPLIST:=TSynDBSQLDataSet.CREATE(nil);
   XQSIPLIST.CONNECTION:=mssqldbConnetion; // TSQLDBConnectionProperties . Connect via MSSQL 2008 R2 Client
   XQSIPLIST.COMMANDTEXT:=XSQLSTR;
   XQSIPLIST.OPEN;
   XQSIPLIST.FIRST;

   WHILE NOT XQSIPLIST.EOF DO BEGIN
      ..
      XLIST.ITEMS[XROW]:=DATETOSTR(XQSIPLIST.FIELDBYNAME('TARIH').ASDATETIME);   // TARIH is a datetime field.   
      ...
       XQSIPLIST.NEXT;
   END;
   XQSIPLIST.CLOSE;
   XQSIPLIST.FREE;

How can I retrieve true datetime from this database using TSynDBSQLDataSet.

Can anybody help me ?

Edit : But this Code block is retrieve true datetime value from database

   XDBCONNECTION:=TOleDBMSSQLConnectionProperties.Create(....);
   XDATA:=XDBCONNECTION.EXECUTE(STRINGTOUTF8(XSQLSTR),[]);
   WHILE XDATA.STEP DO BEGIN
     XBASTARIH:=XDATA.ColumnDateTime('TARIH'); // TARIH is a TdateTime field
     SHOWMESSAGE(XDATETIMETOSTR(XBASTARIH));
   END;

sorry for code blocks

Hi;
I am a newbie delphi and mormot too...
I want to desing a program which has got a lot of part.
I want to use mormot framework to writing this program. Mormot is very nice framework thanks alot to contributors.
All of program(s) share  one database (schema)
Data may be store on a MSSQL Server 2008 or over version, may be MSSQL2005

When I was collecting parts of program has got only five main part.
1th - Some of user use a program on a windows PC these are VCL client1 from local network or RDP (alternatively may be websockets remotely) (Most of users)
(This part of program looks like an accounting system)
2nd - Some of user use another screens using windows PC which is different from fist. These are VCL Client2 from local network or RDP (alternatively may be websockets remotely) (Most of users) (This part of program looks like manufacturing service)
3rd - Some of user use an android/ios device for entry very small data or take reports from data. (a few users) (this part of program looks like a pivot table report or looks like sending items using barcode) May be this part of program divide with two different part. One of take pivot report and other part is sending items using barcode)
4th - Some of user input data from via web interface (I think for broken comminucation, may be run a syncdata services) using online store. (I haven't got any idea and knowledge how much users may be use web interface) (This part of program looks like a hotel booking/reservation service)
5th - Data import/export for importing/exporting with using an other programs (via TXT, CSV, XLS, XLSX etc) and share some of data.

How can I design the server program(s).?
All of this function is mix and run only one service(server) applicaton ?
or
One service(server) application one of that position. Now we got 4 position and 4 service (server) application?
Which type of server(service) application to that position RestFull, RestServer, Restserver ORM, etc ?
Which one is best solution ? Which way I used pfreferred solution ?

Can you help me suggestion to solve this decision.

ps: sorry my bad english.