Uploaded image for project: 'mod-data-export'
  1. mod-data-export
  2. MDEXP-409

DaoImpl: Use single id methods for get, delete, update

    XMLWordPrintable

Details

    • Firebird Sprint 122
    • 2
    • Firebird

    Description

      Running a PostgreSQL get, delete or update query with a single id should use the primary key id column of the table. The primary key automatically has a search index.

      The DaoImpl uses the id property of the JSON in the jsonb field that doesn't have a search index.

      PostgresClient provides dedicated get, delete and update methods that are faster and easier to use.

      TestRail: Results

        Attachments

          1. file definition GET by id.PNG
            file definition GET by id.PNG
            115 kB
          2. file definition POST.PNG
            file definition POST.PNG
            108 kB
          3. job execution GET by id.PNG
            job execution GET by id.PNG
            112 kB
          4. job execution logs GET all.PNG
            job execution logs GET all.PNG
            105 kB
          5. job profile DELETE.PNG
            job profile DELETE.PNG
            106 kB
          6. job profile GET all.PNG
            job profile GET all.PNG
            110 kB
          7. job profile GET by id.PNG
            job profile GET by id.PNG
            113 kB
          8. job profile POST.PNG
            job profile POST.PNG
            116 kB
          9. job profile PUT (update).PNG
            job profile PUT (update).PNG
            106 kB
          10. mapping profile DELETE.PNG
            mapping profile DELETE.PNG
            106 kB
          11. mapping profile GET all.PNG
            mapping profile GET all.PNG
            122 kB
          12. mapping profile GET by id.PNG
            mapping profile GET by id.PNG
            115 kB
          13. mapping profile POST.PNG
            mapping profile POST.PNG
            119 kB
          14. mapping profile PUT (update).PNG
            mapping profile PUT (update).PNG
            108 kB

          Issue Links

            Activity

              People

                TotoroDev Illia Daliek
                julianladisch Julian Ladisch
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases