def connect_db(): _db = pymysql.connect(utils.getHost(), utils.getUser(), utils.getPwd(), utils.getDb(), use_unicode=True, charset="utf8") cursor = _db.cursor() return cursor
def __init__(self, host=utils.getHost(), user=utils.getUser(), pwd=utils.getPwd(), db_name=utils.getDb()): self._db = pymysql.connect(host, user, pwd, db_name, use_unicode=True, charset="utf8") self.cursor = self._db.cursor()
mylogger = None """ Global variables read from config.ini """ api_export_root = exportConfig["COMMON"]["api_export_root"] pom_tmpl_path = os.path.join(api_export_root , exportConfig["COMMON"]["pom_tmpl_path"]) # PM variables pm_url = exportConfig["PM"]["pm_url"] pm_security_api = pm_url + exportConfig["PM"]["pm_security_api"] pm_user_id = exportConfig.get("PM" , "pm_user_id") # If PM password is not provided as input then it will be read from config.ini which requires decrypt password functionality if options.pmPwd: pm_pwd = options.pmPwd else: pm_pwd = utils.getPwd(exportConfig.get("PM" , "pm_pwd")) pm_find_service_api = pm_url + exportConfig["PM"]["pm_find_service_api"] find_service_max_rows = exportConfig["PM"]["find_service_max_rows"] find_service_list_head = exportConfig["PM"]["find_service_list_head"] pm_export_zip_path = exportConfig["PM"]["pm_export_zip_path"] pm_local_zip_path = os.path.join (api_export_root , exportConfig["PM"]["pm_local_zip_path"]) pm_export_api = pm_url + exportConfig["PM"]["pm_export_api"] pm_remote_user = exportConfig["PM"]["pm_remote_user"] pm_remote_addr = exportConfig["PM"]["pm_remote_addr"] # CM variables cm_url = exportConfig["CM"]["cm_url"] cm_security_api = cm_url + exportConfig["CM"]["cm_security_api"] cm_search_api = cm_url + exportConfig["CM"]["cm_search_api"] cm_export_api = cm_url + exportConfig["CM"]["cm_export_api"]
else: contractDict["ContractID"] = contract["ContractID"] contract = updateContract(contractDict) mylogger.info("END -- requestContract ") return contract return except: mylogger.error(traceback.format_exc()) sys.exit() """ Set Global variables read from config.ini """ exportConfig = utils.getConfigFromFile(os.path.join("config" , "config.ini")) mylogger = utils.getLogger ("APA-API-CONTRACT") # CM variables cm_url = exportConfig["CM"]["cm_url"] cm_security_api = cm_url + exportConfig["CM"]["cm_security_api"] cm_search_api = cm_url + exportConfig["CM"]["cm_search_api"] cm_login_id = exportConfig["CM"]["cm_login_id"] cm_pwd = utils.getPwd(exportConfig["CM"]["cm_pwd"]) cm_tenant_id = exportConfig["CM"]["cm_tenant_id"] #get auth token so that it can be used by all methods apiAuthTokenDict = getAPIAuthToken ()