[
https://issues.apache.org/jira/browse/AIRAVATA-2938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Marcus Christie resolved AIRAVATA-2938.
---------------------------------------
Resolution: Fixed
> Change DB initialization in Registry server to use registry-refactoring code
> ----------------------------------------------------------------------------
>
> Key: AIRAVATA-2938
> URL: https://issues.apache.org/jira/browse/AIRAVATA-2938
> Project: Airavata
> Issue Type: Bug
> Reporter: Marcus Christie
> Assignee: Marcus Christie
> Priority: Major
> Attachments: app_catalog_diff.sql, credential_store_diff.sql,
> experiment_catalog_diff.sql, profile_service_diff.sql,
> replica_catalog_diff.sql, sharing_catalog_diff.sql
>
>
> TODO
> * [x] Move DB intialization code to airavata-commons. Code in registry-core
> is duplicated in airavata-sharing-registry-server and
> airavata-credential-store.
> ** Don't need a connection pool (JdbcStorage) for initializing a database
> ** Single DBInitializer class that takes a config object with JDBC properties
> etc.
> ** Each database has its own initialization class that can also have a
> postInit method to do any database setup
> * [x] Update distribution bin assembly to include db scripts from
> registry-refactoring
> * [x] Update RegistryAPIServer to call DBInitializers from
> registry-refactoring
> * [x] code cleanup: DatabaseCreator copies
> ** (/) CredentialStoreInitUtil
> ** (/) orchestrator-core Initialize
> ** (/) registry-refactoring: expcatalog Initialize.java
> ** (/) registry-refactoring: replicacatalog Initialize.java
> ** (/) registry-refactoring: workflowcatalog Initialize.java
> ** -registry-core: appcatalog Initailize.java- registry-core is deprecated so
> no need to convert these
> ** -registry-core: expcatalog Initialize.java-
> ** -registry-core: replicacatalog Initialize.java-
> ** (/) registry-server: appcatalog AppCatalogInitUtil
> ** (/) registry-server: DatabaseCreator
> ** (/) registry-server: ExpCatalogInitUtil
> ** (/) registry-server: ReplicaCatalogInitUtil
> ** (/) registry-server: WorkflowCatalogInitUtil
> ** (/) sharing-registry-server: JPAUtils
> ** (/) sharing-registry-server: Initialize
> ** -registry-tool: DBMigrator- not going to touch this now
> ** (/) gfac-service: Initialize
> * [x] code cleanup: DBInitializer copies
> ** (/) profile-service-commons: Utils.java
> ** (/) CredentialStoreInitiUtil
> ** -registry-core: Utils- registry-core is deprecated so no need to convert
> * [x] code cleanup: DerbyUtils.java copies
> ** AiravataDerbyServer
> ** other locations listed in above lists
> * [x] code cleanup: Merge DerbyUtils.java and DerbyDBManager.java
> * [x] run a DB schema diff between a clean database initialized by these
> refactored scripts and a live existing Airavata develop database
> (dbdev.scigap.org)
> * [x] move Derby start code out of DBInitializer?
> * [x] Factor out EntityManagerFactory creation code from AppCatalogJPAUtils
> and use for all databases
> * [x] turn off the feature in OpenJPA where it adds missing columns/tables
> automatically. Instead we'll require DB scripts, migration scripts.
> * [x] rerun DB schema diff after running migration scripts on live develop
> database
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
