------------------------------------------------------------
revno: 292
committer: Lars Helge Oeverland [email protected]
branch nick: trunk
timestamp: Thu 2009-05-14 16:26:56 +0200
message:
Added statement classes
added:
dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/resourcetable/statement/
dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/resourcetable/statement/CreateExclusiveGroupSetTableStatement.java
=== added directory
'dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/resourcetable/statement'
=== added file
'dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/resourcetable/statement/CreateExclusiveGroupSetTableStatement.java'
---
dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/resourcetable/statement/CreateExclusiveGroupSetTableStatement.java
1970-01-01 00:00:00 +0000
+++
dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/resourcetable/statement/CreateExclusiveGroupSetTableStatement.java
2009-05-14 14:26:56 +0000
@@ -0,0 +1,70 @@
+package org.hisp.dhis.resourcetable.statement;
+
+/*
+ * Copyright (c) 2004-2007, University of Oslo
+ * All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ * * Redistributions of source code must retain the above copyright notice,
this
+ * list of conditions and the following disclaimer.
+ * * Redistributions in binary form must reproduce the above copyright notice,
+ * this list of conditions and the following disclaimer in the documentation
+ * and/or other materials provided with the distribution.
+ * * Neither the name of the HISP project nor the names of its contributors may
+ * be used to endorse or promote products derived from this software without
+ * specific prior written permission.
+ *
+ * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
AND
+ * ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
IMPLIED
+ * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
+ * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE
FOR
+ * ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
DAMAGES
+ * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
+ * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
ON
+ * ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
+ * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF
THIS
+ * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
+ */
+
+import java.util.List;
+
+import org.hisp.dhis.jdbc.Statement;
+import org.hisp.dhis.organisationunit.OrganisationUnitGroupSet;
+
+/**
+ * @author Lars Helge Overland
+ * @version $Id$
+ */
+public class CreateExclusiveGroupSetTableStatement
+ implements Statement
+{
+ public static final String TABLE_NAME =
"orgunitgroupsetexclusivestructure";
+
+ private List<OrganisationUnitGroupSet> groupSets;
+
+ protected CreateExclusiveGroupSetTableStatement()
+ {
+ }
+
+ public CreateExclusiveGroupSetTableStatement(
List<OrganisationUnitGroupSet> groupSets )
+ {
+ this.groupSets = groupSets;
+ }
+
+ public String getStatement()
+ {
+ StringBuffer buffer = new StringBuffer( "CREATE TABLE " + TABLE_NAME +
" ( organisationunitid " );
+
+ buffer.append( NUMERIC_COLUMN_TYPE + SEPARATOR );
+
+ for ( OrganisationUnitGroupSet groupSet : groupSets )
+ {
+ buffer.append( groupSet.getName() + SPACE + LONG_TEXT_COLUMN_TYPE
+ SEPARATOR );
+ }
+
+ buffer.append( "PRIMARY KEY ( organisationunitid ) )" );
+
+ return buffer.toString();
+ }
+}
--
Trunk
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.
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
