def connect_to_db():
try:
# Use config functie to get values from database.ini
db = config()
con = psycopg2.connect(**db)
con.set_isolation_level(ISOLATION_LEVEL_AUTOCOMMIT)
except (Exception, psycopg2.DatabaseError) as error:
print(error)
exit()
return con
def get_popular_products(self):
# con = psycopg2.connect(
# host='localhost',
# password='******',
# user='******',
# database='huwebshop'
# )
db = config()
con = psycopg2.connect(**db)
cur = con.cursor()
query = "select idproducts from popular_products limit(4)"
cur.execute(query)
con.commit()
row = list(cur.fetchall())
list_items = []
for i in row:
list_items.append(i[0])
con.close()
return list_items
def __init__(self):
db = config()
self.con = psycopg2.connect(**db)
self.cur = self.con.cursor()
def __init__(self):
db = config()
self.con = psycopg2.connect(**db)
self.get_freq = GetFreq()
self.cur = self.con.cursor()