NAME

CohortExplorer::Application::OpenClinica::Datasource - CohortExplorer class to initialize datasource stored under OpenClinica framework

SYNOPSIS

The class is inherited from CohortExplorer::Datasource and overrides the following methods:

authenticate( $opts )

This method authenticates the user by performing POST request against the OpenClinica database. The successful POST is followed by SQL query to retrieve user's role and crfs within the study/datasource.

additional_params( $opts, $response )

The method runs a SQL query to determine the datasource type (i.e. standard/cross-sectional or longitudinal). For longitudinal datasources the method attempts to set static_tables (i.e. non repeating CRFs).

entity_structure()

This method returns a hash ref defining the entity structure. The method uses a combination of study_event_definition.oc_oid and study_event.sample_ordinal columns to define visit column for the longitudinal datasources.

table_structure()

This method returns a hash ref defining the table structure. -columns key within the table structure includes table attributes such as table, variable_count, version, description and events.

variable_structure()

This method returns a hash ref defining the variable structure. The variable attributes include columns such as variable, table, unit, type, category, default_value, description, unit and label.

datatype_map()

This method returns variable type to SQL type mapping.

BUGS

At present the application only supports querying of OpenClinica instances that are implemented in PostgreSQL. In future, the application will be available with support for Oracle databases.

SEE ALSO

CohortExplorer

CohortExplorer::Datasource

CohortExplorer::Command::Describe

CohortExplorer::Command::Find

CohortExplorer::Command::History

CohortExplorer::Command::Query::Search

CohortExplorer::Command::Query::Compare

LICENSE AND COPYRIGHT

Copyright (c) 2013 Abhishek Dixit (adixit@cpan.org). All rights reserved.

This program is free software: you can redistribute it and/or modify it under the terms of either:

• the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version, or

• the "Artistic Licence".

AUTHOR

Abhishek Dixit

cpanm CohortExplorer

perl -MCPAN -e shell
install CohortExplorer