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)
