mORMot Open Source

Thanks Arnaud.  This is very exciting and must have taken you a lòt of time! 
So much appreciated.  It is a very useful expansion of the framework.
Can't wait to get my hands on the examples and start playing with this.

32 threads

Maybe this is a browser issue and not a framework issue.  It happens when I test using two tabs of the same browser, but not when using two different browsers at the same time, such as chrome and firefox.

I need to temporarily put something in place of a Datasnap server that third parties integrated to.  So what is important, is that I maintain exactly the same uri formats.  Unfortunately that means that third party clients over which I have no control, need to be able to make POST requests such as /root/Calculator/Add/1/2 which I need to translate to the registered interface functions, ie to ICalculator.Add(1, 2) and execute it.

Is it currently possible to do for example

GET 'customers/{CustomerId}/invoices/{InvoiceNumber}'
or
POST /root/Calculator/Add/1/2

using interface based services?

It looks as if it always thinks the binary data is json, so maybe that is used as a fallback when it can't determine the data type?  Since these are partial files, not full files (which would be too big - up to 1 gb), I assume determining the content type will not succeed.  How can I provide / override / force the content type when serving binary data?

Providing the full path of the original file does not resolve the issue - is still sends the content-type as json.

Hi ab

Streaming the file directly from the server is great.  I wish this was possible with mORMot 1.  If I may get back to the second half of dexter's question - saving of the file by the client.  Is there a way for the client (ie TWinHTTP.Request) to stream the bytes received from the server directly to file/disk without caching it in memory first?

Would the opposite of this be possible?

I have a generic mormot server that is used for authentication and to perform some calculations and database actions.  This runs offline directy at customers' sites.  For some customers, some of the interface functions must be replaced to do calculations differently.

Since I do not want to recompile the exe for every customer request, I'm hoping to move only those functions to a dll and have the mormot server use the custom versions of the functions in the dll if they are present.

From my understanding of TSQLRestServer.ExportServer, the expectation is that the entire mormot server will live inside the dll.  Is that correct?  I hope to keep the rest server inside my main exe (since that is its only reason to exist) and just extend it with additional or replacement interface functions from the dll.  Would that be possible?

It is caused by mormot.db.raw.sqlite3.static

It looks like another GotoNextNotSpace() might be needed in SynCommons.pas in the function TDynArray.LoadFromJSON function before line 50300, since that is where it gets the space value instead of the next [ character.  Unfortunately I dont know the code well enough to know the impact of changes there.

Interesting is that in all scenarios, JSONArrayCount return the correct count.

What would be the most efficient way to format ISQLDBROWS into json that uses the format below? 

{
	"fieldCount": 3,
	"rowCount": 2,
	"fieldNames": ["DateData", "IntData", "StrData"],
	"values": [	
	    ["2016-03-14T13:23:25",  1,  "Hello"],
	    ["2016-03-14T13:23:45",  2,  "Bye"]
  	]
}

I basically need to create a custom version of FetchAllToJSON.  Should I create a new TextWriter and manually step through all the records and fields, or is there maybe a function that can return the entire row in json?

Thanks ab

It can get very complicated to add/update out parameters on many functions when a standard long/nested record result is to be returned, especially if the expected output is prepopulated as a record by a universal function. 

Is there maybe an event on TSQLRestServerFullMemory that can be overridden before the data is sent to manually remove the leading {"Result": and trailing " from the outgoing json string, or another property that can be set to not add it at all?

Hi ab

I used the TFullname records posted by cypriotcalm and added them to the calculator in the sample project 27 (Project14ServerHttpWrapper), since this declaration is already done in there to test the result:

aServer.ServiceDefine(TServiceCalculator,[ICalculator],sicShared).ResultAsJSONObjectWithoutResult := true;

I added a test function like this:

function TServiceCalculator.GetSingleFullname: TFullname;
begin
  Result.Firstname := 'First Name';
  Result.Lastname := 'Last Name';
end;

and expected the result to not contain "Result":

However, it looks like it always encapsulates it in a Result ie

  {"Result":{"Firstname":"First Name","Lastname":"Last Name"}}

Is that the expected behaviour of this property, or did I misunderstood the reason for it?  Is the idea behind this property not to send the data without result, ie:

{"Firstname":"First Name","Lastname":"Last Name"}

?

Is it possible to send a record like that without Result being added?  It seems that using RawJson also always include Result?

Thanks ab

It looks like the code provided by @MCvanderKooij works very well as-is, I just had to add SynTable to the uses clause of uJWTRSA.

Thanks mpv, that is a good idea and will fit very well within the current process, even better than sms or email 2fa

Does anybody know how to achieve this?  Any suggestions will be helpful.

Thanks @mpv.  That is exactly the info I was looking for

That solves about 99% of the issues I was facing.  Thanks @ab!

This link describes it better than I can:
https://techcommunity.microsoft.com/t5/ … a-p/324623

"Client Certificate Authentication is a mutual certificate based authentication, where the client provides its Client Certificate to the Server to prove its identity. This happens as a part of the SSL Handshake"

I need to perform secure tcp communications to a 3rd party server where client certificate authentication is used and where the server is configured for this part to not be optional.

Is it possible to use TLS v1.3 on tcp socket connections with mormot or this wrapper?

This is why politics and programming should never mix.   In this instance I unfortunately don't have a say in what the client does.  They use an html select dropdown, which can sometimes be a single value and sometimes a multiple select.  While it would take them 10 seconds to ensure an array is always sent, its not happening.

My interim solution to keep the project on track, was to keep the grouping as a Variant, but then internally copy it to an array.  It might not be elegant, but will do for now.  I'm sure there is a more efficient way of doing this.

procedure ParseVariantToArray(const Data: Variant; var Arr: TStringDynArray);
var
  I: Integer;
begin
  SetLength(Arr, 0);
  if (not VarIsEmpty(Data)) and (not VarIsNull(Data)) then
  begin
    if VarIsNumeric(Data) then
      Arr := [FloatToStr(Data)]
    else
    if VarIsStr(Data) then
      Arr := [Data]
    else
      for I := 0 to TDocVariantData(Data).Count -1 do
        Arr := Arr + [TDocVariantData(Data).Value[I]];
  end;
end;