#!/usr/bin/python3

# NOT COMPLETE ... this is just the template

import sys
import psycopg2

# define any local helper functions here

### set up some globals

usage = f"Usage: {sys.argv[0]} Params ..."
db = None

if len(sys.argv) < 2:
	print(usage)
	exit()
zid = sys.argv[1]

# process command-line args

try:
  # connect to database, e.g.
  db = psycopg2.connect("dbname=mymy")

  # manipulate database, e.g.
  cur = db.cursor();
  cur.execute("select fullname from people where id=%s",[zid]);
  res = cur.fetchone()
  if not res:
    print("No such student")
  else:
    print(res[0])

except Exception as err:
  print("DB error: ", err)
finally:
  if db:
    db.close()