Database plugin version 2.2

Started by Hervé, October 12, 2019, 16:58:29 PM

Previous topic - Next topic

Hervé

Dear all,

I just released the version 2.2 of my database plugin (https://github.com/archi-contribs/database-plugin/tree/master/v2).

The key updates are:

  • Rewrite of the export process
  • Rewrite of the conflict management process
  • Remove the "Relationship" suffix on the relationships names during Neo4J exports
  • Fix number of model components during export when components are updated or deleted from the database
  • Fix the export of an existing database model when opened from archimate file
  • Remember the import database and set it as the default export database
  • Ask the database password during connection if not provided in the preferences
  • fix tablename case for Microsoft SQL Server databases
  • Add welcome message
  • Update the JDBC drivers

         
    • MySQL --> 8.0.17
    • Neo4J --> 3.4.0
    • PostGreSQL --> 42.2.6
    • SQLite --> 3.27.2.1

This version of the plugin has been tested with Archi 4.4 and 4.5.

Best regards
Hervé

Hervé

Dear all,

I just released the version 2.2.1 of my database plugin (https://github.com/archi-contribs/database-plugin/tree/master/v2).

The key updates are:

  • Fix plugin version in windows title
  • Fix count of model's components during export
  • Fix unnecessary double export of view components
  • Do not compare twice the model to the database if there have been no import
  • Create first admin procedures
  • Rollback MySQL driver to 5.1.48 because of timezone error (https://bugs.mysql.com/bug.php?id=90813)

Best regards
Hervé

Hervé

Dear all,

I just released the version 2.2.2 of my database plugin (https://github.com/archi-contribs/database-plugin/tree/master/v2).

The key updates are :

  • Update database structure to be compliant with Archi 4.6
  • GUI improvement

         
    • Add last export date to the models table on the import window
    • Add a progress bar during a database comparison
  • Performance improvement

         
    • Do not try to import properties, features and bendpoints if not necessary
    • Drastically increase the performance when comparing a model against a database
  • Security improvement

         
    • The database password is not printed in clear text in preference window by default
    • The database password is not stored in clear text anymore in the preference store

Best regards
Hervé

geoffrey

#3
Hi Hervé

I haven't been doing a lot of things with Archi or your plugin at the moment, other then keeping current with the latest versions of both.

When I click on the Check For Update button in the Settings of the Database Plugin, a message thrown:

Did not find any org.archicontribs.database JAR file.

Something else I noticed is that the download from GitHub has "*.archicontribs" as the extension, where the Archi Plugin Manager by default expects a "*.archiplugin" or "*.zip".

I upgraded without any issues from 2.2.1 to 2.2.2 (on MacOS Catalina) using the Manage Plug-Ins of Archi, but perhaps this information is useful for you.

Thank you for all the work.

Best regards

Hervé

Hi Geoffrey,

Regarding the ".archicontribs" extension, you might have been very quick because I realised my mistake and renamed the extension 3 minutes after uploading the plugin. The correct extension for Archi 4.5 is ".zip" and for Archi 4.6 is ".archiplugin". This extension is effectively made to ease the use of Archi's plugin management that I use myself.

Regarding your error message when you click on the "check for update" button, could you please switch the plugin's logger level to "trace" and open a new issue entry on GitHub with the extract of the generated log file that includes the Java exception ?

Thanks and regards
Hervé

Hervé

Dear all,

I just release the version 2.2.3 of my database plugin (https://github.com/archi-contribs/database-plugin/tree/master/v2

The key updates are:

  • Reduce the number of SQL request to speed up the export / import process
  • Fix the get history from database
  • Fix the Neo4J JDBC connection string
  • Fix directed view connections export

Best regards
Hervé