1
package org.hisp.dhis.reporttable.statement;
4
* Copyright (c) 2004-2007, University of Oslo
7
* Redistribution and use in source and binary forms, with or without
8
* modification, are permitted provided that the following conditions are met:
9
* * Redistributions of source code must retain the above copyright notice, this
10
* list of conditions and the following disclaimer.
11
* * Redistributions in binary form must reproduce the above copyright notice,
12
* this list of conditions and the following disclaimer in the documentation
13
* and/or other materials provided with the distribution.
14
* * Neither the name of the HISP project nor the names of its contributors may
15
* be used to endorse or promote products derived from this software without
16
* specific prior written permission.
18
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
19
* ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
20
* WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
21
* DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR
22
* ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
23
* (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
24
* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON
25
* ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
26
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
27
* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
30
import static org.hisp.dhis.reporttable.ReportTable.REGRESSION_COLUMN_PREFIX;
32
import java.util.Iterator;
34
import org.hisp.dhis.jdbc.StatementDialect;
35
import org.hisp.dhis.reporttable.ReportTable;
38
* @author Lars Helge Overland
41
public class CreateReportTableStatement
42
extends ReportTableStatement
44
// -------------------------------------------------------------------------
46
// -------------------------------------------------------------------------
48
public CreateReportTableStatement( ReportTable reportTable, StatementDialect dialect )
50
super( reportTable, dialect );
53
// -------------------------------------------------------------------------
54
// ReportTableStatement implementation
55
// -------------------------------------------------------------------------
58
protected void init( ReportTable reportTable )
60
StringBuffer buffer = new StringBuffer();
62
buffer.append( "CREATE TABLE " + reportTable.getTableName() + " ( " );
64
// ---------------------------------------------------------------------
66
// ---------------------------------------------------------------------
68
for ( String column : reportTable.getIndexColumns() )
70
buffer.append( column + SPACE + NUMERIC_COLUMN_TYPE + SEPARATOR );
73
// ---------------------------------------------------------------------
75
// ---------------------------------------------------------------------
77
for ( String column : reportTable.getIndexNameColumns() )
79
buffer.append( column + SPACE + LONG_TEXT_COLUMN_TYPE + SEPARATOR );
82
// ---------------------------------------------------------------------
83
// Reporting month name
84
// ---------------------------------------------------------------------
86
buffer.append( REPORTING_MONTH_COLUMN_NAME + SPACE + LONG_TEXT_COLUMN_TYPE + SEPARATOR );
88
// ---------------------------------------------------------------------
90
// ---------------------------------------------------------------------
92
for ( String column : reportTable.getCrossTabColumns() )
94
buffer.append( column + SPACE + statementBuilder.getDoubleColumnType() + SEPARATOR );
97
// ---------------------------------------------------------------------
99
// ---------------------------------------------------------------------
101
if ( reportTable.isRegression() )
103
for ( String column : reportTable.getCrossTabColumns() )
105
buffer.append( REGRESSION_COLUMN_PREFIX + column + SPACE + statementBuilder.getDoubleColumnType() + SEPARATOR );
109
// ---------------------------------------------------------------------
111
// ---------------------------------------------------------------------
113
buffer.append( "PRIMARY KEY ( " );
115
Iterator<String> indexColumns = reportTable.getIndexColumns().iterator();
117
while ( indexColumns.hasNext() )
119
buffer.append( indexColumns.next() + ( indexColumns.hasNext() ? SEPARATOR : SPACE ) );
122
buffer.append( ") )" );
124
statement = buffer.toString();