Package org.olat.core.commons.persistence

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

198
199
200
201
202
203
204
205
206
207
208
209
210
    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
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
      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
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
     
      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
46
47
48
49
50
51
52
53
54
55
56
*/
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
58
59
60
61
62
63
64
65
66
67
68
   **/
  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
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
      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
46
47
48
49
50
51
52
53
54
55
56
*/
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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
  /** the logging object used in this class **/
  private static final OLog log_ = Tracing.createLoggerFor(HourOfDayStatisticManager.class);

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

    StatisticResult statisticResult = new StatisticResult(course, dbQuery.list());
    List<String> columnHeaders = statisticResult.getColumnHeaders();
    if (columnHeaders!=null && columnHeaders.size()>1) {
      try{
        int start = Integer.parseInt(columnHeaders.get(0));
        int end = Integer.parseInt(columnHeaders.get(columnHeaders.size()-1));
View Full Code Here
170
171
172
173
174
175
176
177
178
179
180
  public List<Message> getNewMessageInfo(Long forumKey, Date latestRead) {
    // FIXME:fj: lastModified has no index -> test performance with forum with
    // 200 messages
    String query = "select msg from org.olat.modules.fo.MessageImpl as msg" +
      " where msg.forum.key = :forumKey and msg.lastModified > :latestRead order by msg.lastModified desc";
    DBQuery dbquery = DBFactory.getInstance().createQuery(query);
    dbquery.setLong("forumKey", forumKey.longValue());
    dbquery.setTimestamp("latestRead", latestRead);
    dbquery.setCacheable(true);
    return dbquery.list();
  }
View Full Code Here
361
362
363
364
365
366
367
368
369
370
371
372
373
    boolean children = false;
    DB db = DBFactory.getInstance();
    Long message_id = m.getKey();
    String q = " select count(msg) from org.olat.modules.fo.MessageImpl msg where msg.parent = :input ";

    DBQuery query = db.createQuery(q);
    query.setLong("input", message_id.longValue());
    List result = query.list();
    int count = ((Long) result.get(0)).intValue();

    if (count > 0) {
      children = true;
    }
View Full Code Here
TOP

Related Classes of org.olat.core.commons.persistence.DBQuery

  • org.olat.admin.user.delete.service.UserDeletionManager
  • org.olat.basesecurity.PersistingManager
  • org.olat.catalog.CatalogManager
  • org.olat.commons.coordinate.cluster.lock.ClusterLockManager
  • org.olat.commons.lifecycle.LifeCycleManager
  • org.olat.core.commons.services.commentAndRating.impl.UserCommentsManagerImpl
  • org.olat.core.commons.services.commentAndRating.impl.UserRatingsManagerImpl
  • org.olat.core.logging.activity.UserActivityLoggerImpl
  • org.olat.course.assessment.NewCachePersistingAssessmentManager
  • org.olat.course.properties.PersistingCoursePropertyManager
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.