from datetime import datetime
from passlib.handlers.pbkdf2 import pbkdf2_sha256
from app.database import Database
cursor = Database.connect_to_db()
Database.create_database_tables()
class Product:
def __init__(self, id, name, buying_price, created_by, date_created,
date_modified):
self.id = id
self.name = name
self.buying_price = buying_price
self.created_by = created_by
self.date_created = date_created
self.date_modified = date_modified
@classmethod
def get_all(cls):
'''Factory method'''
cursor.execute(f"SELECT * FROM public.products;")
rows = cursor.fetchall()
product_objects = []
for item in rows:
product = Product(id=item[0],
name=item[1],
created_by=item[2],
