jro_apps/redmine Files · lib/tasks/extract_fixtures.rake

Email notifications are now sent as Blind carbon copy by default. This can be changed in email notifications settings (new setting added)....

Email notifications are now sent as Blind carbon copy by default. This can be changed in email notifications settings (new setting added). Emission email address setting moved to the email notifications settings view. git-svn-id: http://redmine.rubyforge.org/svn/trunk@944 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r65:96f83cc8f0f0


                r931:bc060b31ae08

Download file

             extract_fixtures.rake
        
                    23 lines
            
             | 877 B
            
                | text/x-ruby
            
             |
                RubyLexer
            
             / lib / tasks / extract_fixtures.rake
          
                    History
                
                 |
                  Annotation
                 | Raw
                 |Copy content
                 |Copy permalink

      desc 'Create YAML test fixtures from data in an existing database.

      Defaults to development database. Set RAILS_ENV to override.'

      task :extract_fixtures => :environment do

        sql = "SELECT * FROM %s"

        skip_tables = ["schema_info"]

        ActiveRecord::Base.establish_connection

        (ActiveRecord::Base.connection.tables - skip_tables).each do |table_name|

          i = "000"

          File.open("#{RAILS_ROOT}/#{table_name}.yml", 'w' ) do |file|

            data = ActiveRecord::Base.connection.select_all(sql % table_name)

            file.write data.inject({}) { |hash, record|

            # cast extracted values

            ActiveRecord::Base.connection.columns(table_name).each { |col|

              record[col.name] = col.type_cast(record[col.name]) if record[col.name]      

            }      

            hash["#{table_name}_#{i.succ!}"] = record

            hash

            }.to_yaml

          end

        end

      end

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

				desc 'Create YAML test fixtures from data in an existing database.
				Defaults to development database. Set RAILS_ENV to override.'

				task :extract_fixtures => :environment do
				sql = "SELECT * FROM %s"
				skip_tables = ["schema_info"]
				ActiveRecord::Base.establish_connection
				(ActiveRecord::Base.connection.tables - skip_tables).each do \|table_name\|
				i = "000"
				File.open("#{RAILS_ROOT}/#{table_name}.yml", 'w' ) do \|file\|
				data = ActiveRecord::Base.connection.select_all(sql % table_name)
				file.write data.inject({}) { \|hash, record\|

				# cast extracted values
				ActiveRecord::Base.connection.columns(table_name).each { \|col\|
				record[col.name] = col.type_cast(record[col.name]) if record[col.name]
				}

				hash["#{table_name}_#{i.succ!}"] = record
				hash
				}.to_yaml
				end
				end
				end