mORMot Open Source

Sorry, I've missed part of you using CrossPlatform unit, there's likely nothing ready for it. Try to copy GetValueByPath from SynCommons or mormot.core.variants

Check: https://synopse.info/forum/viewtopic.php?id=6415

This seems like server/client mistakes json as text and so escapes " with \.
Try to use RawJSON for your interface function result.

Thanks, this will be perfect.

I'm actully not serving any json to client, it's just standard get to display object record (user for example), post to add/update it and for delete I had to add a custom DeleteUser method. Now with this change it's possible to handle all general actions (get, add, update, delete) in one method which is quite neat.

I'm using htmx library with mORMot MVC and with it client application is not bound to html FORM restrictions (GET/POST only).
Html form is not even needed (it can collect input values from a standard div) and it can issue delete request as well.
It offers some really nice features so it's possible to create complex applications without much javascript on client side.
For example when new user is added/deleted by client it can automatically append/delete it to the list, so it's not necessary to refresh whole page.

> Is that not equal to implement the OnAuthentificationFailed event available on TSQLHttpClient?

It is, with descendant class I have it solved for any application.

> When I tried that, OnAuthentificationFailed only fired when wrong credentials are inserted...

For me it definitely fails after connection is lost (restart of server for example), there are other onError events if this doesn't gets called.
Note that it it won't detect lost connection at the exact moment, it fails when connection is used for the first time after being lost.

AFAIK only published variables will be serialezed, your record is public variable.

Do note that you can use TDocVariantData instead of record, it's much more powerful and sometimes equally fast since it's stored as Variant and that can also be copied by reference.

Do you have control over server side application? If so you have to change there first to https.
Was your code generated through wrappers, if so after changing server side you should regenerate client wrapper again.

Good starting point would be documentation https://synopse.info/files/html/Synopse … #TITLE_491

ServiceRunningContext from mormot.rest.server

ArchiveFile is also defined as working with IInStream (see IArchiveOpenCallback) so 7z archive can fully be in memory.
But I understand what you mean, overhead of having simple buffer treatead as archive instead of compressed buffer, I think that overhead isn't large and is worth having any compression supported.

> And the 7z library we support is a dll for Windows only.

7z does have debian/linux implementation, though I do not know how compatible it is or if 7z ZS has linux support.

BTW there's also LZMA2 compression (default 7z algo), InnoSetup has Pascal implementation of it and there are some other implementation but I don't know if they're cross platform.

Since 7z is already supported I think it would be better to check if 7z ZS is supported as well.
7z ZS supports ZTSD, brotli and other codecs and so it would give more options to users.
Brotli is also becoming more and more supported by webservers or API providers.

> I have my own printer for my application. It creates a Postscript printer from which a catch the output to a .ps file and I
> throw that through ghostscript.

This is very interesting, so you kind of have your own printToPDF printer installed as part of your app.
Can you explain a bit more how you achieved it?

