Python importCisの例

コード例 #1

ファイル: csv_import.py プロジェクト: deezeesms/dd-git

def DiscoveryMain(Framework):
    OSHVResult = ObjectStateHolderVector()
    protocol = Framework.getDestinationAttribute('Protocol')
    try:
        csvFileName = Framework.getRequiredParameterValue(PARAM_CSV_FILE)
        delimiter = Framework.getRequiredParameterValue(
            PARAM_CSV_FILE_DELIMITER)
        if delimiter and delimiter.isdigit():
            delimiter = chr(int(delimiter))
        rowToStartIndex = Framework.getRequiredParameterValue(
            PARAM_ROW_TO_START_INDEX)
        bulkSize = Framework.getParameter(import_utils.PARAM_BULK_SIZE)
        flushObjects = Framework.getParameter(import_utils.PARAM_FLUSH_OBJECTS)
        fileEncoding = Framework.getParameter(import_utils.PARAM_FILE_ENCODING)

        dataSource = CsvFileDataSource(csvFileName, delimiter,
                                       int(rowToStartIndex), Framework,
                                       fileEncoding)
        dataSource.quoteSymbol = Framework.getParameter(PARAM_QUOTE_SYMBOL)

        if flushObjects and (flushObjects.lower() == "true"):
            import_utils.importFlushingCis(dataSource, OSHVResult, Framework,
                                           bulkSize)
        else:
            import_utils.importCis(dataSource, OSHVResult, Framework)

    except Exception, ex:
        exInfo = ex.getMessage()
        errormessages.resolveAndReport(exInfo, protocol, Framework)

コード例 #2

ファイル: properties_file_import.py プロジェクト: ddonnelly19/dd-git

def DiscoveryMain(Framework):
    OSHVResult = ObjectStateHolderVector()
    protocol = Framework.getDestinationAttribute("Protocol")
    try:
        propertyFileName = Framework.getRequiredParameterValue(PARAM_PROPERTY_FILE)
        dataSource = PropertyFileDataSource(propertyFileName, Framework)
        bulkSize = Framework.getParameter(import_utils.PARAM_BULK_SIZE)
        flushObjects = Framework.getParameter(import_utils.PARAM_FLUSH_OBJECTS)

        if flushObjects and (flushObjects.lower() == "true"):
            import_utils.importFlushingCis(dataSource, OSHVResult, Framework, bulkSize)
        else:
            import_utils.importCis(dataSource, OSHVResult, Framework)
    except Exception, ex:
        exInfo = ex.getMessage()
        errormessages.resolveAndReport(exInfo, protocol, Framework)

コード例 #3

ファイル: properties_file_import.py プロジェクト: deezeesms/dd-git

def DiscoveryMain(Framework):
    OSHVResult = ObjectStateHolderVector()
    protocol = Framework.getDestinationAttribute('Protocol')
    try:
        propertyFileName = Framework.getRequiredParameterValue(
            PARAM_PROPERTY_FILE)
        dataSource = PropertyFileDataSource(propertyFileName, Framework)
        bulkSize = Framework.getParameter(import_utils.PARAM_BULK_SIZE)
        flushObjects = Framework.getParameter(import_utils.PARAM_FLUSH_OBJECTS)

        if flushObjects and (flushObjects.lower() == "true"):
            import_utils.importFlushingCis(dataSource, OSHVResult, Framework,
                                           bulkSize)
        else:
            import_utils.importCis(dataSource, OSHVResult, Framework)
    except Exception, ex:
        exInfo = ex.getMessage()
        errormessages.resolveAndReport(exInfo, protocol, Framework)

コード例 #4

