[zanata/zanata-server] d57950: Add a postgresql baseline.

Fri Sep 18 03:27:18 UTC 2015

  Branch: refs/heads/postgresql
  Home:   https://github.com/zanata/zanata-server
  Commit: d57950fda1e2d67ff11b8bec9f68b4955a3cfa5d
      https://github.com/zanata/zanata-server/commit/d57950fda1e2d67ff11b8bec9f68b4955a3cfa5d
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-18 (Fri, 18 Sep 2015)

  Changed paths:
    M zanata-model/src/main/java/org/zanata/model/HAccountRole.java
    A zanata-war/src/main/resources/db/postgresql/postgresql_baseline.sql

  Log Message:
  -----------
  Add a postgresql baseline.

Also change generation type on the ModelEntity base to suit postgresql's generators.

  Commit: 3113c604d5a7699be22bb9e6d21ce26a86b441a9
      https://github.com/zanata/zanata-server/commit/3113c604d5a7699be22bb9e6d21ce26a86b441a9
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-18 (Fri, 18 Sep 2015)

  Changed paths:
    M zanata-war/src/main/resources/db/postgresql/postgresql_baseline.sql

  Log Message:
  -----------
  Change smallint and bits to not null

  Commit: 07f9ce534a41500bce29332f2f67740b2fd77b36
      https://github.com/zanata/zanata-server/commit/07f9ce534a41500bce29332f2f67740b2fd77b36
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-18 (Fri, 18 Sep 2015)

  Changed paths:
    M zanata-model/src/main/java/org/zanata/model/HDocumentHistory.java
    M zanata-model/src/main/java/org/zanata/model/HDocumentUploadPart.java
    M zanata-model/src/main/java/org/zanata/model/HPersonEmailValidationKey.java
    M zanata-model/src/main/java/org/zanata/model/HSimpleComment.java
    M zanata-model/src/main/java/org/zanata/model/HTermComment.java
    M zanata-model/src/main/java/org/zanata/model/HTextFlow.java
    M zanata-model/src/main/java/org/zanata/model/HTextFlowHistory.java
    M zanata-model/src/main/java/org/zanata/model/HTextFlowTargetHistory.java
    M zanata-model/src/main/java/org/zanata/model/ModelEntityBase.java
    M zanata-model/src/main/java/org/zanata/model/WebHook.java
    M zanata-model/src/main/java/org/zanata/model/po/HPotEntryData.java

  Log Message:
  -----------
  Make JPA keys Identity generated.

  Commit: 42bf46d091b04eaf00fb9e32cc84be4168a18775
      https://github.com/zanata/zanata-server/commit/42bf46d091b04eaf00fb9e32cc84be4168a18775
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-18 (Fri, 18 Sep 2015)

  Changed paths:
    A zanata-war/src/main/resources/db/postgresql/mysql2postgresql.sh

  Log Message:
  -----------
  Add a script able to create postgresql 'compatible' dumps.

  Commit: 677f5c235acd06d8c0fad1d43ab82e81035e6c51
      https://github.com/zanata/zanata-server/commit/677f5c235acd06d8c0fad1d43ab82e81035e6c51
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-18 (Fri, 18 Sep 2015)

  Changed paths:
    A zanata-war/etc/scripts/Mysql2Postgresql.groovy

  Log Message:
  -----------
  Add migration script from mysql to postgresql

  Commit: 8df81b7714bed408ba19e1933877fb2ba649c95b
      https://github.com/zanata/zanata-server/commit/8df81b7714bed408ba19e1933877fb2ba649c95b
  Author: Carlos Munoz <chavo16 at hotmail.com>
  Date:   2015-09-18 (Fri, 18 Sep 2015)

  Changed paths:
    R zanata-war/src/main/resources/db/postgresql/mysql2postgresql.sh
    M zanata-war/src/main/resources/db/postgresql/postgresql_baseline.sql

  Log Message:
  -----------
  Add triggers to postgresql baseline.

