Class: Migrate::Lang::Sql

Inherits:
Migrate::Lang show all
Defined in:
lib/migrate/lang/sql.rb

Instance Method Summary collapse

Constructor Details

#initialize(db) ⇒ Sql

Returns a new instance of Sql.



4
5
6
7
 
# File 'lib/migrate/lang/sql.rb', line 4

def initialize(db)
  @db = db
  @ext = "sql"
end

Instance Method Details

#create_migration(dir) ⇒ Object 



9
10
11
12
13
14
15
16
17
 
# File 'lib/migrate/lang/sql.rb', line 9

def create_migration(dir)
  File.open("#{dir}/up.#{@ext}", "w") do |f|
    f.puts "-- Here goes SQL for migration forward\n"
  end

  File.open("#{dir}/down.#{@ext}", "w") do |f|
    f.puts "-- Here goes SQL for migration backward\n"
  end
end

#exec_migration(dir, is_up) ⇒ Object 



19
20
21
22
23
 
# File 'lib/migrate/lang/sql.rb', line 19

def exec_migration(dir, is_up)
  script = "#{dir}/#{is_up ? "up" : "down"}.#{@ext}"
  Log.info("Executing #{script}...")
  @db.exec_sql(File.read(script))
end