def create_tables():
from models import User, Message, Note, Relationship, City, Pinche
# User.create_table()
Relationship.create_table()
Note.create_table()
Message.create_table()
City.create_table()
Pinche.create_table()
def create_tables():
from models import User, Message, Note, Relationship, City, Pinche
# User.create_table()
Relationship.create_table()
Note.create_table()
Message.create_table()
City.create_table()
Pinche.create_table()
import asyncio
import peewee_async
from models import User, Message, ChatRoom
from db import database
from settings import DATABASE
database.init(**DATABASE)
manager = peewee_async.Manager(database)
with manager.allow_sync():
User.create_table(True)
Message.create_table(True)
ChatRoom.create_table(True)
for username in ['User1', 'User2', 'User3']:
try:
User.create(username=username, password='******')
except:
pass
default_user = User.get(User.id == 1)
for room in ['flood', 'nsfw', 'music']:
ChatRoom.create(name=room, owner=default_user)
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)
dt = datetime.datetime.utcnow()
listener = Listener.get(Listener.key == data["key"])
if listener.enable:
Message.create(listener=listener, data=data["data"], timestamp=dt)
msg = f"{listener.description} listener new message:\n"
self.notify(listener.chat_id, data['data'], msg)
return {}, 200
return {}, 403
api.add_resource(Update, '/update')
api.add_resource(UpdateImage, '/update_image')
admin = Admin(app,
url='/listener_bot_api/admin',
name='ListenerBotAdmin',
template_mode='bootstrap3')
admin.add_view(ListenerAdmin(Listener))
admin.add_view(MessageAdmin(Message))
if __name__ == '__main__':
try:
Listener.create_table()
Message.create_table()
except:
pass
app.run()
def init(m):
User.create_table(fail_silently=True)
Message.create_table(fail_silently=True)
System.create_table(fail_silently=True)
System.init()
def init(m): Routing.create_table(fail_silently = True) User.create_table(fail_silently = True) Message.create_table(fail_silently = True) Error.create_table(fail_silently = True)
