class BoardCoordinates(db.Model): __tablename__ = 'boardcoordinates' id = db.Column(db.Integer(), primary_key=True) user = db.Column(db.Integer, db.ForeignKey('users.id')) x1 = db.Column(db.Integer) y1 = db.Column(db.Integer) x2 = db.Column(db.Integer) y2 = db.Column(db.Integer) x3 = db.Column(db.Integer) y3 = db.Column(db.Integer)
class Role(db.Model, RoleMixin): __tablename__ = 'roles' id = db.Column(db.Integer(), primary_key=True) name = db.Column(db.String(80), unique=True) description = db.Column(db.String(255))
from flask_security import UserMixin, RoleMixin from lidarts import db from datetime import datetime, timedelta import secrets from sqlalchemy.ext.associationproxy import association_proxy from sqlalchemy.ext.declarative import declared_attr, AbstractConcreteBase from sqlalchemy.orm import relationship # Define models roles_users = db.Table( 'roles_users', db.Column('user_id', db.Integer(), db.ForeignKey('users.id')), db.Column('role_id', db.Integer(), db.ForeignKey('roles.id'))) tournament_players_association_table = db.Table( 'association', db.Column('user_id', db.Integer, db.ForeignKey('users.id'), primary_key=True), db.Column('tournament_id', db.Integer, db.ForeignKey('tournaments.id'), primary_key=True), ) tournament_banned_players_association_table = db.Table( 'tournament_banned_players_association', db.Column('user_id', db.Integer, db.ForeignKey('users.id'),