class Note(BaseModel):
id = pw.AutoField()
uuid = pw.UUIDField()
title = pw.CharField(max_length=256)
create_time = pw.TimestampField()
update_time = pw.TimestampField()
content = pw.TextField()
class PaymentRequest(BaseModel):
uid = peewee.BinaryUUIDField(primary_key=True)
state = peewee.IntegerField(default=RequestState.UNKNOWN)
description = peewee.TextField(null=True)
date_expires = peewee.TimestampField(null=True, utc=True)
date_created = peewee.TimestampField(utc=True)
tx_hash = peewee.BlobField(null=True)
class User(BaseModel):
id = peewee.BigIntegerField(primary_key=True)
email = peewee.CharField(max_length=128)
bot = peewee.BooleanField(default=False)
username = peewee.CharField(max_length=32)
discriminator = peewee.IntegerField()
password = peewee.CharField(max_length=128, null=True)
flags = peewee.IntegerField(default=0)
verified = peewee.BooleanField(default=False)
last_email_reset = peewee.TimestampField()
last_password_reset = peewee.TimestampField()
def to_dict(self, me=False):
data = {
'id': str(self.id),
'username': self.username,
'discriminator': '{:04d}'.format(self.discriminator),
'flags': self.flags,
}
if self.bot:
data['bot'] = self.bot
if me:
data.update({
'email': self.email,
'verified': self.verified,
})
return data
class Meta:
db_table = 'users'
indexes = (
(('email', ), True),
(('username', ), False),
(('username', 'discriminator'), True),
)
class group(peewee.Model):
id = peewee.CharField(default=utils.shortid)
name = peewee.CharField()
creater = peewee.CharField()
manager = peewee.CharField()
date_out = peewee.TimestampField(default=None, utc=True)
create_date = peewee.TimestampField(utc=True)
joinway = peewee.CharField(default="public_join")
kicked_number = peewee.IntegerField(default=0)
total_number = peewee.IntegerField(default=0) # 我都不知道我之前写的这是啥....先加上先
max_number = peewee.IntegerField(default=1)
total_signout = peewee.IntegerField(default=0)
enable_yggdrasil = peewee.BooleanField(default=True)
enable_invite = peewee.BooleanField(default=True)
enable_public_joinhistory = peewee.BooleanField(default=True)
enable_public_memberlist = peewee.BooleanField(default=False)
#joinway:
#1.public_join:任何人可加入
#2.public_join_review:需要管理员同意
#3.private:私有组,只能于enable_invite为True时通过内部人员邀请进入
class Meta:
database = db['global']
class banner(peewee.Model):
user = peewee.CharField()
profile = peewee.CharField(null=True)
create_time = peewee.TimestampField(utc=True)
group = peewee.CharField(default="global")
until = peewee.TimestampField(default=None, utc=True) # 传入一个utc整数
class Meta:
database = db['global']
class User(pw.Model):
display_name = pw.CharField()
user_id = pw.IntegerField()
profile_image = pw.CharField()
last_subscribed = pw.TimestampField(null=True, default=None)
last_live = pw.TimestampField(null=True, default=None)
broadcaster_type = pw.CharField(default='')
class Meta:
database = db
class AWSCredential(peewee.Model):
profile = peewee.CharField()
profile_type = peewee.CharField()
key = peewee.CharField()
secret = peewee.CharField()
region = peewee.CharField()
created = peewee.TimestampField()
last_activated = peewee.TimestampField()
is_active = peewee.BooleanField()
class Meta:
database = DB
class profile(peewee.Model):
profile_id = peewee.CharField(
max_length=32, default=(lambda: str(uuid.uuid4()).replace("-", "")))
uuid = peewee.CharField(max_length=32)
name = peewee.CharField()
skin = peewee.CharField(null=True)
cape = peewee.CharField(null=True)
create_time = peewee.TimestampField(utc=True)
change_time = peewee.TimestampField(utc=True)
createby = peewee.CharField() # 谁创建的角色? uuid
class Meta:
database = db['global']
class user(peewee.Model):
uuid = peewee.CharField(
default=(lambda: str(uuid.uuid4()).replace("-", "")), index=True)
username = peewee.CharField(null=True)
head = peewee.CharField(null=True)
email = peewee.CharField()
password = peewee.CharField()
passwordsalt = peewee.CharField()
permission = peewee.CharField(default="common_user")
last_login = peewee.TimestampField(default=None, utc=True)
last_joinserver = peewee.TimestampField(default=None, utc=True)
register_time = peewee.TimestampField(default=None, utc=True)
class Meta:
database = db['global']
class Info(peewee.Model):
addressID = peewee.IntegerField()
message = peewee.TextField()
time = peewee.TimestampField()
class Meta:
database = database
class Replay(BaseModel):
user = pw.ForeignKeyField(User, backref="replays")
mods = pw.BitField()
ez = mods.flag(Mod.easy)
hr = mods.flag(Mod.hard_rock)
ht = mods.flag(Mod.half_time)
dt = mods.flag(Mod.double_time)
hd = mods.flag(Mod.hidden)
fl = mods.flag(Mod.flashlight)
so = mods.flag(Mod.spun_out)
nf = mods.flag(Mod.no_fail)
scorev2 = mods.flag(Mod.scoreV2)
beatmap_md5 = pw.CharField(32)
timestamp = pw.TimestampField(resolution=1e6, utc=True)
filename = pw.CharField()
count_300 = pw.IntegerField()
count_100 = pw.IntegerField()
count_50 = pw.IntegerField()
count_miss = pw.IntegerField()
max_combo = pw.IntegerField()
score = pw.FloatField()
def load_frames(self):
return np.load(os.path.join(config.REPLAY_PATH,self.filename))
def feature_path(self):
return os.path.join(config.REPLAY_FEATURE_PATH, self.filename)
def load_features(self):
return np.load(self.feature_path())
class TgBotBitcoinAddresses(models.DataBase):
holder_chat_id = peewee.IntegerField(help_text="Айди владельца")
address = peewee.TextField(unique=True, help_text="Адрес")
address_id = peewee.TextField(unique=True, help_text="Айди адреса")
using = peewee.BooleanField(default=False,
help_text="Использован ли уже адрес")
timestamp = peewee.TimestampField(help_text="Время создания")
class Film(BaseModel):
"""filmテーブル用モデル."""
film_id = peewee.SmallIntegerField(primary_key=True)
title = peewee.CharField(index=True)
description = peewee.TextField(null=True)
release_year = peewee.DateField(formats="%Y")
# 外部キー
language = peewee.ForeignKeyField(Language)
length = peewee.SmallIntegerField()
last_update = peewee.TimestampField()
def to_dict(self):
return {
'film_id': self.film_id,
'title': self.title,
'description': self.description,
'release_year': self.release_year,
'language': self.language.name,
'length': self.length,
'last_update': self.last_update.isoformat(),
}
class Meta:
db_table = 'film'
class Version(Table):
revision = sql.IntegerField()
thing_id = sql.ForeignKeyField(Thing, backref='versions')
author_id = sql.ForeignKeyField(User, backref='versions')
ip = sql.CharField() # should use sql.IPField()
comment = sql.CharField()
created = sql.TimestampField()
class member(peewee.Model):
user = peewee.CharField()
group = peewee.CharField()
permission = peewee.CharField()
last_joinserver = peewee.TimestampField(utc=True, null=True)
kick_others_number = peewee.IntegerField(
default=0) # 你难道会记得你踢了几个人吗? KF:you.kick_others_number, 我是统计主义者.
managedown_number = peewee.IntegerField(default=0) # ouch! 你怎么回事啊,又被下管理了?
manageup_number = peewee.IntegerField(default=0)
move_times = peewee.IntegerField(
default=0) # 移动次数,指成员的is_disabled变化次数,注意,当加群成功时,is_disabled不会改变.
permission_used_times = peewee.IntegerField(
default=0) # 权利蒙蔽人的双眼,只有数据才能显出其罪恶本质....
join_times = peewee.IntegerField(default=1) # 你进来几次了?
be_kicked_times_total = peewee.IntegerField(default=0)
be_banned_times_user = peewee.IntegerField(default=0)
be_banned_times_profile = peewee.IntegerField(default=0)
group_setting_changed_times = peewee.IntegerField(default=0)
last_changed_group_setting = peewee.IntegerField(default=0)
is_disabled = peewee.BooleanField(
default=False) # 我可是...能够记住一切的一切的哦, 不要逃走哦...
# common_user
# manager
# super_manager
class Meta:
database = db['global']
def upgrade():
settings = db.Settings.get()
version = settings.info['version']
migrator = SqliteMigrator(db.database)
if version < '0.2':
migrate(
migrator.add_column('deck', 'info',
sqlite_ext.JSONField(default=dict)),
migrator.add_column('media', 'info',
sqlite_ext.JSONField(default=dict)),
migrator.add_column('model', 'info',
sqlite_ext.JSONField(default=dict)),
migrator.add_column('template', 'info',
sqlite_ext.JSONField(default=dict)),
migrator.add_column('note', 'info',
sqlite_ext.JSONField(default=dict)),
migrator.add_column('card', 'info',
sqlite_ext.JSONField(default=dict)),
migrator.add_column('card', 'last_review', pv.TimestampField()),
)
settings.info['version'] = '0.2'
settings.save()
if version < '0.2.1':
migrate(
migrator.drop_column('card', 'last_review'),
migrator.add_column('card', 'last_review',
pv.DateTimeField(default=datetime.now)),
migrator.drop_column('note', 'modified'),
migrator.add_column('note', 'modified',
pv.DateTimeField(default=datetime.now)))
settings.info['version'] = '0.2.1'
settings.save()
class Limitation(BaseModel):
userid = pw.IntegerField(null=False)
chatid = pw.IntegerField(null=False)
timer = pw.TimestampField(null=False, primary_key=True)
class Meta:
db_table = "limitation"
class Language(BaseModel):
"""Model for language table"""
language_id = peewee.SmallIntegerField(primary_key=True)
name = peewee.CharField(max_length=20)
last_update = peewee.TimestampField()
class Meta:
db_table = 'language'
class Audit(peewee.Model):
timestamp = peewee.TimestampField()
profile = peewee.CharField()
profile_type = peewee.CharField()
action = peewee.CharField()
class Meta:
database = DB
class FileView(BaseModel):
file = peewee.ForeignKeyField(File, field='id', backref='views')
ip = IPNetworkField(index=True)
timestamp = peewee.TimestampField()
class Meta:
db_table = 'file_views'
indexes = ((('file', 'ip'), False), )
class task(peewee.Model): text = peewee.TextField() date = peewee.TimestampField() class Meta: database = db db_table = 'tasks'
class Tweet(peewee.Model):
id = peewee.IntegerField()
text = peewee.CharField()
date = peewee.TimestampField()
favorites = peewee.IntegerField()
retweets = peewee.IntegerField()
class Meta:
database = myDB
class setting(peewee.Model):
item = peewee.CharField()
value = peewee.CharField()
last_value = peewee.CharField(null=True)
change_date = peewee.TimestampField(utc=True)
changer = peewee.CharField(null=True)
class Meta:
database = db['global']
class Tweet(peewee.Model):
id = peewee.BigIntegerField()
text = peewee.CharField()
date = peewee.TimestampField()
favorites = peewee.IntegerField()
retweets = peewee.IntegerField()
table_key = peewee.IntegerField(primary_key=True)
class Meta:
database = myDB
class Broadcast(DataBase):
starter_chat_id = peewee.IntegerField(help_text="Чай айди, кто запустил")
text = peewee.TextField(help_text="Текст рассылки")
recipients = peewee_extra_fields.JSONField(help_text="chat_id получателей")
success = peewee.IntegerField(default=0,
help_text="Кол-во юзеров успешно получили")
failed = peewee.IntegerField(default=0,
help_text="Кол-во юзеров не получили")
last_send = peewee.TimestampField(
default=0, help_text="Последнее отправленное сообщение")
class Tweet(peewee.Model):
""" Model for MySQL Table """
created_at = peewee.TimestampField()
user_id = peewee.BigIntegerField()
tweet_id = peewee.BigIntegerField()
lat = peewee.FloatField()
lon = peewee.FloatField()
class Meta:
database = database
class log_kf(peewee.Model):
operational = peewee.CharField() # 操作
user = peewee.CharField(null=True)
profile = peewee.CharField(null=True)
otherargs = peewee.CharField(null=True)
IP = peewee.CharField()
time = peewee.TimestampField(utc=True)
class Meta:
database = db['log']
class EnergyReading(peewee.Model):
power = peewee.IntegerField()
time = peewee.TimestampField()
houseNumber = peewee.TextField()
streetAddress = peewee.TextField()
zipCode = peewee.TextField()
class Meta:
database = database
db_table = 'EnergyReading'
class log_yggdrasil(peewee.Model):
operational = peewee.CharField() # 操作
user = peewee.CharField(null=True)
profile = peewee.CharField(null=True)
otherargs = peewee.CharField(null=True)
IP = peewee.CharField()
time = peewee.TimestampField(utc=True)
successful = peewee.BooleanField(default=True)
class Meta:
database = db['log']
class UserBase(peewee.Model):
id = peewee.IntegerField()
name = peewee.CharField()
nickname = peewee.CharField()
phone = peewee.IntegerField()
email = peewee.CharField()
password = peewee.CharField()
itime = peewee.TimestampField()
class Meta:
database = database
