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)
from models import BaseModel, TextContent, MessageContent, Photo, Role, User, UserRoles, MessageType, ConversationType, Conversation, Message, ConversationParty, Quotation, Company, database try: database.drop_tables(BaseModel.__subclasses__(), safe = True, cascade = True) # database.create_tables(BaseModel.__subclasses__()) Photo.create_table() Role.create_table() User.create_table() UserRoles.create_table() MessageType.create_table() ConversationType.create_table() Quotation.create_table() Company.create_table() TextContent.create_table() MessageContent.create_table() Conversation.create_table() Message.create_table() ConversationParty.create_table() database.create_foreign_key(Conversation, Conversation.last_message) except Exception as e: print('Error while creating schema %s' % e)