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