class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
username = db.Column(db.String(30), nullable=False)
password = db.Column(db.String(30), nullable=False)
icons = db.Column(db.String(100), nullable=True)
___tablename__ = 'user'
class Raca(db.Model):
idRaca = db.Column(db.Integer(), primary_key=True)
nomeRaca = db.Column(db.String())
idStatus = db.Column(db.Integer(), ForeignKey('Status.idStatus'))
descricao = db.Column(db.String())
def __init__(self, **kwargs):
super().__init__(**kwargs)
self.nomeRaca = kwargs.pop('nomeRaca')
self.idStatus = kwargs.pop('idStatus')
self.descricao = kwargs.pop('descricao')
class Resposta(db.Model):
__tablename__ = "Resposta"
idResposta = db.Column(db.Integer, primary_key=True)
resposta = db.Column(db.String())
contadorResposta = db.Column(db.Integer())
idPergunta = db.Column(db.Integer(), ForeignKey('Pergunta.idPergunta'), primary_key=True)
perg = relationship(Pergunta)
def __init__(self, **kwargs):
super().__init__(**kwargs)
self.resposta = kwargs.pop('resposta')
self.contadorResposta = 0
self.idPergunta = kwargs.pop('idPergunta')
class Eleitor(db.Model):
__tablename__ = "Eleitor"
statusVoto = db.Column(db.Integer())
idEleicao = db.Column(db.Integer(), ForeignKey('Eleicao.idEleicao'), primary_key=True)
eleicao = relationship(Eleicao)
login = db.Column(db.String(),ForeignKey('Pessoa.login'),primary_key=True)
pessoa = relationship(Pessoa)
def __init__(self, **kwargs):
super().__init__(**kwargs)
self.statusVoto = 0
self.idEleicao = kwargs.pop('idEleicao')
self.login = kwargs.pop('login')
class User(db.Model):
__tablename__ = 'usertable'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(15), unique=True)
username = db.Column(db.String(15), unique=True)
email = db.Column(db.String(50), unique=True)
password = db.Column(db.String(256), unique=True)
class Pergunta(db.Model):
__tablename__ = "Pergunta"
idPergunta = db.Column(db.Integer, primary_key=True)
pergunta = db.Column(db.String())
numMinResposta = db.Column(db.Integer())
numMaxResposta = db.Column(db.Integer())
idEleicao = db.Column(db.Integer(), ForeignKey('Eleicao.idEleicao'))
eleicao = relationship(Eleicao)
def __init__(self, **kwargs):
super().__init__(**kwargs)
self.pergunta = kwargs.pop('pergunta')
self.numMinResposta = kwargs.pop('numMinResposta')
self.numMaxResposta = kwargs.pop('numMaxResposta')
self.idEleicao = kwargs.pop('idEleicao')
class Pessoa(db.Model):
__tablename__ = "Pessoa"
login = db.Column(db.String(), primary_key=True)
nomePessoa = db.Column(db.String())
tipo = db.Column(db.Integer())
senha = db.Column(db.String(128))
def __init__(self, **kwargs):
super().__init__(**kwargs)
self.login = kwargs.pop('login')
self.nomePessoa = kwargs.pop('nomePessoa')
self.tipo = kwargs.pop('tipo')
self.senha = generate_password_hash(kwargs.pop('senha'))
def set_password(self, password):
self.senha = generate_password_hash(password)
def check_password(self, password):
return check_password_hash(self.senha, password)
def __repr__(self):
return '<User {}>'.format(self.login)
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
def repr(self):
return f"User1('{self.username}','{self.email}')"
def get_reset_token(self, expires_sec=1800):
s = Serializer(app.config['SECRET_KEY'], expires_sec)
return s.dumps({'user_id': self.id}).decode('utf-8')
@staticmethod
def verify_reset_token(token):
s = Serializer(app.config['SECRET_KEY'])
try:
user_id = s.loads(token)['user_id']
except:
return None
return User.query.get(user_id)
class ColdSession(db.Model):
__tablename__ = 'cold_session'
uuid = db.Column(db.String, primary_key=True, nullable=False)
created_on = db.Column(db.DateTime, default=datetime.utcnow)
notes = db.Column(db.Text, default='')
duration = db.Column(db.Integer, default=0)
type = db.Column(db.String)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
def __init__(self, **kwargs):
self.uuid = kwargs.pop('uuid')
self.notes = kwargs.pop('notes', '')
self.type = kwargs.pop('type', '')
self.user_id = kwargs.pop('user_id')
def to_dict(self):
return {
'uuid': self.uuid,
'userId': self.user_id,
'createdOn': self.created_on,
'duration': self.duration,
'notes': self.notes
}
def to_json(self):
return json.dumps(self.to_dict())
class Status(db.Model):
__tablename__ = "Status"
idStatus = db.Column(db.Integer(), primary_key=True)
vidaMax = db.Column(db.Integer())
vidaAtual = db.Column(db.Integer())
forca = db.Column(db.Integer())
resistencia = db.Column(db.Integer())
inteligencia = db.Column(db.Integer())
velocidade = db.Column(db.Integer())
iniciativa = db.Column(db.Integer())
sorte = db.Column(db.Integer())
tamInventario = db.Column(db.Integer())
def __init__(self, **kwargs):
super().__init__(**Kwargs)
self.vidaMax = kwargs.pop('vidaMax')
self.vidaAtual = kwargs.pop('vidaAtual')
self.forca = kwargs.pop('forca')
self.resistencia = kwargs.pop('resistencia')
self.inteligencia = kwargs.pop('inteligencia')
self.velocidade = kwargs.pop('velocidade')
self.iniciativa = kwargs.pop('iniciativa')
self.sorte = kwargs.pop('sorte')
self.tamInventario = kwargs.pop('tamInventario')
class Task(Base):
"""Task for the to-Do List."""
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.Unicode, nullable=False)
note = db.Column(db.Unicode)
creation_date = db.Column(db.DateTime, nullable=False)
due_date = db.Column(db.DateTime)
completed = db.Column(db.Boolean, default=False)
def __init__(self, *args, **kwargs):
"""On constructionn, set date of creation."""
super().__init__(*args, **kwargs)
self.creation_date = datetime.now()
class Eleicao(db.Model):
__tablename__ = "Eleicao"
idEleicao = db.Column(db.Integer, primary_key=True)
eleicao = db.Column(db.String())
dataInicio = db.Column(db.String())
dataFinal = db.Column(db.String())
statusEleicao = db.Column(db.Integer())
apuracao = db.Column(db.Integer())
login = db.Column(db.String(),ForeignKey('Pessoa.login'))
pessoa = relationship(Pessoa)
def __init__(self, **kwargs):
super().__init__(**kwargs)
self.eleicao = kwargs.pop('eleicao')
self.dataInicio = (str(datetime.now())).split('.')[0]
self.dataFinal = '0'
self.statusEleicao = 0
self.apuracao = 0
self.login = kwargs.pop('login')
class Article(db.Model):
__tablename__ = 'article' # 如果不指定表名，会默认以这个类名的小写为表名
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
title = db.Column(db.String(100), nullable=False)
content = db.Column(db.Text, nullable=False)
