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

[GitHub]

  Branch: refs/heads/postgresql
  Home:   https://github.com/zanata/zanata-server
  Commit: 7e87d2e50cd7ba25c75c83c5a0cdea03ee85942e
      https://github.com/zanata/zanata-server/commit/7e87d2e50cd7ba25c75c83c5a0cdea03ee85942e
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-08-30 (Sun, 30 Aug 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: 70a5155b8ac2d030bd1b56c8c130b2c932f775f3
      https://github.com/zanata/zanata-server/commit/70a5155b8ac2d030bd1b56c8c130b2c932f775f3
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-08-30 (Sun, 30 Aug 2015)

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

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


  Commit: 25e47ac4a1ffa9ab90d09d3d94caffc640b9bbb8
      https://github.com/zanata/zanata-server/commit/25e47ac4a1ffa9ab90d09d3d94caffc640b9bbb8
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-08-30 (Sun, 30 Aug 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: 190e9a9ba1942d577c7eff036a91e8403ff60322
      https://github.com/zanata/zanata-server/commit/190e9a9ba1942d577c7eff036a91e8403ff60322
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-08-30 (Sun, 30 Aug 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: 951357b24515199d5616b03a1538181374fbea04
      https://github.com/zanata/zanata-server/commit/951357b24515199d5616b03a1538181374fbea04
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-08-30 (Sun, 30 Aug 2015)

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

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


  Commit: a762536b8a3e91a82e951dcf51756fe1b65d3e8d
      https://github.com/zanata/zanata-server/commit/a762536b8a3e91a82e951dcf51756fe1b65d3e8d
  Author: Carlos Munoz <chavo16 at hotmail.com>
  Date:   2015-08-30 (Sun, 30 Aug 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: 12cbe5d68872a8169e0cfd072e5eca244d5a9c94
      https://github.com/zanata/zanata-server/commit/12cbe5d68872a8169e0cfd072e5eca244d5a9c94
  Author: Carlos Munoz <chavo16 at hotmail.com>
  Date:   2015-08-30 (Sun, 30 Aug 2015)

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

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


  Commit: 981908bd0c741162289331a6d4692e23cb85f6f9
      https://github.com/zanata/zanata-server/commit/981908bd0c741162289331a6d4692e23cb85f6f9
  Author: Damian Jansen <djansen at redhat.com>
  Date:   2015-08-30 (Sun, 30 Aug 2015)

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

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


  Commit: dfb167337c02df767827c88e2dba84a90ad405f4
      https://github.com/zanata/zanata-server/commit/dfb167337c02df767827c88e2dba84a90ad405f4
  Author: Damian Jansen <djansen at redhat.com>
  Date:   2015-08-30 (Sun, 30 Aug 2015)

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

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


  Commit: 4022c22df3b8e567fd1c0b8a39c994c1e23050d1
      https://github.com/zanata/zanata-server/commit/4022c22df3b8e567fd1c0b8a39c994c1e23050d1
  Author: Carlos A. Munoz <camunoz at redhat.com>
  Date:   2015-08-30 (Sun, 30 Aug 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.


Compare: https://github.com/zanata/zanata-server/compare/bfcb7a471423...4022c22df3b8