def idmquery(wsdlurl, begintime, endtime, pagenum, systemid, idmid, clientsrv): try: history = HistoryPlugin() client = Client(wsdl=wsdlurl, plugins=[history]) querydto_type = client.get_type('ns0:queryDto') header_type = client.get_type('ns2:Header') querydto = querydto_type(beginDate=begintime, endDate=endtime, pageNo=pagenum, pageRowNo='100', systemID=systemid) header = header_type(BIZTRANSACTIONID=idmid, COUNT='', CONSUMER='', SRVLEVEL='', ACCOUNT='idmadmin', PASSWORD='******') if clientsrv == 'idmorg': residmquery = client.service.PUBLIC_SUNAC_301_queryIdmOrgData( queryDto=querydto, _soapheaders={'parameters2': header}) if clientsrv == 'idmuser': residmquery = client.service.PUBLIC_SUNAC_300_queryIdmUserData( queryDto=querydto, _soapheaders={'parameters2': header}) debuglog_sys(history.last_sent) debuglog_sys(history.last_received) except Exception as e: errlog_sys(e) return residmquery
def adrename(self, objaddn, objdnname): if self.adconn: try: resadrename = self.adconn.modify_dn(objaddn, objdnname) except Exception as e: errlog_sys(e) return resadrename
def adadd(self, objdn, objtype): if self.adconn: try: resadadd = self.adconn.add(objdn, objtype) except Exception as e: errlog_sys(e) return resadadd
def adquery(self, searchou, searchfilter): if self.adconn: try: resadquery = self.adconn.search(search_base=searchou, search_filter=searchfilter) except Exception as e: errlog_sys(e) return resadquery
def dbonequery(self, sql, *args): resone = '' if self.dbconn: try: self.dbcursor.execute(sql, args) resone = self.dbcursor.fetchone() except Exception as e: errlog_sys(e) return resone
def dbclose(self): if self.dbconn: try: if self.dbcursor: self.dbcursor.close() if self.dbconn: self.dbconn.close() except Exception as e: errlog_sys(e)
def admove(self, objaddn, objdnname, objnewdn): if self.adconn: try: resadmove = self.adconn.modify_dn(objaddn, objdnname, new_superior=objnewdn) except Exception as e: errlog_sys(e) return resadmove
def adattrquery(self, searchou, searchfilter, *args): if self.adconn: try: resadattrquery = self.adconn.search(search_base=searchou, search_filter=searchfilter, attributes=list(args)) except Exception as e: errlog_sys(e) return resadattrquery
def dbonemod(self, sql, *args): if self.dbconn: try: self.dbcursor.execute(sql, args) self.dbconn.commit() return 1 except Exception as e: self.dbconn.rollback() errlog_sys(e) return 0
def dbmanyinsert(self, sql, l_value): if self.dbconn: try: self.dbcursor.executemany(sql, l_value) self.dbconn.commit() return 1 except Exception as e: self.dbconn.rollback() errlog_sys(e) return 0
def __init__(self): try: # server = Server('192.168.4.100') # self.adconn = Connection(server, 'testing\\admin_adsrv', 'Sunac2020', auto_bind=True) server = Server('192.168.4.200') self.adconn = Connection(server, 'sunac\\jt_srv_ad', 'pass@word1', auto_bind=True) except Exception as e: errlog_sys(self.adconn.result)
def dbconnect(self): mysqlconn = '' try: mysqlconn = pymysql.connect(host=self.host, user=self.user, passwd=self.passwd, db=self.dbname, charset=self.charset) except Exception as e: errlog_sys(repr(e)) return mysqlconn
def dbmanyquery(self, sql, *args): """ 执行多行查询语句 """ resmany = '' if self.dbconn: try: self.dbcursor.execute(sql, args) resmany = self.dbcursor.fetchall() except Exception as e: errlog_sys(repr(e)) return resmany
def excelidm(excelpath): try: # 读取excel文档 wb = load_workbook(excelpath) ws = wb['sheet'] row_totle = ws.max_row col_totle = ws.max_column l_excelvalue = [] for rowcell in ws.iter_rows(min_row=2, max_row=row_totle): l_rowvalue = [] for i in range(1, col_totle): colvalue = rowcell[i].value l_rowvalue.append(colvalue) t_rowvalue = tuple(l_rowvalue) l_excelvalue.append(t_rowvalue) except Exception as e: errlog_sys(e) return l_excelvalue