require 'activerecord'
require 'win32ole'


class Diskspace < ActiveRecord::Base
end

ActiveRecord::Base.establish_connection(:adapter  => "mysql",
                                                        :host     => "localhost",
                                                        :database => "podstatus",
                                                        :username => "root",
                                                        :password => "root" )



wmi = WIN32OLE.connect("winmgmts:")
dspace = wmi.ExecQuery("Select * From Win32_LogicalDisk Where DeviceID = \"C:\"")
dspace.each do |f|
  @freespace=f.FreeSpace.to_i
  @totalspace=f.Size.to_i
  @usedspace=@totalspace-@freespace
end
@diskspace = Diskspace.create(:pod => "mylaptop",
                                            :used_space => @usedspace,
                                            :total_space => @totalspace,
                                            :added_date => Time.now)

  #dspace.each { |f| @crap =  f.FreeSpace.to_s }