Examples of DBQuery

com.manatee.multiple.v2.db.DbQuery
@author 6806291@google.com (Gary Lee) @QQ 6806291 @date 2012-10-24
jodd.db.DbQuery
Encapsulates {@link Statement} and all its operations.
It may be:
- used in an un-managed way, created directly from connection;
- managed by {@link DbSession};
- managed by {@link jodd.db.DbThreadSession} i.e. {@link ThreadDbSessionHolder}.
Query life-cycle states:
- 1) created: statement == null, initialized == false
- 2) initialized: statement != null, initialized == true
- 3) closed: statement == null, initialized == true
org.apache.empire.db.DBQuery
This class can be used to wrap a query from a DBCommand and use it like a DBRowSet.
You may use this class for two purposes:
- In oder to define subqueries simply define a command object with the subquery and wrap it inside a DBQuery. Then in a second command object you can reference this Query to join with your other tables and views. In order to join other columns with your query use findQueryColumn(DBColumnExpr expr) to get the query column object for a given column expression in the original select clause.
- With a key supplied you can have an updateable query that will update several records at once.
org.olat.core.commons.persistence.DBQuery
A DBQuery is @author Andreas

Examples of org.olat.core.commons.persistence.DBQuery

    return INSTANCE;
  }
  
  LockImpl findLock(String asset) {
    Tracing.logInfo("findLock: "+asset+" START", getClass());
    DBQuery q = DBFactory.getInstance().createQuery(
        "select alock from org.olat.commons.coordinate.cluster.lock.LockImpl as alock inner join fetch alock.owner where alock.asset = :asset");
    q.setParameter("asset", asset);
    List res = q.list();
    if (res.size() == 0) {
      Tracing.logInfo("findLock: null END", getClass());
      return null; 
    } else {
      Tracing.logInfo("findLock: "+res.get(0)+" END", getClass());

View Full Code Here

Examples of org.olat.core.commons.persistence.DBQuery

  }
  
  @SuppressWarnings("unchecked")
  List<LockImpl> getAllLocks() {
    Tracing.logInfo("getAllLocks START", getClass());
    DBQuery q = DBFactory.getInstance().createQuery(
        "select alock from org.olat.commons.coordinate.cluster.lock.LockImpl as alock inner join fetch alock.owner");
    List<LockImpl> res = q.list();
    Tracing.logInfo("getAllLocks END. res.length:"+ (res==null ? "null" : res.size()), getClass());
    return res;
  }

View Full Code Here

Examples of org.olat.core.commons.persistence.DBQuery

    }
    if (end != null) {
      query = query.concat(" AND (v.creationDate < :createdBefore)");
    }


    DBQuery dbQuery = DBFactory.getInstance().createQuery(query);
    dbQuery.setBoolean("resAdminAction", resourceAdminAction);
    dbQuery.setString("resId", Long.toString(resourceableId));
    if (begin != null) {
      dbQuery.setDate("createdAfter", begin);
    }
    if (end != null) {
      Calendar cal = Calendar.getInstance();
      cal.setTime(end);
      cal.add(Calendar.DAY_OF_MONTH, 1);
      end = cal.getTime();
      dbQuery.setDate("createdBefore", end);
    }


    List queryResult = dbQuery.list();
    result.append(logLineConverter_.getCSVHeader());
    result.append(LINE_SEPARATOR);
    
    for (Object loggingObject : queryResult) {
      result.append(logLineConverter_.getCSVRow((LoggingObject)loggingObject, anonymize, resourceableId ));

View Full Code Here

Examples of org.olat.core.commons.persistence.DBQuery

    query.append(" and ( p.name = '").append(AssessmentManager.SCORE);
    query.append("' or p.name = '").append(AssessmentManager.PASSED);
    query.append("' )");


    DB db = DBFactory.getInstance();
    DBQuery dbq = db.createQuery(query.toString());
    ICourse course = CourseFactory.loadCourse(ores);
    dbq.setLong("resid", course.getResourceableId().longValue());
    dbq.setString("resname", course.getResourceableTypeName());


    List res = dbq.list();
    return res;
  }

View Full Code Here

