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)
