List of generateSelectQuery() Examples

Examples of generateSelectQuery()

com.vaadin.data.util.sqlcontainer.query.generator.DefaultSQLGenerator.generateSelectQuery()
com.vaadin.data.util.sqlcontainer.query.generator.MSSQLGenerator.generateSelectQuery()
com.vaadin.data.util.sqlcontainer.query.generator.OracleGenerator.generateSelectQuery()
com.vaadin.data.util.sqlcontainer.query.generator.SQLGenerator.generateSelectQuery()
Generates a SELECT query with the provided parameters. Uses default filtering mode (INCLUSIVE). @param tableName Name of the table queried @param filters The filters, converted into a WHERE clause @param orderBys The the ordering conditions, converted into an ORDER BY clause @param offset The offset of the first row to be included @param pagelength The number of rows to be returned when the query executes @param toSelect String containing what to select, e.g. "*", "COUNT(*)" @return StatementHelper instance containing the query string for aPreparedStatement and the values required for the parameters

Examples of com.vaadin.data.util.sqlcontainer.query.generator.DefaultSQLGenerator.generateSelectQuery()

    }


    @Test
    public void generateSelectQuery_basicQuery_shouldSucceed() {
        SQLGenerator sg = new DefaultSQLGenerator();
        StatementHelper sh = sg.generateSelectQuery("TABLE", null, null, 0, 0,
                null);
        Assert.assertEquals(sh.getQueryString(), "SELECT * FROM TABLE");
    }


    @Test

View Full Code Here

Examples of com.vaadin.data.util.sqlcontainer.query.generator.DefaultSQLGenerator.generateSelectQuery()

    }


    @Test
    public void generateSelectQuery_pagingAndColumnsSet_shouldSucceed() {
        SQLGenerator sg = new DefaultSQLGenerator();
        StatementHelper sh = sg.generateSelectQuery("TABLE", null, null, 4, 8,
                "COL1, COL2, COL3");
        Assert.assertEquals(sh.getQueryString(),
                "SELECT COL1, COL2, COL3 FROM TABLE LIMIT 8 OFFSET 4");
    }

View Full Code Here

Examples of com.vaadin.data.util.sqlcontainer.query.generator.DefaultSQLGenerator.generateSelectQuery()

    public void generateSelectQuery_filtersAndOrderingSet_shouldSucceed() {
        SQLGenerator sg = new DefaultSQLGenerator();
        List<com.vaadin.data.Container.Filter> f = new ArrayList<Filter>();
        f.add(new Like("name", "%lle"));
        List<OrderBy> ob = Arrays.asList(new OrderBy("name", true));
        StatementHelper sh = sg.generateSelectQuery("TABLE", f, ob, 0, 0, null);
        Assert.assertEquals(sh.getQueryString(),
                "SELECT * FROM TABLE WHERE \"name\" LIKE ? ORDER BY \"name\" ASC");
    }


    @Test

View Full Code Here

Examples of com.vaadin.data.util.sqlcontainer.query.generator.DefaultSQLGenerator.generateSelectQuery()

    public void generateSelectQuery_filtersAndOrderingSet_exclusiveFilteringMode_shouldSucceed() {
        SQLGenerator sg = new DefaultSQLGenerator();
        List<Filter> f = new ArrayList<Filter>();
        f.add(new Or(new Like("name", "%lle"), new Like("name", "vi%")));
        List<OrderBy> ob = Arrays.asList(new OrderBy("name", true));
        StatementHelper sh = sg.generateSelectQuery("TABLE", f, ob, 0, 0, null);
        // TODO
        Assert.assertEquals(sh.getQueryString(),
                "SELECT * FROM TABLE WHERE (\"name\" LIKE ? "
                        + "OR \"name\" LIKE ?) ORDER BY \"name\" ASC");
    }

View Full Code Here

