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