diff options
author | Carl Lerche <carllerche@mac.com> | 2010-03-11 17:08:55 -0800 |
---|---|---|
committer | Carl Lerche <carllerche@mac.com> | 2010-03-11 17:10:40 -0800 |
commit | 8db90ba95d4a240fde68127e806162b3e600c383 (patch) | |
tree | 9b4ecaeb523e53c1f86cf3cb654e71de945c4e83 /spec/support/schemas/mysql_schema.rb | |
parent | e3461239adfa972de8f25a2bc6b48b4a8aa62c9c (diff) | |
download | rails-8db90ba95d4a240fde68127e806162b3e600c383.tar.gz rails-8db90ba95d4a240fde68127e806162b3e600c383.tar.bz2 rails-8db90ba95d4a240fde68127e806162b3e600c383.zip |
Move all spec support files into spec/support
Diffstat (limited to 'spec/support/schemas/mysql_schema.rb')
-rw-r--r-- | spec/support/schemas/mysql_schema.rb | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/spec/support/schemas/mysql_schema.rb b/spec/support/schemas/mysql_schema.rb new file mode 100644 index 0000000000..a2e913d756 --- /dev/null +++ b/spec/support/schemas/mysql_schema.rb @@ -0,0 +1,26 @@ +sql = <<-SQL + DROP TABLE IF EXISTS users; + CREATE TABLE users ( + id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, + name VARCHAR(255) NOT NULL + ); + + DROP TABLE IF EXISTS photos; + CREATE TABLE photos ( + id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, + user_id INTEGER NOT NULL, + camera_id INTEGER NOT NULL + ); + DROP TABLE IF EXISTS developers; + CREATE TABLE developers ( + id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, + name VARCHAR(255) NOT NULL, + salary INTEGER NOT NULL, + department VARCHAR(255) NOT NULL, + created_at TIMESTAMP NOT NULL + ); +SQL + +sql.split(/;/).select(&:present?).each do |sql_statement| + ActiveRecord::Base.connection.execute sql_statement +end |