gary (owner)

Revisions

gist: 161529 Download_button fork
public
Public Clone URL: git://gist.github.com/161529.git
Embed All Files: show embed
backup.rake #
raw 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

  task :load_raw_data => :merb_env do
    adapter = DataMapper.repository(:default).adapter
 
    load_query = <<-QUERY
      LOAD DATA LOCAL INFILE ? INTO TABLE %s
        FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
         LINES TERMINATED BY '\n';
    QUERY
    Dir["#{Merb.root_path("tmp/text4work_redux_production")}/*.txt"].each { |f|
      table_name = File.basename(f).gsub(/\.txt/, '')
      adapter.execute(load_query % table_name, f)
 
      Merb.logger.info("Loaded #{table_name}...")
    }
  end