Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: RMB-388 PostgresClient.getById with transaction

...

  • Refactoring of the RMB's PostgresClient and add a couple of new methods for updating with blocking, transactions and loading records with the blocking of the record itself in the scope of the transaction
    • Create a single approach to query data from the database. For now get, save, update, delete methods at PostgresClient have different query mechanisms: CQLWrapper, Criterion, UUID. Need to create a wrapper for the querying functionality or encapsulate this logic.

    • Add a possibility to run custom SQL with “SELECT” statements.

      • Use one of the PostgresClient.select methods.
    • Add methods for an update with row blocking in the table.

      • There are several non-transactional update methods and two transactional update methods. Please file an issue against RMB for each missing transactional update method that you need.
      • Jira
        serverFOLIO Issue Tracker
        serverId6ccf3fe4-3301-368a-983e-20c466b11a49
        keyRMB-388
    • Add batchUpdate method

      • There are 9 update methods. Please file an issue against RMB for each single method that you need with batch capability.
      • Jira
        serverFOLIO Issue Tracker
        serverId6ccf3fe4-3301-368a-983e-20c466b11a49
        keyRMB-374
    • Change saveBatch method. For now, it doesn’t work with ids in the table.

      • Is this 
        Jira
        serverFOLIO Issue Tracker
        serverId6ccf3fe4-3301-368a-983e-20c466b11a49
        keyRMB-204
        what you need? If not please file an issue against RMB for each single method that you need.
    • Create a transaction helper for PostgresClient similar to rxjava 2 SQLClientHelper (PostgresClient doesn't support rxjava2, but creating a similar helper is straightforward).
  • Investigate the possibility of using other database tools. Conduct a study on the compatibility of the vert.x framework and existing solutions for the database, perhaps even synchronous solutions.

...