Guest User

Untitled

a guest
Nov 30th, 2018
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. require 'mysql2'
  2. require 'csv'
  3.  
  4. socket = '/Applications/MAMP/tmp/mysql/mysql.sock'
  5.  
  6. file = '/tmp/items.csv'
  7.  
  8. if File.exists?(file)
  9. File.delete(file)
  10. end
  11.  
  12.  
  13. query =<<EOQ
  14. SELECT * FROM omeka_items
  15. INTO OUTFILE '/tmp/items.csv'
  16. FIELDS TERMINATED BY ','
  17. ENCLOSED BY '"'
  18. LINES TERMINATED BY '\n';
  19. EOQ
  20.  
  21. connection = Mysql2::Client.new(
  22. :host => 'localhost',
  23. :database => 'database_name',
  24. :username => 'username',
  25. :password => 'password',
  26. :port => 8889,
  27. :socket => socket
  28. )
  29.  
  30. connection.query(query)
  31.  
  32. CSV.foreach(file, :headers => true, :header_converters => :symbol) do |line|
  33. puts line
  34. end
Add Comment
Please, Sign In to add comment