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

Display the last 30 days on the activity view rather than the current month....

Display the last 30 days on the activity view rather than the current month. Number of days can be configured in the application settings. git-svn-id: http://redmine.rubyforge.org/svn/trunk@1196 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r65:96f83cc8f0f0


                r1182:bbe8ea29e8d3

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