tables.py

from peewee import *
import datetime
from config import config

db = SqliteDatabase(config["database"]["path"])


class BaseModel(Model):
    class Meta:
        database = db


class User(BaseModel):
    user_id = IntegerField(primary_key=True)     # telegram user ID
    group = IntegerField()                  # each user can belong to only one group
    dci = IntegerField(null=True)           # dci wotc gamer number
    name = CharField()
    arena = CharField(null=True)            # mtg arena player username
    win = IntegerField(default=0)           # total wins
    lose = IntegerField(default=0)          # total match lost
    lgs_points = IntegerField(default=0)    # points assigned in LGS leagues
    dci_points = IntegerField(null=True)    # dci planeswalker points
    status = IntegerField(default=0)        # bot navigation based on FSM machine


class Event(BaseModel):
    event_id = IntegerField()
    name = CharField()          # event title
    type = CharField(null=True)          # fnm, draft, constructed, ...
    date = DateTimeField(default=datetime.date.today() + datetime.timedelta(days=1))      # planned event day
    expired = BooleanField(default=False)
    prize = CharField(null=True)
    infos = CharField(null=True)         # further infos about the event
    subs = IntegerField(default=0)       # total subscribers to this event
    winner = IntegerField(null=True)     # player ID who went first


class Round(BaseModel):
    event_id = IntegerField()   # an event id
    round = IntegerField(default=1)      # round number
    player1 = IntegerField(null=True)    # first player ID
    player2 = IntegerField(null=True)    # second player ID
    winner = IntegerField(null=True)     # winner player ID
    home = IntegerField(null=True)       # player 1 points on 3 rounds
    visitor = IntegerField(null=True)    # player 2 points on 3 rounds (ex: 2-1)


class Code(BaseModel):
    code_id = IntegerField(primary_key=True)
    code = CharField(null=True)     # actual code
    type = CharField(null=True)     # fnm, draft, constructed, ...
    date_insert = DateTimeField(default=datetime.date.today())  # when the code is uploaded
    date_expire = DateTimeField(default=datetime.date.today() + datetime.timedelta(days=2))  # when this code will expire
    expired = BooleanField(default=False)   # either a claimed or an expired code
    password = BooleanField(default=False)  # a specific word to get this code
    infos = CharField(null=True)  # further infos about this code


class Feed(BaseModel):
    feed_id = CharField(primary_key=True)
    date = DateTimeField(default=datetime.datetime.today())