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.

        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

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.