const pg = require('pg');

const client = new pg.Client({
  user: 'development',
  password: 'development',
  database: 'test_db',
  host: 'localhost',
  port: 5432,
  ssl: true
})

const firstName = process.argv[2];

client.connect((err) => {
  console.log('connected')
  if (err) {
    return console.log('error', err);
  }

  let query = 'SELECT * FROM famous_people WHERE first_name = $1'
  let values = [firstName]

  client.query(query, values, (err, result) => {
    if (err) {
      return console.log('query error', err);
    }
    console.log(result.rows);
    client.end();
  })

})