def __init__(self) : self.config_bible = { 'user': '******', 'password': '******', 'host': 'mthx.cafe24.com', 'database': 'bible', 'raise_on_warnings': True, } self.config_bot = { 'user': '******', 'password': '******', 'host': 'mthx.cafe24.com', 'database': 'chatbot', 'raise_on_warnings': True, } self.dbBible = dbConMysql( self.config_bible ) self.dbBot = dbConMysql( self.config_bot )
def initDBMgs(self): config_db = { 'user': '******', 'password': '******', 'host': 'mthx.cafe24.com', 'database': 'bible', 'raise_on_warnings': True } self.db = dbConMysql(config_db)
def initDBMgs(self): config_db = { 'user': '******', 'password': '******', 'host': 'mthx.cafe24.com', 'database': 'bible', 'raise_on_warnings': True } self.db = dbConMysql(config_db) if (self.db != None): self.addLog("I", "DB", "Init OK") else: self.addLog("E", "DB", "Init Fail")
def initDB( self, config_db={ 'user': '******', 'password': '******', 'host': 'mthx.cafe24.com', 'database': 'bible', 'raise_on_warnings': True }): print("initDB : {}".format(config_db)) self.config_db = config_db self.db = dbConMysql(self.config_db) print(self.db)
def func_query_dict_except(api_name, isDebug, query, requestarg, list_args=[]): if (len(list_args) > 0): dictArgs = requestarg.to_dict(flat=True) cntNotContain = 0 for elem in list_args: if (elem not in dictArgs.keys()): cntNotContain = cntNotContain + 1 if (cntNotContain > 0): return { "ret": False, "code": 1, "msg": "invalid args", "cnt": 0, "data": [] } # code 0 -- arg invali print(dictArgs) tquery = query.format(**dictArgs) else: tquery = query db = dbConMysql(config_db) try: print("api_command:{} query:{}".format(api_name, tquery)) Ret = db.selectQueryWithRet(tquery) if (Ret["ret"] == False): if (isDebug): print("api_command:{} query:{} is FAIL".format( api_name, query)) return { "ret": False, "code": 2, "msg": "query fail", "cnt": 0, "data": [] } else: if (isDebug): print("api_command:{} query:{} is OK".format(api_name, query)) return { "ret": True, "code": 0, "msg": "ok", "cnt": len(Ret), "data": Ret['data'] } except Exception as e: return { "ret": False, "code": 3, "msg": "query fail", "cnt": 0, "data": [] }
def swinfo(): db_local = dbConMysql(config_db) query_appver = "select attrname , attrvalue from tSetting where attrname = 'appver'" ret_appdbver = db_local.selectQueryWithRet(query_appver) query_biblever = "select attrname , attrvalue from tSetting where attrname = 'bibledbver'" ret_bibledbver = db_local.selectQueryWithRet(query_biblever) query_contentver = "select attrname , attrvalue from tSetting where attrname = 'contentdbver'" ret_contentver = db_local.selectQueryWithRet(query_contentver) print(ret_appdbver['data'][0]['attrvalue']) print(ret_bibledbver['data'][0]['attrvalue']) print(ret_contentver['data'][0]['attrvalue']) dicSwinfo = { "appver": ret_appdbver['data'][0]['attrvalue'], "bibledbver": ret_bibledbver['data'][0]['attrvalue'], "contentdbver": ret_contentver['data'][0]['attrvalue'] } return dicSwinfo
import sys sys.path.append("../../Common") from Mysql.libmysql import dbConMysql config_db = {'user': '******', 'password': '******', 'host': 'mthx.cafe24.com', 'database': 'mthx_app', 'raise_on_warnings': True} db = dbConMysql(config_db) #1. fill `tBibleIWordAdv` if True : # Done query = "select * from tBibleIWord" ins_query = "insert into tBibleIWordAdv( iw_cateid , iw_catenm , iw_catedesc_desc ) values ( {bibleiword_seq} , '{bibleiword_nm}' , '{bibleiword_desc}' )" ret = db.selectQueryWithRet( query ) for row in ret['data'] : print( row ) act_query = ins_query.format(**row) print( act_query ) ret = db.commitQuery(act_query) if True : dicData = {} if False : query = "select * from tBibleBook" ret = db.selectQueryWithRet(query) if( ret['ret'] == False ) : print("False")
from time import sleep from selenium import webdriver import json import re from time import sleep import json config_db = { 'user': '******', 'password': '******', 'host': 'mthx.cafe24.com', 'database': 'bible', 'raise_on_warnings': True } db = dbConMysql(config_db) db2 = dbConMysql(config_db) db3 = dbConMysql(config_db) path_chrome_driver_win = "\\..\\Common\\lib\\chromedriver.exe" path_chrome_driver_win_abs = "D:/workspace/PyCharm/PyTorch/couragesuper-ds/Common/Crawler/lib/chromedriver.exe" url_biblebook = [ 'Gen', 'Exo', 'Lev', 'num', 'deu', 'jos', 'jdg', 'rth', '1sa', '2sa', '1ki', '2ki', '1ch', '2ch', 'ezr', 'neh', 'est', 'job', 'psa', 'pro', 'ecc', 'son', 'isa', 'jer', 'lam', 'eze', 'dan', 'hos', 'joe', 'amo', 'oba', 'jon', 'mic', 'nah', 'hab', 'zep', 'hag', 'zec', 'mal', 'mat', 'mar', 'luk', 'joh', 'act', 'rom', '1co', '2co', 'gal', 'eph', 'phi', 'col', '1th', '2th', '1ti', '2ti', 'tit', 'phm', 'heb', 'jam', '1pe', '2pe', '1jo', '2jo', '3jo', 'jud', 'rev' ]
def openDB() : config_db = {'user': '******', 'password': '******', 'host': 'mthx.cafe24.com', 'database': 'bible', 'raise_on_warnings': True} return dbConMysql(config_db)
import sys import json sys.path.append("../Common") from Mysql.libmysql import dbConMysql config_bot = { 'user': '******', 'password': '******', 'host': 'mthx.cafe24.com', 'database': 'chatbot', 'raise_on_warnings': True } db = dbConMysql(config_bot) qry = "select * from tUserChatStatJson where userkey='U9A9agpChomm'; " listRet = db.selectQuery( qry ) jsonStr = listRet[0]['jsondata'] ret = json.loads(jsonStr) print( ret )
import sys sys.path.append("../Common") from Mysql.libmysql import dbConMysql import sqlite3 config_db = { 'user': '******', 'password': '******', 'host': 'mthx.cafe24.com', 'database': 'mthx_app', 'raise_on_warnings': True } db = dbConMysql(config_db) dbinput = dbConMysql(config_db) ret_category = db.selectQueryWithRet("select * from tBibleIWordAdv;") print(ret_category) #ret = db.selectQueryWithRet("select * from tBibleIWordContAdv") #print( ret ) iw_cateid = 0 iw_seq = 0 iw_subseq = 0 iw_subsubseq = 0 for category in ret_category['data']: print(category) ret = db.selectQueryWithRet(