Examples of org.olat.core.commons.persistence.DBQuery

      else if (roles.isGuestOnly()) query.append(RepositoryEntry.ACC_USERS_GUESTS);
      else query.append(RepositoryEntry.ACC_USERS);
      isFirstOfWhereClause = false;
    }
    
    DBQuery dbQuery = DBFactory.getInstance().createQuery(query.toString());
    if (var_author) {
      dbQuery.setString("author", author);
    }
    if (var_displayname) {
      dbQuery.setString("displayname", displayName);
    }
    if (var_desc) {
      dbQuery.setString("desc", desc);
    }
    if (var_resourcetypes) {
      dbQuery.setParameterList("resourcetypes", resourceTypes, Hibernate.STRING);
    }
    return dbQuery.list();
  }

View Full Code Here

Examples of org.olat.core.commons.persistence.DBQuery

      
      if (!isFirstOfWhereClause) query.append(" and ");
      query.append("v.access = 1 and user.properties['institutionalName']= :institution ");
      isFirstOfWhereClause = false;
      
      DBQuery dbQuery = DBFactory.getInstance().createQuery(query.toString());
      dbQuery.setString("institution", institution);
      if (var_author) {
        dbQuery.setString("author", author);
      }
      if (var_displayname) {
        dbQuery.setString("displayname", displayName);
      }
      if (var_desc) {
        dbQuery.setString("desc", desc);
      }
      if (var_resourcetypes) {
        dbQuery.setParameterList("resourcetypes", resourceTypes, Hibernate.STRING);
      }
      List result = dbQuery.list();
      result.addAll(runGenericANDQueryWithRolesRestriction(displayName, author, desc, resourceTypes, roles));
      return result;
    } else {
      return runGenericANDQueryWithRolesRestriction(displayName, author, desc, resourceTypes, roles);
    }

View Full Code Here

Examples of org.olat.core.commons.persistence.DBQuery

 */
public class HomeOrgStatisticManager implements IStatisticManager {


  @Override
  public StatisticResult generateStatisticResult(UserRequest ureq, ICourse course, long courseRepositoryEntryKey) {
    DBQuery dbQuery = DBFactory.getInstance().createQuery("select businessPath,homeOrg,value from org.olat.course.statistic.homeorg.HomeOrgStat sv "
        + "where sv.resId=:resId");
    dbQuery.setLong("resId", courseRepositoryEntryKey);


    return new StatisticResult(course, dbQuery.list());
  }

View Full Code Here

Examples of org.olat.core.commons.persistence.DBQuery

   **/
  private final SimpleDateFormat columnHeaderFormat_ = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");


  @Override
  public StatisticResult generateStatisticResult(UserRequest ureq, ICourse course, long courseRepositoryEntryKey) {
    DBQuery dbQuery = DBFactory.getInstance().createQuery("select businessPath,day,value from org.olat.course.statistic.daily.DailyStat sv "
        + "where sv.resId=:resId");
    dbQuery.setLong("resId", courseRepositoryEntryKey);


    return new StatisticResult(course, dbQuery.list());
  }

View Full Code Here

Examples of org.olat.core.commons.persistence.DBQuery

      dateClause.append(" and (day>=:fromDate) ");
    }
    if (toDate!=null) {
      dateClause.append(" and (day<=:toDate) ");
    }
    DBQuery dbQuery = DBFactory.getInstance().createQuery("select businessPath,day,value from org.olat.course.statistic.daily.DailyStat sv "
        + "where sv.resId=:resId "
        + dateClause);
    dbQuery.setLong("resId", courseRepositoryEntryKey);
    if (fromDate!=null) {
      dbQuery.setDate("fromDate", fromDate);
    }
    if (toDate!=null) {
      dbQuery.setDate("toDate", toDate);
    }
    
    StatisticResult statisticResult = new StatisticResult(course, dbQuery.list());
    fillGapsInColumnHeaders(statisticResult);
    return statisticResult;
  }

View Full Code Here

Examples of org.olat.core.commons.persistence.DBQuery

 */
public class StudyBranch3StatisticManager implements IStatisticManager {


  @Override
  public StatisticResult generateStatisticResult(UserRequest ureq, ICourse course, long courseRepositoryEntryKey) {
    DBQuery dbQuery = DBFactory.getInstance().createQuery("select businessPath,studyBranch3,value from org.olat.course.statistic.studybranch3.StudyBranch3Stat sv "
        + "where sv.resId=:resId");
    dbQuery.setLong("resId", courseRepositoryEntryKey);


    return new StatisticResult(course, dbQuery.list());
  }

View Full Code Here

0 1 2 3 4 5

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.