mORMot Open Source

I have a module that contains several classes mapped to database tables. When I use CreateMissingTables in mORMot, it creates the missing tables for the classes. However, there is an issue:

CreateMissingTables automatically adds an ID field to the tables it creates.

In my case, some classes already have an ID field defined as varchar, but CreateMissingTables still tries to add its default ID field as integer.

This causes a conflict because the table ends up with the wrong type for the ID field, or sometimes it fails to create the table correctly.

Goal:

I want CreateMissingTables to respect the existing ID fields in my classes and not automatically add an integer ID field, especially when my class already defines a varchar ID.

As part of a 3-tier architecture (SOA), I need to implement a business function that operates on three different ORM classes, each corresponding to a different table in the database.

My goal is to ensure data consistency by using a transaction: if an error occurs while saving any of the entities, I want all changes to be rolled back.

However, in mORMot 2, the TransactionBegin(Table, SessionID) method appears to support only one class at a time.

Therefore, I am wondering:

         How can I manage a transaction that spans multiple ORM classes (tables) in mORMot?

         Does using transactions in mORMot block other users from accessing or modifying the database during the transaction?

When I connect to an external database like PostgreSQL, when using the MultiFieldsValues function, it returns RowId instead of ID.
why

I am using the Objects property of IdocList.

For example:
var dL: IdocList;
for var d: IdocDicts in dl.Objects('Name=', '')
I found that it skips the d objects that do not have a 'Name'."

It seems like you're trying to iterate through an IdocList and filter or process objects based on their 'Name' property, but the issue is that objects without a 'Name' are being skipped.