database.py

from flask_sqlalchemy import SQLAlchemy
from flask import *
from datetime import datetime

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///base.db'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
app.config['UPLOAD_FOLDER'] = '/tmp'
db = SQLAlchemy(app)
app.config['SECRET_KEY'] = 'yandexlyceum_secret_key'


# Здесь будут храниться логины и пароли пользователей.

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    login = db.Column(db.String(20), unique=True, nullable=False)
    password = db.Column(db.String(50), unique=False, nullable=False)
    email = db.Column(db.String(50), unique=True, nullable=True)
    admin = db.Column(db.Boolean, unique=False, nullable=False)
    tid = db.Column(db.String(50), unique=False, nullable=True)


# Данная таблица описывает задачу

class Problem(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(500), unique=False, nullable=False)
    statement = db.Column(db.String(5000), unique=False, nullable=False)
    time_end = db.Column(db.String(50), unique=False, nullable=False)
    author_id = db.Column(db.Integer, unique=False, nullable=False)
    solver_id = db.Column(db.Integer, unique=False, nullable=True)
    priority = db.Column(db.Integer, unique=False, nullable=True)
    completion_stage = db.Column(db.Integer, unique=False, nullable=True)
    category = db.Column(db.String(100), unique=False, nullable=True)
    deleted = db.Column(db.Boolean, unique=False, nullable=True)


class TID(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    tid = db.Column(db.String(20), unique=True, nullable=False)
    login = db.Column(db.String(20), unique=False, nullable=False)
# Данная таблица описывает задачу


db.create_all()