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

Support WikiCaps for Trac migrations...

Support WikiCaps for Trac migrations Trac wikis support WikiCaps for links to pages. They also use !WikiCaps syntax to prevent links. Support both. Uses patch from and closes #758. git-svn-id: http://redmine.rubyforge.org/svn/trunk@1242 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r65:96f83cc8f0f0


                r1228:87fb78be0b48

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