def get_by_id(self, oderdetails: OrderDetailsEntity): con = None try: con = psycopg2.connect(user=self.ConnectionData['user'], password=self.ConnectionData['password'], host=self.ConnectionData['host'], port=self.ConnectionData['port'], database=self.ConnectionData['database']) cur = con.cursor() sql = "SELECT * FROM OrderDetails WHERE OrderDetailID= %s" cur.execute(sql, (oderdetails.OrderDetailID, )) con.commit() row = cur.fetchone() if row: c = EmployeesEntity() c.fetch_data(row) return c, 200 con.close() return 'OrderDetails', 404 except (Exception, psycopg2.DatabaseError) as error: return str(error) finally: if con is not None: con.close()
def get_all(self): con = None try: con = psycopg2.connect(user=self.ConnectionData['user'], password=self.ConnectionData['password'], host=self.ConnectionData['host'], port=self.ConnectionData['port'], database=self.ConnectionData['database']) cur = con.cursor() # sql = "SELECT * FROM TblCustomers" sql = "SELECT * FROM Employees" cur.execute(sql) con.commit() rows = cur.fetchall() result = [] for row in rows: c = EmployeesEntity() c.fetch_data(row) result.append(c.to_json()) con.close() return result except (Exception, psycopg2.DatabaseError) as error: return str(error) finally: if con is not None: con.close()