Package fi.evident.dalesbred

Examples of fi.evident.dalesbred.SqlQuery

53
54
55
56
57
58
59
60
61
    }

    @Test
    public void placeholders() {
        QueryBuilder qb = new QueryBuilder("select * from document");
        SqlQuery query = qb.append(" where id in (").appendPlaceholders(4).append(")").addArguments(1,2,3).addArgument(4).build();

        assertEquals(query("select * from document where id in (?,?,?,?)", 1, 2, 3, 4), query);
    }
View Full Code Here
80
81
82
83
84
85
86
87
        assertEquals(QueryBuilder.PLACEHOLDER, new QueryBuilder().appendPlaceholders(1).build().getSql());
    }

    @Test
    public void confidentialArguments() {
        SqlQuery query = new QueryBuilder("select * from user where password=?").addConfidentialArgument("foo").build();
        assertEquals("select * from user where password=? [****]", query.toString());
    }
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
        assertEquals("select * from user where password=? [****]", query.toString());
    }

    @Test
    public void appendQuery() {
        SqlQuery query = query("select * from foo where bar = ? and baz = ?", 42, "foobar");

        QueryBuilder qb = new QueryBuilder();
        qb.append("select * from (").append(query).append(") where row < ?", 10);

        assertEquals(query("select * from (select * from foo where bar = ? and baz = ?) where row < ?", 42, "foobar", 10), qb.build());
View Full Code Here
57
58
59
60
61
62
63
64
65
66
        assertThat(query("select * from foo", 1, 2).hashCode(), is(query("select * from foo", 1, 2).hashCode()));
    }

    @Test
    public void accessors() {
        SqlQuery query = query("select * from foo", asList(1, 2, 3));

        assertEquals("select * from foo", query.getSql());
        assertEquals(asList(1, 2, 3), query.getArguments());
    }
View Full Code Here
65
66
67
68
69
70
71
72
73
        assertEquals(asList(1, 2, 3), query.getArguments());
    }

    @Test
    public void secretValuesAreNotShownInToString() {
        SqlQuery query = query("select * from foo where login=? and password=?", "foo", confidential("bar"));

        assertEquals("select * from foo where login=? and password=? [foo, ****]", query.toString());
    }
View Full Code Here
72
73
74
75
76
77
78
79
80
81
        assertEquals("select * from foo where login=? and password=? [foo, ****]", query.toString());
    }

    @Test
    public void namedQueryFromMap() {
        SqlQuery query = namedQuery("select * from foo where name = :name", Collections.singletonMap("name", "bar"));

        assertEquals("select * from foo where name = ?", query.getSql());
        assertEquals(singletonList("bar"), query.getArguments());
    }
View Full Code Here
80
81
82
83
84
85
86
87
88
89
        assertEquals(singletonList("bar"), query.getArguments());
    }

    @Test
    public void namedQueryFromBean() {
        SqlQuery query = namedQuery("select * from foo where name = :name", new ExampleNamed("bar"));

        assertEquals("select * from foo where name = ?", query.getSql());
        assertEquals(singletonList("bar"), query.getArguments());
    }
View Full Code Here
TOP

Related Classes of fi.evident.dalesbred.SqlQuery

  • fi.evident.dalesbred.query.QueryBuilderTest
  • fi.evident.dalesbred.SqlQueryTest
    • 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.