Examples with FakeDataManager org.teiid.query.processor.FakeDataManager used on opensource projects

Example 46 with FakeDataManager

use of org.teiid.query.processor.FakeDataManager in project teiid by teiid.

the class TestProcedureProcessor method testParamsWithResultSetVirtual.

@Test
public void testParamsWithResultSetVirtual() throws Exception {
    // $NON-NLS-1$
    String sql = "{? = call TEIIDSP9(1)}";
    TransformationMetadata metadata = RealMetadataFactory.exampleBQTCached();
    ProcessorPlan plan = getProcedurePlan(sql, metadata);
    FakeDataManager dataMgr = new FakeDataManager();
    List[] expected = new List[] { Arrays.asList("hello", null, null), // $NON-NLS-1$
    Arrays.asList(null, 1, 10) };
    helpTestProcess(plan, expected, dataMgr, metadata);
}

Example 47 with FakeDataManager

use of org.teiid.query.processor.FakeDataManager in project teiid by teiid.

the class TestProcedureProcessor method testVirtualProcedure10.

@Test
public void testVirtualProcedure10() throws Exception {
    // $NON-NLS-1$
    String userUpdateStr = "EXEC pm1.vsp13()";
    QueryMetadataInterface metadata = RealMetadataFactory.example1Cached();
    FakeDataManager dataMgr = exampleDataManager(metadata);
    ProcessorPlan plan = getProcedurePlan(userUpdateStr, metadata);
    // Create expected results
    List[] expected = new List[] { // $NON-NLS-1$
    Arrays.asList(new Object[] { "Third", Integer.valueOf(5) }) };
    helpTestProcess(plan, expected, dataMgr, metadata);
}

Example 48 with FakeDataManager

use of org.teiid.query.processor.FakeDataManager in project teiid by teiid.

the class TestProcedureProcessor method testVirtualProcedure6.

@Test
public void testVirtualProcedure6() throws Exception {
    // $NON-NLS-1$
    String userUpdateStr = "EXEC pm1.vsp7(5)";
    QueryMetadataInterface metadata = RealMetadataFactory.example1Cached();
    FakeDataManager dataMgr = exampleDataManager(metadata);
    ProcessorPlan plan = getProcedurePlan(userUpdateStr, metadata);
    // Create expected results
    List[] expected = new List[] { // $NON-NLS-1$
    Arrays.asList(new Object[] { "Second" }) };
    helpTestProcess(plan, expected, dataMgr, metadata);
}

Example 49 with FakeDataManager

use of org.teiid.query.processor.FakeDataManager in project teiid by teiid.

the class TestProcedureProcessor method testDynamicCommandWithIntoAndLoop.

@Test
public void testDynamicCommandWithIntoAndLoop() throws Exception {
    // Test INTO clause with loop
    TransformationMetadata metadata = RealMetadataFactory.example1();
    // $NON-NLS-1$
    StringBuffer procedure = new StringBuffer("CREATE VIRTUAL PROCEDURE \n");
    // $NON-NLS-1$
    procedure.append("BEGIN\n");
    // $NON-NLS-1$
    procedure.append("declare integer VARIABLES.e2_total=0;\n");
    // $NON-NLS-1$
    procedure.append("execute string 'SELECT e1, e2 FROM pm1.g1' as e1 string, e2 integer into #temp;\n");
    // $NON-NLS-1$
    procedure.append("loop on (Select e2 from #temp where e2 > 2) as mycursor\n");
    // $NON-NLS-1$
    procedure.append("BEGIN\n");
    // $NON-NLS-1$
    procedure.append("IF (mycursor.e2>5) \n");
    // $NON-NLS-1$
    procedure.append("VARIABLES.e2_total=VARIABLES.e2_total+mycursor.e2;\n");
    // $NON-NLS-1$
    procedure.append("END\n");
    // $NON-NLS-1$
    procedure.append("SELECT cast(VARIABLES.e2_total as string);\n");
    // $NON-NLS-1$
    procedure.append("END");
    addProc(metadata, procedure.toString());
    // $NON-NLS-1$
    String userUpdateStr = "EXEC pm1.sq2()";
    FakeDataManager dataMgr = exampleDataManager(metadata);
    ProcessorPlan plan = getProcedurePlan(userUpdateStr, metadata);
    // Create expected results
    List[] expected = new List[] { Arrays.asList(new Object[] { "66" }) };
    helpTestProcess(plan, expected, dataMgr, metadata);
}

Example 50 with FakeDataManager

use of org.teiid.query.processor.FakeDataManager in project teiid by teiid.

the class TestProcedureProcessor method testDynamicCommandTypeConversion.

// converts e1 from integer to string, with a different name
@Test
public void testDynamicCommandTypeConversion() throws Exception {
    TransformationMetadata metadata = RealMetadataFactory.example1();
    addProc(metadata, "sq2", // $NON-NLS-1$ //$NON-NLS-2$
    "CREATE VIRTUAL PROCEDURE BEGIN\n" + "declare string VARIABLES.x; VARIABLES.x = 'a'; execute string 'SELECT e2 ' || ' FROM pm1.g1 ' || ' where e1=pm1.sq2.in'; END", new String[] { "e1" }, new String[] { DataTypeManager.DefaultDataTypes.STRING }, new String[] { "in" }, new String[] { DataTypeManager.DefaultDataTypes.STRING });
    // $NON-NLS-1$
    String userUpdateStr = "EXEC pm1.sq2('First')";
    FakeDataManager dataMgr = exampleDataManager(metadata);
    ProcessorPlan plan = getProcedurePlan(userUpdateStr, metadata);
    // Create expected results
    List[] expected = new List[] { // $NON-NLS-1$
    Arrays.asList(new Object[] { "5" }) };
    helpTestProcess(plan, expected, dataMgr, metadata);
}