Examples of com.scooterframework.orm.activerecord.TableGateway

com.scooterframework.orm.activerecord.TableGateway

TableGateway class implements Table Data Gateway pattern. TableGateway handles access to all records of a table or view for a domain model: selects, updates, deletes.

There is no callback involved in methods in this class. To enable callbacks when deleting or updating a set of records, you can first retrieve them and then use the record instance's delete() or update() method which has callbacks.

@author (Fei) John Chen

            // count records
            Map<String, Object> inputs = ActiveRecordUtil.getGateway(modelClass).constructFindSQL((String)null, (Map<String, Object>)null, inputOptions);
            String findSQL = (String)inputs.get(ActiveRecordConstants.key_finder_sql);
            String selectCountSQL = "SELECT count(*) total FROM (" + findSQL + ") xxx";
            
            TableGateway tg = ActiveRecordUtil.getGateway(modelClass);
            Object total = null;
            Object cacheKey = null;
            if (tg.getModelCacheClient().useCache("countTotalRecords")) {
              cacheKey = tg.getModelCacheClient().getCacheKey("countTotalRecords", selectCountSQL);
              total = tg.getModelCacheClient().getCache().get(cacheKey);
              if (total != null) return Util.getSafeIntValue(total);
            }
            
            total = SqlServiceClient.retrieveObjectBySQL(selectCountSQL, inputs);
            
            if (tg.getModelCacheClient().useCache("countTotalRecords")) {
              tg.getModelCacheClient().getCache().put(cacheKey, total);
      }
            
            totalRecords = Util.getSafeIntValue(total);
        }
        catch (Exception ex) {

Examples of com.scooterframework.orm.activerecord.TableGateway

Related Classes of com.scooterframework.orm.activerecord.TableGateway