1
package org.hisp.dhis.datamart.crosstab;
3
import java.util.ArrayList;
7
import org.hisp.dhis.DhisConvenienceTest;
8
import org.hisp.dhis.dataelement.Operand;
9
import org.hisp.dhis.datamart.crosstab.jdbc.CrossTabStore;
11
public class CrossTabStoreTest
12
extends DhisConvenienceTest
14
private CrossTabStore crossTabStore;
16
private List<Operand> operands;
18
// -------------------------------------------------------------------------
20
// -------------------------------------------------------------------------
23
public void setUpTest()
25
crossTabStore = (CrossTabStore) getBean( CrossTabStore.ID );
27
operands = new ArrayList<Operand>();
28
operands.add( new Operand( 1, 1 ) );
29
operands.add( new Operand( 1, 2 ) );
30
operands.add( new Operand( 2, 1 ) );
31
operands.add( new Operand( 2, 2 ) );
34
// -------------------------------------------------------------------------
36
// -------------------------------------------------------------------------
38
public void testCreateGetCrossTabTable()
40
crossTabStore.createCrossTabTable( operands );
42
Map<Integer, String> columnNames = crossTabStore.getCrossTabTableColumns();
44
assertEquals( 6, columnNames.size() );
45
assertEquals( "periodid", columnNames.get( 1 ) );
46
assertEquals( "sourceid", columnNames.get( 2 ) );
47
assertEquals( "de1_1", columnNames.get( 3 ) );
48
assertEquals( "de1_2", columnNames.get( 4 ) );
49
assertEquals( "de2_1", columnNames.get( 5 ) );
50
assertEquals( "de2_2", columnNames.get( 6 ) );
53
public void testDropCrossTabTable()
55
crossTabStore.createCrossTabTable( operands );
57
crossTabStore.dropCrossTabTable();
60
public void testDropCrossTabColumn()
62
crossTabStore.createCrossTabTable( operands );
64
crossTabStore.dropCrossTabColumn( "de1_1" );