create database in script

Question

In my Rails application development, I would like to write a script to create a new database and a table in the new database (I am using MySQL), so that I can later run the script like following:

rails runner db/scripts/data_mover.rb

But I do not know how to do it in ruby code or Rails way...Anyone can provide some hint or sample?

Just do what you do in migration

ShiningRay
– ShiningRay

2011-11-24 11:53:36 +00:00
Commented Nov 24, 2011 at 11:53 — ShiningRay
– ShiningRay, Commented Nov 24, 2011 at 11:53
How? I need to create a new database, not only table

Leem.fin
– Leem.fin

2011-11-24 12:05:08 +00:00
Commented Nov 24, 2011 at 12:05 — Leem.fin
– Leem.fin, Commented Nov 24, 2011 at 12:05

ShiningRay · Accepted Answer · 2011-11-24 13:11:51Z

2

write the code in a class, and place the file under app/models, such as `app/models/data_mover.rb'

class DataMover
  def self.run
    ActiveRecord::Base.connection.execute("CREATE DATABASE somedatabase")

    ActiveRecord::Base.establish_connection(
     :adapter  => "mysql",
     :host     => "localhost",
     :username => "myuser",
     :password => "mypass",
     :database => "somedatabase"
    )

    ActiveRecord::Base.connection.create_table :sometable do |t|
      #...
    end
  end
end

Then you can run rails runner 'DataMover.run' to create databases and tables.

answered Nov 24, 2011 at 13:11

ShiningRay

1,0087 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

create database in script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related