def del_film(user_id, name, age):
for user in User.select().where(User.user_id == user_id):
film_lis = str(user.lis_film)
film_lis = film_lis.split(',')
nam = ''
for film_id in film_lis:
for film in Film.select().where(Film.film_id == int(film_id)):
if ((name in film.name_film) and (film.year_release == age)):
nam = name
id = film_id
film_lis = film_lis[:film_lis.
index(id)] + film_lis[film_lis.index(id) + 1:]
lis_film = ''
for film in film_lis:
lis_film += str(film) + ','
lis_film = lis_film[:-1]
user.lis_film = lis_film
if user.lis_film[0] == ',':
user.lis_film = user.lis_film[1:]
user.save()
return nam
def change_position(user_id, name, age, pos):
for user in User.select().where(User.user_id == user_id):
film_lis = str(user.lis_film)
film_lis = film_lis.split(',')
for film_id in film_lis:
for film in Film.select().where(Film.film_id == int(film_id)):
if ((name in film.name_film) and (film.year_release == age)):
id = film_id
pos = int(pos) - 1
if pos >= len(film_lis):
pos = len(film_lis) - 1
pos_id = film_lis.index(id)
if pos_id > pos:
film_lis = film_lis[:pos] + list(
id) + film_lis[pos:pos_id] + film_lis[pos_id + 1:]
if pos_id < pos:
film_lis = film_lis[:pos_id] + film_lis[pos_id + 1:pos + 1] + list(
id) + film_lis[pos + 1:]
lis_film = ''
for film in film_lis:
lis_film += str(film) + ','
lis_film = lis_film[:-1]
user.lis_film = lis_film
if user.lis_film[0] == ',':
user.lis_film = user.lis_film[1:]
user.save()
def return_film(name, age):
for film in Film.select().where(Film.name_film == name):
if film.year_release == age:
text = 'Название: ' + film.name_film + "\nГод выхода: " + film.year_release
text += "\nРежзисер и актеры: " + film.actors + "\nЖанр: " + film.genre
text += "\nРейтинг: " + film.reit
return text
return False
def return_up_age(user_id, age):
film_list = []
for user in User.select().where(User.user_id == user_id):
film_lis = str(user.lis_film).split(',')
for film_id in film_lis:
for film in Film.select().where(Film.film_id == film_id):
if film.year_release > age:
film_list.append(
str(film.name_film + ' ' + film.year_release))
return film_list
def print_films(user_id):
film_lis = []
for user in User.select().where(User.user_id == user_id):
movie_lis = str(user.lis_film)
movie_lis = movie_lis.split(',')
film_lis = []
for film_id in movie_lis:
for film in Film.select().where(Film.film_id == film_id):
film_lis.append(
str('%s. %s ' % (film.name_film, film.year_release)))
return film_lis
def del_unusable_film():
set_id = set()
for user in User.select():
film_lis = str(user.lis_film)
film_lis = film_lis.split(',')
for film_id in film_lis:
set_id |= set(film_id)
for film in Film.select():
if not (str(film.film_id) in list(set_id)):
film.delete_instance()
return list(set_id)
def add_film_user(name, age, user_id):
for user in User.select().where(User.user_id == user_id):
for film in Film.select().where(name == Film.name_film):
if film.year_release == age:
if not (str(film.film_id) in user.lis_film):
if user.lis_film:
user.lis_film += ',' + str(film.film_id)
else:
user.lis_film += str(film.film_id)
if user.lis_film[0] == ',':
user.lis_film = user.lis_film[1:]
user.save()
def find_empty():
id_list = []
for film in Film.select():
id_list.append(film.film_id)
id_list.sort()
empty_pos = []
i = 0
for el in id_list:
if i == el:
i += 1
else:
while not (i == el):
empty_pos.append(i)
i += 1
return empty_pos