def add_film(self, event):
name = self.ent1.get()
du = self.ent2.get()
newfilm = Film(name=name, duration=du)
newfilm.save()
self.ent1.delete(0, 'end')
self.ent1.delete(0, 'end')
def __init__(self, master):
self.slave = Toplevel(master)
self.slave.title('Create a new film')
self.slave.geometry('550x400+300+225')
self.lbl1 = Label(self.slave, text='Create new film:', font='Arial 18')
self.lbl2 = Label(self.slave, text='Name:', font='Arial 12')
self.lbl3 = Label(self.slave, text='Duration:', font='Arial 12')
self.ent1 = Entry(self.slave, width=20, bd=3, textvariable=StringVar())
self.ent2 = Entry(self.slave, width=20, bd=3, textvariable=IntVar())
self.but_create = Button(self.slave, text='Create',
font='Arial 12',)
self.lbl1.grid(row=1, column=15)
self.lbl2.grid(row=2, column=2)
self.lbl3.grid(row=2, column=20)
self.ent1.grid(row=3, column=2)
self.ent2.grid(row=3, column=20)
self.but_create.bind("<Button-1>", lambda event: self.add_film(event))
self.but_create.grid(row=5, column=15)
self.lst = Text(self.slave, height=7, width=15, font="Verdana 12", wrap=WORD)
self.scr = Scrollbar(self.slave, command=self.lst.yview)
self.lst.grid(row=10, column=2)
self.scr.grid(row=9, column=9, rowspan=50)
for i in Film.select():
self.lst.insert(1.0, i.name + "\n")
def get(self):
"""Action when GET is executed"""
args = self.parser.parse_args()
# Fetch 5 items from film table in response to page parameter
films = Film.select().order_by(Film.film_id).paginate(
args['page'], self.ITEMS_PER_PAGE)
return [film.to_dict() for film in films]
def get(self, film_id):
"""Action when GET is executed"""
try:
# Fetch film data from film tabel searching film_id
film = Film.get(Film.film_id == film_id)
except Film.DoesNotExist:
abort(404, description="Film not found")
return film.to_dict()
def get(self, film_id):
"""GET実行時のアクション."""
try:
# filmテーブルからfilm_id を検索してデータベースから取得する
film = Film.get(Film.film_id == film_id)
except Film.DoesNotExist:
# 見つからなかった場合は処理を中断して 404 を返す
abort(404, description="Film not found.")
# 辞書形式でreturnすると、自動的にJSONに変換される
return film.to_dict()
def get(self, film_id):
"""GET 실행 때의 액션"""
try:
# film 테이블에서 film_id를 검색해서 데이터베이스에서 추출하기
film = Film.get(Film.film_id == film_id)
except Film.DoesNotExist:
# 없는 경우 404 응답
abort(404, description="Film not found.")
# 딕셔너리 자료형으로 반환하면 자동으로 JSON으로 변환됨
return film.to_dict()
def get(self):
"""GET実行時のアクション."""
# GET で受け取ったパラメーター (例: ?page=2) をパースする
args = self.parser.parse_args()
# filmテーブルから5件ずつ、pageパラメーターに応じてアイテムを取得する
films = Film.select()\
.order_by(Film.film_id)\
.paginate(args['page'], self.ITEMS_PER_PAGE) # ページング処理
# 辞書形式でreturnすると、自動的にJSONに変換される
return [film.to_dict() for film in films]
def get(self):
"""GET 실행 때의 액션"""
# GET 요청 때의 요청 매개 변수 추출하기
args = self.parser.parse_args()
# film 테이블에서 page 요청 매개 변수에 따라 페이징해서 아이템 5개씩 추출
films = Film.select()\
.order_by(Film.film_id)\
.paginate(args['page'], self.ITEMS_PER_PAGE) # 페이징 처리
# 딕셔너리 자료형으로 반환하면 자동으로 JSON으로 변환됨
return [film.to_dict() for film in films]
from db import Genre, Film, User, Comment
path = "kinopoisk.sql"
def convertToBinaryData(filename):
# Convert digital data to binary format
with open(filename, 'rb') as file:
blobData = file.read()
return blobData
def write_file(data, filename):
# Convert binary data to proper format and write it on Hard Disk
with open(filename, 'wb') as file:
file.write(data)
genresTable = Genre(path)
films = Film(path)
users = User(path)
commentTable = Comment(path)
tupleGenres = []
genre_map = {}
listGenres = genresTable.get_genres()
for i in listGenres:
genre_map[i[1]] = i[0]
tupleGenres.append(i[1])