Uploaded image for project: 'FOLIO'
  1. FOLIO
  2. FOLIO-1845

Replace postgresql-embedded by testcontainers.org

    XMLWordPrintable

Details

    • CP: ready for planning, CP: Roadmap backlog
    • Core: Platform

    Description

      We cannot upgrade from postgres 10 to postgres 11, 12 or 13 as long as our back-ends still use Postgresql-embedded for unit/integration tests because Postgresql-embedded only supports postgres 9 und 10.

      Postgresql-embedded is is not being actively maintained anymore and recommends to switch to testcontainers.org, see announcement from April 2019: https://github.com/yandex-qatools/postgresql-embedded/commit/0895ad0ad96ff27613bd1e1a351fb329a76fde22

      Vert.x has replaced postgresql-embedded by testcontainers.org for their unit tests eight months before in August 2018:
      https://github.com/vert-x3/vertx-mysql-postgresql-client/commit/16c538947d0e99ba3a66e4c99ccb87c9a972ffbb

      testcontainers.org starts and stops a postgresql docker container.

      postgresql-embedded does NOT support Linux x86-64, Linux x86-32, Windows x86-32 for PostgreSQL >= 11.
      References:
      https://github.com/yandex-qatools/postgresql-embedded/commit/15685611972bacd8ba61dd7f11d4dbdcb3ba8dc1
      https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

      Okapi has succesfully implemented postgres testcontainers.org containers for the SSL tests (OKAPI-787, pull request), this works fine in Jenkins.

      General Docker requirements of testcontainers.org: https://www.testcontainers.org/supported_docker_environment/
      Windows Docker requirements of testcontainers.org: https://www.testcontainers.org/supported_docker_environment/windows/

      TestRail: Results

        Attachments

          Issue Links

            blocks

            New Feature - New feature requests FOLIO-2144 Upgrade to PostgreSQL 11

            • TBD - To be determined
            • Closed

            New Feature - New feature requests FOLIO-2145 Upgrade to PostgreSQL 12

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            is blocked by

            Task - A task that needs to be done. CQLPG-100 Replace postgresql-embedded by testcontainers.org

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Task - A task that needs to be done. OKAPI-825 Switch from postgresql-embedded to testcontainers

            • P2 - normal priority level, must be included in the current development cycle
            • Closed
            is duplicated by

            Task - A task that needs to be done. RMB-483 TestContainers instead of postgresql-embedded

            • P2 - normal priority level, must be included in the current development cycle
            • Closed
            is required by

            Task - A task that needs to be done. RMB-789 Remove support of EmbeddedPostgres

            • P2 - normal priority level, must be included in the current development cycle
            • Closed
            relates to

            Task - A task that needs to be done. OKAPI-971 Fail unit tests if docker is not available (needed for testcontainers)

            • TBD - To be determined
            • Closed

            Task - A task that needs to be done. FOLIO-1955 Create databases using und-x-icu collation

            • P2 - normal priority level, must be included in the current development cycle
            • Open

            Task - A task that needs to be done. FOLIO-3118 SPIKE: testcontainers and Vagrant

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODCAT-194 New embedded Postgres release to create a test db

            • TBD - To be determined
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODINVSTOR-369 Unit tests may hang when using Embedded Postgres

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Task - A task that needs to be done. MODPWD-49 Discover tools/libraries to support PostgreSQL DB in Spring integration tests

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Task - A task that needs to be done. RMB-317 Error message about embedded Postgres under Alpine

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            mentioned in

            Page Loading...

            Activity

              People

                Unassigned Unassigned
                julianladisch Julian Ladisch
                Votes:
                0 Vote for this issue
                Watchers:
                11 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases