Package com.redspr.redquerybuilder.core.client.expression

Examples of com.redspr.redquerybuilder.core.client.expression.Comparison

89
90
91
92
93
94
95
96
97
98
99
                .getTableFilter(ref.getTable());

        TableFilter refTableFilter = session.createTableFilter(ref
                .getRefTable());

        Comparison joinCond = new Comparison(session, Operator.EQUAL,
                new ExpressionColumn(session, null, tableFilter.getAlias(), ref
                        .getColumns()[0].getName()), new ExpressionColumn(
                        session, null, refTableFilter.getAlias(), ref
                                .getRefColumns()[0].getName()));
        tableFilter.addJoin(refTableFilter, false, joinCond);
View Full Code Here
101
102
103
104
105
106
107
108
109
        vp.add(xcondition);
    }

    // XXX scope for testing
    public Comparison addFirstCondition() {
        Comparison c = new Comparison(session);
        addCondition(c);
        return c;
    }
View Full Code Here
35
36
37
38
39
40
41
42
43
public class GwtTestBasics extends AbstractTest {
    @Test
    public void testComparison() throws Exception {
        Parser p = new Parser(getSession());
        Comparison c = (Comparison) p.parseExpression("id = ?");
        ExpressionColumn left = (ExpressionColumn) c.getLeft();
        Parameter param = (Parameter) c.getRight();
    }
View Full Code Here
55
56
57
58
59
60
61
62
63
        assertEquals(1, s.getFilters().size());
        TableFilter tf = s.getFilters().get(0);
        assertTrue(tf != null);
        assertEquals("PERSON", tf.getTable().getName());

        Comparison c = (Comparison) s.getCondition();

        assertEquals("SELECT ID\nFROM PERSON\nWHERE (SEX = ?)", s.getSQL(new ArrayList()));
    }
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
        Parser p = new Parser(sess);

        Prepared prep = p.parseOnly("SELECT id FROM Person x1 WHERE x1.sex IS NULL");

        Select s = (Select) prep;
        Comparison c = (Comparison) s.getCondition();

        // test output
        List outArgs = new ArrayList();
        String outSql = s.getSQL(new ArrayList());
        assertEquals("SELECT ID\nFROM PERSON X1\nWHERE (X1.SEX IS NULL)", outSql);
View Full Code Here
128
129
130
131
132
133
134
135
136
137
138
        TableFilter tf = s.getFilters().get(0);
        assertTrue(tf != null);
        assertEquals("PERSON", tf.getTable().getName());
        assertEquals("X1", tf.getAlias());

        Comparison c = (Comparison) s.getCondition();

        // test output
        List outArgs = new ArrayList();
        String outSql = s.getSQL(outArgs);
        assertEquals("SELECT ID\nFROM PERSON X1\nWHERE (X1.SEX = ?)", outSql);
View Full Code Here
158
159
160
161
162
163
164
165
166
167
168
        TableFilter tf = s.getFilters().get(0);
        assertTrue(tf != null);
        assertEquals("PERSON", tf.getTable().getName());
        assertEquals("X1", tf.getAlias());

        Comparison c = (Comparison) s.getCondition();

        // test output
        List outArgs = new ArrayList();
        String outSql = s.getSQL(outArgs);
        assertEquals("SELECT ID\nFROM PERSON X1\nWHERE (X1.SEX = ?)", outSql);
View Full Code Here
190
191
192
193
194
195
196
197
198
199
200
        CommandBuilder cb = new CommandBuilder(s);
        cb.getSelect().updateTable(
                s.getDatabase().getMainSchema().findTableOrView("PERSON"));
        cb.getSelect().getSQL(new ArrayList());

        Comparison c = new Comparison(s);

        cb.getSelect().addCondition(c);
        cb.fireDirty();

        cb.getSelect().remove(c);
View Full Code Here
207
208
209
210
211
212
213
214
215
216
217
        CommandBuilder cb = new CommandBuilder(s);
        cb.getSelect().updateTable(
                s.getDatabase().getMainSchema().findTableOrView("Log"));
        cb.getSelect().getSQL(new ArrayList());

        Comparison c = new Comparison(s);

        cb.getSelect().addCondition(c);
        cb.fireDirty();

        cb.getSelect().remove(c);
View Full Code Here
225
226
227
228
229
230
231
232
233
234
235
        // RootPanel.get().add(cb);
        cb.getSelect().updateTable(
                s.getDatabase().getMainSchema().findTableOrView("PERSON"));
        cb.fireDirty();

        Comparison c = new Comparison(s);

        cb.getSelect().addCondition(c);
        cb.fireDirty();

        cb.getSelect().updateTable(
View Full Code Here
TOP

Related Classes of com.redspr.redquerybuilder.core.client.expression.Comparison

  • com.google.gwt.event.dom.client.ClickHandler
  • com.google.gwt.user.client.ui.Button
  • com.google.gwt.user.client.ui.HorizontalPanel
  • com.redspr.redquerybuilder.core.client.command.dml.Select
  • com.redspr.redquerybuilder.core.client.command.Parser
  • com.redspr.redquerybuilder.core.client.GwtTestBasics
  • com.redspr.redquerybuilder.core.client.table.JoinHelper
  • com.redspr.redquerybuilder.core.client.table.TableFilter
  • com.redspr.redquerybuilder.core.shared.meta.Cardinality
  • com.redspr.redquerybuilder.core.shared.meta.Column
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.