Page History

...

• 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
      server FOLIO Issue Tracker serverId 6ccf3fe4-3301-368a-983e-20c466b11a49 key RMB-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
      server FOLIO Issue Tracker serverId 6ccf3fe4-3301-368a-983e-20c466b11a49 key RMB-374

  • Change saveBatch method. For now, it doesn’t work with ids in the table.

    • Is this 

      Jira
      server FOLIO Issue Tracker serverId 6ccf3fe4-3301-368a-983e-20c466b11a49 key RMB-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.

...