def creation_tables():
database.execute_sql("SET FOREIGN_KEY_CHECKS=0")
if CategoriesProduct.table_exists():
CategoriesProduct.drop_table(cascade=True)
if Category.table_exists():
Category.drop_table(cascade=True)
if Product.table_exists():
Product.drop_table(cascade=True)
if User.table_exists():
User.drop_table(cascade=True)
if Store.table_exists():
Store.drop_table(cascade=True)
database.execute_sql("SET FOREIGN_KEY_CHECKS=1")
User.create_table()
Store.create_table()
Product.create_table()
Category.create_table()
CategoriesProduct.create_table()
def create_table():
if CategoriesProduct.table_exists():
CategoriesProduct.drop_table()
if Category.table_exists():
Category.drop_table()
if Product.table_exists():
Product.drop_table()
if Store.table_exists():
Store.drop_table()
if User.table_exists():
User.drop_table()
User.create_table()
Store.create_table()
Product.create_table()
Category.create_table()
CategoriesProduct.create_table()
def insert_categories_products():
CategoriesProduct.create(category_id=1, product_id=2)
CategoriesProduct.create(category_id=1, product_id=5)
CategoriesProduct.create(category_id=1, product_id=4)
CategoriesProduct.create(category_id=2, product_id=3)
CategoriesProduct.create(category_id=3, product_id=6)
CategoriesProduct.create(category_id=4, product_id=4)
CategoriesProduct.create(category_id=4, product_id=6)
CategoriesProduct.create(category_id=5, product_id=3)
def insert_categories_products():
CategoriesProduct.create(category_id=1, product_id=2) # liquidos ->Leche
CategoriesProduct.create(category_id=1, product_id=5) # liquidos ->Soda
CategoriesProduct.create(category_id=1, product_id=7) # liquidos ->Salsa
CategoriesProduct.create(category_id=2, product_id=3) # liquidos ->jamon
CategoriesProduct.create(category_id=3, product_id=6) # snacks ->frituras
CategoriesProduct.create(category_id=4, product_id=4) # aderezos ->mostaza
CategoriesProduct.create(category_id=4, product_id=8) # aderezos ->mostaza
CategoriesProduct.create(category_id=5, product_id=3) # aderezos ->mostaza