def add_film(room_id, cinema_id, user_id):
    form = AddFilmForm()
    if form.validate_on_submit():
        name = form.filmname.data
        content = form.filmadress.data
        nm = FilmModel(db.get_connection())
        nm.insert(name, content, session['user_id'], room_id)
        return redirect("/films/{}/{}/{}".format(str(room_id), str(cinema_id),
                                                 str(user_id)))
    return render_template('add_film.html',
                           title='Добавление фильма',
                           form=form,
                           username=session['username'],
                           room_id=room_id)
def show(film_id, room_id, cinema_id, user_id):
    film = FilmModel(db.get_connection()).get(film_id)
    return '''<div>
            {}
            <a class="btn btn-primary" href="/films/{}/{}/{}">Вернуться в комнату</a>
            </div>'''.format(film[2], str(room_id), str(cinema_id),
                             str(user_id))
def films(room_id, cinema_id, user_id):
    films = FilmModel(db.get_connection()).get_room(room_id)
    return render_template('films.html',
                           username=session['username'],
                           films=films,
                           room_id=room_id,
                           cinema_id=cinema_id,
                           user_id=user_id)
def delete_film(film_id, room_id):
    if 'username' not in session:
        return redirect('/login')
    nm = FilmModel(db.get_connection())
    nm.delete(film_id)
    return redirect("/films/{}".format(room_id))
def delete_room(room_id, cinema_id, user_id):
    nm = RoomModel(db.get_connection())
    films = [x[0] for x in FilmModel(db.get_connection()).get_all(room_id)]
    nm.delete(room_id)
    films = [delete_film(x, room_id) for x in films]
    return redirect("/rooms/{}/{}".format(cinema_id, user_id))