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()