def beginSearch(event):
global cursor
global inner_frame
global sf
global authorKey
#удаление прокручиваемого блока, если он существует
if(not(inner_frame is None)):
inner_frame.destroy()
sf.destroy()
sf1.configure(highlightbackground="#ffffff")
#Создание прокручиваемого блока
sf = ScrolledFrame(root, width=640, height=480, highlightthickness=5, highlightbackground="red")
sf.itemId=0
sf.pack(side="top", expand=1, fill="both")
sf.bind_arrow_keys(root)
sf.bind_scroll_wheel(root)
sf.bind("<Enter>", hoverFrame)
inner_frame = sf.display_widget(Frame, True)
#параметры обработанных статей
author = "author"
theme = "theme"
name = "name"
link = "link"
author_inputted = getAuthor(authorKey.get())
print(author_inputted)
keywords = []
for s in getKeywords(boolArr):
keywords.append(s)
command = "select Book.Name,Book.Author,Book.Cloud_Link, Book.Language, Book.Format from Book"
command += """\njoin BookKeyWord on Book.Id = BookKeyWord.Book_Id\njoin KeyWord on BookKeyWord.KeyWord_Id = KeyWord.Id"""
keywords_count = len(keywords)
if keywords_count > 0:
command = command + "\nwhere Keyword.Name = N'###KEYWORD###'"
pattern = command
for i in range(keywords_count):
if i != 0:
command = command + "\nintersect\n" + pattern.replace("###KEYWORD###",keywords[i])
else:
command = command.replace("###KEYWORD###",keywords[i])
if not (author_inputted == "ЛЮБОЙ"):
command = command + " and Book.Author = N'" + author_inputted + "'"
else:
if not (author_inputted == "ЛЮБОЙ"):
command = command + "\nwhere Book.Author = N'" + author_inputted + "'"
print(command)
cursor.execute(command)
for book in cursor.fetchall():
printArticle(book[1], book[0], book[2], book[3], book[4], inner_frame)
"""
#------------------------------------------------------------------------------------------------
#второй фрейм
#------------------------------------------------------------------------------------------------
fr2 = Frame(bg="#ffffff", width = 100)
#подсказка для пользователя
Label(fr2, text="Автор:", width = 100, height = 2, font="Arial 13").pack()
#Создание прокручиваемого блока для кчпичка авторов
sf2 = ScrolledFrame(fr2, width=880, height=100, highlightthickness=5, highlightbackground="#ffffff")
sf2.itemId=2
sf2.pack(side="top", expand=0)
sf2.bind_arrow_keys(root)
sf2.bind_scroll_wheel(root)
sf2.bind("<Enter>", hoverFrame)
frame_authors = sf2.display_widget(Frame, True)
#значения выпадающего списка
arrAuth = getDBAuthors()
#количество значений в списке(нужно для программы)
length1 = len(arrAuth)
#массив булеан значений, сопоставляемый списку
authorKey = IntVar()
authorKey.set(0)
#добавление на экран флажков
for i in range(0, length1):
checkbox = Radiobutton(frame_authors, text = arrAuth[i], variable = authorKey, value=i)