[
http://mifosforge.jira.com/browse/MIFOS-4220?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=64218#action_64218
]
Mifos Hudson Jira Plugin User commented on MIFOS-4220:
------------------------------------------------------
Integrated in !http://ci.mifos.org/hudson/images/16x16/red.png! [head-master
#2792|http://ci.mifos.org/hudson/job/head-master/2792/]
[MIFOS-4220] Db upgrade validation during server start
[MIFOS-4220] Liquibase Db upgrade on tomcat start up
[MIFOS-4220] Dataset upgrade using Liquibase
[MIFOS-4220] Simplified DB management across different modules
[MIFOS-4220] Added support for packaging DB module artifacts inside the mifos
assembly
[MIFOS-4220] Baselining Elsie-F upgrades into base-schema.sql and
base-data.sql. Using mifos-db support for acceptance tests
[MIFOS-4220] Decommissioning NSDU
Vinod :
[be5af77bc58ac04d6fa6695e335930c648778877|http://mifos.git.sourceforge.net/git/gitweb.cgi?p=mifos/head&a=commit&h=be5af77bc58ac04d6fa6695e335930c648778877]
Files :
* application/src/main/webapp/WEB-INF/web-app-config.xml
* db/src/main/resources/META-INF/spring/DbUpgradeContext.xml
* db/src/main/resources/META-INF/MANIFEST.MF
* db/src/main/java/org/mifos/db/upgrade/ResourceOpener.java
* db/src/main/resources/sql/base-schema.sql
*
application/src/main/java/org/mifos/framework/persistence/DatabaseInitFilter.java
* db/src/main/changesets/changelog-Elsie_F.xml
* db/pom.xml
* db/src/test/java/org/mifos/db/upgrade/DbUpgradeIntegrationTest.java
* db/src/main/sql/base-data.sql
* db/src/test/java/org/mifos/db/upgrade/DbUpgradeTest.java
* db/src/main/resources/changesets/changelog-Elsie_F.xml
*
application/src/test/java/org/mifos/framework/persistence/DatabaseInitFilterTest.java
* application/src/main/java/org/mifos/framework/ApplicationInitializer.java
* db/src/test/resources/test-dbContext.xml
* db/src/main/resources/changesets/changelog-master.xml
* db/src/main/resources/sql/base-data.sql
* pom.xml
* db/src/main/sql/base-schema.sql
* db/src/main/java/org/mifos/db/upgrade/DbUpgradeValidationResult.java
* db/src/main/resources/liquibase.properties
* application/pom.xml
* db/src/test/resources/integrationDatabase.properties
* db/src/main/java/org/mifos/db/upgrade/DbUpgrade.java
* db/src/main/changesets/changelog-master.xml
Vinod :
[6625da01078f54882a60d2adc36a73523c68268f|http://mifos.git.sourceforge.net/git/gitweb.cgi?p=mifos/head&a=commit&h=6625da01078f54882a60d2adc36a73523c68268f]
Files :
*
application/src/main/java/org/mifos/framework/persistence/DatabaseInitFilter.java
* db/src/test/java/org/mifos/db/upgrade/DbUpgradeTest.java
*
application/src/main/java/org/mifos/framework/persistence/DatabaseMigrator.java
* application/src/main/java/org/mifos/framework/ApplicationInitializer.java
* db/src/main/java/org/mifos/db/upgrade/DbUpgrade.java
* db/pom.xml
Vinod :
[48f2b208b945282309969394791d52d522f6b130|http://mifos.git.sourceforge.net/git/gitweb.cgi?p=mifos/head&a=commit&h=48f2b208b945282309969394791d52d522f6b130]
Files :
* db/src/test/java/org/mifos/db/upgrade/DbUpgradeIntegrationTest.java
* db/src/test/java/org/mifos/db/upgrade/DbUpgradeTest.java
*
acceptanceTests/src/test/resources/dataSets/UndoLoanDisbursal_001_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/ClientLoanStatusHistory_002_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/AdditionalHolidayTest_009_result_dbunit.xml
* application/src/test/java/org/mifos/framework/util/DataSetUpgradeUtil.java
*
acceptanceTests/src/test/resources/dataSets/ClientLoanTransactionHistory_001_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/SavingsDeposit_001_result_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/acceptance_small_001_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/ClientLoanStatusHistory_005_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/AdditionalHolidayTest_010_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/ColSheetCustAcct_001_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/DefineNewSavingsProduct_004_result_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/acceptance_small_008_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/AdditionalHolidayTest_004_result_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/acceptance_small_016_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/ClientLoanStatusHistory_003_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/AdditionalHolidayTest_005_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/AdditionalHolidayTest_011_result_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/acceptance_small_005_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/AdditionalHolidayTest_013_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/ClientLoanRepaymentPeriodTest_002_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/AdditionalHolidayTest_007_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/ClientLoanStatusHistory_001_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/CreateLoanScheduleWithMoratorium_002_result_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/acceptance_small_013_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/FeeTest_002_result_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/acceptance_small_010_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/RedoLoanDisbursalTest_001_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/DefineNewSavingsProduct_003_result_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/acceptance_small_007_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/acceptance_small_012_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/PenaltyTest_002_result_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/FeeTest_001_result_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/acceptance_default_003_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/ClientLoanStatusChange_005_result_dbunit.xml
* db/src/main/java/org/mifos/db/upgrade/DbUpgrade.java
*
acceptanceTests/src/test/resources/dataSets/DefineNewSavingsProduct_005_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/ClientLoanStatusChange_001_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/ImportTransactions_001_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/ClientLoanStatusChange_002_result_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/acceptance_small_011_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/acceptance_small_004_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/ClientLoanStatusChange_004_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/CreateLoanScheduleWithMoratorium_001_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/AdditionalHolidayTest_012_result_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/acceptance_small_002_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/ColSheetLoanTest_001_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/DefineNewSavingsProduct_006_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/ClientLoanDisbursalTest_001_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/ClientLoanStatusHistory_007_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/ImportTransactions_002_result_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/acceptance_small_006_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/AdditionalHolidayTest_001_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/ClientLoanStatusHistory_006_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/AdditionalHolidayTest_008_result_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/HolidayTest_001_result_dbunit.xml
* db/src/main/resources/changesets/changelog-master.xml
*
acceptanceTests/src/test/resources/dataSets/DefineNewSavingsProduct_002_result_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/acceptance_small_003_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/acceptance_medium_005_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/DefineNewSavingsProduct_001_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/AdditionalHolidayTest_003_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/AdditionalHolidayTest_002_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/UndoLoanDisbursal_002_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/ClientLoanStatusHistory_004_result_dbunit.xml
* db/src/main/resources/changesets/changelog-Elsie_F.xml
* acceptanceTests/src/test/resources/dataSets/PenaltyTest_001_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/AdditionalHolidayTest_006_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/ClientLoanRepaymentPeriodTest_003_result_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/acceptance_small_009_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/LoanProcessWithDifferentCurrencyTest_001_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/acceptance_small_015_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/ClientLoanStatusChange_003_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/LoanAccountPerformanceHistoryTest_001_result_dbunit.xml
* acceptanceTests/src/test/resources/dataSets/acceptance_small_014_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/ClientLoanRepaymentPeriodTest_001_result_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/LoanProcessWithDifferentCurrencyTest_002_dbunit.xml
*
acceptanceTests/src/test/resources/dataSets/SavingsPerformanceHistory_001_dbunit.xml
Vinod :
[cd997bce10b8e1cb707e4120227b59eb9584e04c|http://mifos.git.sourceforge.net/git/gitweb.cgi?p=mifos/head&a=commit&h=cd997bce10b8e1cb707e4120227b59eb9584e04c]
Files :
* cashflow/pom.xml
* application/pom.xml
* pom.xml
* db/pom.xml
* questionnaire/pom.xml
* db/src/test/sql/test-data.sql
Vinod :
[0c8f17793d29a5a19e648790161b45f209de4a4b|http://mifos.git.sourceforge.net/git/gitweb.cgi?p=mifos/head&a=commit&h=0c8f17793d29a5a19e648790161b45f209de4a4b]
Files :
* db/deploy/liquibase.sh
* db/src/test/sql/init_mifos_password.sql
* application/src/main/assembly/release.xml
* db/deploy/lib/liquibase.jar
* db/deploy/liquibase.bat
Vinod :
[ca70daa67d652e83a7413aa423900f5699ae4402|http://mifos.git.sourceforge.net/git/gitweb.cgi?p=mifos/head&a=commit&h=ca70daa67d652e83a7413aa423900f5699ae4402]
Files :
* db/src/main/resources/sql/base-schema.sql
* db/src/test/sql/test-data.sql
* db/src/test/resources/sql/acceptance_test_data.sql
* application/pom.xml
* acceptanceTests/pom.xml
* db/src/test/resources/sql/init_mifos_password.sql
* db/src/test/sql/init_mifos_password.sql
* db/src/main/resources/sql/base-data.sql
* db/src/test/resources/sql/integration_test_data.sql
* db/pom.xml
Vinod :
[d0cd248a43dfd244dc6bcf74f90899b49a08ecd6|http://mifos.git.sourceforge.net/git/gitweb.cgi?p=mifos/head&a=commit&h=d0cd248a43dfd244dc6bcf74f90899b49a08ecd6]
Files :
* application/src/main/sql/mifosdroptables-checkpoint.sql
* application/src/main/sql/upgrade1295985566.sql
* application/src/main/sql/upgrade1285651956.sql
* application/src/main/sql/latest-schema.sql
* application/src/main/sql/mifosdroptables.sql
* application/src/main/sql/upgrade1292234934.sql
* application/src/main/sql/upgrade1298198335.sql
* application/src/main/sql/init_mifos_password.sql
*
application/src/main/java/org/mifos/application/master/persistence/Upgrade1294738016.java
*
application/src/test/java/org/mifos/framework/persistence/DatabaseMigratorIntegrationTest.java
* application/src/main/sql/latest-data-checkpoint.sql
* application/src/main/sql/upgrade1289541994.sql
* application/src/main/sql/custom_data.sql
* application/src/main/sql/latest-schema-checkpoint.sql
* application/src/main/sql/upgrade1289125815.sql
* application/src/main/sql/upgrade1296137314.sql
* application/src/main/sql/maskmifos.sql
* application/src/main/java/org/mifos/framework/ApplicationInitializer.java
* application/src/main/sql/upgrade1285812348.sql
*
application/src/test/java/org/mifos/framework/persistence/Upgrade1275913405.java
* application/src/main/sql/upgrades-checkpoint.txt
* application/src/main/sql/upgrade1289994929.sql
* application/src/test/java/org/mifos/framework/persistence/TestDatabase.java
* application/src/main/sql/upgrade1285046834.sql
* application/src/main/sql/upgrade1299279218.sql
*
application/src/main/java/org/mifos/framework/persistence/DatabaseMigrator.java
* application/src/main/sql/testdbinsertionscript.sql
* application/src/main/sql/upgrade1292241366.sql
*
application/src/test/java/org/mifos/framework/persistence/LatestTestAfterCheckpointIntegrationTest.java
* application/src/main/sql/upgrades.txt
* application/src/main/sql/upgrade1284977483.sql
* application/src/main/sql/latest-data.sql
*
application/src/main/java/org/mifos/application/master/persistence/Upgrade1294927843.java
* application/src/main/sql/truncate_tables.sql
> [Tech] Migrate the scripts for current release (only) to liquibase
> ------------------------------------------------------------------
>
> Key: MIFOS-4220
> URL: http://mifosforge.jira.com/browse/MIFOS-4220
> Project: mifos
> Issue Type: Story
> Components: Database
> Affects Versions: Elsie F - Iteration 6
> Reporter: Vivek Singh
> Assignee: Kalyan Akella
> Priority: Major
>
> For older releases we would continue to use NSDU. The migration should take
> care of scripts for current release only.
> Tasks
> - categorize scripts into contraction and expansion. This was not mentioned
> in the epic. (assume 10 upgrade scripts)
> - write them in Liquibase
> - convert any code based migration to sql based (Assume no codebase migration)
> - create maven script for running Liquibase from command line, not called
> from any CI or Dev build targets yet. This should be done in a way that
> expansion, contraction or both can be run conveniently.
> (Do not delete old scripts and keep the new scripts in a folder where NSDU
> doesn't see it. This is an interim step.)
> Acceptance Criteria:
> - Smoke and integration test should continue to work when the liquibase
> scripts are used instead of NSDU.
> - Two versions of App should be working with one db version.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
