[SUMMARY] Restoring Data From SQL (#199)

No submissions this week (there may have been a glitch causing this
not to have even been posted to the mailing list, so that might
explain it…)

Here’s the solution that I ended up using:

file_names = Dir['PROD_*']

compositions_found = false

compositions = Hash.new {{}}

file_names.each do |file_name|
  File.read(file_name).each_line do |line|
    compositions_found = false if line =~ /\/\*/
    if compositions_found
      line =~

/(([^,]+),([^,]+),([^,]+),([^,]+),([^,]+),([^,]+),([^,]+),([^,]+)/

      if $2 && $2 != 'NULL'
        composition = {:id => $1.to_i}
        composition[:product_id] = $2.to_i if $2 && $2 != 'NULL'
        composition[:component_id] = $3.to_i if $3 && $3 != 'NULL'
        composition[:quantity] = $6[1...-1].to_f if $6 && $6 != 

‘NULL’
composition[:line_num] = $7.to_i if $7 && $7 != ‘NULL’
composition[:fixed] = $8.to_i if $8 && $8 != ‘NULL’
#puts composition.inspect
compositions[$1] = compositions[$1].merge(composition)
end
#puts line
else
compositions_found = true if line =~ /INSERT INTO
compositions/
end

    next unless compositions_found
  end
end

compositions.sort.each do |id, composition|
  puts composition.inspect
end

It reads the comma separated fields using a wonky regex (please let me
know of a better way!). The output is inspected hashes that I eval in
another program to load the data back into the DB. It worked
surprisingly well.

I apologize for the late summary and any mishaps on the mailing of this
quiz.

On Tue, Apr 14, 2009 at 10:21 PM, Daniel M. [email protected]
wrote:

It reads the comma separated fields using a wonky regex (please let me
know of a better way!). The output is inspected hashes that I eval in

There’s a nice, friendly CSV library! http://fastercsv.rubyforge.org/

martin

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs