rquest-omop-worker
Executes BC|RQuest Availability queries via an open source implementation of BC|Link against a target PostgreSQL data source containing OMOP CDM 5.3 data.
Inputs
### Body Sample input payload:
{
"task_id": "job-2023-01-13-14: 20: 38-",
"project": "",
"owner": "",
"cohort": {
"groups": [
{
"rules": [
{
"varname": "OMOP",
"varcat": "Person",
"type": "TEXT",
"oper": "=",
"value": "8507"
}
],
"rules_oper": "AND"
}
],
"groups_oper": "OR"
},
"collection": "",
"protocol_version": "",
"char_salt": "",
"uuid": ""
}
Database access
Currently this workflow requires inputs for connecting to the database it will run queries against using SQL Alchemy compatible options:
db_host
- the postgres db server hostnamedb_name
- the database namedb_user
- the username for postgresdb_password
the password for postgres
It is not currently possible to use a port other than the postgres default (5432
)
Click and drag the diagram to pan, double click or use the controls to zoom.
Inputs
ID | Name | Description | Type |
---|---|---|---|
body | n/a | n/a |
|
result_modifiers | n/a | n/a |
|
is_availability | n/a | n/a |
|
results | n/a | n/a |
|
db_host | n/a | n/a |
|
db_name | n/a | n/a |
|
db_user | n/a | n/a |
|
db_password | n/a | n/a |
|
Steps
ID | Name | Description |
---|---|---|
run_query | n/a | n/a |
Outputs
ID | Name | Description | Type |
---|---|---|---|
output_file | n/a | n/a |
|
Version History
main @ 724775a (latest) Created 23rd Oct 2023 at 14:58 by Vasiliki Panagi
Merge pull request #1 from HDRUK/env_variables
Remove db parameters from workflows
Frozen
main
724775a
main @ 8a4c8c1 Created 10th Oct 2023 at 16:03 by Jon Couldridge
adding cwl files
Frozen
main
8a4c8c1
main @ b916ecf (earliest) Created 15th May 2023 at 17:15 by Stian Soiland-Reyes
AB105814: Create scope in HostedService for WfexsJobService (#194)
Frozen
main
b916ecf
Creator
Submitter
Views: 2599 Downloads: 1022
Created: 15th May 2023 at 17:15
Last updated: 23rd Oct 2023 at 14:58
This item has not yet been tagged.
None