dbQuery (DbResponse)

Takes details from config to attempt a connection to the specified DB and then uses that connection to process code.model.flows.processors.db.DbQuery objects from upstream.

Class names

scala: code.model.flows.processors.db.DbQueryScannable
javascript: code_model_flows_processors_db_DbQueryScannable

Aliases

DbQuery, DbProcessor, database

Coercions

RequiredFields: {
params or
queryParams
used to define
params
query or
dbQuery or
queryString
used to define
query
}
RequiredFields: {
query or
queryString or
dbQuery
used to define
query
}

Config

{"categories":[{"defaultCollapsed":true,"fields":["throttleRpm","mutualThrottlingKey","delayBetweenThrottlingChecks","throttleCheckRetryLimit"],"name":"Quality of Service (QOS)"},{"defaultCollapsed":true,"fields":["testData","testDataTransformFunc","assertionFunc"],"name":"Testing"}],"fieldName":"dbQuery","fields":[{"default":-1,"fieldName":"dbQuery.throttleCheckRetryLimit","hidden":false,"hideLabel":false,"name":"throttleCheckRetryLimit","readonly":false,"renderStrategies":[],"type":"I","validators":[]},{"default":null,"fieldName":"dbQuery.parallelism","hidden":false,"hideLabel":false,"name":"parallelism","readonly":false,"renderStrategies":[],"type":"I","validators":[]},{"default":null,"fieldName":"dbQuery.name","hidden":false,"hideLabel":false,"name":"name","readonly":false,"renderStrategies":[],"type":"S","validators":[]},{"default":"dbQuery","fieldName":"dbQuery.classPath","hidden":false,"hideLabel":false,"name":"classPath","readonly":false,"renderStrategies":[],"type":"S","validators":[]},{"default":null,"fieldName":"dbQuery.threadPoolSize","hidden":false,"hideLabel":false,"name":"threadPoolSize","readonly":false,"renderStrategies":[],"type":"I","validators":[]},{"categories":[],"fieldName":"dbQuery.provider","fields":[{"default":[],"fieldName":"dbQuery.provider.additionalProps","hidden":false,"hideLabel":false,"itemType":{"categories":[],"fieldName":"dbQuery.provider.additionalProps","fields":[{"default":null,"fieldName":"fake.dbQuery.provider.additionalProps.0.additionalProps.key","hidden":false,"hideLabel":false,"name":"key","readonly":false,"renderStrategies":[],"type":"S","validators":[]},{"default":null,"fieldName":"fake.dbQuery.provider.additionalProps.0.additionalProps.value","hidden":false,"hideLabel":false,"name":"value","readonly":false,"renderStrategies":[],"type":"S","validators":[]}],"hidden":false,"hideLabel":false,"name":"additionalProps","readonly":false,"renderStrategies":[],"type":"O"},"name":"additionalProps","readonly":false,"renderStrategies":[],"type":"A"},{"default":null,"fieldName":"dbQuery.provider.jdbcUri","hidden":false,"hideLabel":false,"name":"jdbcUri","readonly":false,"renderStrategies":[],"type":"S","validators":[]},{"default":null,"fieldName":"dbQuery.provider.name","hidden":false,"hideLabel":false,"name":"name","readonly":false,"renderStrategies":[],"type":"S","validators":[]},{"default":"genericDatabaseServerConnection","fieldName":"dbQuery.provider.classPath","hidden":false,"hideLabel":false,"name":"classPath","readonly":false,"renderStrategies":[],"type":"S","validators":[]},{"default":null,"fieldName":"dbQuery.provider.username","hidden":false,"hideLabel":false,"name":"username","readonly":false,"renderStrategies":[],"type":"S","validators":[]},{"default":"T1726099538660_F1639379857935HXQDLY","fieldName":"dbQuery.provider.id","hidden":false,"hideLabel":false,"name":"id","readonly":false,"renderStrategies":[],"type":"S","validators":[]},{"default":null,"fieldName":"dbQuery.provider.jdbcDriver","hidden":false,"hideLabel":false,"name":"jdbcDriver","readonly":false,"renderStrategies":[],"type":"S","validators":[]},{"default":null,"fieldName":"dbQuery.provider.password","hidden":false,"hideLabel":false,"name":"password","readonly":false,"renderStrategies":[],"type":"S","validators":[]}],"hidden":false,"hideLabel":false,"name":"provider","readonly":false,"renderStrategies":[],"type":"O"},{"default":-1,"fieldName":"dbQuery.throttleRpm","hidden":false,"hideLabel":false,"name":"throttleRpm","readonly":false,"renderStrategies":[],"type":"I","validators":[]},{"default":500,"fieldName":"dbQuery.retryDelay","hidden":false,"hideLabel":false,"name":"retryDelay","readonly":false,"renderStrategies":[],"type":"L","validators":[]},{"default":"","fieldName":"dbQuery.mutualThrottlingKey","hidden":false,"hideLabel":false,"name":"mutualThrottlingKey","readonly":false,"renderStrategies":[],"type":"S","validators":[]},{"default":2,"fieldName":"dbQuery.retryCount","hidden":false,"hideLabel":false,"name":"retryCount","readonly":false,"renderStrategies":[],"type":"I","validators":[]},{"default":false,"fieldName":"dbQuery.useSharedConnections","hidden":false,"hideLabel":false,"name":"useSharedConnections","readonly":false,"renderStrategies":[],"type":"B","validators":[]},{"default":null,"fieldName":"dbQuery.testDataTransformFunc","hidden":false,"hideLabel":false,"name":"testDataTransformFunc","readonly":false,"renderStrategies":[],"type":"Js","validators":[]},{"default":"T1726099538660_F1639379857961ZBYSMA","fieldName":"dbQuery.id","hidden":false,"hideLabel":false,"name":"id","readonly":false,"renderStrategies":[],"type":"S","validators":[]},{"default":null,"fieldName":"dbQuery.testData","hidden":false,"hideLabel":false,"name":"testData","readonly":false,"renderStrategies":[],"type":"Jv","validators":[]},{"default":null,"fieldName":"dbQuery.assertionFunc","hidden":false,"hideLabel":false,"name":"assertionFunc","readonly":false,"renderStrategies":[],"type":"Js","validators":[]},{"default":-1,"fieldName":"dbQuery.delayBetweenThrottlingChecks","hidden":false,"hideLabel":false,"name":"delayBetweenThrottlingChecks","readonly":false,"renderStrategies":[],"type":"L","validators":[]}],"hidden":false,"hideLabel":false,"label":"Connector Configuration","name":"dbQuery","readonly":false,"renderStrategies":[],"type":"O"}