summaryrefslogtreecommitdiff
path: root/ATRI/database/models.py
blob: b3953dff8fb2023ddb2684e845f03f54093e9d0c (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
"""
    定义SQLITE数据库的关系模式(表)
    数据库采用了tortoise orm,可以很好地支持异步
"""

from tortoise.models import Model
from tortoise import fields
from datetime import datetime

# b站订阅表
class Subscription(Model):
    uid = fields.IntField(pk=True)  # up的uid
    groupid = fields.IntField()  # 群号
    nickname = fields.TextField(null=True)  # 订阅up的名称
    last_update = fields.DatetimeField(
        default=datetime.fromordinal(1)
    )  # 上一条动态更新时间 默认0001-01-01 00:00:00

    def __str__(self):
        return "[{nickname}|{uid}|{groupid}]".format(
            nickname=self.nickname, uid=self.uid, groupid=self.groupid
        )