> I closely examined most of the Pascal related web development applications over a number of years, and for me the standout
> solution was Elevate Web Builder both because of it's excellent architecture, delphi like IDE and form designer, and excellent visual controls.
> So it's well worth a look (and it's very reasonably priced).
> Let me know if you need further info (I've been using it as a mORMot client for some years now).

Thanks, I've tried EWB but decided on SMS and that's abandon now.
Do you know what kind of compiler EWB uses, is it a proprietary or DWScript?
For me UI and html controls are not important, I've did it for years and it's hard to maintain or change. What I'm doing now is create UI in html with mustache template and bootstrap and so UI can be changed by others (designer) and I just focus on code side.

I've created 7z wrapper years ago, it supports more of 7z options (GetNumberOfFormats, GetHandlerProperty2, self extracting). To create dir in 7z you have to pass empty file name, perhaps if you expose T7zWriter.AddOrReplace it could be done.

Here's my code in case someone want's to add more functionality to this implementation:
https://www.dropbox.com/s/iszoge0frqocf … er.7z?dl=0

Yes, mustache is powerfull but sometimes it's simplicity is weak link. In some cases it requires creating new variables or additional processing on code side to achive something. I do think an additional MustacheEx or MustachemORM descendant could help in many areas and make it much more powerful.

On a similar note, TMVCRendererJson isn't cacheable by default while TMVCRendererFromViews.

Situation I have in practice is that I have server MVCApp that creates pages, fills it via mustache templates and it's then consumed by JS client.
JS client needs same data as server (taken from database or from some external API), it just does some additional handling with it.
Retrieving data depending on page (query) could take few seconds or more if it uses some external API. From client I'm getting data by calling same URL just with added /json param which makes MVC let it go through TMVCRendererJSON that does call same interface method as default page handler (without /json sufix). So in span of few second same method will be called twice (so twice DB call, and API call) and that's a perfect candidate for caching.

Rendering html based on json data is fast but creating that json data is slow so having caching in the first step would be quite usefull.
For example if inheritance order is changed here, make TMVCRendererJson a base and then inherit TMVCRendererFromViews from it.
That way database/API call that generates json could be cached and used several times either with different user/session or from both server that produces html page and js client that consumes raw json.

Alternative (or best both) would be to decouple TMVCRunOnRestServer.InternalRunOnRestServer from TMVCRendererJSON/TMVCRendererFromViews and allow app to specify inherited renderers for use here.

> Problem with this is that we have to treat all input/output parameters of service method, getting of Ctx. very hard work!

Note for parsing input params you can use Ctx.GetInputAsTDocVariant to receive params as JSON document which is easy to parse.
Also when sending result you can do that as JSON which is easy to write/read on both server and client side.

Partials changes are not tracked, so you can try to force changes yourself (perhaps with FlushAnyCache) or change code for example I did this:

function TSynMustachePartials.GetPartial(const PartialName: RawUTF8): TSynMustache;
var
  i: integer;
  Temp: TSynMustache;
begin
  if self=nil then begin
    result := nil;
    exit;
  end;
  i := fList.IndexOf(PartialName);
  if i<0 then
    result := nil
  else begin
    // Partial files by default in mORMot are loaded just once and then cached which is very bad
    // during debugging when files are changed and it requires constant restart of the application.
    // With this change we're disabling cache in debugMode.
    // Note that internal partials (defined in template, not in external file) have to be loaded in a standard manner
    Result := TSynMustache(fList.Objects[i]);
    if DebugHook <> 0 then
    begin
      Temp := TSynMustache.Parse(AnyTextFileToRawUTF8(UTF8ToString(ViewsPath + PartialName + '.partial'), true));
      if Temp.Template <> '' then
        Result := Temp;
    end;
  end;
end;

It would probably be a good idea to update https://synopse.info/fossil/wiki?name=Downloads page and to include m2 info/links and m2 NightlyBuild.

Just try to parse that file and check if you get expected results, you can use TDocVariantData.InitJsonFromFile for example.

I think GetValueByPath should be OK.

Just a note to everyone using OpenSSL there's a major vulnerability discovered, it's necessary to update both client/server:
https://www.tenable.com/blog/cve-2022-3 … rabilities

Try to update your mORMot code with latest version.

Code is fine and it will create template with default settings, I think it's better if you specify it yourself, for example:

var
  Params: TMVCViewsMustacheParameters;
begin
  FillChar(Params, sizeof(Params), 0);
  Params.Folder := Settings.TemplatesLocation;
  Params.FileTimestampMonitorAfterSeconds := 5;
  Params.ExtensionForNotExistingTemplate := '.html';
  Params.Helpers := TSynMustache.HelpersGetStandardList;

  FViews := TMVCViewsMustache.Create(Self.Factory.InterfaceTypeInfo, Params, FRestServer.LogClass);
  FMainRunner := TMVCRunOnRestServer.Create(Self, nil, '', FViews, [publishStatic, registerORMTableAsExpressions]);

It means object you retrieved do not contain that member (Value or what ever you used). There are examples (and I think library) for working with Excel through OleAPI.

This is not a problem for this forum.