Python select_dbservice_byname Beispiele

Beispiel #1

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

Beispiel #2

def update_runmode(dbname, runmode):
    '''
    编辑数据库模式
    :param dbname:数据库名称
    '''
    id = dbservice.select_dbservice_byname(dbname)
    LOG.info('开始编辑。。。')
    dbservice.update_service(dbname, id, runmode)
    LOG.info('编辑结束。。。')

Beispiel #3

Datei: Func_dm_re_off.py Projekt: rcoons/python_api

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

Beispiel #4

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

Beispiel #5

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)

Beispiel #6

Datei: DBSecurityconf_Case.py Projekt: rcoons/python_api

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('编辑开关开始结束。。。')

Beispiel #7

 def setUp(self):
     self.whitecase = WhitelistCase(dbservice.select_dbservice_byname(gp.run_db['oracle']), gp.app_dict["oracle"])
     self.whitelist = WhitelistWay()

Beispiel #8

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