class DatabaseConnection

  def getHostInfo
    print('Enter host or IP of database server: ')
    dbserver = gets.chomp
    return dbserver
  end

  def getUserName
    print('Please enter your database username: ')
    user = gets.chomp
    return user
  end

  def getPassword
    print('Please enter your password: ')
    password = gets.chomp
    return password
  end

  def DatabaseConnection.connect(u, p, db)
    client = TinyTds::Client.new username: "#{u}", password: "#{p}", host: "#{db}", port: 1433, database: 'ISO_AVM2'

    if client.active?
      puts 'Connection established'
    end
  end

end