Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- require 'mysql2'
- require 'csv'
- socket = '/Applications/MAMP/tmp/mysql/mysql.sock'
- file = '/tmp/items.csv'
- if File.exists?(file)
- File.delete(file)
- end
- query =<<EOQ
- SELECT * FROM omeka_items
- INTO OUTFILE '/tmp/items.csv'
- FIELDS TERMINATED BY ','
- ENCLOSED BY '"'
- LINES TERMINATED BY '\n';
- EOQ
- connection = Mysql2::Client.new(
- :host => 'localhost',
- :database => 'database_name',
- :username => 'username',
- :password => 'password',
- :port => 8889,
- :socket => socket
- )
- connection.query(query)
- CSV.foreach(file, :headers => true, :header_converters => :symbol) do |line|
- puts line
- end
Add Comment
Please, Sign In to add comment