def db_init(): DB.connect() try: DB.create_tables([User]) print('Creating tables...') except OperationalError: pass DB.close() redis.delete('chatcount')
def debug_create_tables(): DB.create_tables([ User, ])
from config import DB as db from models import * db.connect() db.create_tables([User, Message]) db.close()
from peewee import * from config import DB class Person(Model): firstname = CharField() surname = CharField() class Meta: database = DB if __name__ == "__main__": DB.connect() DB.create_tables([Person]) # Add some data Person(firstname="John", surname="Bob").save() Person(firstname="Jane", surname="Bob").save() Person(firstname="Michael", surname="Clark").save()
from peewee import Model, CharField, IntegerField, DateTimeField, TextField, DecimalField, DateTimeField from config import DB from datetime import datetime class BaseModel(Model): class Meta: database = DB class User(BaseModel): tg_id = IntegerField() username = CharField() registered = DateTimeField(default=datetime.now) last_activity_date = DateTimeField(default=datetime.now) mode = TextField(default='message') message_id = IntegerField(default=0) publish_id = IntegerField(default=0) class Message(BaseModel): message_id = IntegerField() text = TextField() media = TextField(default='') out_message = TextField(default='none') price = DecimalField(default=0.0) DB.create_tables([User, Message])
from config import DB from data.models import User, Entry DB.connect() DB.create_tables([User, Entry])
from config import DB as db from models import * db.connect() db.create_tables([Book]) db.close()