def setUp(self): self.sqllist = commen.PutsqlNum() self.ruler_name = commen.PutsqlName("db2_") LOG.info("规则名称:%s" % self.ruler_name) LOG.info("SQL语句:%s" % self.sqllist) self.sensql = SensitiveSql(self.ruler_name, GlobalConfig.db_type_['DB2'], dbservice.select_dbservice_byname(gp.run_db["db2"])) self.sensitiveway = SensitiveWay()
def update_runmode(dbname, runmode): ''' 编辑数据库模式 :param dbname:数据库名称 ''' id = dbservice.select_dbservice_byname(dbname) LOG.info('开始编辑。。。') dbservice.update_service(dbname, id, runmode) LOG.info('编辑结束。。。')
def setUp(self): self.dbtable = commen.PutsqlName("dbtable_") self.sqllist = "SELECT * FROM " + self.dbtable self.ruler_name = commen.PutsqlName("dm_") LOG.info("规则名称:%s" % self.ruler_name) LOG.info("SQL语句:%s" % self.sqllist) self.sensql = SensitiveSql( self.ruler_name, GlobalConfig.db_type_['dm'], dbservice.select_dbservice_byname(gp.run_db['dm'])) self.sensitiveway = SensitiveWay()
def setUp(self): self.dbtable = commen.PutsqlName("dbtable_") sql_execute.db2_create_table('db2', self.dbtable) self.sqllist = "SELECT * FROM " + self.dbtable self.ruler_name = commen.PutsqlName("db2_") LOG.info("规则名称:%s" % self.ruler_name) LOG.info("SQL语句:%s" % self.sqllist) self.sensql = SensitiveSql( self.ruler_name, GlobalConfig.db_type_['DB2'], dbservice.select_dbservice_byname(gp.run_db["db2"])) self.sensitiveway = SensitiveWay()
def create_DB(dbnameList): for name in dbnameList: num = dbservice.select_dbservice_bynullname(name) if num == 0: LOG.info('开始创建%s数据库服务。。。' % (name)) dbservice.create_dbservice(name) LOG.info('开始启用%s数据库服务。。。' % (name)) id = dbservice.select_dbservice_byname(name) dbservice.startOrstop_dbservice(id, mode=1) LOG.info('启用%s数据库服务成功' % (name)) else: LOG.info(name + '数据库服务已存在') time.sleep(30)
def update_switch(dispose=None, featuresStatus=None, virStatus=None, name=None, dataMaskStatusOM=None): id = dbservice.select_dbservice_byname(name=name) LOG.info('编辑开关开始。。。') dbsecurityconf.update_switch(dispose=dispose, featuresStatus=featuresStatus, virStatus=virStatus, id=id, dataMaskStatusOM=dataMaskStatusOM) LOG.info('编辑开关开始结束。。。')
def setUp(self): self.whitecase = WhitelistCase(dbservice.select_dbservice_byname(gp.run_db['oracle']), gp.app_dict["oracle"]) self.whitelist = WhitelistWay()
stdin, stdout, stderr = ssh.exec_command( '''su - oracle -c"echo '%s;'|sqlplus -s '%s'"''' % (sql, gStrConnection)) elif (dbtype == "MySQL"): stdin, stdout, stderr = ssh.exec_command( '''echo "%s;"|mysql %s''' % (sql, gStrConnection)) # 读取结果 time.sleep(4) result = stdout.readlines() time.sleep(1) ssh.close() except Exception as e: print('%s Error' % ip) print(e) return False def sql_ops(con_dict, sql, dbtype): if (dbtype == "Sql Server"): Win_winrm(con_dict, sql) else: ssh_con(con_dict, sql, dbtype) if __name__ == '__main__': # print(Win_winrm(DBConfig.sqlserver_dict, "select * from table")) print( sql_ops(dbservice.select_dbservice_byname(gp.run_db["oracle"]), "SELECT * FROM P123", "Oracle"))