TMS Aurelius / TMS Data Modeler and PostgreSQL and UniDAC

[Ickler_Oliver]

Hi,
I want to use a PostgreSQL database with TMS Aurelius.
So I imported my Test-Database with 2 tables and the 2 sequences for autoinc, but the sequences were not imported. I get an error when I try to export the data structure to Aurelius.

So I have to add them manually and configure them in the Export-Settings.
Now I can export the DB as Delphi-Unit.

After that I tried to do the same within Delphi in the Popup-Menu of the TMSAurelius connection, but there I can not manually add the sequence. So I get again the error, that the sequence is missing.

Is this a problem of me, or is PostgreSQL not really supported?

Also I can not use a connection using UniDAC, there is an error: UniDac is not supported at designtime. So I used FireDAC, but I always use UniDAC and not FireDAC. What to do to use UniDAC in DesignTime?

[wlandgraf (Wagner Landgraf)]

PostgreSQL is fully supported, but you have to indicate the sequences for the tables when importing classes from existing database, like you said you did in the Export-Settings.

In the TMS Aurelius connection popup you can simply tell the importer to ignore the sequences, import the tables, and then add the sequences later in the mapping, if needed.

This was discussed in this topic:

EMissingSequenceError problem

Hi Paul, You've hit a very specific situation.First, when the database doesn't support identity/autogenerated columns, Aurelius will require sequences/generators to be associated with each table for id generation. That means that for SQL Server, for example, nothing will happen, but for Firebird 2.5 for example, a generator for a table with an autogenerated id is required. That's why the entity generator asks you that. You can control that in option "Check for missing sequences", in tab "Advance…

Regarding UniDAC, design-time support is not installed by default because it's not a native Delphi component, so not available for everyone. You can install it manually, and it's also discussed here:

Aurelius connection to MySQL via uniDAC at designtime?

To create package, use the Delphi menu File | New | Package: [image] Delphi will create a package, right click Contains folder and choose Add...: [image] Find and choose the Aurelius.Drivers.UniDac.pas file: [image] Then right-click the package name and click Install. You can save the package somewhere in your disk for later usage and recompilation. [image] About Data Modeler, indeed you have to use a x86 version of libmysql.dll file. You can use 5.7 version and the same for MS SQL, y…

[Ickler_Oliver]

Thanks for your fast reply, but ...
I already found the topic with the package, but it does not work for me.
I also added a "ShowMessage" in the registration method, and it is displayed.
Are you sure, this is working in Delphi 12.1?

The topic with the MissingSequence I have noticed, but my question was, why TMS Data Modeler does not import the sequences.

If it does not work, to directly import from the Aurelis Connection, this is ok for me, but I need the feature that the sequences are imported in Data Modeler.

I have a project in VisualStudio with EntityFramework that has much tables.
So, when the datastructure is changed by EF I have to reimport the database. And if I have to set every sequence everytime, this is too much to do.
Therefore I asked about the sequence import, that does not work for me.

[wlandgraf (Wagner Landgraf)]

About the package, try adding the following attached unit to it, so it also registers the design-time support:

Aurelius.Drivers.UniDac.Design.pas (758 Bytes)

@Ickler_Oliver

why TMS Data Modeler does not import the sequences.

Because it doesn't know which sequence belongs to each table.

@Ickler_Oliver

And if I have to set every sequence everytime, this is too much to do.

You can automate this using customization scripts, by setting the sequence names directly from code.

[Ickler_Oliver]

UniDac works correctly now. Thanks for that.

I apologize for asking again, but I want to clarify something. I understand that it doesn't associate the sequences correctly. However, since the sequence names always follow the format "[TableName]_[PrimaryKey]_seq," this could be automated.

The issue I'm facing is that it doesn't import the sequences at all; I always have to create them manually. As I understand it, this is intentional and not a bug, correct?

[wlandgraf (Wagner Landgraf)]

@Ickler_Oliver

However, since the sequence names always follow the format "[TableName]_[PrimaryKey]_seq," this could be automated.

Yes, as I mentioned, you can use customization scripts in Data Module.

@Ickler_Oliver

As I understand it, this is intentional and not a bug, correct?

Correct.