class DegreeProgramm(db.Model): id = db.Column(db.Integer, primary_key=True) faculty_id = db.Column(db.Integer, nullable=True) name = db.Column(db.String(255), nullable=True) def __repr__(self): return f'{self.id} {self.faculty_id} {self.name}'
class hospitals(db.Model): __tablename__ = 'hospitals' __table_args__ = {'extend_existing': True} id = db.Column(db.Integer, primary_key=True) hospital_name = db.Column(db.String(128), nullable=False, unique=False) street = db.Column(db.String(128), nullable=False, unique=False) boss = db.Column(db.String(128), nullable=False, unique=False)
class Message(db.Model): id = db.Column(db.Integer, primary_key=True) text = db.Column(db.String(1024), nullable=False) def __init__(self, text, tags): self.text = text.strip() self.tags = [Tag(text=tag.strip()) for tag in tags.split(',')]
class Tag(db.Model): id = db.Column(db.Integer, primary_key=True) text = db.Column(db.String(32), nullable=False) message_id = db.Column(db.Integer, db.ForeignKey('message.id'), nullable=False) message = db.relationship('Message', backref=db.backref('tags', lazy=True))
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) login = db.Column(db.String(64), nullable=False, unique=True) email = db.Column(db.String(128), nullable=False, unique=True) password = db.Column(db.String(255), nullable=False) date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow()) def __repr__(self): return '<User %r>' % self.id
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) login = db.Column(db.String(255), nullable=False, unique=True) password = db.Column(db.String(255), nullable=False) type = db.Column(db.Integer, nullable=2) fio = db.Column(db.String(255), nullable=True) def __repr__(self): return f'{self.id} {self.fio} {self.type}'
class Student(db.Model): id = db.Column(db.Integer, db.ForeignKey('user.id'), primary_key=True) group_id = db.Column(db.Integer, db.ForeignKey('group.id'), nullable=True) # чтобы это заработало, нужно указать какой из ключей выше является внешним ключем userData = db.relationship('User', backref='student', uselist=False) group = db.relationship('Group', backref='student', uselist=False) def __repr__(self): return f'{self.id}'
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) login = db.Column(db.String(128), nullable=False, unique=True) password = db.Column(db.String(255), nullable=False) pass_img = db.Column(db.String(255), nullable=False) counter = db.Column(db.Integer, default=0) coordinates = db.Column(db.String(128)) banned = db.Column(db.Integer, default=0) false_click_counter = db.Column(db.Integer, default=0) zone = db.Column(db.String(512)) probability = db.Column(db.String(512))
class Users(db.Model): id = db.Column(db.Integer, primary_key=True) login = db.Column(db.String(128), nullable=False) password = db.Column(db.String(128), nullable=False) def __init__(self, login, password): self.login = login self.password = password def __rept__(self): return f'id:{self.id} | login:{self.login} | password:{self.password}'
class Discipline(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(255), nullable=True) teacher_id = db.Column(db.Integer, db.ForeignKey('teacher.id'), nullable=True) teacher = db.relationship('Teacher', backref='discipline', uselist=False) def __repr__(self): return f'{self.id} {self.teacher_id} {self.name}'
class Department(db.Model): id = db.Column(db.Integer, primary_key=True) faculty_id = db.Column(db.Integer, db.ForeignKey('faculty.id'), nullable=True) name = db.Column(db.String(255), nullable=True) faculty = db.relationship('Faculty', backref='department', uselist=False) def __repr__(self): return f'\nid = {self.id}\tfaculty_id={self.faculty_id} name={self.name}'
class Teacher(db.Model): id = db.Column(db.Integer, db.ForeignKey('user.id'), primary_key=True) department_id = db.Column(db.Integer, db.ForeignKey('department.id')) # чтобы это заработало, нужно указать какой из ключей выше является внешним ключем department = db.relationship('Department', backref='teacher', uselist=False) userData = db.relationship('User', backref='teacher', uselist=False) def __repr__(self): return f'{self.id}'
class Posts(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(128), nullable=False) text = db.Column(db.String(128), nullable=False) author = db.Column(db.String(128), nullable=False) def __init__(self, title, text, author): self.title = title self.text = text self.author = author def __rept__(self): return f'id:{self.id} | title:{self.title} | text:{self.text} | author:{self.author}'
class Todos(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(128), nullable=False) successful = db.Column(db.Boolean) author = db.Column(db.String(128), nullable=False) def __init__(self, name, successful, author): self.name = name self.successful = successful self.author = author def __rept__(self): return f'id:{self.id} | name:{self.name} | successful:{self.successful} | author:{self.author}'
class Group(db.Model): id = db.Column(db.Integer, primary_key=True) degree_programm_id = db.Column(db.Integer, db.ForeignKey('degree_programm.id')) name = db.Column(db.String(255), nullable=True) disciplines = db.Column(db.String, nullable=True) # чтобы это заработало, нужно указать какой из ключей выше является внешним ключем degreeProgramm = db.relationship('DegreeProgramm', backref='group', uselist=False) def __repr__(self): return f'{self.id} {self.name}'
class Comment(db.Model): id = db.Column(db.Integer, primary_key=True) text = db.Column(db.Text, nullable=False) date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow()) owner_id = db.Column(db.Integer, db.ForeignKey('user.id')) owner = db.relationship('User', backref=db.backref('creater', lazy=True)) article_id = db.Column(db.Integer, db.ForeignKey('article.id')) article = db.relationship('Article', backref=db.backref('article', lazy=True)) def __repr__(self): return '<Comment %r' % self.id
class arrival_of_medicines(db.Model): __tablename__ = 'arrival_of_medicines' __table_args__ = {'extend_existing': True} id = db.Column(db.Integer, primary_key=True) num = db.Column(db.Integer, nullable=False, unique=False) producer = db.Column(db.String(128), nullable=False, unique=False) date_arrival = db.Column(db.DATE, nullable=False, unique=False) units = db.Column(db.String(128), nullable=False, unique=False) price_per_piece = db.Column(db.Integer, nullable=False, unique=False) number = db.Column(db.Integer, nullable=False, unique=False) expiration_date = db.Column(db.DATE, nullable=False, unique=False) name = db.Column(db.String(128), nullable=False, unique=False)
class Article(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(128), nullable=False) cut = db.Column(db.String(128), nullable=False) text = db.Column(db.Text, nullable=False) date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow()) owner_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) owner = db.relationship('User', backref=db.backref('owner', lazy=True)) tags = db.relationship('Tag', secondary=tags, lazy='subquery', backref=db.backref('articles', lazy=True)) comments = db.relationship('Comment', lazy=True, backref=db.backref('comments', lazy=True)) def __repr__(self): return '<Article %r>' % self.id
class Europeflags(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(255)) url_img = db.Column(db.String(255))
class Users(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) login = db.Column(db.String(255), nullable=False, unique=True) password = db.Column(db.String(1024), nullable=False) all_tries = db.Column(db.Integer, default=0) right_answers = db.Column(db.Integer, default=0)
from datetime import datetime from flask_login import UserMixin from sweater import db, login_manager tags = db.Table( 'tags', db.Column('tag_id', db.Integer, db.ForeignKey('tag.id'), primary_key=True), db.Column('article_id', db.Integer, db.ForeignKey('article.id'), primary_key=True)) class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) login = db.Column(db.String(64), nullable=False, unique=True) email = db.Column(db.String(128), nullable=False, unique=True) password = db.Column(db.String(255), nullable=False) date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow()) def __repr__(self): return '<User %r>' % self.id class Article(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(128), nullable=False) cut = db.Column(db.String(128), nullable=False) text = db.Column(db.Text, nullable=False)
class Europe(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(255)) capital = db.Column(db.String(255))
class Image(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(128), nullable=False, unique=True)
class drugs_and_invertar(db.Model): __tablename__ = 'drugs_invertar' __table_args__ = {'extend_existing': True} id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(128), nullable=False, unique=False) country = db.Column(db.String(128), nullable=False, unique=False)
class units(db.Model): __tablename__ = 'units' __table_args__ = {'extend_existing': True} id = db.Column(db.Integer, primary_key=True) unit = db.Column(db.String(128), nullable=False, unique=False)
class provider(db.Model): __tablename__ = 'provider' __table_args__ = {'extend_existing': True} id = db.Column(db.Integer, primary_key=True) provider_name = db.Column(db.String(128), nullable=False, unique=False) location = db.Column(db.String(128), nullable=False, unique=False)
class User(db.Model, UserMixin): __tablename__ = 'users' __table_args__ = {'extend_existing': True} id = db.Column(db.Integer, primary_key=True) login = db.Column(db.String(128), nullable=False, unique=True) password = db.Column(db.String(255), nullable=False)
class Tag(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(32), nullable=False) def __repr__(self): return '<tag %r>' % self.name
class User (db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) login = db.Column(db.String(128), nullable=False, unique=True) password = db.Column(db.String(255), nullable=False)
class departments_of_hospital(db.Model): __tablename__ = 'departments_of_hospital' __table_args__ = {'extend_existing': True} id = db.Column(db.Integer, primary_key=True) department_name = db.Column(db.String(128), nullable=False, unique=False)