Examples of net.floodlightcontroller.storage.IQuery

Package net.floodlightcontroller.storage

Examples of net.floodlightcontroller.storage.IQuery

net.floodlightcontroller.storage.IQuery
Representation of a database query. For SQL queries this maps to a prepared statement, so it will be more efficient than if you use the methods in IStorageSource that bypass the IQuery. For many NoSQL storage sources there won't be any performance improvement from keeping around the query. The query interface also supports parameterized queries (i.e. which maps to using ? values in a SQL query). The values of the parameters are set using the setParameter method. In the storage source API the parameters are named rather than positional. The format of the parameterized values in the query predicates is the parameter name bracketed with question marks (e.g. ?MinimumSalary? ). @author rob

        Object[][] expectedResults = {
                {"Lisa", "Jones"},
                {"Susan", "Jones"}
        };
        IPredicate predicate = new OperatorPredicate(PERSON_LAST_NAME, OperatorPredicate.Operator.EQ, "Jones");
        IQuery query = storageSource.createQuery(PERSON_TABLE_NAME, columnList, predicate, new RowOrdering(PERSON_SSN));
        IResultSet resultSet = storageSource.executeQuery(query);
        checkExpectedResults(resultSet, columnList, expectedResults);
    }

View Full Code Here

                {"John", "Smith", 40},
                {"Bjorn", "Borg", 55},
                {"John", "McEnroe", 53}
        };
        IPredicate predicate = new OperatorPredicate(PERSON_AGE, OperatorPredicate.Operator.GTE, "?MinimumAge?");
        IQuery query = storageSource.createQuery(PERSON_TABLE_NAME, columnList, predicate, new RowOrdering(PERSON_SSN));
        query.setParameter("MinimumAge", 40);
        IResultSet resultSet = storageSource.executeQuery(query);
        checkExpectedResults(resultSet, columnList, expectedResults);
    }

View Full Code Here

                {"John", "Smith", 40},
                {"Jim", "White", 24},
        };
        String[] columnList = {PERSON_FIRST_NAME,PERSON_LAST_NAME,PERSON_AGE};
        IPredicate predicate = new OperatorPredicate(PERSON_LAST_NAME, OperatorPredicate.Operator.GTE, "Sm");
        IQuery query = storageSource.createQuery(PERSON_TABLE_NAME, columnList, predicate, new RowOrdering(PERSON_SSN));
        Future<IResultSet> future = storageSource.executeQueryAsync(query);
        waitForFuture(future);
        try {
            IResultSet resultSet = future.get();
            checkExpectedResults(resultSet, columnList, expectedResults);

View Full Code Here

TOP

Related Classes of net.floodlightcontroller.storage.IQuery

net.floodlightcontroller.storage.tests.StorageTest

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.