Package org.olat.core.commons.persistence

Examples of org.olat.core.commons.persistence.DBQuery.list()

363
364
365
366
367
368
369
370
371
372
373
    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
50
51
52
53
54
55
56
57
58
59
60
  public StatisticResult generateStatisticResult(UserRequest ureq, ICourse course, long courseRepositoryEntryKey) {
    DBQuery dbQuery = DBFactory.getInstance().createQuery("select businessPath,studyLevel,value from org.olat.course.statistic.studylevel.StudyLevelStat sv "
        + "where sv.resId=:resId");
    dbQuery.setLong("resId", courseRepositoryEntryKey);

    return new StatisticResult(course, dbQuery.list());
  }
 
  @Override
  public ColumnDescriptor createColumnDescriptor(UserRequest ureq, int column, String headerId) {
    if (column==0) {
View Full Code Here
146
147
148
149
150
151
152
153
154
155
156
        dbQuery.setString("value"+i, value);
        i++;
      }
    }

    return dbQuery.list();
  }

  private void setAggregation(int a) {
    this.aggregation = a;
  }
View Full Code Here
125
126
127
128
129
130
131
132
133
134
135
        dbQuery.setString("value"+i, value);
        i++;
      }
    }

    count = ((Long)dbQuery.list().get(0)).intValue();

    setAggregation(count);
  }

  private void setAggregation(int a) {
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
  public StatisticResult generateStatisticResult(UserRequest ureq, ICourse course, long courseRepositoryEntryKey) {
    DBQuery dbQuery = DBFactory.getInstance().createQuery("select businessPath,week,value from org.olat.course.statistic.weekly.WeeklyStat sv "
        + "where sv.resId=:resId");
    dbQuery.setLong("resId", courseRepositoryEntryKey);

    return new StatisticResult(course, dbQuery.list());
  }
 
  @Override
  public ColumnDescriptor createColumnDescriptor(UserRequest ureq, int column, String headerId) {
    if (column==0) {
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
      dbQuery.setString("toDate", toDateStr);
    }
   
    log_.info("generateStatisticResult: Searching with params "+infoMsg.toString());
   
    StatisticResult statisticResult = new StatisticResult(course, dbQuery.list());
    fillGapsInColumnHeaders(statisticResult);
    return statisticResult;
  }

  private String getWeek(Date date) {
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
 
  private PLock findPLock(String asset) { 
    DBQuery q = DBFactory.getInstance().createQuery("select plock from org.olat.resource.lock.pessimistic.PLockImpl as plock where plock.asset = :asset");
    q.setParameter("asset", asset);
    q.setLockMode("plock", LockMode.UPGRADE);
    List res = q.list();
    if (res.size() == 0) {
      return null;
    } else {
      return (PLock) res.get(0);
    }
View Full Code Here
160
161
162
163
164
165
166
167
168
169
170
    query.setString("restypename", course.getResourceableTypeName());
    query.setLong("restypeid", course.getResourceableId().longValue());
    if (identity != null) {
      query.setEntity("id", identity);
    }
    List properties = query.list();
    return properties;   
  }
 
  /**
   * @see org.olat.course.assessment.AssessmentManager#preloadCache(org.olat.core.id.Identity)
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
    String q = "select area from org.olat.group.area.BGAreaImpl area " + " where area.name = :areaName"
        + " and area.groupContext = :context";
    DBQuery query = db.createQuery(q);
    query.setString("areaName", areaName);
    query.setEntity("context", groupContext);
    List areas = query.list();
    if (areas.size() == 0) {
      return null;
    } else if (areas.size() > 1) { throw new OLATRuntimeException(BGAreaManagerImpl.class, "findBGArea(" + areaName
        + ") returned more than one row for BGContext with key " + groupContext.getKey(), null); }
    return (BGAreaImpl) areas.get(0);
View Full Code Here
204
205
206
207
208
209
210
211
212
213
214
  public List findBusinessGroupsOfArea(BGArea area) {
    String q = " select grp from org.olat.group.BusinessGroupImpl as grp," + " org.olat.group.area.BGtoAreaRelationImpl as bgarel"
        + " where bgarel.businessGroup = grp" + " and bgarel.groupArea = :area";
    DBQuery query = DBFactory.getInstance().createQuery(q);
    query.setEntity("area", area);
    List result = query.list();
    return result;
  }

  /**
   * @see org.olat.group.area.BGAreaManager#findBusinessGroupsOfAreaAttendedBy(org.olat.core.id.Identity,
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.