Workflow Type: Common Workflow Language
Work-in-progress

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 hostname
  • db_name - the database name
  • db_user - the username for postgres
  • db_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
  • File
result_modifiers n/a n/a
  • string?
is_availability n/a n/a
  • boolean
results n/a n/a
  • string?
db_host n/a n/a
  • string
db_name n/a n/a
  • string
db_user n/a n/a
  • string
db_password n/a n/a
  • string

Steps

ID Name Description
run_query n/a n/a

Outputs

ID Name Description Type
output_file n/a n/a
  • File

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
help Creators and Submitter
Creator
Submitter
Citation
Panagi, V. (2023). rquest-omop-worker. WorkflowHub. https://doi.org/10.48546/WORKFLOWHUB.WORKFLOW.471.2
License
Activity

Views: 2599   Downloads: 1022

Created: 15th May 2023 at 17:15

Last updated: 23rd Oct 2023 at 14:58

help Tags

This item has not yet been tagged.

help Attributions

None

Total size: 5.94 KB
Powered by
(v.1.16.0-main)
Copyright © 2008 - 2024 The University of Manchester and HITS gGmbH