Examples of ca.carleton.gcrc.dbSec.DbTableAccess

ca.carleton.gcrc.dbSec.DbTableAccess
An instance of this class is used to control the operations that a user can perform on a database table. The four basic operations are implemented: query, insert, update, delete. A table schema specific to the user is derived from permissions given on the database. From this schema, all operations are verified before carried out.

  
  private void performGetSchema(HttpServletRequest request, HttpServletResponse response) throws Exception {
    User user = AuthenticationUtils.getUserFromRequest(request);
    String tableName = getTableNameFromRequest(request);
    
    DbTableAccess tableAccess = DbTableAccess.getAccess(dbSecurity, tableName, new DbUserAdaptor(user));
    JSONObject schema = tableAccess.getSchema();
    
    sendJsonResponse(response, schema);
  }

View Full Code Here

   */
  private void performQuery(HttpServletRequest request, HttpServletResponse response) throws Exception {
    User user = AuthenticationUtils.getUserFromRequest(request);
    String tableName = getTableNameFromRequest(request);
    
    DbTableAccess tableAccess = DbTableAccess.getAccess(dbSecurity, tableName, new DbUserAdaptor(user));
    
    List<RecordSelector> whereMap = getRecordSelectorsFromRequest(request);
    List<FieldSelector> selectSpecifiers = getFieldSelectorsFromRequest(request);
    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

        List<FieldSelector> groupByColumnNames = query.getGroupByColumnNames();
        List<OrderSpecifier> orderSpecifiers = query.getOrderBySpecifiers();
        Integer limit = query.getLimit();
        Integer offset = query.getOffset();
        
        DbTableAccess tableAccess = tableAccessCache.get(tableName);
        if( null == tableAccess ) {
          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


  private void performInsert(HttpServletRequest request, HttpServletResponse response) throws Exception {
    User user = AuthenticationUtils.getUserFromRequest(request);
    String tableName = getTableNameFromRequest(request);
    
    DbTableAccess tableAccess = DbTableAccess.getAccess(dbSecurity, tableName, new DbUserAdaptor(user));


    Map<String,String> setterMap = getSetParametersMap(request);


    JSONObject insertedObj = tableAccess.insert(setterMap);
    
    JSONObject obj = new JSONObject();
    obj.put("inserted", insertedObj);
    
    sendJsonResponse(response, obj);

View Full Code Here

  
  private void performUpdate(HttpServletRequest request, HttpServletResponse response) throws Exception {
    User user = AuthenticationUtils.getUserFromRequest(request);
    String tableName = getTableNameFromRequest(request);
    
    DbTableAccess tableAccess = DbTableAccess.getAccess(dbSecurity, tableName, new DbUserAdaptor(user));
    
    List<RecordSelector> whereMap = getRecordSelectorsFromRequest(request);
    Map<String,String> setterMap = getSetParametersMap(request);


    JSONArray updatedObjects = tableAccess.update(whereMap, setterMap);
    
    JSONObject obj = new JSONObject();
    obj.put("updated", updatedObjects);
    
    sendJsonResponse(response, obj);

View Full Code Here

  
  private void performDelete(HttpServletRequest request, HttpServletResponse response) throws Exception {
    User user = AuthenticationUtils.getUserFromRequest(request);
    String tableName = getTableNameFromRequest(request);
    
    DbTableAccess tableAccess = DbTableAccess.getAccess(dbSecurity, tableName, new DbUserAdaptor(user));
    
    List<RecordSelector> whereMap = getRecordSelectorsFromRequest(request);


    tableAccess.delete(whereMap);
    
    JSONObject obj = new JSONObject();
    
    sendJsonResponse(response, obj);
  }

View Full Code Here

  
  private void performGetSchema(HttpServletRequest request, HttpServletResponse response) throws Exception {
    User user = AuthenticationUtils.getUserFromRequest(request);
    String tableName = getTableNameFromRequest(request);
    
    DbTableAccess tableAccess = DbTableAccess.getAccess(dbSecurity, tableName, new DbUserAdaptor(user));
    JSONObject schema = tableAccess.getSchema();
    
    sendJsonResponse(response, schema);
  }

View Full Code Here

   */
  private void performQuery(HttpServletRequest request, HttpServletResponse response) throws Exception {
    User user = AuthenticationUtils.getUserFromRequest(request);
    String tableName = getTableNameFromRequest(request);
    
    DbTableAccess tableAccess = DbTableAccess.getAccess(dbSecurity, tableName, new DbUserAdaptor(user));
    
    List<RecordSelector> whereMap = getRecordSelectorsFromRequest(request);
    List<FieldSelector> selectSpecifiers = getFieldSelectorsFromRequest(request);
    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

        List<FieldSelector> groupByColumnNames = query.getGroupByColumnNames();
        List<OrderSpecifier> orderSpecifiers = query.getOrderBySpecifiers();
        Integer limit = query.getLimit();
        Integer offset = query.getOffset();
        
        DbTableAccess tableAccess = tableAccessCache.get(tableName);
        if( null == tableAccess ) {
          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


  private void performInsert(HttpServletRequest request, HttpServletResponse response) throws Exception {
    User user = AuthenticationUtils.getUserFromRequest(request);
    String tableName = getTableNameFromRequest(request);
    
    DbTableAccess tableAccess = DbTableAccess.getAccess(dbSecurity, tableName, new DbUserAdaptor(user));


    Map<String,String> setterMap = getSetParametersMap(request);


    JSONObject insertedObj = tableAccess.insert(setterMap);
    
    JSONObject obj = new JSONObject();
    obj.put("inserted", insertedObj);
    
    sendJsonResponse(response, obj);

View Full Code Here

0 1 2

TOP

Related Classes of ca.carleton.gcrc.dbSec.DbTableAccess

ca.carleton.gcrc.dbSec.impl.ColumnDataComparator

ca.carleton.gcrc.dbSec.impl.ExpressionConstantImpl

ca.carleton.gcrc.dbSec.impl.RecordSelectorComparator

ca.carleton.gcrc.dbSec.impl.VariablesImpl

ca.carleton.gcrc.dbWeb.DbWebServlet

net.sf.json.JSONArray

org.json.JSONArray

java.sql.Connection

java.sql.PreparedStatement

java.io.StringWriter

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.