Mixing creation and migration scripts with Flyway -

-

can flyway used mix creation , migration scripts that:

  • new installations run schema creation script
  • existing installations run migration scripts, , never see creation scripts of subsequent versions

?

e.g. given:

db/create/v1/v1__schema.sql db/create/v2/v2__schema.sql db/create/v3/v3__schema.sql db/migration/v1/v1.1__migratea.sql db/migration/v2/v2.1__migrateb.sql db/migration/v2/v2.2__migratec.sql

an existing v1 installation run following v3:

  • db/migration/v1/v1.1__migratea.sql
  • db/migration/v2/v2.1__migrateb.sql
  • db/migration/v2/v2.2__migratec.sql

it never run following, these represent schema-only sql produced mysqldump:

  • db/create/v2/v2__schema.sql
  • db/create/v3/v3__schema.sql

a new v3 installation run:

  • db/create/v3/v3__schema.sql

the above conflicts approach recommended upgrade scenario when using flyway required data populated independently of migration.

it looks should possible use flyway.locations support this, installations need include path creation script flyway can see it.

the alternative appears to run creation scripts outside of flyway , set baseline, nice if flyway manage everything.

in end, developed tool this. tool has latest schema in:

db/schema/schema.sql

and migration scripts in:

db/migration/<version>/<version>.<sequence>__<jira issue>.sql

e.g.:

db/migration/v1/v1.1__jira-15.sql     db/migration/v2/v2.1__jira-12.sql db/migration/v2/v2.2__jira-22.sql db/migration/v3/v3.0__jira-34.sql

if database has no tables, schema.sql executed, , flyway baselined recent version, reported flyway's migrationinfoservice.pending() method.

i.e. last migrationinfo element returned pending() determines version pass flyway.setbaselineversion() before invoking flway.baseline() e.g:

dbsupport support = dbsupportfactory.createdbsupport(connection, true); schema schema = support.getoriginalschema(); if (schema.alltables().length == 0) {   resource resource = new classpathresource("db/schema/schema.sql", getclass().getclassloader());   sqlscript script = new sqlscript(resource.loadasstring("utf-8"), support);   script.execute(support.getjdbctemplate());   migrationinfo[] pending = flyway.info().pending();   migrationinfo version = pending.length > 0 ? pending[pending.length - 1] : null;   if (version != null) {     flyway.setbaselineversion(version.getversion());     flyway.setbaselinedescription(version.getdecription());     flyway.baseline();   } }

this ensures none of migration scripts invoked newly created databases, mean schema.sql must contain of changes.

if database has tables, no flyway information, baselined according detected schema version.


Comments

Post a Comment

Popular posts from this blog

php - How to display all orders for a single product showing the most recent first? Woocommerce -

-
i have password protected page on frontend. on page, want display full list of purchases associated single woocommerce product id. option 1: i've looked through woocommerce docs , , found: wc_cli_order , list_( $args, $assoc_args ) function lists orders. presumably, orders can filtered product id [--=] filter orders based on order property. line item fields (numeric array, started index zero): line_items.0.product_id option 2: i found article , based on customer id. i've modified code based on guesses meta_key , meta_value. $customer_orders = get_posts( array( 'numberposts' => -1, 'meta_key' => '_product', 'meta_value' => get_product_id(), 'post_type' => wc_get_order_types(), 'post_status' => array_keys( wc_get_order_statuses() ), ) ); how display orders single product showing recent order first? here solution put based on these articles: http://www.w...
Read more

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

-
i'm having difficult time , hope guys can help. using helicon isapi rewrite version 3.1.0.104 on our iis server. edit http.conf file , have tried , still fail. this trying do: redirect url: https://www.domain.com/switch-by-version?version=2.8.5.2594 to: https://test.domain.com/load/load.aspx?tver=2.8.5.2594 the version number @ end source url change, , need target url have same version number @ end of url example above shows. i tried following not work: rewritecond %{query_string} ^version=(\d\d?)\.(\d\d?)\.(\d\d?)\.(.*)$ [nc] rewriterule ^/switch-by-version(.*)$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l] any appreciated! thanks. if it's running in equivalent context of .htaccess , rule shouldn't start / . here's simpler version: rewritecond %{query_string} ^version=(\d+\.\d+\.\d+(?:\..+)?)$ [nc] rewriterule ^switch-by-version/?$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l]
Read more

angularjs - How restrict admin panel using in backend laravel and admin panel on angular? -

-
https://scotch.io/tutorials/token-based-authentication-for-angularjs-and-laravel-apps following tutorials, try write authentication restrict admin panel, didn't understood how can that. this admin panel, admin panel don't want show , request database unauthenticated users. my laravel-routes route::get('/admin',function(){ return view('index'); }); route::get('/api/v1/employees/{id?}', 'employees@index'); route::get('/api/v1/users/{id?}', 'employees@users'); route::post('/api/v1/employees', 'employees@store'); route::post('/api/v1/employees/{id}', 'employees@update'); route::delete('/api/v1/employees/{id}', 'employees@destroy'); route::group(['prefix' => 'api'], function() { route::resource('authenticate', 'authenticatecontroller', ['only' => ['index']]); route::post('authenticate', 'authentic...
Read more