retrography
4/15/2015 - 12:22 PM

Ruby one-liners

Ruby one-liners

# OrientDB CSV import
CSV::foreach('./out.csv',{headers: true}) {|r| client.command "create edge COAUTHOR from (select from Gem where title='#{r['sourcegem']}') to (select from Gem where title='#{r['targetgem']}') content #{r.to_hash.to_json}"; puts "#{r['sourcegem']} -> #{r['targetgem']}"}

# OR
CSV::foreach('./yanknmissing.tsv',{headers: true, col_sep: "\t"}) do |r| 
    @oc.command "insert into _missing_and_yanked (gem, minup, maxup) values ('"+r[0]+"', date('"+r[1][0..9]+"','yyyy-MM-dd'),date('"+r[2][0..9]+"','yyyy-MM-dd'))"
end  
# MongoDB GridFile export
CSV::foreach('/Volumes/Content/Dropbox/Code/reuse/reimport/licenses/licensefiles.csv',{headers: true}) {|r| puts %x[mongofiles -d github -l #{r[1].gsub(/^\.\/([^\/]+)\/([^\/]+)\/.*/,'"\1\|\2"')} get "#{r[1]}"];}