@Test public void testInsert1() { Insert insert = new Insert(); insert.setGroup(new GroupSymbol("m.g1")); //$NON-NLS-1$ List<ElementSymbol> vars = new ArrayList<ElementSymbol>(); vars.add(new ElementSymbol("e1")); //$NON-NLS-1$ vars.add(new ElementSymbol("e2")); //$NON-NLS-1$ insert.setVariables(vars); List<Constant> values = new ArrayList<Constant>(); values.add(new Constant(new Integer(5))); values.add(new Constant("abc")); //$NON-NLS-1$ insert.setValues(values); helpTest(insert, "INSERT INTO m.g1 (e1, e2) VALUES (5, 'abc')"); //$NON-NLS-1$ }
insert.setValues(newValues);
insert.setValues(newValues);
@Test public void testMerge1() { Insert insert = new Insert(); insert.setUpsert(true); insert.setGroup(new GroupSymbol("m.g1")); //$NON-NLS-1$ List<ElementSymbol> vars = new ArrayList<ElementSymbol>(); vars.add(new ElementSymbol("e1")); //$NON-NLS-1$ vars.add(new ElementSymbol("e2")); //$NON-NLS-1$ insert.setVariables(vars); List<Constant> values = new ArrayList<Constant>(); values.add(new Constant(new Integer(5))); values.add(new Constant("abc")); //$NON-NLS-1$ insert.setValues(values); helpTest(insert, "UPSERT INTO m.g1 (e1, e2) VALUES (5, 'abc')"); //$NON-NLS-1$ }
insert.setValues(newValues);
public void testVisitInsert2() { Insert insert = new Insert(); insert.setGroup(exampleGroup(true, 0)); List values = new ArrayList(); values.add(new Constant("abc")); //$NON-NLS-1$ values.add(new Constant("abc")); //$NON-NLS-1$ insert.setValues(values); helpTest(insert, getSymbolMap()); }
public void testVisitInsert1() { Insert insert = new Insert(); insert.setGroup(exampleGroup(true, 0)); List vars = new ArrayList(); vars.add(exampleElement(true, 0)); vars.add(exampleElement(true, 1)); insert.setVariables(vars); List values = new ArrayList(); values.add(new Constant("abc")); //$NON-NLS-1$ values.add(new Constant("abc")); //$NON-NLS-1$ insert.setValues(values); helpTest(insert, getSymbolMap()); }
/** INSERT INTO m.g (a) VALUES (?) */ @Test public void testInsertWithReference() { Insert insert = new Insert(); insert.setGroup(new GroupSymbol("m.g")); //$NON-NLS-1$ List<ElementSymbol> vars = new ArrayList<ElementSymbol>(); vars.add(new ElementSymbol("a")); //$NON-NLS-1$ insert.setVariables(vars); List<Reference> values = new ArrayList<Reference>(); values.add(new Reference(0)); insert.setValues(values); helpTest("INSERT INTO m.g (a) VALUES (?)", //$NON-NLS-1$ "INSERT INTO m.g (a) VALUES (?)", //$NON-NLS-1$ insert); }
insert.setValues(evalExpressions); return insert;
insert.setValues(evalExpressions); return insert;
insert.setValues(evalExpressions); return insert;
@Test public void testInsertWithOption() { Insert insert = new Insert(); insert.setGroup(new GroupSymbol("m.g")); //$NON-NLS-1$ List<ElementSymbol> vars = new ArrayList<ElementSymbol>(); vars.add(new ElementSymbol("a")); //$NON-NLS-1$ insert.setVariables(vars); List<Reference> values = new ArrayList<Reference>(); values.add(new Reference(0)); insert.setValues(values); Option option = new Option(); option.setNoCache(true); insert.setOption(option); TestParser.helpTest("INSERT INTO m.g (a) VALUES (?) OPTION NOCACHE", //$NON-NLS-1$ "INSERT INTO m.g (a) VALUES (?) OPTION NOCACHE", //$NON-NLS-1$ insert); }
references.add(ref); insert.setValues(references);
newInsert.setValues(values); update.setCriteria((Criteria) Criteria.combineCriteria(crits).clone()); exists.setCriteria((Criteria) Criteria.combineCriteria(crits).clone());
newInsert.setValues(values); update.setCriteria((Criteria) Criteria.combineCriteria(crits).clone()); exists.setCriteria((Criteria) Criteria.combineCriteria(crits).clone());
newInsert.setValues(values); update.setCriteria((Criteria) Criteria.combineCriteria(crits).clone()); exists.setCriteria((Criteria) Criteria.combineCriteria(crits).clone());
values.setQueryExpression(insert.getQueryExpression()); } else { values.setValues(insert.getValues());
values.setQueryExpression(insert.getQueryExpression()); } else { values.setValues(insert.getValues());
values.setQueryExpression(insert.getQueryExpression()); } else { values.setValues(insert.getValues());