Examples of ca.carleton.gcrc.dbSec.DbTableAccess.query()

Class ca.carleton.gcrc.dbSec.DbTableAccess

Examples of ca.carleton.gcrc.dbSec.DbTableAccess.query()

ca.carleton.gcrc.dbSec.DbTableAccess.query()
Queries the database for a set of rows matching the given selectors. Returns the list of columns if specified. Returns all available columns if no columns are specified. @param recordSelectors List of record selectors (WHERE) @param fieldSelectors List of column selectors (SELECT) or null to select all @param groupBySelectors Field selectors to group records (GROUP BY) or null for not grouping @param orderBySpecifiers Field selectors to order records (ORDER BY) or null for no order @param limit Limit on the number of records returned (LIMIT) or null if not used @param offset Start offset or returned records (OFFSET) or null if not used. Should be used onlywith limit and orderBySpecifiers @return @throws Exception

    List<FieldSelector> groupByColumnNames = getGroupByFromRequest(request);
    List<OrderSpecifier> orderBy = getOrderByList(request);
    Integer limit = getLimitFromRequest(request);
    Integer offset = getOffsetFromRequest(request);
    
    JSONArray queriedObjects = tableAccess.query(
        whereMap
        ,selectSpecifiers
        ,groupByColumnNames
        ,orderBy
        ,limit

View Full Code Here

          tableAccess = DbTableAccess.getAccess(dbSecurity, tableName, new DbUserAdaptor(user));
          tableAccessCache.put(tableName, tableAccess);
        }
        
        try {
          JSONArray queriedObjects = tableAccess.query(
              whereMap
              ,fieldSelectors
              ,groupByColumnNames
              ,orderSpecifiers
              ,limit

View Full Code Here

    List<FieldSelector> groupByColumnNames = getGroupByFromRequest(request);
    List<OrderSpecifier> orderBy = getOrderByList(request);
    Integer limit = getLimitFromRequest(request);
    Integer offset = getOffsetFromRequest(request);
    
    JSONArray queriedObjects = tableAccess.query(
        whereMap
        ,selectSpecifiers
        ,groupByColumnNames
        ,orderBy
        ,limit

View Full Code Here

          tableAccess = DbTableAccess.getAccess(dbSecurity, tableName, new DbUserAdaptor(user));
          tableAccessCache.put(tableName, tableAccess);
        }
        
        try {
          JSONArray queriedObjects = tableAccess.query(
              whereMap
              ,fieldSelectors
              ,groupByColumnNames
              ,orderSpecifiers
              ,limit

View Full Code Here

    List<FieldSelector> groupByColumnNames = getGroupByFromRequest(request);
    List<OrderSpecifier> orderBy = getOrderByList(request);
    Integer limit = getLimitFromRequest(request);
    Integer offset = getOffsetFromRequest(request);
    
    JSONArray queriedObjects = tableAccess.query(
        whereMap
        ,selectSpecifiers
        ,groupByColumnNames
        ,orderBy
        ,limit

View Full Code Here

          tableAccess = DbTableAccess.getAccess(dbSecurity, tableName, new DbUserAdaptor(user));
          tableAccessCache.put(tableName, tableAccess);
        }
        
        try {
          JSONArray queriedObjects = tableAccess.query(
              whereMap
              ,fieldSelectors
              ,groupByColumnNames
              ,orderSpecifiers
              ,limit

View Full Code Here

    List<FieldSelector> groupByColumnNames = getGroupByFromRequest(request);
    List<OrderSpecifier> orderBy = getOrderByList(request);
    Integer limit = getLimitFromRequest(request);
    Integer offset = getOffsetFromRequest(request);
    
    JSONArray queriedObjects = tableAccess.query(
        whereMap
        ,selectSpecifiers
        ,groupByColumnNames
        ,orderBy
        ,limit

View Full Code Here

          tableAccess = DbTableAccess.getAccess(dbSecurity, tableName, new DbUserAdaptor(user));
          tableAccessCache.put(tableName, tableAccess);
        }
        
        try {
          JSONArray queriedObjects = tableAccess.query(
              whereMap
              ,fieldSelectors
              ,groupByColumnNames
              ,orderSpecifiers
              ,limit

View Full Code Here

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.