def DiscoveryMain(Framework):

    OSHVResult = ObjectStateHolderVector()

    protocol = 'SQL'

    try:
        schemaName = Framework.getParameter(PARAM_SCHEMA_NAME)
        tableName = Framework.getParameter(PARAM_TABLE_NAME)
        sqlQuery = Framework.getParameter(PARAM_SQL_QUERY)
        bulkSize = Framework.getParameter(import_utils.PARAM_BULK_SIZE)
        flushObjects = Framework.getParameter(import_utils.PARAM_FLUSH_OBJECTS)

        #Set connection related properties from triggered CI
        props = Properties()

        dbPort = Framework.getDestinationAttribute('database_port')
        if dbPort and dbPort != NA:
            props.put(Protocol.PROTOCOL_ATTRIBUTE_PORT, dbPort)

        db_instance_name = Framework.getDestinationAttribute('instance_name')
        if db_instance_name and db_instance_name != NA:
            props.put(Protocol.SQL_PROTOCOL_ATTRIBUTE_DBSID,
                      db_instance_name[db_instance_name.find('\\') + 1:])
        props.put(Protocol.SQL_PROTOCOL_ATTRIBUTE_DBNAME, schemaName)
        client = Framework.createClient(props)
        dbType = client.getProtocolDbType()

        queryFactory = DbQueryFactory(schemaName, tableName, dbType, sqlQuery)

        dataSource = DBDataSource(client, schemaName, queryFactory)

        if flushObjects and (flushObjects.lower() == "true"):
            import_utils.importFlushingCis(dataSource, OSHVResult, Framework,
                                           bulkSize)
        else:
            import_utils.importCis(dataSource, OSHVResult, Framework)

    except Exception, ex:
        exInfo = ex.getMessage()
        errormessages.resolveAndReport(exInfo, protocol, Framework)

コード例 #5

ファイル: db_import.py プロジェクト: ddonnelly19/dd-git

def DiscoveryMain(Framework):

    OSHVResult = ObjectStateHolderVector()
    
    protocol = 'SQL'
    
    try:
        schemaName = Framework.getParameter(PARAM_SCHEMA_NAME)
        tableName = Framework.getParameter(PARAM_TABLE_NAME)
        sqlQuery = Framework.getParameter(PARAM_SQL_QUERY)
        bulkSize = Framework.getParameter(import_utils.PARAM_BULK_SIZE)
        flushObjects = Framework.getParameter(import_utils.PARAM_FLUSH_OBJECTS)
        
        #Set connection related properties from triggered CI
        props = Properties()
        
        dbPort = Framework.getDestinationAttribute('database_port')
        if dbPort and dbPort != NA:
            props.put(Protocol.PROTOCOL_ATTRIBUTE_PORT, dbPort)
        
        db_instance_name = Framework.getDestinationAttribute('instance_name')
        if db_instance_name and db_instance_name != NA:
            props.put(Protocol.SQL_PROTOCOL_ATTRIBUTE_DBSID, db_instance_name[db_instance_name.find('\\')+1:])
        props.put(Protocol.SQL_PROTOCOL_ATTRIBUTE_DBNAME, schemaName)
        client = Framework.createClient(props)
        dbType = client.getProtocolDbType()
        
        queryFactory = DbQueryFactory(schemaName, tableName, dbType, sqlQuery)

        dataSource = DBDataSource(client, schemaName, queryFactory)

        if flushObjects and (flushObjects.lower() == "true"):
            import_utils.importFlushingCis(dataSource, OSHVResult, Framework, bulkSize)
        else:
            import_utils.importCis(dataSource, OSHVResult, Framework)

    except Exception, ex:
        exInfo = ex.getMessage()
        errormessages.resolveAndReport(exInfo, protocol, Framework)

コード例 #6

ファイル: csv_import.py プロジェクト: ddonnelly19/dd-git

def DiscoveryMain(Framework):
    OSHVResult = ObjectStateHolderVector()
    protocol = Framework.getDestinationAttribute("Protocol")
    try:
        csvFileName = Framework.getRequiredParameterValue(PARAM_CSV_FILE)
        delimiter = Framework.getRequiredParameterValue(PARAM_CSV_FILE_DELIMITER)
        if delimiter and delimiter.isdigit():
            delimiter = chr(int(delimiter))
        rowToStartIndex = Framework.getRequiredParameterValue(PARAM_ROW_TO_START_INDEX)
        bulkSize = Framework.getParameter(import_utils.PARAM_BULK_SIZE)
        flushObjects = Framework.getParameter(import_utils.PARAM_FLUSH_OBJECTS)
        fileEncoding = Framework.getParameter(import_utils.PARAM_FILE_ENCODING)

        dataSource = CsvFileDataSource(csvFileName, delimiter, int(rowToStartIndex), Framework, fileEncoding)
        dataSource.quoteSymbol = Framework.getParameter(PARAM_QUOTE_SYMBOL)

        if flushObjects and (flushObjects.lower() == "true"):
            import_utils.importFlushingCis(dataSource, OSHVResult, Framework, bulkSize)
        else:
            import_utils.importCis(dataSource, OSHVResult, Framework)

    except Exception, ex:
        exInfo = ex.getMessage()
        errormessages.resolveAndReport(exInfo, protocol, Framework)