mORMot Open Source

I found the problem. It seems it was my mistake:

var
  NewArray2: Variant;
begin
  ss := '{"a":["1"],"b":"2"}';
  NewArray2 := _Arr(['2']);
  V := _Json(ss);
  V.a := NewArray2;
  ShowMessage(TDocVariantData(V).ToJson);

or

  LDocDict := DocDict(ss);
  LDocDict['a'] := NewArray2;

I am using sql capabilties for generate DTO and classes. It is realy simple and flexible, maybe help some one (this is for mysql and can be implement for other dbms by changing sql):

select t.table_name,concat(group_concat(col order by ordinal_position separator ';\r\n'),';') table_create from (
select a.table_name,a.ordinal_position,concat(a.column_name,': ',
if(a.data_type in ('varchar','enum','text','char','time','varbinary','tinytext','set','mediumtext'),
if(a.is_nullable='YES','TNullableUtf8Text','RawUtf8'),
if(a.data_type in ('int','tinyint','mediumint','smallint'),
if(a.is_nullable='YES','TNullableInteger','integer'),
if(a.data_type in ('decimal'),
if(a.is_nullable='YES','TNullableCurrency','currency'),
if(a.data_type in ('bigint'),
if(a.is_nullable='YES','TNullableInteger','int64'),
if(a.data_type in ('timestamp','date','datetime'),
if(a.is_nullable='YES','TNullableDateTime','TDateTime'),
if(a.data_type in ('longblob','blob','mediumblob'),
if(a.is_nullable='YES','TNullableUtf8Text','RawUtf8'),
if(a.data_type in ('double','float'),'Double','unDefined')))))))
) col from information_schema.columns a
where table_schema='your_mysql_db_name') t
group by t.table_name;

I use encrypt method and same again ?
It is decrypted with motmot, but with another tool it gives no multi byte string error

var
  key: string;
  PlainText: string;
  akey : RawByteString;
  CryptCipher: ICryptCipher;
  dest: RawByteString;
  InputRawString: RawByteString;
  Bytes: TBytes;
begin
  PlainText := 'да, это работает. спасибо';
  Key := '12345678901234567890123456789012';
  akey := HexToBin(SHA256(Key));
  Bytes := TEncoding.UTF8.GetBytes(PlainText);
  SetString(InputRawString, PAnsiChar(PByte(Bytes)), Length(Bytes));
  CryptCipher := Encrypt('aes-256-gcm', Pointer(akey));
  CryptCipher.Process(InputRawString, dest, '');
  dest := BinToBase64(dest);
  Memo2.Text := dest;

I test result in online site like devglan. for same key and IV result is different.

Is there a future plan to implement OAEP ?

We can add more managers to the group. If any of the people who are here and are approved by you, I can add them

After making the suggested change, the same error occurred again. But by creating a new instance, the problem was solved!
Thanks. you are the best!

It is requierment of taxpayer system.
Taxpayer document says:
After encryption of the bill, through the AES/GCM algorithm, the encrypted symmetric key and IV must be placed next to the encrypted bill. To encrypt the symmetric key, the asymmetric RSA-OAEP-SHA256 method must be used, which is obtained from the public key(s) of the taxpayer system with a length of 4096 bits. A valid intermediate center is used (the public key of the taxpayer system is obtained using the GET_SERVER_INFORMATION method).
C# example of this document is :
https://jsfiddle.net/8w2u3sex/

There is a taxpayer system that requires the national code of individuals or the company's national ID in this field to produce a certificate in field 2.5.4.5.
Therefore, I have no choice and I have to fill this field so that I can send an invoice to the government taxpayer system. Is there no solution?

[dcc32 Error] View.Server.pas(109): E2250 There is no overloaded version of 'ServiceRegister' that can be called with these arguments

unit Service.Invoice ;

TInvoiceService = class(TInjectableObjectRest, IInvoiceService)
public
constructor Create; overload;
function GetInvoiceList(const DateFr,DateTo: string): RawJson;

function TInvoiceService.GetInvoiceList(const DateFr,DateTo: string): RawJson;
begin
--   self.server is nil here
end;

constructor TInvoiceService.Create;
begin
  inherited Create;
end;

Hi mr TBO. property ConnectionPool is readonly property, how can I assgin connectionpool?
I passed it by TRestServer  constructor at the moment.

But I do it with other third party component now.I want to change it to mormot.
CkCsr_SetSubjectField(csr,'2.5.4.5', pchar(Shenase) ,'UTF8String');

ok
As you can see in the code above, I pass the dbconnection to the InvoiceService constructor. I inject connection by constructor to service, and I hold connection in fConnection defined inside service. I hope it is the right approach.
I am concerned about one thing. Is a connection shared between different threads created by mormot for other services or operations? Doesn't it cause a problem in Mormot being multi-thread?

openssl disabled by default. I think mormot.crypt.x509 is better.

This is a big challenge in the beginning. I had the same problem. First, I tried to work on the documentation with Json and how to work with it in mormot using docvariant and doclist. Then I went back to the examples and was able to modify it to create a very basic web service. Then I tried to understand the interface  base service and method base service . And finally I worked a little with swagger.
Considering that in my existing database, the primary keys are narural key and compiste. I can't use orm. Because in Orm there must be a primary key for each table. So, I leave this section aside and use the functions that take the model and store it in the database by SQL.
The next step is how to call and share the interface for the client program. The power of mormot shows itself here. And how beautifully this work is implemented.
I'm still at the beginning of the journey, but I learned a lot within a month and I try to learn more every day.
I agree that it is much more difficult to start working with mormot than other frameworks.

It is natural that piloting a plane is more difficult than driving a car. But there are many unique possibilities here. Thanks to AB

I know, but the interesting thing is why the speed is still low when datasource is set to nil. But when beginupdate is executed, the problem is solved.

Thank you.
Setter solved the problem. but i have alot of tables (600 tables), with many enum fields. I want to use existing database structure as possible.

publish
  Size: RawUtf8;

field data type is enum('xxlarge','xlarge','large','medium','small');
I don't know where this conversion is happen. In orm level or Zeus level.

Hi.
For reports I have very complex sql,what is the best way for executing this kind of sql?
Is it correct using :

Hello . I want to check one of the demos related to mormot1 but TCQRSResult is missing in mormot2. What is its equivalent?