-
Notifications
You must be signed in to change notification settings - Fork 0
/
util.py
49 lines (40 loc) · 1.53 KB
/
util.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
import psycopg2
from psycopg2 import Error
# this function is based on the tutorial at: https://pynative.com/python-postgresql-tutorial/
def connect_to_db(username='raywu1990',password='test',host='127.0.0.1',port='5432',database='dvdrental'):
try:
# Connect to an existing database
connection = psycopg2.connect(user=username,
password=password,
host=host,
port=port,
database=database)
# Create a cursor to perform database operations
cursor = connection.cursor()
print("connected to the database")
return cursor, connection
except (Exception, Error) as error:
print("Error while connecting to PostgreSQL", error)
def disconnect_from_db(connection,cursor):
if (connection):
cursor.close()
connection.close()
print("PostgreSQL connection is closed.")
else:
print("Connection does not work.")
# run_sql(cursor,"select from;")
def run_and_fetch_sql(cursor, sql_string=""):
try:
# Executing a SQL query
# cursor.execute("SELECT version();")
# cursor.execute("SELECT * from customer;")
cursor.execute(sql_string)
# Fetch result
# record = cursor.fetchone()
# print("You are connected to - ", record, "\n")
record = cursor.fetchall()
# print("Here are the first 5 rows", record[:5])
return record
except (Exception, Error) as error:
print("Errors while executes the code: ", error)
return -1