class MysqlTest
  #Code here
  require "mysql"
  def testMysql
    dbc=Mysql.real_connect('localhost','root','123','Ivic_Portal')
    res=dbc.query('select * from virtual_machines')
    puts "Test Mysql...."
    while row=res.fetch_row do
      puts "#{row[0]}"
    end
  end
  def createTable
    dbc=Mysql.real_connect('localhost','root','123','Ivic_Portal')
    res = dbc.query("SELECT id,hostname,internet_tx,internet_rx,traffic_tx,traffic_rx FROM virtual_machines")
    puts "===Select Data===/n"
    while row = res.fetch_row do
      printf("%s, %s, %s, %s, %s, %s\n",row[0],row[1],row[2],row[3],row[4],row[5])
    end
    puts "==================/n"
    puts "Server version: " + dbc.get_server_info
    rescue Mysql::Error => e
      puts "Error code: #{e.errno}"
      puts "Error message: #{e.error}"
      puts "Error SQLSTATE: #{e.sqlstate}" if e.respond_to?("sqlstate")
    ensure
      puts "Close Connection......."
      dbc.close if dbc
  end


  def insertinto
    dbc=Mysql.real_connect('localhost','root','123','Ivic_Portal')
    res = dbc.query("SELECT id,hostname,internet_tx,internet_rx,traffic_tx,traffic_rx FROM virtual_machines")
    while row = res.fetch_row do
      id = row[0]
      a = rand(1000)
      b = rand(1000)
      c = rand(1000)
      d = rand(1000)
      puts a,b,c,d
      printf("%s, %s, %s, %s, %s, %s\n",row[0],row[1],row[2],row[3],row[4],row[5])
      dbc.query("update virtual_machines set internet_tx=internet_tx+#{a} where id = #{id} ")
      dbc.query("update virtual_machines set internet_rx=internet_rx+#{b} where id = #{id} ")
      dbc.query("update virtual_machines set traffic_tx=traffic_tx+#{c} where id = #{id} ")
      dbc.query("update virtual_machines set traffic_rx=traffic_rx+#{d} where id = #{id} ")
    end
    rescue Mysql::Error => e
      puts "Error code: #{e.errno}"
      puts "Error message: #{e.error}"
      puts "Error SQLSTATE: #{e.sqlstate}" if e.respond_to?("sqlstate")
    ensure
      puts "Close Connection......."
      dbc.close if dbc
  end
  while true do
    (MysqlTest.new).insertinto
    (MysqlTest.new).createTable
    sleep(5)
  end
end