class DatabaseConnection

  def initialize
    dbserver = @dbserver
    user = @user
    password = @password
  end

  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
  end

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

  def DatabaseConnection.connect(dbserver, user, password)
    ## Connect to database
    client = TinyTds::Client.new username: "#{user}", password: "#{password}", host: "#{dbserver}", port: 1433, database: 'ISO_AVM2'

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

end