def job_info(id):
session = create_session()
job = session.query(Jobs).filter(Jobs.id == id).first()
user = session.query(User).filter(job.customer == User.id).first()
return render_template('job_info.html', job=job, user=user)
def jobs_list(id):
session = create_session()
jobs = session.query(Jobs).filter(Jobs.customer == id).all()
user = session.query(User).filter(User.id == id).first()
return render_template('jobs_list.html', jobs=jobs, user=user)
def index():
db_sess = db_session.create_session()
journal = db_sess.query(Jobs)
return render_template('index.html', journal=journal)
def get(self, note_id):
session = db_session.create_session()
note = session.query(Note).get(note_id)
if note:
return jsonify(note.to_dict(only=('authorid', 'text', 'category')))
abort(404, message=f"User {note_id} not found")
def index():
db_sess = db_session.create_session()
news = db_sess.query(News).filter(News.is_private != True)
return render_template("index.html", news=news)
def isAuthorized(userid):
session = db_session.create_session()
return userid in [user[0] for user in session.query(Users.userid).all()]
def load_user(user_id):
db_sess = db_session.create_session()
return db_sess.query(User).get(user_id)
def load_user(user_id):
session = db_session.create_session()
return session.query(User).get(user_id)
def abort_if_job_not_found(job_id):
session = db_session.create_session()
job = session.query(Jobs).get(job_id)
if not job:
abort(404, message=f"Job {job_id} not found")
def lesson_attendance(lesson_id): # TODO: ДОДЕЛАТЬ ФОРМУ АТО НЕ РАБОТАЕТ ЫЫЫЫЫ
db_sess = db_session.create_session()
if current_user.type in (1, 3):
if current_user.type == 1: # Проверка принадлежит ли группа учителю
groups = db_sess.query(Group.id).filter(Group.teacher_id == current_user.id).all
if lesson_id not in groups:
return abort(404) # выгоняем со странички, если нет
lesson = db_sess.query(Lessons).filter(Lessons.id == lesson_id).first()
attendance = db_sess.query(Attendance).filter(Attendance.lesson_id == lesson_id).all()
if not attendance:
add_attendances(lesson_id)
attendance = db_sess.query(Attendance).filter(Attendance.lesson_id == lesson_id).all()
attendance.sort(key=lambda x: x.lesson_number)
data = [[]]
prev = attendance[0].lesson_number
for elem in attendance:
if elem.lesson_number != prev:
prev = elem.lesson_number
data.append([])
data[-1].append(elem)
data = tuple(zip(*data[::-1]))
students = []
for elem in data:
user = db_sess.query(User).filter(elem[0].student_id == User.id).first()
# students.append(user.name + ' ' + user.surname)
students.append(user)
# print(students)
today = datetime.now()
first = datetime(today.year, 1, int(lesson.date[:1]))
dtime = timedelta(days=7)
dates = [(str((first + dtime * j).date().day) + '.' + str((first + dtime * j).date().month)) for j in
range(max([len(i) for i in data]) + 1)]
form = AttendanceForm()
for _ in range(len(attendance)):
form.all.append_entry()
if form.validate_on_submit(): # обработка формы (получение даг=ныых)
# print(form.all.data)
new_id = request.form.get('student_id')
if new_id:
student = db_sess.query(User).filter(User.id == new_id).first()
if not student:
return render_template('attendance_table.html', data=data, students=students, dates=dates,
form=form,
title='Посещаемость', message='Такого пользователя не существует')
return redirect('/')
# adder_form = AddPaymentForm()
# if adder_form.validate_on_submit():
# new_id = request.form.get('student_id')
# student = db_sess.query(User).filter(User.id == new_id).first()
# if not student:
# return render_template('attendance_table.html', data=data, students=students, dates=dates, form=form,
# title='Посещаемость', message='Такого пользователя не существует')
# db_sess.add()
return render_template('attendance_table.html', data=data, students=students, dates=dates, form=form,
title='Посещаемость')
elif current_user.type == 2:
return abort(404)
def get(self, job_id):
abort_if_job_not_found(job_id)
session = db_session.create_session()
job = session.query(Jobs).get(job_id)
return jsonify({'job': job.to_dict(only=(list_of_parameters_jobs))})
def info(goods_id):
sessions = db_session.create_session()
goods = sessions.query(Goods).filter(Goods.id == goods_id).first()
return render_template("info.html", title='Информация о товаре', goods=goods)
def main():
db_session.global_init("db/blogs.db")
db_sess = db_session.create_session()
db_sess.commit()
app.run()
def profile(id):
session = create_session()
user = session.query(User).filter(User.id == id).first()
projects = session.query(Projects).filter(user.id == Projects.author).all()
return render_template('profile.html', user=user, projects=projects)
def validate_username(self, username):
session = db_session.create_session()
user = session.query(User).filter(User.name == username.data).first()
if user is not None:
raise ValidationError('Такое имя пользователя уже существует!')
def read_maps(
): # функция для загрузки карт из папки static/maps в базу данных
songs = os.listdir(path="static/maps")
maps = []
sess = db_session.create_session()
for song in songs:
if song.endswith('.zip'):
continue
file_names = os.listdir(path=f'static/maps/{song}')
diffs = [diff for diff in file_names if diff.endswith('.osu')]
for diff in diffs:
file = open(f'static/maps/{song}/{diff}',
encoding="utf-8").read().split('\n')
dir = song
general_line = file.index('[General]')
general = {}
cur_line = general_line + 1
while file[cur_line].lstrip() != '':
current = file[cur_line]
tag = current[:current.find(':')]
info = current[current.find(':') + 1:]
general[tag] = info.lstrip()
cur_line += 1
metadata_line = file.index('[Metadata]')
metadata = {}
cur_line = metadata_line + 1
while file[cur_line].lstrip() != '':
current = file[cur_line]
tag = current[:current.find(':')]
info = current[current.find(':') + 1:]
metadata[tag] = info.lstrip()
cur_line += 1
events_line = file.index('[Events]')
events = []
cur_line = events_line + 1
while file[cur_line].lstrip() != '':
current = file[cur_line]
current = current.split(',')
current = [i.lstrip() for i in current]
events.append(current)
cur_line += 1
name = metadata['Title']
artist = metadata['Artist']
creator = metadata['Creator']
version = metadata['Version']
beatmap_id = metadata['BeatmapID']
music = f"/static/maps/{dir}/{general['AudioFilename']}"
mp = sess.query(Map).filter(Map.name == name, Map.artist == artist,
Map.creator == creator,
Map.version == version,
Map.music == music)
try:
model = mp.one()
continue
except NoResultFound:
for elem in events:
event_type, *another = elem
if event_type == '0':
c, background_file, x_offset, y_offset = another
background_file = background_file.rstrip('"').lstrip(
'"')
background = pygame.image.load(
f'static/maps/{dir}/{background_file}')
path = f"static/img/maps/{background_file}.png"
pygame.image.save(background, path)
map = Map(name=name,
artist=artist,
creator=creator,
version=version,
music=music,
image=path,
filename=f"/static/maps/{song}",
beatmap_id=beatmap_id)
sess.add(map)
sess.commit()
def abort_if_user_not_found(user_id):
session = db_session.create_session()
user = session.query(User).get(user_id)
if not user:
abort(404, message=f"User {user_id} not found")
def abort_if_news_not_found(note_id):
session = db_session.create_session()
notes = session.query(Posts).get(note_id)
if not notes:
abort(404, message=f"Note {note_id} not found")
def get_one_news(jobs_id):
db_sess = db_session.create_session()
jobs = db_sess.query(Jobs).get(jobs_id)
if not jobs:
return flask.jsonify({'error': 'Not found'})
return flask.jsonify({'jobs': jobs.to_dict()})
'quiet': True,
'no_warnings': True,
'default_search': 'auto',
'source_address':
'0.0.0.0' # bind to ipv4 since ipv6 addresses cause issues sometimes
}
ffmpeg_options = {'options': '-vn'}
ytdl = youtube_dl.YoutubeDL(ytdl_format_options)
logging.basicConfig(filename='logs.txt', level=20)
players = {}
queue = asyncio.Queue(maxsize=1000)
player = None
db_session.global_init('db/discord_users.db')
db_sess = db_session.create_session()
title = None
administration_roles = []
class UrlError(Exception):
pass
def is_url(string: str):
protocol = string.startswith('https://') or string.startswith('http://')
address = 'youtube.com' in string
params = 'watch?v=' in string
return protocol and address and params
def get_jobs():
db_sess = db_session.create_session()
news = db_sess.query(Jobs).all()
return flask.jsonify({'jobs': [item.to_dict() for item in news]})
def get_order(order_id):
session = db_session.create_session()
return session.query(Order).get(order_id)
def abort_if_comment_not_found(comment_id):
session = db_session.create_session()
comments = session.query(Comments).get(comment_id)
if not comments:
abort(404, message=f"Comment {comment_id} not found")
