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