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

Thu Sep 17 05:23:36 UTC 2015

  Branch: refs/heads/postgresql
  Home:   https://github.com/zanata/zanata-server
  Commit: bdc7175e0ff08a2e005bae59d8ad833640fe9e4a
      https://github.com/zanata/zanata-server/commit/bdc7175e0ff08a2e005bae59d8ad833640fe9e4a
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-17 (Thu, 17 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: 6cf5694cc9b00d5c3a8bfc15e0969c149f66136a
      https://github.com/zanata/zanata-server/commit/6cf5694cc9b00d5c3a8bfc15e0969c149f66136a
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-17 (Thu, 17 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: 992d412a017ad9ff221c72894246d19069f5db81
      https://github.com/zanata/zanata-server/commit/992d412a017ad9ff221c72894246d19069f5db81
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-17 (Thu, 17 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: f01a37c749bd2e4aab100d203eaf5b4ab7143d43
      https://github.com/zanata/zanata-server/commit/f01a37c749bd2e4aab100d203eaf5b4ab7143d43
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-17 (Thu, 17 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: f81c07a6dbbf17a65f30e898d389fa743ea1d823
      https://github.com/zanata/zanata-server/commit/f81c07a6dbbf17a65f30e898d389fa743ea1d823
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-17 (Thu, 17 Sep 2015)

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

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

  Commit: 9e90e50424b390034f8bb49e463dbc5acdae7d2f
      https://github.com/zanata/zanata-server/commit/9e90e50424b390034f8bb49e463dbc5acdae7d2f
  Author: Carlos Munoz <chavo16 at hotmail.com>
  Date:   2015-09-17 (Thu, 17 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: e0c20b7398bf1435e982200dd80f58b44bb7dc09
      https://github.com/zanata/zanata-server/commit/e0c20b7398bf1435e982200dd80f58b44bb7dc09
  Author: Carlos Munoz <chavo16 at hotmail.com>
  Date:   2015-09-17 (Thu, 17 Sep 2015)

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

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

  Commit: 45830048abafd5ac417956398358c9061b863fc1
      https://github.com/zanata/zanata-server/commit/45830048abafd5ac417956398358c9061b863fc1
  Author: Damian Jansen <djansen at redhat.com>
  Date:   2015-09-17 (Thu, 17 Sep 2015)

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

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

  Commit: 90a13448438d6160a100c268f33424e49e15851b
      https://github.com/zanata/zanata-server/commit/90a13448438d6160a100c268f33424e49e15851b
  Author: Damian Jansen <djansen at redhat.com>
  Date:   2015-09-17 (Thu, 17 Sep 2015)

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

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

  Commit: e99cae920de9ef69befd41b83f72d14e66214895
      https://github.com/zanata/zanata-server/commit/e99cae920de9ef69befd41b83f72d14e66214895
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-17 (Thu, 17 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: 06168dbb20446b4034455f7d2ad6adbe86f217f4
      https://github.com/zanata/zanata-server/commit/06168dbb20446b4034455f7d2ad6adbe86f217f4
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-17 (Thu, 17 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: 37d1ec582ed39a8c46c2c2012a1dc6cfe1a6d1dd
      https://github.com/zanata/zanata-server/commit/37d1ec582ed39a8c46c2c2012a1dc6cfe1a6d1dd
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-17 (Thu, 17 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: 97088f239376b9e287f4b83cc5e6f8857c2548cd
      https://github.com/zanata/zanata-server/commit/97088f239376b9e287f4b83cc5e6f8857c2548cd
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-17 (Thu, 17 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: 9d05b7773d51788cf19c2f3b8b75ede25a1e8bb8
      https://github.com/zanata/zanata-server/commit/9d05b7773d51788cf19c2f3b8b75ede25a1e8bb8
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-17 (Thu, 17 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: 1ba5bf9fba4ffe9269ad27f867f121c136f7ec7e
      https://github.com/zanata/zanata-server/commit/1ba5bf9fba4ffe9269ad27f867f121c136f7ec7e
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-17 (Thu, 17 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: 241b0dec362742a0cbe1f1de53ff681120f861cf
      https://github.com/zanata/zanata-server/commit/241b0dec362742a0cbe1f1de53ff681120f861cf
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-17 (Thu, 17 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: 472a4096641cd909dddb26fa103f4fc606bf3cbc
      https://github.com/zanata/zanata-server/commit/472a4096641cd909dddb26fa103f4fc606bf3cbc
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-17 (Thu, 17 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: d21cd232c037de441a28378310be55dce3b1d315
      https://github.com/zanata/zanata-server/commit/d21cd232c037de441a28378310be55dce3b1d315
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-09-17 (Thu, 17 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

Compare: https://github.com/zanata/zanata-server/compare/89050d5dc505...d21cd232c037