cursor-illu

main.py

from psycopg2 import connect
import time

# Get this from ENV variables or configuration store
config = {
    "host": "db",
    "dbname": "dvdrental",
    "user": "postgres",
    "password": "mypassword",
    "port": "5432"
}

def main():
    sql_query = 'SELECT *  FROM actor WHERE first_name LIKE %s'
    with connect(**config) as conn:
        with conn.cursor() as cur:
            cur.execute(sql_query, ["John%"])
            res = cur.fetchall()
            print("Fetched records: %s" % res)

if __name__ == "__main__":
    main()