Also remove unnecessary data migration script.

  Commit: b73dccf0e158b468a3eaefdfaee5620bd40d981b
      https://github.com/zanata/zanata-server/commit/b73dccf0e158b468a3eaefdfaee5620bd40d981b
  Author: Carlos Munoz <chavo16 at hotmail.com>
  Date:   2015-09-18 (Fri, 18 Sep 2015)

  Changed paths:
    M zanata-war/src/main/java/org/zanata/dao/DocumentDAO.java

  Log Message:
  -----------
  Adapt native queries to postgresql.

  Commit: 9e97b8a227a258545ac1c9f5b1ee36736c65f279
      https://github.com/zanata/zanata-server/commit/9e97b8a227a258545ac1c9f5b1ee36736c65f279
  Author: Damian Jansen <djansen at redhat.com>
  Date:   2015-09-18 (Fri, 18 Sep 2015)

  Changed paths:
    M zanata-war/etc/scripts/Mysql2Postgresql.groovy

  Log Message:
  -----------
  fix(postgres-script): Show usage on no options given

  Commit: 9517ba6bdd2f99ad907c659402d6ed521762b6bb
      https://github.com/zanata/zanata-server/commit/9517ba6bdd2f99ad907c659402d6ed521762b6bb
  Author: Damian Jansen <djansen at redhat.com>
  Date:   2015-09-18 (Fri, 18 Sep 2015)

  Changed paths:
    M zanata-war/etc/scripts/Mysql2Postgresql.groovy

  Log Message:
  -----------
  fix(postgres-script): Don't print null or exceptions

  Commit: d3af486cc8e87e66783908680c4df3305cef4670
      https://github.com/zanata/zanata-server/commit/d3af486cc8e87e66783908680c4df3305cef4670
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-18 (Fri, 18 Sep 2015)

  Changed paths:
    M zanata-war/src/main/java/org/zanata/dao/DocumentDAO.java
    M zanata-war/src/main/java/org/zanata/dao/TextFlowTargetHistoryDAO.java
    A zanata-war/src/main/java/org/zanata/util/query/H2NativeQueryHelper.java
    A zanata-war/src/main/java/org/zanata/util/query/MysqlNativeQueryHelper.java
    A zanata-war/src/main/java/org/zanata/util/query/NativeQueryHelper.java
    A zanata-war/src/main/java/org/zanata/util/query/NativeQueryHelperFactory.java
    A zanata-war/src/main/java/org/zanata/util/query/PostgresqlNativeQueryHelper.java
    M zanata-war/src/test/java/org/zanata/dao/DocumentDAOTest.java
    M zanata-war/src/test/java/org/zanata/service/impl/ActivityServiceImplTest.java
    M zanata-war/src/test/java/org/zanata/service/impl/CopyVersionServiceImplTest.java
    M zanata-war/src/test/java/org/zanata/service/impl/TextFlowSearchServiceImplTest.java
    A zanata-war/src/test/java/org/zanata/util/query/NativeQueryHelperTest.java
    M zanata-war/src/test/java/org/zanata/webtrans/server/rpc/GetTransUnitListHandlerTest.java

  Log Message:
  -----------
  Add classes to take care of native SQL fragments.

  Commit: 776af3f327d59b59e004d302533b051bcf1bf52c
      https://github.com/zanata/zanata-server/commit/776af3f327d59b59e004d302533b051bcf1bf52c
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-18 (Fri, 18 Sep 2015)

  Changed paths:
    M zanata-war/src/main/java/org/zanata/dao/TextFlowTargetHistoryDAO.java

  Log Message:
  -----------
  Add classes to take care of native SQL fragments.

  Commit: 0a55c91cf27ab56fc6cd929abf5d56db3aca468a
      https://github.com/zanata/zanata-server/commit/0a55c91cf27ab56fc6cd929abf5d56db3aca468a
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-18 (Fri, 18 Sep 2015)

  Changed paths:
    M zanata-model/src/main/java/org/zanata/model/HProjectIteration.java
    M zanata-war/src/main/java/org/zanata/dao/TextFlowDAO.java
    M zanata-war/src/main/java/org/zanata/dao/TextFlowTargetHistoryDAO.java
    M zanata-war/src/main/java/org/zanata/search/FilterConstraintToQuery.java
    M zanata-war/src/main/java/org/zanata/util/query/H2NativeQueryHelper.java
    M zanata-war/src/test/java/org/zanata/dao/TextFlowTargetHistoryDAOTest.java
    M zanata-war/src/test/java/org/zanata/model/HTextFlowTargetHistoryJPATest.java
    M zanata-war/src/test/java/org/zanata/util/query/NativeQueryHelperTest.java

  Log Message:
  -----------
  Use native query helpers where necessary.

Also change hql queries to be compatible with Postgresql.

  Commit: 878ba13fb2729b1be67a05acac8f36adc21f9a4b
      https://github.com/zanata/zanata-server/commit/878ba13fb2729b1be67a05acac8f36adc21f9a4b
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-18 (Fri, 18 Sep 2015)

  Changed paths:
    M zanata-model/src/main/java/org/zanata/model/HProjectIteration.java
    A zanata-war/src/main/java/org/zanata/database/CustomPostgreSQLDialect.java
    M zanata-war/src/main/webapp-jboss/WEB-INF/classes/META-INF/persistence.xml
    M zanata-war/src/test/java/org/zanata/database/CustomH2Dialect.java

  Log Message:
  -----------
  Add custom Postgresql dialect

