def __generateExecCommand(self): dbworkingDir = ContextInitiator().getProperDict( )['dbWorkingFloder'] + '/' db = DBHelper() self.__getSmr = db.dbExecCommand("smr2CmrPrdct.sql", self.__logsPath, "smr2CmrPrdct.log") self.__makeSpace = db.dbExecCommand("space4StagePrdct.sql", self.__logsPath, "space4StagePrdct.log") self.__ins2Differ = db.dbExecCommand( "ins2Differ.sql") # ,self.__logsPath,"ins2Differ.log" # self.__backupSnyc = db.dbExecCommand("backupSnyc.sql")#,self.__logsPath,"backupSnyc.log" self.__smrImpFail = db.dbExecCommand("smrImpFailed.sql", self.__logsPath, "smrImpFailed.log") self.__productsData = db.dbExecCommand("getProduct.sql", self.__logsPath, "getProduct.log") self.__impPrdctFaild = db.dbExecCommand("impPrductFailed.sql", self.__logsPath, "impPrductFailed.log") self.__impSourceCSV = dbHelper.dbExecCmd4Remote( dbworkingDir, "impSmr2CmrPrdct.sql") self.__importProduct = dbHelper.dbExecCmd4Remote( dbworkingDir, "impProduct.sql") self.__impSourceCSVLocal = db.dbExecCommand( "impSmr2CmrPrdct.sql") # ,logsPath,"impSmrFromCsv.log" self.__importProductLocal = db.dbExecCommand( "impProduct.sql") # ,logsPath,"impProduct.log"
def __DBConnStr(self): dicty = ContextInitiator().getProperDict() db = DBHelper() self.__remoteDbAlia = db.getDbAliaCmd( (dicty['dbInstance'], dicty['alia'], dicty['nodeName'])) self.__remoteDBNode = db.getDbNodeCmd(( dicty['nodeName'], dicty['dbIp'], dicty['port'], dicty['dbInstance'], )) self.__conn2RemoteDb = db.getConn2DbCmd( (dicty['alia'], dicty['usr'], dicty['pwd'])) self.__ourDbAlia = db.getDbAliaCmd( (dicty['ourDbInstance'], dicty['ourAlia'], dicty['ourNodeName'])) self.__ourDBNode = db.getDbNodeCmd( (dicty['ourNodeName'], dicty['ourDbIp'], dicty['ourPort'], dicty['ourDbInstance'])) self.__conn2OurDb2 = db.getConn2DbCmd( (dicty['ourAlia'], dicty['ourUsr'], dicty['ourPwd'])) self.__isNodeExist = db.isNodeExistCmd((dicty['nodeName'])) self.__isAliaExist = db.isAliaExistCmd((dicty['alia'])) # .upper() self.__isOurNodeExist = db.isNodeExistCmd((dicty['ourNodeName'])) self.__isOurAliaExist = db.isAliaExistCmd( (dicty['ourAlia'])) # .upper() self.__uncataDBAlia = db.getUncataDBAliaCmd((dicty['alia'])) self.__uncataNode = db.getUncataNode((dicty['nodeName'])) self.__uncataOurDBAlia = db.getUncataDBAliaCmd((dicty['ourAlia'])) self.__uncataOurNode = db.getUncataNode((dicty['ourNodeName'])) self.__connOuterSpaceDb = db.getOuterSpaceDbCmd( (dicty['ourDbInstance'], dicty['ourUsr'], dicty['ourPwd']))
def btn_query_clicked(self): condition = self.conditionEdit.text() dbname = "dbbook" if self.comboBox.currentText() == "豆瓣" else "Fang" db = DBHelper() rows = db.Query_by_condition(dbname, condition) if rows is None: QtWidgets.QMessageBox.warning(self.btn_delete, "提示", '查询失败') return None self.tableWidget.setRowCount(len(rows)) self.tableWidget.setColumnCount(3 if dbname == 'dbbook' else 5) if dbname == 'dbbook': self.tableWidget.setHorizontalHeaderLabels( ['title', 'author', 'rate']) for row, i in zip(rows, range(self.tableWidget.rowCount())): for column, j in zip(row, range(self.tableWidget.columnCount())): newItem = QtWidgets.QTableWidgetItem(str(column)) self.tableWidget.setItem(i, j, newItem) else: self.tableWidget.setHorizontalHeaderLabels([ 'describtion', 'structure', 'areasize', 'selling_price', 'address' ]) for row, i in zip(rows, range(self.tableWidget.rowCount())): for column, j in zip(row, range(self.tableWidget.columnCount())): newItem = QtWidgets.QTableWidgetItem(str(column)) self.tableWidget.setItem(i, j, newItem)
def btn_register_click(self): user_info = { 'username': self.username_Edit.text(), 'password': self.passEdit.text() } db = DBHelper() result = db.Regist_user(user_info) QtWidgets.QMessageBox.information(self.btn_login, "提示", result)
def btn_delete_clicked(self): condition = self.conditionEdit.text() dbname = "dbbook" if self.comboBox.currentText() == "豆瓣" else "Fang" db = DBHelper() result = db.Delete_by_condition(dbname, condition) if not result: QtWidgets.QMessageBox.warning(self.btn_delete, "提示", '删除失败或未输入条件') else: QtWidgets.QMessageBox.information(self.btn_delete, "提示", '删除成功')
def download(): db = DBHelper() db.export() db.close() filename = 'label.zip' response = make_response( send_from_directory('static/', filename.encode('utf-8').decode('utf-8'), as_attachment=True)) response.headers["Content-Disposition"] = "attachment; filename={}".format( filename.encode().decode('latin-1')) return response
def dashboard(): db = DBHelper() data = {'todo': 0, 'checked': 0, 'pending': 0} for row in db.select(): if row['status'] == 0: data['todo'] += 1 elif row['status'] == 1: data['checked'] += 1 elif row['status'] == 2: data['pending'] += 1 db.close() return json.dumps(data)
def delete(): args = request.args db = DBHelper() if args: # save value filename = args.get('filename') db.delete(filename) data = {'message': 'OK'} else: data = {'message': 'No data'} db.close() return json.dumps(data)
def btn_login_click(self, Login): user_info = { 'username': self.username_Edit.text(), 'password': self.passEdit.text() } db = DBHelper() result = db.Confirm_user(user_info) if result: QtWidgets.QMessageBox.information(self.btn_login, "提示", '登录成功') self.MWinow_UI.setupUi(self.MWindow, user_info['username']) self.center(self.MWindow) Login.close() self.MWindow.show() else: QtWidgets.QMessageBox.warning(self.btn_login, "提示", '登录失败')
def next_picture(): args = request.args db = DBHelper() fetch_status = 0 if args: # save value value = args.get('value') filename = args.get('filename') status = args.get('status') fetch_status = args.get('fetch_status') db.update(filename, value, status) data = db.select_by_status(fetch_status) if data: data = data[0] else: data = {} db.close() return json.dumps(data)
def main(): db = DBHelper() while True: print("********************") print() print("press 1 to insert new user") print("press 2 to display all user") print("press 3 to delete user") print("press 4 to update user") print("press 5 to exit program") print() try: choice = int(input()) if (choice == 1): ##insert user uid = int(input("Enter user id:")) username = input("Enter user name: ") userphone = input("Enter user phone: ") db.insert_user(uid, username, userphone) elif choice == 2: ##display user db.fetch_all() pass elif choice == 3: ##delete user userid = int( input("enter user id to which you want to delete")) db.delete_user(userid) elif choice == 4: #update user userid = int(input("Enter user id you want to update:")) username = input("Enter new name: ") userphone = input("Enter new phone: ") db.update_user(userid, username, userphone) elif choice == 5: break else: print("INVALID TRY AGAIN") except Exception as e: print(e) print("Invalid Details !Try again")
def __init__(self , my_time, my_greeting ="Hi"): self.db=DBHelper() self.last_update_id = None self.updates = None self.TOKEN = 'token user telegram' self.URL = "https user data".format(self.TOKEN) self.WPA_CONF_PATH = '/etc/wpa_supplicant/wpa_supplicant.conf' self.GOOGLE_SERVER_ADDRESS = ('speech.googleapis.com', 443) self.chat_ID = "user id chat" self.boolean_thread = False self.my_wifi = False self.send_message(my_greeting, self.chat_ID) self.kill = False self.exit = False self.my_callback = None self.mosquitto = False self.start_time = my_time self.time_control = 0.0
def main(): db = DBHelper() while True: print("************WELCOME****************") print("Press 1 to insert user") print("Press 2 to display all user") print("Press 3 to delete user") print("Press 4 to update user") print("Press 5 to exit program") print() try: choice = int(input()) if (choice == 1): #insert uid = int(input("Enter User ID:")) username = input("Enter UserName:"******"Enter phone Number:") db.insert_user(uid, username, userPhone) elif choice == 2: #display db.fetch_userData() elif choice == 3: #delete uid = int(input("Enter User ID to delete:")) db.delete_data(uid) elif choice == 4: #update uid = int(input("Enter User ID you want to update:")) username = input("Enter new UserName:"******"Enter new phone Number:") db.update_data(uid, username, userPhone) elif choice == 5: #exit break else: print("Invalid Input Try Again") except Exception as e: print(e) print("Invalid User Try Again Dear!")
def __generateTmpSql(self): ex = '' try: db = DBHelper() smrTmpSql = db.sql2TmpSql("smr2CmrPrdct.sql", {"workingDir": self.__spDir}) productTmpSql = db.sql2TmpSql("getProduct.sql", {"workingDir": self.__spDir}) # impProductTmpSql = db.sql2TmpSql("impProduct.sql",{"workingDir":self.__spDir4Outer}) # impSmrTmpSql = db.sql2TmpSql("impSmr2CmrPrdct.sql",{"workingDir":self.__spDir4Outer,"stagingTable":self.__containStaging}) impProductTmpSql = db.sql2TmpSql("impProduct.sql", {"workingDir": self.__spDir}) impSmrTmpSql = db.sql2TmpSql("impSmr2CmrPrdct.sql", { "workingDir": self.__spDir, "stagingTable": self.__containStaging }) diffTmpSql = db.sql2TmpSql( "ins2Differ.sql", { "stagingTable": self.__containStaging, "rulesDataTable": self.__containData }) # buckupTmpSql = db.sql2TmpSql("backupSnyc.sql",{"stagingTable":self.__containStaging,"rulesDataTable":self.__containData}) impSmrFailTmpSql = db.sql2TmpSql( "smrImpFailed.sql", {"stagingTable": self.__containStaging}) space4StagePrdct = db.sql2TmpSql( "space4StagePrdct.sql", {"stagingTable": self.__containStaging}) impPdctFailTmpSql = db.sql2TmpSql("impPrductFailed.sql", {}) except Exception as e: ex = str(e) else: pass finally: return ex
def __init__(self): self.c = Crawler() self.db = DBHelper('localhost', 'root', '', 'test', 3306) self.lorder = int(time.time())
def spawnDBTask(self, db, sql, data): dbh = DBHelper(db) returnedData = dbh.query(sql, data) self.dbPane.messages.insert('end', f'Done! Found {len(returnedData)} games.') self.after(0, self.populateTree, returnedData)
def __init__(self): self.dbHelper = DBHelper()
def __init__(self): self.db = DBHelper() self.db.setup()
return respone if '_id' not in data: respone = make_response( jsonify({ "success": "collection.get_one:fail", "errMsg": "missing id" })) respone.status_code = 400 return respone _openid = data['_openid'] _id = data['_id'] result = db_helper.selectHomeworkSingle(_openid, _id) if result: result['_id'] = str(result['_id']).lstrip("Object(").rstrip(")") respone = make_response( jsonify({ "success": "collection.get_one:OK", "result": result })) respone.status_code = 200 return respone if __name__ == '__main__': db_helper = DBHelper() app.run(host="0.0.0.0", port="8989", debug=False)
import json import requests import time import urllib import io import random from dbHelper import DBHelper from secrets import bot_token, appid db = DBHelper() URL = "https://api.telegram.org/bot{}/".format(bot_token) WOLF_URL = "http://api.wolframalpha.com/v2/" SHORT_ANS_URL = WOLF_URL + "result?appid={}".format(appid) SIMPLE_ANS_URL = WOLF_URL + "simple?appid={}".format(appid) def get_url(url): """ sends a GET request to the telegram API """ response = requests.get(url) content = response.content.decode("utf8") return content def get_json(url): """ converts the response from the telegram API into json format """ content = get_url(url) js = json.loads(content)