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")