const person = process.argv.slice(2);

const pg = require("pg");
const settings = require("./settings"); // settings.json

const client = new pg.Client({
  user: settings.user,
  password: settings.password,
  database: settings.database,
  host: settings.hostname,
  port: settings.port,
  ssl: settings.ssl
});

client.connect(err => {
  if (err) {
    return console.error("Connection Error", err);
  }
  getPerson();
});

function getPerson() {
  const query = "SELECT * FROM famous_people WHERE first_name = $1";
  client.query(query, person, (err, result) => {
    if (err) {
      return console.error("error running query", err);
    }
    console.log("Searching..");
    const res = result.rows[0];
    console.log(`Found: ${result.rows.length} by the name of ${res.first_name}`);
    console.log(`${res.first_name} ${res.last_name} born ${res.birthdate}`);
  });
}