/*  Base.cpp
 */

#include "stdlib.h"
#include "stdio.h"
#include <string>
#include <iostream>
#include <fstream>
#include <vector>

#include "libpq++.h"


int main(void)
{

  char query_string[256];             // holds constructed SQL query 
  string query;

  // connect to the database 
  PgDatabase data("dbname=testdb user=gerome password=cse444"); 
  if ( data.ConnectionBad() )         // did the database connection fail? 
  { 
    cout << "Connection to database failed." << endl 
    << "Error returned: " << data.ErrorMessage() << endl; 
    exit(1); 
  } 


  sprintf(query_string, "SELECT * FROM beers;" ); 
  if ( !data.ExecTuplesOk(query_string) )   // send the query 
    cout << "SELECT query failed." << endl; 

  for (int i=0; i < data.Tuples(); i++ )

    cout << data.GetValue(i,0) << "  " << data.GetValue(i,1) << endl;


}