예제 #1
0
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()
예제 #2
0
def create_tables():
    auth.User.create_table(fail_silently=True)
    Users.create_table(fail_silently=True)
    Role.create_table(fail_silently=True)
    Category.create_table(fail_silently=True)
    Product.create_table(fail_silently=True)
    Period.create_table(fail_silently=True)
    Order_detail.create_table(fail_silently=True)
    Address.create_table(fail_silently=True)
    Show.create_table(fail_silently=True)
    UserRoles.create_table(fail_silently=True)
    Configure.create_table(fail_silently=True)
    WinRecord.create_table(fail_silently=True)
예제 #3
0
def create_tables():
    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()