dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #36034
[Branch ~dhis2-devs-core/dhis2/trunk] Rev 18454: Analytics tables, using inner joins for tables which have not-null columns.
------------------------------------------------------------
revno: 18454
committer: Lars Helge Overland <larshelge@xxxxxxxxx>
branch nick: dhis2
timestamp: Mon 2015-03-02 11:56:38 +0100
message:
Analytics tables, using inner joins for tables which have not-null columns.
modified:
dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcAnalyticsTableManager.java
dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcCompletenessTableManager.java
dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcCompletenessTargetTableManager.java
dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcEventAnalyticsTableManager.java
dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcOrgUnitTargetTableManager.java
--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk
Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== modified file 'dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcAnalyticsTableManager.java'
--- dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcAnalyticsTableManager.java 2015-02-27 12:31:01 +0000
+++ dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcAnalyticsTableManager.java 2015-03-02 10:56:38 +0000
@@ -217,12 +217,12 @@
"left join _categoryoptiongroupsetstructure cogs on dv.attributeoptioncomboid=cogs.categoryoptioncomboid " +
"left join _categorystructure dcs on dv.categoryoptioncomboid=dcs.categoryoptioncomboid " +
"left join _categorystructure acs on dv.attributeoptioncomboid=acs.categoryoptioncomboid " +
- "left join _periodstructure ps on dv.periodid=ps.periodid " +
"left join _orgunitstructure ous on dv.sourceid=ous.organisationunitid " +
"left join _dataelementstructure des on dv.dataelementid = des.dataelementid " +
"inner join dataelement de on dv.dataelementid=de.dataelementid " +
"inner join categoryoptioncombo co on dv.categoryoptioncomboid=co.categoryoptioncomboid " +
"inner join period pe on dv.periodid=pe.periodid " +
+ "inner join _periodstructure ps on dv.periodid=ps.periodid " +
"inner join organisationunit ou on dv.sourceid=ou.organisationunitid " +
"where de.valuetype = '" + valueType + "' " +
"and de.domaintype = 'AGGREGATE' " +
=== modified file 'dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcCompletenessTableManager.java'
--- dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcCompletenessTableManager.java 2015-02-27 12:31:01 +0000
+++ dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcCompletenessTableManager.java 2015-03-02 10:56:38 +0000
@@ -142,9 +142,9 @@
"from completedatasetregistration cdr " +
"left join _organisationunitgroupsetstructure ougs on cdr.sourceid=ougs.organisationunitid " +
"left join _orgunitstructure ous on cdr.sourceid=ous.organisationunitid " +
+ "inner join period pe on cdr.periodid=pe.periodid " +
"left join _periodstructure ps on cdr.periodid=ps.periodid " +
- "left join period pe on cdr.periodid=pe.periodid " +
- "left join dataset ds on cdr.datasetid=ds.datasetid " +
+ "inner join dataset ds on cdr.datasetid=ds.datasetid " +
"where pe.startdate >= '" + start + "' " +
"and pe.startdate <= '" + end + "'" +
"and cdr.date is not null";
=== modified file 'dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcCompletenessTargetTableManager.java'
--- dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcCompletenessTargetTableManager.java 2015-02-27 12:31:01 +0000
+++ dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcCompletenessTargetTableManager.java 2015-03-02 10:56:38 +0000
@@ -141,7 +141,7 @@
sql +=
"1 as value " +
"from datasetsource dss " +
- "left join dataset ds on dss.datasetid=ds.datasetid " +
+ "inner join dataset ds on dss.datasetid=ds.datasetid " +
"left join _orgunitstructure ous on dss.sourceid=ous.organisationunitid " +
"left join _organisationunitgroupsetstructure ougs on dss.sourceid=ougs.organisationunitid";
=== modified file 'dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcEventAnalyticsTableManager.java'
--- dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcEventAnalyticsTableManager.java 2015-02-27 12:31:01 +0000
+++ dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcEventAnalyticsTableManager.java 2015-03-02 10:56:38 +0000
@@ -200,13 +200,13 @@
sql = removeLast( sql, 1 ) + " ";
sql += "from programstageinstance psi " +
- "left join _organisationunitgroupsetstructure ougs on psi.organisationunitid=ougs.organisationunitid " +
- "left join programinstance pi on psi.programinstanceid=pi.programinstanceid " +
- "left join programstage ps on psi.programstageid=ps.programstageid " +
- "left join program pr on pi.programid=pr.programid " +
+ "inner join programinstance pi on psi.programinstanceid=pi.programinstanceid " +
+ "inner join programstage ps on psi.programstageid=ps.programstageid " +
+ "inner join program pr on pi.programid=pr.programid " +
"left join trackedentityinstance tei on pi.trackedentityinstanceid=tei.trackedentityinstanceid " +
- "left join organisationunit ou on psi.organisationunitid=ou.organisationunitid " +
+ "inner join organisationunit ou on psi.organisationunitid=ou.organisationunitid " +
"left join _orgunitstructure ous on psi.organisationunitid=ous.organisationunitid " +
+ "left join _organisationunitgroupsetstructure ougs on psi.organisationunitid=ougs.organisationunitid " +
"left join _dateperiodstructure dps on psi.executiondate=dps.dateperiod " +
"where psi.executiondate >= '" + start + "' " +
"and psi.executiondate <= '" + end + "' " +
=== modified file 'dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcOrgUnitTargetTableManager.java'
--- dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcOrgUnitTargetTableManager.java 2015-02-27 12:31:01 +0000
+++ dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcOrgUnitTargetTableManager.java 2015-03-02 10:56:38 +0000
@@ -140,7 +140,7 @@
sql +=
"1 as value " +
"from orgunitgroupmembers ougm " +
- "left join orgunitgroup oug on ougm.orgunitgroupid=oug.orgunitgroupid " +
+ "inner join orgunitgroup oug on ougm.orgunitgroupid=oug.orgunitgroupid " +
"left join _orgunitstructure ous on ougm.organisationunitid=ous.organisationunitid " +
"left join _organisationunitgroupsetstructure ougs on ougm.organisationunitid=ougs.organisationunitid";