Skip to content

Instantly share code, notes, and snippets.

@gelias

gelias/mix.rb

Created September 15, 2017 16:28
Show Gist options
  • Save gelias/b14f065c4e65c54cc5fcca5ec67af9b6 to your computer and use it in GitHub Desktop.
Save gelias/b14f065c4e65c54cc5fcca5ec67af9b6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mix.rb
file=File.new('/tmp/Mix.csv')
while (line = file.gets)
parts = line.split("\;")
puts("DELETE FROM cadastrocustomizavelvalor WHERE cdv_identificadoralternativo = '#{parts[0]}_mix_#{parts[1]}' and cdv_cli_codigo = 14100 and cad_codigo = 96411;")
end
file.close
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment