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

Custom fields can now be displayed as columns on the issue list....

Custom fields can now be displayed as columns on the issue list. Custom fields marked as "for all projects" can be added to the default columns of the issue list (in application settings). Project specific custom fields can be displayed on custom queries. git-svn-id: http://redmine.rubyforge.org/svn/trunk@889 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r65:96f83cc8f0f0


                r876:63ceea2e2183

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