On Tue, 2008-01-22 at 12:09 +0545, Soham Dhakal wrote: > in DatabaseVersionPersistance.java I see some register functions that > are handling security related settings, but then there are some that > use upgradeXXX (e.g upgrade167.java) > > In what scenarios do we do upgrades this way vs, using sql statements?
Answered in another thread: http://article.gmane.org/gmane.comp.finance.mifos.devel/3583 In general: * When checks too complex for [mostly] ANSI-compliant SQL must be performed prior to data migration (see the Upgrade167 and Upgrade169 classes) * When a Mayfly limitation prevents using plain SQL (see issue #1387) -- Adam Monsen ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
