use of org.teiid.translator.UpdateExecution in project teiid by teiid.
the class TestUpdates method testBulkUpdate.
@Test
public void testBulkUpdate() throws Exception {
CassandraExecutionFactory cef = new CassandraExecutionFactory();
String input = "insert into pm1.g1 (e1) values ('a')";
TranslationUtility util = FakeTranslationFactory.getInstance().getExampleTranslationUtility();
Command command = util.parseCommand(input);
Insert insert = (Insert) command;
Parameter p = new Parameter();
p.setType(String.class);
p.setValueIndex(0);
((ExpressionValueSource) insert.getValueSource()).getValues().set(0, p);
insert.setParameterValues(Arrays.asList(Arrays.asList("a"), Arrays.asList("b")).iterator());
ExecutionContext ec = Mockito.mock(ExecutionContext.class);
RuntimeMetadata rm = Mockito.mock(RuntimeMetadata.class);
CassandraConnection connection = Mockito.mock(CassandraConnection.class);
ResultSetFuture rsf = Mockito.mock(ResultSetFuture.class);
Mockito.stub(rsf.isDone()).toReturn(true);
Mockito.stub(connection.executeBatch(Mockito.eq("INSERT INTO g1 (e1) VALUES (?)"), (List<Object[]>) Mockito.anyObject())).toReturn(rsf);
UpdateExecution execution = (UpdateExecution) cef.createExecution(command, ec, rm, connection);
execution.execute();
assertArrayEquals(new int[] { 2 }, execution.getUpdateCounts());
}
use of org.teiid.translator.UpdateExecution in project teiid by teiid.
the class TestSimpleDBExecution method testDeleteAll.
@Test
public void testDeleteAll() throws Exception {
String query = "delete from item";
Command cmd = utility.parseCommand(query);
ExecutionContext context = Mockito.mock(ExecutionContext.class);
UpdateExecution exec = translator.createUpdateExecution(cmd, context, Mockito.mock(RuntimeMetadata.class), connection);
exec.execute();
Mockito.verify(connection).deleteDomain("item");
}
use of org.teiid.translator.UpdateExecution in project teiid by teiid.
the class TestSimpleDBExecution method testInsert.
@Test
public void testInsert() throws Exception {
String query = "insert into item (\"itemName()\", attribute, somedate, strarray) values ('one', 'value', {ts '2014-04-04 10:50:45'}, ('1', '2'))";
Command cmd = utility.parseCommand(query);
ExecutionContext context = Mockito.mock(ExecutionContext.class);
UpdateExecution exec = translator.createUpdateExecution(cmd, context, Mockito.mock(RuntimeMetadata.class), connection);
exec.execute();
SimpleDBInsertVisitor visitor = new SimpleDBInsertVisitor();
visitor.visitNode(cmd);
ArgumentCaptor<Iterator> argument = ArgumentCaptor.forClass(Iterator.class);
ArgumentCaptor<String> itemName = ArgumentCaptor.forClass(String.class);
ArgumentCaptor<ArrayList> columns = ArgumentCaptor.forClass(ArrayList.class);
Mockito.verify(connection).performInsert(itemName.capture(), columns.capture(), argument.capture());
assertEquals("item", itemName.getValue());
List<?> values = (List<?>) argument.getValue().next();
assertEquals("value", values.get(1));
assertEquals("2014-04-04 10:50:45.0", values.get(2).toString());
assertEquals("1,2,", arrayToStr((String[]) values.get(3)));
}
use of org.teiid.translator.UpdateExecution in project teiid by teiid.
the class ConnectorHost method readResultsFromExecution.
private List<List> readResultsFromExecution(Execution execution) throws TranslatorException {
List<List> results = new ArrayList<List>();
while (true) {
try {
if (execution instanceof ResultSetExecution) {
ResultSetExecution rs = (ResultSetExecution) execution;
List result = null;
while ((result = rs.next()) != null) {
results.add(result);
}
break;
}
UpdateExecution rs = (UpdateExecution) execution;
int[] result = rs.getUpdateCounts();
for (int i = 0; i < result.length; i++) {
results.add(Arrays.asList(result[i]));
}
break;
} catch (DataNotAvailableException e) {
if (e.getRetryDelay() > 0) {
try {
Thread.sleep(e.getRetryDelay());
} catch (InterruptedException e1) {
throw new TranslatorException(e1);
}
}
}
}
return results;
}
use of org.teiid.translator.UpdateExecution in project teiid by teiid.
the class TestMongoDBUpdateExecution method helpUpdate.
private DBCollection helpUpdate(String query, String[] expectedCollection, DBObject match_result, ArrayList<DBObject> results) throws TranslatorException {
Command cmd = this.utility.parseCommand(query);
ExecutionContext context = Mockito.mock(ExecutionContext.class);
CommandContext cc = Mockito.mock(CommandContext.class);
Mockito.stub(context.getCommandContext()).toReturn(cc);
MongoDBConnection connection = Mockito.mock(MongoDBConnection.class);
DB db = Mockito.mock(DB.class);
DBCollection dbCollection = Mockito.mock(DBCollection.class);
for (String collection : expectedCollection) {
Mockito.stub(db.getCollection(collection)).toReturn(dbCollection);
}
Mockito.stub(db.collectionExists(Mockito.anyString())).toReturn(true);
Mockito.stub(connection.getDatabase()).toReturn(db);
Mockito.stub(db.getCollectionFromString(Mockito.anyString())).toReturn(dbCollection);
Mockito.stub(dbCollection.findOne(Mockito.any(BasicDBObject.class))).toReturn(match_result);
WriteResult result = Mockito.mock(WriteResult.class);
Mockito.stub(result.getN()).toReturn(1);
Mockito.stub(dbCollection.insert(Mockito.any(BasicDBObject.class), Mockito.any(WriteConcern.class))).toReturn(result);
Mockito.stub(dbCollection.update(Mockito.any(BasicDBObject.class), Mockito.any(BasicDBObject.class), Mockito.eq(false), Mockito.eq(true), Mockito.any(WriteConcern.class))).toReturn(result);
if (results != null) {
Cursor out = new ResultsCursor(results);
for (DBObject obj : results) {
Mockito.stub(dbCollection.aggregate(Mockito.anyList(), Mockito.any(AggregationOptions.class))).toReturn(out);
Mockito.stub(dbCollection.aggregate(Mockito.anyList(), Mockito.any(AggregationOptions.class))).toReturn(out);
}
}
UpdateExecution execution = this.translator.createUpdateExecution(cmd, context, this.utility.createRuntimeMetadata(), connection);
execution.execute();
return dbCollection;
}
Aggregations