Examples with Update org.teiid.language.Update used on opensource projects

Example 11 with Update

use of org.teiid.language.Update in project teiid by teiid.

the class TestIckleConversionVisitor method helpUpdate.

private void helpUpdate(MetadataFactory mf, String query, String expected) throws Exception {
    InfinispanExecutionFactory ef = new InfinispanExecutionFactory();
    TransformationMetadata metadata = TestProtobufMetadataProcessor.getTransformationMetadata(mf, ef);
    TranslationUtility utility = new TranslationUtility(metadata);
    Command cmd = utility.parseCommand(query);
    InfinispanUpdateVisitor visitor = new InfinispanUpdateVisitor(new RuntimeMetadataImpl(metadata));
    visitor.append(cmd);
    String actual = null;
    if (cmd instanceof Update) {
        actual = visitor.getUpdateQuery();
    } else {
        actual = visitor.getDeleteQuery();
    }
    assertEquals(expected, actual);
}

Example 12 with Update

use of org.teiid.language.Update in project teiid by teiid.

the class TestODataIntegration method testInsertDifferentTypes.

@Test
public void testInsertDifferentTypes() throws Exception {
    AutoUpdateHardCodedExecutionFactory hc = new AutoUpdateHardCodedExecutionFactory();
    hc.addUpdate("INSERT INTO PostTable (intkey, intnum, stringkey, stringval, booleanval, " + "decimalval, timeval, dateval, timestampval) " + "VALUES (4, 4, '4', 'value_4', FALSE, -20.4, {t '00:00:04'}, " + "{d '2004-04-04'}, {ts '2004-01-01 00:00:04.0'})", new int[] { 1 });
    hc.addData("SELECT PostTable.intkey, PostTable.intnum, PostTable.stringkey, " + "PostTable.stringval, PostTable.booleanval, PostTable.decimalval, " + "PostTable.timeval, PostTable.dateval, PostTable.timestampval, " + "PostTable.clobval FROM PostTable " + "WHERE PostTable.intkey = 4", Arrays.asList(Arrays.asList(4, 4, "4", "value_4", false, new BigDecimal("-20.4"), new java.sql.Time(0), new java.sql.Date(0), new java.sql.Timestamp(0), null)));
    teiid.addTranslator("x11", hc);
    try {
        ModelMetaData mmd = new ModelMetaData();
        mmd.setName("m");
        mmd.addSourceMetadata("ddl", "CREATE foreign TABLE PostTable(\n" + "intkey integer PRIMARY KEY,\n" + "intnum integer,\n" + "stringkey varchar(20),\n" + "stringval varchar(20),\n" + "booleanval boolean,\n" + "  decimalval decimal(20, 10),\n" + "timeval time,\n" + "dateval date,\n" + "timestampval timestamp,\n" + "clobval clob) options (updatable true);");
        mmd.addSourceMapping("x11", "x11", null);
        teiid.deployVDB("northwind", mmd);
        localClient = getClient(teiid.getDriver(), "northwind", new Properties());
        String payload = "\n" + "<entry xmlns=\"http://www.w3.org/2005/Atom\" xmlns:d=\"http://docs.oasis-open.org/odata/ns/data\" " + "xmlns:georss=\"http://www.georss.org/georss\" " + "xmlns:gml=\"http://www.opengis.net/gml\" " + "xmlns:m=\"http://docs.oasis-open.org/odata/ns/metadata\">\n" + "   <category scheme=\"http://docs.oasis-open.org/odata/ns/scheme\" />\n" + "   <content type=\"application/xml\">\n" + "      <m:properties>\n" + "         <d:intkey m:type=\"Int32\">4</d:intkey>\n" + "         <d:intnum m:type=\"Int32\">4</d:intnum>\n" + "         <d:stringkey>4</d:stringkey>\n" + "         <d:stringval>value_4</d:stringval>\n" + "         <d:booleanval m:type=\"Boolean\">false</d:booleanval>\n" + "         <d:decimalval m:type=\"Double\">-20.4</d:decimalval>\n" + "         <d:timeval m:type=\"TimeOfDay\">00:00:04</d:timeval>\n" + "         <d:dateval m:type=\"Date\">2004-04-04</d:dateval>\n" + "         <d:timestampval m:type=\"DateTimeOffset\">2004-01-01T00:00:04Z</d:timestampval>\n" + "      </m:properties>\n" + "   </content>\n" + "</entry>";
        ContentResponse response = http.newRequest(baseURL + "/northwind/m/PostTable").method("POST").content(new StringContentProvider(payload)).header("Content-Type", "application/xml").header("Prefer", "return=minimal").send();
        assertEquals(204, response.getStatus());
        assertTrue(response.getHeaders().get("OData-EntityId"), response.getHeaders().get("OData-EntityId").endsWith("northwind/m/PostTable(4)"));
        String jsonPlayload = "{\n" + "  \"intkey\":4,\n" + "  \"intnum\":4,\n" + "  \"stringkey\":\"4\",\n" + "  \"stringval\":\"value_4\",\n" + "  \"booleanval\":false,\n" + "  \"decimalval\":-20.4,\n" + "  \"timeval\":\"00:00:04\",\n" + "  \"dateval\":\"2004-04-04\",\n" + "  \"timestampval\":\"2004-01-01T00:00:04Z\"" + "}";
        response = http.newRequest(baseURL + "/northwind/m/PostTable").method("POST").content(new StringContentProvider(jsonPlayload)).header("Content-Type", "application/json").header("Prefer", "return=representation").send();
        assertEquals(201, response.getStatus());
        assertEquals("{\"@odata.context\":\"$metadata#PostTable\"," + "\"intkey\":4," + "\"intnum\":4," + "\"stringkey\":\"4\"," + "\"stringval\":\"value_4\"," + "\"booleanval\":false," + "\"decimalval\":-20.4," + "\"timeval\":\"00:00:00\"," + "\"dateval\":\"1970-01-01\"," + "\"timestampval\":\"1970-01-01T00:00:00Z\"" + "}", response.getContentAsString());
        response = http.newRequest(baseURL + "/northwind/m/PostTable(4)/clobval").method("POST").content(new StringContentProvider("clob value")).send();
        assertEquals(405, response.getStatus());
        hc.validator = (org.teiid.language.Command c) -> {
            Update update = (Update) c;
            Literal value = (Literal) update.getChanges().get(0).getValue();
            Clob clob = (Clob) value.getValue();
            try {
                assertEquals("clob value", clob.getSubString(1, (int) clob.length()));
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        };
        response = http.newRequest(baseURL + "/northwind/m/PostTable(4)/clobval").method("PUT").content(new StringContentProvider("clob value")).send();
        assertEquals(204, response.getStatus());
        hc.validator = null;
        response = http.newRequest(baseURL + "/northwind/m/PostTable(4)/clobval").method("DELETE").send();
        assertEquals(204, response.getStatus());
    } finally {
        localClient = null;
        teiid.undeployVDB("northwind");
    }
}