Guest User

Untitled

a guest
Mar 11th, 2018
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. require "rubygems"
  2. require "activerecord"
  3. require "csv"
  4. class Computer < ActiveRecord
  5. def initialize
  6. self::Base.establish_connection(
  7. :adapter => "mysql",
  8. :host => "na",
  9. :username => "na",
  10. :password => "na",
  11. :database => "pc_inventory")
  12. end
  13. end
  14.  
  15. computer = Computer.new
  16.  
  17. CSV::Reader.parse(File.open('\\\\somefileserver\somefile.csv','rb')) do |row|
  18. computer.create(:username => row[0],:computername => row[1], )
  19. end
Add Comment
Please, Sign In to add comment