Some things don't work quite right with the out-of-the-box dialect.
For example 'true' and 'false' are not considered keywords.

  Commit: 6be0033ab7a7c7ca7bedfdb366ada7cd837775a8
      https://github.com/zanata/zanata-server/commit/6be0033ab7a7c7ca7bedfdb366ada7cd837775a8
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-18 (Fri, 18 Sep 2015)

  Changed paths:
    M zanata-war/etc/scripts/Mysql2Postgresql.groovy
    M zanata-war/src/main/resources/db/changelogs/db.changelog-3.8.xml
    M zanata-war/src/main/resources/db/db.changelog.xml
    M zanata-war/src/main/resources/db/postgresql/postgresql_baseline.sql

  Log Message:
  -----------
  Modify liquibase changesets for Postgresql.

Add validation changesets that check for the right state of the database
before an upgrade to Postgresql.
Add a baseline sql script for Postgresql.

  Commit: 57d0f1d7cd27361127caf5dcce40030fffb81591
      https://github.com/zanata/zanata-server/commit/57d0f1d7cd27361127caf5dcce40030fffb81591
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-18 (Fri, 18 Sep 2015)

  Changed paths:
    M functional-test/pom.xml
    M pom.xml

  Log Message:
  -----------
  Modify functional tests so it doesn't expect mysql

Remove plugins that start an embedded mysql instance.
It now expects a Postgresql database already running.

  Commit: d09a2b51a11b450bbcf49394d409af145ee450b9
      https://github.com/zanata/zanata-server/commit/d09a2b51a11b450bbcf49394d409af145ee450b9
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-18 (Fri, 18 Sep 2015)

  Changed paths:
    M etc/scripts/cargowait.sh
    A functional-test/etc/start-postgresql-container.sh
    A functional-test/etc/stop-postgresql-container.sh
    M functional-test/pom.xml

  Log Message:
  -----------
  Start a docker postgresql container for FTs.

Requires the docker daemon service to be
running, and the preferably the postgres
docker image to be locally available.

  Commit: 661cf726d3e429ef81ff96a9a37447e0b81211c6
      https://github.com/zanata/zanata-server/commit/661cf726d3e429ef81ff96a9a37447e0b81211c6
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-18 (Fri, 18 Sep 2015)

  Changed paths:
    M functional-test/etc/start-postgresql-container.sh
    M functional-test/etc/stop-postgresql-container.sh
    M functional-test/pom.xml
    M pom.xml

  Log Message:
  -----------
  Downgrade postgresql dependency for jdk1.7 compatibility.

Correct checkstyle violations.
Make docker run with sudo.

  Commit: dc8a85e10b92239f2627955f42a51bfd6dcc9c26
      https://github.com/zanata/zanata-server/commit/dc8a85e10b92239f2627955f42a51bfd6dcc9c26
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-18 (Fri, 18 Sep 2015)

  Changed paths:
    M functional-test/etc/start-postgresql-container.sh
    M functional-test/etc/stop-postgresql-container.sh

  Log Message:
  -----------
  Remove pg docker container after functional tests

  Commit: 10bd2f546550cb62ea16ea86b2d1097e602aa53e
      https://github.com/zanata/zanata-server/commit/10bd2f546550cb62ea16ea86b2d1097e602aa53e
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-18 (Fri, 18 Sep 2015)

  Changed paths:
    M zanata-war/src/main/java/org/zanata/dao/TextFlowTargetHistoryDAO.java
    M zanata-war/src/test/java/org/zanata/search/FilterConstraintToQueryTest.java

  Log Message:
  -----------
  Fix integration tests.

  Commit: 6f7c24d85f1cf895590ccdb22f54e8f602f93008
      https://github.com/zanata/zanata-server/commit/6f7c24d85f1cf895590ccdb22f54e8f602f93008
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-18 (Fri, 18 Sep 2015)

  Changed paths:
    M functional-test/etc/start-postgresql-container.sh
    A zanata-liquibase/src/main/java/liquibase/ext/CustomPostgresDatabase.java
    M zanata-war/src/main/resources/db/postgresql/postgresql_baseline.sql

  Log Message:
  -----------
  Ensure liquibase doesn't quote table or column names.

Also give some time to the container database to
come up before running tests.

Compare: https://github.com/zanata/zanata-server/compare/3d174b875a2e...6f7c24d85f1c