#335: reduce DataBuilder dependencies to i2b2 platform: ant, JVM, JDBC, jboss
--------------------------+------------------------
Reporter: dconnolly | Owner:
Type: enhancement | Status: closed
Priority: major | Milestone: gpc2sites
Component: data-sharing | Resolution: fixed
Keywords: | Blocked By:
Blocking: |
--------------------------+------------------------
Comment (by gkowalski):
OMG , we're going to need a machine gun to shoot down all these herons :
{{{
CTSI-iMac-gkowalski:seine-minibuilder-0.5-f08eb078cb97 gkowalsk$ cd sql-
ora/
CTSI-iMac-gkowalski:sql-ora gkowalsk$ grep blue *
concept_dimension_extract.sql: blueherondata.qt_query_result_instance v
concept_dimension_extract.sql:join blueherondata.concept_dimension cd on
cd.concept_path like (v.variable_path || '%')
observation_fact_extract.sql:from blueherondata.qt_query_instance job
observation_fact_extract.sql:blueherondata.qt_query_result_instance v, job
observation_fact_extract.sql:join blueherondata.qt_patient_set_collection
pset on pset.result_instance_id = job.patient_set
observation_fact_extract.sql:join blueherondata.concept_dimension cd on
cd.concept_path like (v.variable_path || '%')
observation_fact_extract.sql:cross join blueherondata.observation_fact obs
patient_dimension_extract.sql:from blueherondata.qt_query_instance job
patient_dimension_extract.sql:join blueherondata.qt_patient_set_collection
pset on pset.result_instance_id = job.patient_set
patient_dimension_extract.sql:join blueherondata.patient_dimension pat on
pat.patient_num = pset.patient_num
variable_extract.sql:from blueherondata.qt_query_result_instance v
CTSI-iMac-gkowalski:sql-ora gkowalsk$
}}}
ok expunging the bird form these 4 scripts .
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/335#comment:36>
gpc-informatics <http://informatics.gpcnetwork.org/>
Greater Plains Network - Informatics
_______________________________________________
Gpc-dev mailing list
[email protected]
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
