def home(request): db = None try: if request.method == 'POST': db = dbhelper.DBHelper() result_dict = {} result_dict['hot_search_word'] = ['曼谷', '芭提雅', '清迈'] location_results = db.get_hot_search(1, 4) hot_locations = [] for result in location_results: content = {} content['piciture'] = None if result[ 'picture'] == None else result['picture'].split(';')[0] content['scene_name'] = result['scene_name'] scores = db.get_score(result['scene_name']) scores = scores['score'].split(',') content['chi_score'] = scores[0] if scores[0] else 0 content['eng_score'] = scores[1] if scores[1] else 0 content['thai_score'] = scores[2] if scores[2] else 0 hot_locations.append(content) result_dict['hot_location'] = hot_locations travel_note_results = db.get_notes_list(1, 4) result_dict['recommend_travel_notes'] = travel_note_results return HttpResponse(json.dumps(result_dict)) else: raise Exception() except Exception as e: print e.message return HttpResponse('404 NOT FOUND!!')
def __init__(self, parent, account): self.account = account style = wx.DEFAULT_FRAME_STYLE ^ (wx.RESIZE_BORDER | wx.MAXIMIZE_BOX) wx.Frame.__init__(self, parent, title="书籍借阅", size=(300, 270), style=style) self.SetBackgroundColour("#FFFFFF") self.HeadLine = wx.StaticText(self, -1, label="书籍借阅", pos=(80, 30)) self.HeadLine.SetFont(wx.Font(20, wx.DECORATIVE, wx.NORMAL, wx.BOLD)) wx.StaticText(self, -1, label="书籍编号", pos=(50, 100)) wx.StaticText(self, -1, label="注意:请根据查询结果输入要借阅的书籍编号", pos=(30, 180)) self.ID = wx.TextCtrl(self, -1, pos=(125, 100), size=(-1, 20)) confirm_button = wx.Button(self, -1, label="确认", pos=(70, 150), size=(50, 20)) exit_button = wx.Button(self, -1, label="退出", pos=(160, 150), size=(50, 20)) self.Bind(wx.EVT_BUTTON, self.Borrow, confirm_button) self.Bind(wx.EVT_BUTTON, self.Exit, exit_button) self.helper = dbhelper.DBHelper() self.Show()
def check_user(message): aux_db = dbhelper.DBHelper() if not aux_db.get_user_by_id(message[-1].from_user.id): aux_db.add_user(message[-1].from_user.id, message[-1].from_user.first_name, message[-1].from_user.last_name, message[-1].from_user.username)
def get_travel_note_list(request): db = None try: db = dbhelper.DBHelper() index = request.GET.get('page', default=1) result = db.get_notes_list(int(index)) return HttpResponse(result) except Exception as e: logger.error(e.message) finally: db.close()
def login(request): db = None try: if request.method == 'POST': db = dbhelper.DBHelper() account = request.REQUEST.get('account', '') password = request.REQUEST.get('password', '') result = db.login(account, password) return HttpResponse(json.dumps(result)) except Exception as e: return HttpResponse('404 Not Found!')
def register(request): db = None try: if request.method == 'POST': db = dbhelper.DBHelper() account = request.POST('account', '') password = request.POST('password', '') user_name = request.POST('user_name', '') result = db.register(account, password, user_name) return HttpResponse(json.dumps(result)) except Exception as e: return HttpResponse('404 Not Found!')
def get_translation(request): db = dbhelper.DBHelper() try: scene_name = request.GET.get('scene_name') index = request.GET.get('index') lang = request.GET.get('lang') result = db.get_single_scene_comments(scene_name, index, lang) return HttpResponse(json.dumps(result)) except Exception as e: logger.error(e.message) finally: db.close()
def __init__(self, parent): style = wx.DEFAULT_FRAME_STYLE ^ (wx.RESIZE_BORDER | wx.MAXIMIZE_BOX) wx.Frame.__init__(self, parent, title="单册编辑", size=(550, 250), style=style) self.SetFont(wx.Font(12, wx.DECORATIVE, wx.NORMAL, wx.NORMAL)) self.SetBackgroundColour("#FFFFFF") wx.StaticText(self, label="书名", pos=(10, 10)) wx.StaticText(self, label="作者", pos=(150, 10)) wx.StaticText(self, label="出版社", pos=(300, 10)) wx.StaticText(self, label="数量", pos=(150, 75)) wx.StaticText(self, label="出版时间", pos=(300, 75)) wx.StaticText(self, label="类型", pos=(10, 75)) wx.StaticText(self, label="输入书籍ID", pos=(10, 125)) self.text1 = wx.TextCtrl(self, -1, pos=(45, 10), size=(100, 20)) #书名 self.text2 = wx.TextCtrl(self, -1, pos=(185, 10), size=(100, 20)) #作者 self.text3 = wx.TextCtrl(self, -1, pos=(350, 10), size=(130, 20)) #出版社 self.text4 = wx.TextCtrl(self, -1, pos=(185, 70), size=(100, 25)) #数量 self.text5 = wx.TextCtrl(self, -1, pos=(100, 125), size=(100, 20)) self.YearList = [str(x) for x in range(1970, 2019)] self.TypeList = [ "计算机", "外语", "文学", "艺术", "经管", "人文社科", "少儿", "生活", "进口原版", "科技", "考试", "离职", "学术", "古籍", "哲学", "旅游", "法律", "宗教", "历史", "地理", "政治", "军事心理学", "传记", "工具书", "建筑", "才会", "教育", "医学", "电子电工", "农业", "文化", "美食", "娱乐时尚", "青春文学", "机械", "美术", "经济", "化工", "汽车与交通运输", "健康", "冶(yě)金", "服饰美容", "育儿", "通信", "管理", "摄影", "投资理财", "音乐", "少儿科普", "家庭与办公", "儿童文学", "图象图形与多媒体", "程序设计" ] self.List1 = wx.Choice(self, -1, (370, 70), size=(70, 25), choices=self.YearList) #出版日期 self.List3 = wx.Choice(self, -1, (45, 70), size=(100, 25), choices=self.TypeList) #种类 self.button1 = wx.Button(self, -1, label="编辑", pos=(200, 170)) self.button2 = wx.Button(self, -1, label="重置", pos=(300, 170)) self.button3 = wx.Button(self, -1, label="查找", pos=(40, 170)) self.button4 = wx.Button(self, -1, label="删除", pos=(400, 170)) self.Bind(wx.EVT_BUTTON, self.edit, self.button1) #入库 self.Bind(wx.EVT_BUTTON, self.clear, self.button2) #清空 self.Bind(wx.EVT_BUTTON, self.search, self.button3) #查找 self.Bind(wx.EVT_BUTTON, self.delete, self.button4) #删除 self.helper = dbhelper.DBHelper() self.Show()
def __init__(self, parent): style = wx.DEFAULT_FRAME_STYLE ^ (wx.RESIZE_BORDER | wx.MAXIMIZE_BOX) wx.Frame.__init__(self, parent, title="账户管理", size=(800, 600), style=style) self.SetBackgroundColour("#FFFFFF") self.helper = dbhelper.DBHelper() self.list = wx.ListCtrl(self, -1, size=(600, 400), style=wx.LC_REPORT | wx.LC_HRULES | wx.LC_VRULES) self.list.InsertColumn(0, "用户名") self.list.InsertColumn(1, "密码") self.list.InsertColumn(2, "借书证") self.list.InsertColumn(3, "可借本数") self.list.InsertColumn(4, "已借本数") self.list.SetColumnWidth(0, 150) self.list.SetColumnWidth(1, 100) self.list.SetColumnWidth(2, 100) self.list.SetColumnWidth(3, 100) self.list.SetColumnWidth(4, 120) wx.StaticText(self, label="用户名", pos=(10, 450)) wx.StaticText(self, label="可借本数", pos=(180, 450)) self.text1 = wx.TextCtrl(self, -1, pos=(60, 450), size=(90, 20)) #用户名 self.text4 = wx.TextCtrl(self, -1, pos=(240, 450), size=(50, 20)) #可借本数 self.grant_button = wx.Button(self, -1, label="授权/删除账号", pos=(50, 500), size=(100, 40)) self.edit_button = wx.Button(self, -1, label="编辑可借本数", pos=(200, 500), size=(100, 40)) self.clear_button = wx.Button(self, -1, label="重置", pos=(350, 500), size=(100, 40)) self.Bind(wx.EVT_BUTTON, self.grant, self.grant_button) self.Bind(wx.EVT_BUTTON, self.clear, self.clear_button) self.Bind(wx.EVT_BUTTON, self.edit, self.edit_button) self.display() self.Show()
def get_scene_comments(request): db = dbhelper.DBHelper() try: scene_name = '' if request.method == 'GET': scene_name = request.GET["scene"] offset = request.REQUEST.get('offset', '0') lang = request.REQUEST.get('lang', 'chi') comments = db.get_scene_comments(scene_name, int(offset), lang) return HttpResponse(json.dumps(comments)) except Exception as e: return HttpResponse('404 NOT FOUND!!') finally: db.close()
def search(request): db = dbhelper.DBHelper() search_word = None index = 1 if request.method == 'POST': search_word = request.POST['search_word'] return HttpResponseRedirect("?scene=" + search_word) else: search_word = request.GET["scene"] index = request.REQUEST.get('page', '1') status = db.check_word(search_word) if status == 1: results, max_page = db.get_scene_list(search_word, int(index)) pictureContent = [] for result in results: content ={} content['picSrc'] = None if result['picture'] == None else result['picture'].split(';')[0] content['titleSrc'] = '../search/search/?scene=' + result['scene_name'] + "&page=1" content['titleText'] = result['scene_name'] content['ch'] = 5 content['en'] = 5 content['th'] = 5 pictureContent.append(json.dumps(content)) return render(request, 'Search/sceneList.html', {'pictureContent': json.dumps(pictureContent), 'maxPage': max_page}) elif status == 0: result = db.get_scene_content(search_word) result_dict = {} logger.info(result) if result['picture'] != None: pictures = result['picture'].split(';') maxPic = 5 if len(pictures) > 5 else len(pictures) result_dict['BigPic'] = pictures[0] for i in range(1, maxPic): result_dict['Simg' + str(i)] = pictures[i] result_dict['totalEva'] = 5 result_dict['chEva'] = 5 result_dict['enEva'] = 5 result_dict['thEva'] = 5 result_dict['mainBody'] = result['introduction'] result_dict['title'] = result['scene_name'] result_dict['tag1'] = '美食' result_dict['tag2'] = '好玩' result_dict['tag3'] = '天堂' # result_dict['comments'] = db.get_scene_comments(result['scene_name']) return render(request, 'Search/detailCh.html', {'result_dict': json.dumps(result_dict)}) else: return HttpResponse('404 NOT FOUND!!') db.close()
def get_tag(scene_name): db = None try: db = dbhelper.DBHelper() all_tag = [] comments = db.get_scene_comments(scene_name, -1, 'chi')['comments'] all_tag += get_chi_tag(comments) comments = db.get_scene_comments(scene_name, -1, 'thai')['comments'] all_tag += thaisegment.extract_tags(comments) comments = db.get_scene_comments(scene_name, -1, 'eng')['comments'] all_tag += engsegment.extract_tags(comments) return all_tag except Exception as e: logger.error(e.message) finally: db.close()
def get_travel_note(request): db = None try: db = dbhelper.DBHelper() id = request.GET.get('id') if not id: raise Exception() else: result = db.get_note(id) if result: return HttpResponse(result) else: raise Exception() except Exception as e: return HttpResponse('404 NOT FOUND!!') finally: db.close()
def __init__(self, parent): style = wx.DEFAULT_FRAME_STYLE ^ (wx.RESIZE_BORDER | wx.MAXIMIZE_BOX) wx.Frame.__init__(self, parent, title="注册账号", size=(300, 300), style=style) self.SetBackgroundColour("#FFFFFF") self.HeadLine = wx.StaticText(self, -1, label="账号注册", pos=(80, 30)) self.HeadLine.SetFont(wx.Font(20, wx.DECORATIVE, wx.NORMAL, wx.BOLD)) wx.StaticText(self, -1, label="用户名", pos=(50, 100)) wx.StaticText(self, -1, label="密码", pos=(50, 135)) wx.StaticText(self, -1, label="再次输入密码", pos=(50, 170)) wx.StaticText(self, -1, label="注意:账户注册后,需管理员授权后才能借书", pos=(30, 220)) self.account = wx.TextCtrl(self, -1, pos=(125, 100), size=(-1, 20)) self.password = wx.TextCtrl(self, -1, pos=(125, 135), size=(-1, 20), style=wx.TE_PASSWORD) self.password_confirm = wx.TextCtrl(self, -1, pos=(125, 170), size=(-1, 20), style=wx.TE_PASSWORD) confirm_button = wx.Button(self, -1, label="确认", pos=(70, 200), size=(50, 20)) exit_button = wx.Button(self, -1, label="退出", pos=(160, 200), size=(50, 20)) self.Bind(wx.EVT_BUTTON, self.CreateAcount, confirm_button) self.Bind(wx.EVT_BUTTON, self.Exit, exit_button) self.helper = dbhelper.DBHelper() self.Show()
def __init__(self, parent, account): self.account = account style = wx.DEFAULT_FRAME_STYLE ^ (wx.RESIZE_BORDER | wx.MAXIMIZE_BOX) wx.Frame.__init__(self, parent, title="借阅记录", size=(800, 600), style=style) self.SetBackgroundColour("#FFFFFF") self.helper = dbhelper.DBHelper() self.list = wx.ListCtrl(self, -1, size=(600, 400), style=wx.LC_REPORT | wx.LC_HRULES | wx.LC_VRULES) self.list.InsertColumn(0, "借阅编号") self.list.InsertColumn(1, "书本编号") self.list.InsertColumn(2, "书名") self.list.InsertColumn(3, "借阅日期") self.list.InsertColumn(4, "最晚归还日期") self.list.InsertColumn(5, "归还时间") self.list.SetColumnWidth(0, 100) self.list.SetColumnWidth(1, 100) self.list.SetColumnWidth(2, 100) self.list.SetColumnWidth(3, 100) self.list.SetColumnWidth(4, 100) self.list.SetColumnWidth(5, 100) wx.StaticText(self, label="借阅编号", size=(100, -1), pos=(10, 450)) self.text1 = wx.TextCtrl(self, -1, pos=(120, 450), size=(90, 20)) #借阅编号 self.grant_button = wx.Button(self, -1, label="归还书籍", pos=(50, 500), size=(100, 40)) self.Bind(wx.EVT_BUTTON, self.returnBook, self.grant_button) self.display() self.Show()
def hot_search(request): db = None try: index = request.GET.get('page', default=1) db = dbhelper.DBHelper() results = db.get_hot_search(int(index), 8) result_content = [] for result in results: content = {} content['piciture'] = None if result[ 'picture'] == None else result['picture'].split(';')[0] # content['titleSrc'] = '../search/search?scene=' + result['scene_name'] content['scene_name'] = result['scene_name'] scores = db.get_score(result['scene_name']) scores = scores['score'].split(',') content['chi_score'] = scores[0] if scores[0] else 0 content['eng_score'] = scores[1] if scores[1] else 0 content['thai_score'] = scores[2] if scores[2] else 0 result_content.append(json.dumps(content)) return HttpResponse(json.dumps(result_content)) except Exception as e: return HttpResponse('404 NOT FOUND!!')
def search_notes(request): db = None try: db = dbhelper.DBHelper() search_word = request.GET.get('search_word') if not search_word: raise Exception() else: # result = {} notes_result = db.search_note(search_word) if notes_result: return HttpResponse(json.dumps(notes_result)) else: raise Exception() # result['search_word'] = search_word # result['content'] = notes_result # if result: # return HttpResponse(json.dumps(result)) except Exception as e: return HttpResponse('404 NOT FOUND!!') finally: db.close()
def search(request): #数据库 db = dbhelper.DBHelper() #搜索词 search_word = None try: if request.method == 'GET': search_word = request.GET['search_word'] if not search_word: raise Exception() #检查search_word的语言类型,分别为chi,eng,thai lang = check_search_word(search_word) #将搜索词转换为中文,且检查该景点是否存在,是否是大小景点。 # 1为大景点,0为小景点,-1为找不到 status, search_word = db.check_word(search_word, lang) result = {} if status == 1: temp_result = db.get_big_scene_content(search_word) result['scene_name'] = temp_result['scene_name'] if temp_result['picture']: result['picture'] = temp_result['picture'].split(';') result['introduction'] = temp_result['introduction'] result['scene_num'] = len(temp_result['indices']) result['recommend_scene'] = temp_result['recommend_scene'] return HttpResponse(json.dumps(result)) elif status == 0: temp_result = db.get_small_scene_content(search_word) if temp_result['picture']: temp_result['picture'] = temp_result['picture'].split(';') return HttpResponse(json.dumps(temp_result)) else: raise Exception() except Exception as e: logger.error(e.message) return HttpResponse('404 NOT FOUND!!') finally: db.close()
def __init__(self, parent): wx.Frame.__init__(self, parent, title="批量入库", size=(300, 300)) self.helper = dbhelper.DBHelper() Dia = wx.FileDialog(parent, message="Choose a file", defaultDir="C:\\Users\Sail\Desktop\DBLab5", style=1) L = self.helper.getMaxBookID() if L != None and L[0] != None: BookID = int(L[0]) + 1 else: BookID = 10000 if Dia.ShowModal() == wx.ID_OK: f = open(Dia.GetPath(), 'r') num = 1 Book = Table.Book(BookID) for line in f: line.rstrip('\n') line = line.split() Book.setID(BookID) Book.setName(line[0]) Book.setAuthor(line[1]) Book.setPress(line[2]) Book.setPressDate(line[3]) Book.setType(line[4]) Book.setNumber(line[5]) BookID = BookID + 1 self.helper.BookInsert(Book) num = num + 1 print(line) f.close() result = wx.MessageDialog(self, message="导入成功", caption="导入结果") result.ShowModal() result.Destroy() Dia.Destroy() self.Destroy()
def __init__(self, parent): self.User_Account = "" self.sign = 0 style = wx.DEFAULT_FRAME_STYLE ^ (wx.RESIZE_BORDER | wx.MAXIMIZE_BOX) wx.Frame.__init__(self, parent, title="登陆", size=(300, 300), style=style) self.user_type = "游客" self.SetBackgroundColour("#FFFFFF") self.HeadLine = wx.StaticText(self, -1, label="登陆账号", pos=(80, 30)) self.HeadLine.SetFont(wx.Font(20, wx.DECORATIVE, wx.NORMAL, wx.BOLD)) wx.StaticText(self, -1, label="用户名", pos=(50, 100)) wx.StaticText(self, -1, label="密码", pos=(50, 135)) self.account = wx.TextCtrl(self, -1, pos=(125, 100), size=(-1, 20)) self.password = wx.TextCtrl(self, -1, pos=(125, 135), size=(-1, 20), style=wx.TE_PASSWORD) self.confirm_button = wx.Button(self, -1, label="确认", pos=(70, 200), size=(50, 20)) self.exit_button = wx.Button(self, -1, label="退出", pos=(160, 200), size=(50, 20)) self.Bind(wx.EVT_BUTTON, self.login, self.confirm_button) self.Bind(wx.EVT_BUTTON, self.exit, self.exit_button) self.helper = dbhelper.DBHelper() self.Show()
def get_scene_list(request): db = dbhelper.DBHelper() scene_name = None offset = 0 try: if request.method == 'GET': scene_name = request.GET['scene_name'] offset = request.REQUEST.get('offset', '1') if scene_name == None or offset == None: raise Exception temp_result = db.get_scene_list(scene_name, int(offset)) for t in temp_result: t['picture'] = t['picture'].split(';')[0] scores = t['score'].split(',') t['chi_score'] = scores[0] t['eng_score'] = scores[1] t['thai_score'] = scores[2] return HttpResponse(json.dumps(temp_result)) except Exception as e: return HttpResponse('404 NOT FOUND!!') finally: db.close()
import dbhelper import telegram db = dbhelper.DBHelper() def start(update, context): """ :param update: telegram.Update :param context: telegram.Context """ update.message.reply_text( 'send any text and I will add it to your todo list') def show_items(update, context): """ :param update: telegram.Update :param context: telegram.Context """ items = db.get_items(update.message.chat_id) keyboard = [[item] for item in items] reply_markup = telegram.ReplyKeyboardMarkup(keyboard) context.bot.send_message(chat_id=update.message.chat_id, text='your todo stuff', reply_markup=reply_markup)
def __init__(self, parent, User_Type, User_ID=""): self.user = User_Type self.UserID = User_ID style = wx.DEFAULT_FRAME_STYLE ^ (wx.RESIZE_BORDER | wx.MAXIMIZE_BOX) wx.Frame.__init__(self, parent, title="图书管理系统", size=(810, 670), style=style) self.helper = dbhelper.DBHelper() self.Book = Table.Book("") self.SetBackgroundColour("#FFFFFF") self.Top = wx.Panel(self, size=(770, 90), pos=(10, 10)) #顶端部分 self.Display = wx.Panel(self, size=(770, 300), pos=(10, 110)) #顶端部分 self.Search = wx.Panel(self, size=(500, 200), pos=(10, 420)) self.Switch = wx.Panel(self, size=(100, 200), pos=(600, 420)) #----------------------Top--------------------------------------------------- self.Top_text1 = wx.StaticText(self.Top, label="图书管理系统", pos=(10, 20)) self.Top_text1.SetFont(wx.Font(30, wx.DECORATIVE, wx.NORMAL, wx.BOLD)) self.time = wx.StaticText( self.Top, label="当前日期:" + time.strftime('%Y-%m-%d', time.localtime(time.time())), pos=(400, 70)) wx.StaticText(self.Top, label="当前用户:" + self.user, pos=(540, 70)) if self.user == "游客": self.enroll = wx.Button(self.Top, -1, label="注册", pos=(630, 68), size=(50, 20)) self.login = wx.Button(self.Top, -1, label="登陆", pos=(700, 68), size=(50, 20)) self.Bind(wx.EVT_BUTTON, self.Sign, self.enroll) self.Bind(wx.EVT_BUTTON, self.log, self.login) else: wx.StaticText(self.Top, label="用户名:" + User_ID, pos=(650, 70)) self.exit_button = wx.Button(self.Top, -1, label="退出", pos=(680, 30), size=(50, 20)) self.Bind(wx.EVT_BUTTON, self.exit, self.exit_button) #---------------------------------Display------------------------------------- self.list = wx.ListCtrl(self.Display, -1, size=(700, 280), style=wx.LC_REPORT | wx.LC_HRULES | wx.LC_VRULES) self.list.InsertColumn(0, "书籍编号") self.list.InsertColumn(1, "书名") self.list.InsertColumn(2, "作者") self.list.InsertColumn(3, "出版社") self.list.InsertColumn(4, "出版时间") self.list.InsertColumn(5, "书籍类型") self.list.InsertColumn(6, "余量") self.list.SetColumnWidth(0, 100) self.list.SetColumnWidth(1, 120) self.list.SetColumnWidth(2, 100) self.list.SetColumnWidth(3, 80) self.list.SetColumnWidth(4, 80) self.list.SetColumnWidth(5, 80) self.list.SetColumnWidth(6, 80) #------------------------------Search---------------------------------- self.Search.SetFont(wx.Font(12, wx.DECORATIVE, wx.NORMAL, wx.NORMAL)) wx.StaticText(self.Search, label="书名", pos=(10, 10)) wx.StaticText(self.Search, label="作者", pos=(150, 10)) wx.StaticText(self.Search, label="出版社", pos=(300, 10)) wx.StaticText(self.Search, label="出版时间", pos=(250, 75)) wx.StaticText(self.Search, label="类型", pos=(10, 75)) wx.StaticText(self.Search, label="--", pos=(390, 75)) self.Search_text1 = wx.TextCtrl(self.Search, -1, pos=(45, 10), size=(100, 20)) self.Search_text2 = wx.TextCtrl(self.Search, -1, pos=(185, 10), size=(100, 20)) self.Search_text3 = wx.TextCtrl(self.Search, -1, pos=(350, 10), size=(130, 20)) self.Search_checkBox1 = wx.CheckBox(self.Search, -1, "可租借", pos=(170, 75)) self.YearList = [str(x) for x in range(1970, 2019)] self.TypeList = [ "计算机", "外语", "文学", "艺术", "经管", "人文社科", "少儿", "生活", "进口原版", "科技", "考试", "离职", "学术", "古籍", "哲学", "旅游", "法律", "宗教", "历史", "地理", "政治", "军事心理学", "传记", "工具书", "建筑", "才会", "教育", "医学", "电子电工", "农业", "文化", "美食", "娱乐时尚", "青春文学", "机械", "美术", "经济", "化工", "汽车与交通运输", "健康", "冶(yě)金", "服饰美容", "育儿", "通信", "管理", "摄影", "投资理财", "音乐", "少儿科普", "家庭与办公", "儿童文学", "图象图形与多媒体", "程序设计" ] self.Search_List1 = wx.Choice(self.Search, -1, (320, 75), size=(70, 20), choices=self.YearList) self.Search_List2 = wx.Choice(self.Search, -1, (410, 75), size=(70, 20), choices=self.YearList) self.Search_List3 = wx.Choice(self.Search, -1, (45, 70), size=(100, 25), choices=self.TypeList) self.Search_button1 = wx.Button(self.Search, -1, label="搜索", pos=(100, 120)) self.Search_button2 = wx.Button(self.Search, -1, label="重置", pos=(220, 120)) self.Search_button1.Bind(wx.EVT_BUTTON, self.search) self.Search_button2.Bind(wx.EVT_BUTTON, self.Search_Clear) #--------------------------------------------------------------------------------- if self.user == "管理员": #管理员按钮 self.Switch_button1 = wx.Button(self.Switch, -1, label="单册入库", pos=(10, 10)) self.Switch_button2 = wx.Button(self.Switch, -1, label="批量入库", pos=(10, 50)) self.Switch_button3 = wx.Button(self.Switch, -1, label="单册编辑", pos=(10, 90)) self.Switch_button4 = wx.Button(self.Switch, -1, label="用户管理", pos=(10, 130)) self.Bind(wx.EVT_BUTTON, self.AddOne, self.Switch_button1) self.Bind(wx.EVT_BUTTON, self.AddMul, self.Switch_button2) self.Bind(wx.EVT_BUTTON, self.EditOne, self.Switch_button3) self.Bind(wx.EVT_BUTTON, self.Manage, self.Switch_button4) elif self.user == "用户": #用户按钮 self.Switch_button5 = wx.Button(self.Switch, -1, label="借阅书籍", pos=(10, 10)) self.Switch_button6 = wx.Button(self.Switch, -1, label="借阅记录", pos=(10, 70)) self.Bind(wx.EVT_BUTTON, self.BorrowBook, self.Switch_button5) self.Bind(wx.EVT_BUTTON, self.BorrowRecord, self.Switch_button6) self.Show()
def get_poleman_id(): db = dbhelper.DBHelper() id = db.get_poleman_id()[0][0] return id
def __init__(self): self._dbo = dbhelper.DBHelper() self.loginWindow()
import re import utils import json import dash from dateutil import parser import pytz from imageio import imread import dbhelper from dash.exceptions import PreventUpdate import environment import os if os.environ.get('USE_DATABASE', False): config_settings = dbhelper.parsed_config_file(filename=os.environ.get('DATABASE_CONFIG', 'config.ini')) db_connection = dbhelper.DBHelper(config_settings) DISPLAY_COLS = ['created_at', 'text', 'favorite_count', 'retweet_count', 'in_reply_to_status_id'] else: with open(os.environ.get('PARSED_TWEETS_PATH', ''), 'r', encoding='utf-8') as fp: res = json.loads(fp.read()) DISPLAY_COLS = ['created_at', 'text', 'favorite_count', 'retweet_count', 'in_reply_to_status_id_str'] selected_features_api_tweets = ['created_at', 'favorite_count', 'favorited', 'id_str', 'in_reply_to_screen_name', 'in_reply_to_status_id_str', 'lang', 'retweet_count', 'retweeted', 'source', 'text'] selected_features_api_users = ['created_at', 'friends_count', 'followers_count', 'protected'] def register_callbacks(app): @app.callback( [Output('tweet-data-table', 'data'), Output('currently-showing-helper', 'children'),
def __init__(self): self._dbObject = dbhelper.DBHelper() super().__init__(self.loginHandler, self.regHandler)
def __init__(self): self._dbObject = dbhelper.DBHelper() super().__init__(self)
version = '1.1 stable release' strikes = {'id': 0} userIDs = {'owner': '319285994253975553', 'self': '442722388757446671'} imgs = { 'avatar': 'https://avatars0.githubusercontent.com/u/14945942?s=400&u=\ 563ecf361e3cc4d40074868152d10951ca5e85b2&v=4', 'sebas_profile': 'https://cdn.discordapp.com/attachments/44414784649363\ 4560/444744084830289921/Sebas_Profile.png' } log = Logger() emoji = EmojiHandler() dbh = dbhelper.DBHelper() # dictionary provides text files to look for txt_f = { 'splash': 'txt/splash.txt', 'help': 'txt/help.txt', 'verify': 'txt/verify.txt', 'rhelp': 'txt/rhelp.txt', 'vrfres': 'txt/verify_response.txt', 'vrfres_m': 'txt/verify_response_manual.txt', 'v_chan_err': 'txt/verify_channel_set_error.txt', 'v_chan_success': 'txt/verify_channel_set_success.txt' } # default help string helpstr = " Type `..help` for more information."