| @@ -1,23 +1,22 | |||
|
|
1 | 1 | desc 'Create YAML test fixtures from data in an existing database. |
|
|
2 | 2 | Defaults to development database. Set RAILS_ENV to override.' |
|
|
3 | 3 | |
|
|
4 | 4 | task :extract_fixtures => :environment do |
|
|
5 | 5 | sql = "SELECT * FROM %s" |
|
|
6 | 6 | skip_tables = ["schema_info"] |
|
|
7 | 7 | ActiveRecord::Base.establish_connection |
|
|
8 | 8 | (ActiveRecord::Base.connection.tables - skip_tables).each do |table_name| |
|
|
9 | 9 | i = "000" |
|
|
10 | 10 | File.open("#{Rails.root}/#{table_name}.yml", 'w' ) do |file| |
|
|
11 | 11 | data = ActiveRecord::Base.connection.select_all(sql % table_name) |
|
|
12 | 12 | file.write data.inject({}) { |hash, record| |
|
|
13 | 13 | # cast extracted values |
|
|
14 | 14 | ActiveRecord::Base.connection.columns(table_name).each { |col| |
|
|
15 | 15 | record[col.name] = col.type_cast(record[col.name]) if record[col.name] |
|
|
16 | 16 | } |
|
|
17 | 17 | hash["#{table_name}_#{i.succ!}"] = record |
|
|
18 | 18 | hash |
|
|
19 | 19 | }.to_yaml |
|
|
20 | 20 | end |
|
|
21 | 21 | end |
|
|
22 | 22 | end |
|
|
23 | ||
General Comments 0
You need to be logged in to leave comments.
Login now