require "crystal-monetdb-libmapi/monetdb"
require "crystal-monetdb-libmapi/monetdb_data"
require "colorize"

class ConnectionError < Exception; end
class QueryError < Exception; end
class InternalError < Exception; end
class TimeoutError < Exception; end

mero = MonetDB::ClientJSON.new
mero.host = "127.0.0.1"
mero.port = 50000
mero.username = "monetdb"
mero.password = "monetdb"
mero.db = "monetdb-example1"

query = "SELECT name, price FROM \"test\".fruits;"
mid = mero.connect
result_json = mero.query_json(query)
result = mero.json_to_hash(result_json)
puts "Hash Created:".colorize(:red)
p result
puts "Display specific fields".colorize(:red)
result.each {|k,v|
  puts "Hash Key: #{k} Name: #{v["name"]} Price: #{v["price"]}"
}