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 ()
