Package com.redspr.redquerybuilder.core.client.command

Examples of com.redspr.redquerybuilder.core.client.command.Prepared

43
44
45
46
47
48
49
50
51
52
53
    }

    @Test
    public void testSimpleSelect() throws Exception {
        Parser p = new Parser(getSession());
        Prepared prep = p.parseOnly("SELECT id FROM Person WHERE sex = ?");

        Select s = (Select) prep;
        assertTrue(s != null);
        ExpressionColumn ec = (ExpressionColumn) s.getExpressions().get(0);
        assertEquals("ID", ec.getSQL(new ArrayList()));
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
    }

    @Test
    public void testParseLike() throws Exception {
        Parser p = new Parser(getSession());
        Prepared prep = p.parseOnly("SELECT id FROM Person WHERE owner LIKE ?");

        Select s = (Select) prep;

        assertEquals("SELECT ID\nFROM PERSON\nWHERE (OWNER LIKE ?)", s.getSQL(new ArrayList()));
    }
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
    }

    @Test
    public void testParseCustom() throws Exception {
        Parser p = new Parser(getSession());
        Prepared prep = p.parseOnly("SELECT id FROM Person WHERE sex CUSTOM_OP ?");

        Select s = (Select) prep;

        assertEquals("SELECT ID\nFROM PERSON\nWHERE (SEX CUSTOM_OP ?)", s.getSQL(new ArrayList()));
    }
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
    @Test
    public void testIsNull() throws Exception {
        Session sess = getSession();
        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
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
    public void testParseAlias() throws Exception {
        Session sess = getSession();
        Parser p = new Parser(sess);

        sess.getValueRegistry().add("foo");
        Prepared prep = p.parseOnly("SELECT id FROM Person x1 WHERE x1.sex = ?");

        Select s = (Select) prep;
        assertTrue(s != null);
        ExpressionColumn ec = (ExpressionColumn) s.getExpressions().get(0);
View Full Code Here
144
145
146
147
148
149
150
151
152
153
154
    public void testParseAliasWithBrackets() throws Exception {
        Session sess = getSession();
        Parser p = new Parser(sess);

        sess.getValueRegistry().add("foo");
        Prepared prep = p.parseOnly("SELECT id FROM Person x1 WHERE (x1.sex = ?)");

        Select s = (Select) prep;
        assertTrue(s != null);
        ExpressionColumn ec = (ExpressionColumn) s.getExpressions().get(0);
View Full Code Here
368
369
370
371
372
373
374
375
376
377
378
    public void testParseJoin() throws Exception {
        Session sess = getSession();
        Parser p = new Parser(sess);

        sess.getValueRegistry().add("foo");
        Prepared prep = p.parseOnly("SELECT x1.id FROM \"Log\" x1 JOIN \"PERSON\" x0 ON x1.\"parent\" = x0.\"id\" WHERE (x0.\"owner\" = ?)");

        Select s = (Select) prep;

        assertEquals(2, s.getFilters().size());
View Full Code Here
450
451
452
453
454
455
456
457
458
459
460
            + " LEFT JOIN Log x2 ON x2.parent=x0.id"
            + " LEFT JOIN Log x4 ON x4.parent=x0.id"
            + " LEFT JOIN Person x3 ON x2.parent=x3.id"
            + " WHERE x1.id=?";

        Prepared prep = p.parseOnly(sql0);

        Select s = (Select) prep;

        s.garbageCollectFilters();
View Full Code Here
513
514
515
516
517
518
519
520
521
522
523
    public void testParseAndGenerateEmptyIn() throws Exception {
        Parser p = new Parser(getSession());
        String sql0 = "SELECT x.id FROM Person x"
            + " WHERE x.category IN (NULL)";

        Prepared prep = p.parseOnly(sql0);

        Select s = (Select) prep;

        // collect initial non-sense...
        String sql1 = "SELECT X.ID\nFROM PERSON X\n"
View Full Code Here
TOP

Related Classes of com.redspr.redquerybuilder.core.client.command.Prepared

  • com.redspr.redquerybuilder.core.client.GwtTestBasics
    • 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.