Examples of com.vaadin.data.util.sqlcontainer.query.generator.MSSQLGenerator.generateSelectQuery()

            throws SQLException {
        SQLGenerator sg = new MSSQLGenerator();
        List<Filter> f = new ArrayList<Filter>();
        f.add(new Like("name", "%lle"));
        List<OrderBy> ob = Arrays.asList(new OrderBy("name", true));
        StatementHelper sh = sg.generateSelectQuery("TABLE", f, ob, 4, 8,
                "NAME, ID");
        Assert.assertEquals(sh.getQueryString(),
                "SELECT * FROM (SELECT row_number() OVER "
                        + "( ORDER BY \"name\" ASC) AS rownum, NAME, ID "
                        + "FROM TABLE WHERE \"name\" LIKE ?) "

View Full Code Here

Examples of com.vaadin.data.util.sqlcontainer.query.generator.MSSQLGenerator.generateSelectQuery()

            throws SQLException {
        SQLGenerator sg = new MSSQLGenerator();
        List<Filter> f = new ArrayList<Filter>();
        f.add(new Or(new Like("name", "%lle"), new Like("name", "vi%")));
        List<OrderBy> ob = Arrays.asList(new OrderBy("name", true));
        StatementHelper sh = sg.generateSelectQuery("TABLE", f, ob, 4, 8,
                "NAME, ID");
        Assert.assertEquals(sh.getQueryString(),
                "SELECT * FROM (SELECT row_number() OVER "
                        + "( ORDER BY \"name\" ASC) AS rownum, NAME, ID "
                        + "FROM TABLE WHERE (\"name\" LIKE ? "

View Full Code Here

Examples of com.vaadin.data.util.sqlcontainer.query.generator.MSSQLGenerator.generateSelectQuery()

                        if (SQLTestsConstants.db == DB.MSSQL) {
                            SQLGenerator gen = new MSSQLGenerator();
                            if (orderBys == null || orderBys.isEmpty()) {
                                List<OrderBy> ob = new ArrayList<OrderBy>();
                                ob.add(new OrderBy("ID", true));
                                return gen.generateSelectQuery("people", null,
                                        ob, offset, limit, null)
                                        .getQueryString();
                            } else {
                                return gen.generateSelectQuery("people", null,
                                        orderBys, offset, limit, null)

View Full Code Here

Examples of com.vaadin.data.util.sqlcontainer.query.generator.MSSQLGenerator.generateSelectQuery()

                                ob.add(new OrderBy("ID", true));
                                return gen.generateSelectQuery("people", null,
                                        ob, offset, limit, null)
                                        .getQueryString();
                            } else {
                                return gen.generateSelectQuery("people", null,
                                        orderBys, offset, limit, null)
                                        .getQueryString();
                            }
                        } else if (SQLTestsConstants.db == DB.ORACLE) {
                            SQLGenerator gen = new OracleGenerator();

View Full Code Here

Examples of com.vaadin.data.util.sqlcontainer.query.generator.MSSQLGenerator.generateSelectQuery()

                        } else if (SQLTestsConstants.db == DB.ORACLE) {
                            SQLGenerator gen = new OracleGenerator();
                            if (orderBys == null || orderBys.isEmpty()) {
                                List<OrderBy> ob = new ArrayList<OrderBy>();
                                ob.add(new OrderBy("ID", true));
                                return gen.generateSelectQuery("people", null,
                                        ob, offset, limit, null)
                                        .getQueryString();
                            } else {
                                return gen.generateSelectQuery("people", null,
                                        orderBys, offset, limit, null)

View Full Code Here

Examples of com.vaadin.data.util.sqlcontainer.query.generator.MSSQLGenerator.generateSelectQuery()

                                ob.add(new OrderBy("ID", true));
                                return gen.generateSelectQuery("people", null,
                                        ob, offset, limit, null)
                                        .getQueryString();
                            } else {
                                return gen.generateSelectQuery("people", null,
                                        orderBys, offset, limit, null)
                                        .getQueryString();
                            }
                        } else {
                            StringBuffer query = new StringBuffer(

View Full Code Here

0 1 2 3 4

TOP

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.