class Withdrawal(BaseModel):
__tablename__ = 'withdrawal'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column('user_id', db.ForeignKey(User.id), unique=True)
amount = db.Column('amount', db.Float, nullable=False)
created_time = db.Column('created_time', db.Float, nullable=False)
settled = db.Column('settled', db.Integer, nullable=False, default=0)
user = db.relationship('User', foreign_keys='Withdrawal.user_id', lazy='select')
_fields = {
'user': {
'type': 'model',
'show': True
},
'amount': {
'type': 'base',
'show': True
},
'created_time': {
'type': 'base',
'show': True
},
'settled': {
'type': 'base',
'show': True
}
}
class Userrefreshtoken(BaseModel):
__tablename__ = 'userrefreshtoken'
id = db.Column('id', db.Integer, primary_key=True)
user_id = db.Column('user_id', db.ForeignKey(User.id), nullable=False)
refresh_token = db.Column('refresh_token', db.String(64), nullable=False)
expired_time = db.Column('expired_time', db.Float, nullable=False)
user = db.relationship('User',
foreign_keys='Userrefreshtoken.user_id',
lazy='select')
_fields = {
'user': {
'type': 'model',
'show': False
},
'refresh_token': {
'type': 'base',
'show': True
},
'expired_time': {
'type': 'base',
'show': True
}
}
class Spamblock(BaseModel):
__tablename__ = 'spamblock'
id = db.Column(db.Integer, primary_key=True)
count = db.Column('count', db.Integer, nullable=False, default=0)
key = db.Column('key', db.String(128), nullable=False)
expired_time = db.Column('expired_time', db.Float, nullable=True)
class User(BaseModel):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True)
username = db.Column('username', db.String(64), nullable=True)
passhash = db.Column('passhash', db.String(64), nullable=True)
salt = db.Column('salt', db.String(32), nullable=True)
balance = db.Column('balance', db.Float, nullable=False, default=0)
created_time = db.Column('created_time', db.Float, nullable=False)
updated_time = db.Column('updated_time', db.Float, nullable=False)
deleted = db.Column('deleted', db.Integer, nullable=False, default=0)
_fields = {
'id': {
'type': 'base',
'show': True
},
'username': {
'type': 'base',
'show': True
},
'balance': {
'type': 'base',
'show': False
},
'created_time': {
'type': 'base',
'show': True
},
'updated_time': {
'type': 'base',
'show': True
}
}
class Game(BaseModel):
__tablename__ = 'game'
id = db.Column(db.Integer, primary_key=True)
name = db.Column('name', db.String(64), nullable=False)
title = db.Column('title', db.String(128), nullable=False)
def __init__(self, **kwargs):
kwargs['fields'] = {
'name': {
'type': 'base',
'show': True
},
'title': {
'type': 'base',
'show': True
}
}
super().__init__(**kwargs)
class Tag(BaseModel):
__tablename__ = 'tag'
id = db.Column(db.Integer, primary_key=True)
name = db.Column('name', db.String(64), nullable=False)
title = db.Column('title', db.String(64), nullable=False)
blog_id = db.Column('blog_id', db.ForeignKey(Blog.id), nullable=False)
blog = db.relationship('Blog', foreign_keys='Tag.blog_id', lazy='select')
_fields = {
'id': {
'type': 'base',
'show': True
},
'name': {
'type': 'base',
'show': True
},
'title': {
'type': 'base',
'show': True
}
}
class Pokerhand(BaseModel):
__tablename__ = 'pokerhand'
id = db.Column(db.Integer, primary_key=True)
identifier = db.Column('identifier', db.String(32), nullable=False)
user_id = db.Column('user_id', db.ForeignKey(User.id), nullable=False)
info = db.Column('info',
JSONField(enforce_string=True, enforce_unicode=False),
nullable=False)
multiplier = db.Column('multiplier', db.Integer, nullable=False)
time = db.Column('time', db.Float, nullable=False)
settled = db.Column('settled', db.Integer, nullable=False, default=0)
user = db.relationship('User',
foreign_keys='Pokerhand.user_id',
lazy='select')
_fields = {
'identifier': {
'type': 'model',
'show': True
},
'user': {
'type': 'model',
'show': False
},
'info': {
'type': 'base',
'show': True
},
'multiplier': {
'type': 'base',
'show': True
},
'time': {
'type': 'base',
'show': True
},
'settled': {
'type': 'base',
'show': False
},
}
class Deposit(BaseModel):
__tablename__ = 'deposit'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column('user_id', db.ForeignKey(User.id))
amount = db.Column('amount', db.Float, nullable=False)
r_hash = db.Column('r_hash', db.String(64), nullable=False)
created_time = db.Column('created_time', db.Float, nullable=False)
expired_time = db.Column('expired_time', db.Float, nullable=False)
settled = db.Column('settled', db.Integer, nullable=False, default=0)
user = db.relationship('User', foreign_keys='Deposit.user_id', lazy='select')
_fields = {
'user': {
'type': 'model',
'show': True
},
'amount': {
'type': 'base',
'show': True
},
'r_hash': {
'type': 'base',
'show': True
},
'created_time': {
'type': 'base',
'show': True
},
'expired_time': {
'type': 'base',
'show': True
},
'settled': {
'type': 'base',
'show': True
}
}
class Log(BaseModel):
__tablename__ = 'log'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column('user_id', db.ForeignKey(User.id))
game_id = db.Column('game_id', db.ForeignKey(Game.id), nullable=True)
event = db.Column('event', db.String(64), nullable=False)
info = db.Column('info',
JSONField(enforce_string=True, enforce_unicode=False),
nullable=False)
time = db.Column('time', db.Float, nullable=False)
user = db.relationship('User', foreign_keys='Log.user_id', lazy='select')
game = db.relationship('Game', foreign_keys='Log.game_id', lazy='select')
def __init__(self, **kwargs):
kwargs['fields'] = {
'user': {
'type': 'model',
'show': True
},
'game': {
'type': 'model',
'show': True
},
'event': {
'type': 'base',
'show': True
},
'info': {
'type': 'base',
'show': True
},
'time': {
'type': 'base',
'show': True
}
}
super().__init__(**kwargs)
