Sequel is similar IF you're feeding raw SQL to the database. You can just use "run" inside the up and down blocks. However, in this case I'm using a plugin and what to use the methods provided by it.
On Sep 24, 6:48 am, byrnejb <[email protected]> wrote: > On Sep 24, 2:35 am, cult hero <[email protected]> wrote: > > > This works like a charm. Thanks. > > > How do I incorporate these into a migration? > > I do not have a Sequel example to hand, but for ActiveRecord > migrations I do this: > > class HllPgFnIdentInsert < ActiveRecord::Migration > > def self.up > > if /.*PostgreSQL.*/i =~ ActiveRecord::Base.connection.class.to_s > > # First, define trigger function to insert identifier for aliases > sql_string = <<-'SQLEND' > CREATE OR REPLACE FUNCTION hll_pg_fn_ident_insert() > . . . > SQLEND > puts sql_string > execute sql_string > end # if > > end #up > > def self.down > > if /.*PostgreSQL.*/i =~ ActiveRecord::Base.connection.class.to_s > > sql_string = <<-'SQLEND' > DROP FUNCTION hll_pg_fn_ident_insert(); > SQLEND > > puts sql_string > execute sql_string > end > > end #down > > The puts is just for confidence checking when running migrations. -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
