Displaying 3 results from an estimated 3 matches for "drop_database".
2007 Jan 26
1
rake test:x recreates tables in MySQL with server (not database) charset and collation
Any thoughts on how to avoid this problem? Already tried:
1. Setting the charset and collation in migration 001 - no effect:
def self.up
db_name = ActiveRecord::Base::connection.current_database()
execute "ALTER DATABASE #{db_name} CHARACTER SET utf8 COLLATE
utf8_bin"
end
2. Setting the charset and collation on each table individually - no
effect:
2006 Apr 26
2
migrations and database creation
...k:
class RbacDataStructures < ActiveRecord::Migration
def self.up
create_database <<dbname from database.yml>>
class :table_name < ActiveRecord::Base; end
create_table :table_name do |t|
t.column :column_1 :string
...
end
end
def self.down
drop_database <<dbname from database.yml>>
end
end
Regards,
Jim
--
Posted via http://www.ruby-forum.com/.
2006 Jan 11
2
Creating a DB in the schema import process
I''ve got a bunch of table creations in the schema.rb file and all is
well. However, I have to manually go and create the db first. Is there a
way (something like a create_database method) to get this to work?
(execute "create database ..." didn''t seem to cut it either.)
_______________________
Brad Eck
Sr. Software Engineer
Pelco
3500 Pelco Way
Clovis, CA 93612