Package com.google.appengine.api.datastore

Examples of com.google.appengine.api.datastore.PreparedQuery

503
504
505
506
507
508
509
510
511
512
513
      String courseId, String sectionId) {
    Query q = new Query(SECTION_KIND);
    q.addFilter(DEPARTMENT_ID_PROPERTY, FilterOperator.EQUAL, departmentId);
    q.addFilter(COURSE_ID_PROPERTY, FilterOperator.EQUAL, courseId);
    q.addFilter(SECTION_ID_PROPERTY, FilterOperator.EQUAL, sectionId);
    PreparedQuery pq = datastore.prepare(q);
    Entity e = pq.asSingleEntity();
    if (e == null)
      return null;
    return getSectionFromEntity(e);
  }
View Full Code Here
566
567
568
569
570
571
572
573
574
575
576
577
  public List<DepartmentInformationObject> queryDepartmentByPrefix(String prefix) {
    Query q = new Query(DEPARTMENT_KIND);
    q.addFilter(DEPARTMENT_ID_PROPERTY, FilterOperator.GREATER_THAN_OR_EQUAL, prefix);
    q.addSort(DEPARTMENT_ID_PROPERTY,SortDirection.ASCENDING);
    PreparedQuery pq = datastore.prepare(q);
    List<Entity> results = pq.asList(FetchOptions.Builder.withLimit(10));
    List<DepartmentInformationObject> diol = new ArrayList<DepartmentInformationObject>();
    for(Iterator<Entity> i = results.iterator(); i.hasNext();) {
      Entity e = i.next();
      String deptId = (String)e.getProperty(DEPARTMENT_ID_PROPERTY);
      if(deptId.startsWith(prefix))
View Full Code Here
584
585
586
587
588
589
590
591
592
593
594
595
    Query q = new Query(COURSE_KIND);
    q.addFilter(DEPARTMENT_ID_PROPERTY, FilterOperator.EQUAL, deptId);
    q.addFilter(COURSE_ID_PROPERTY, FilterOperator.GREATER_THAN_OR_EQUAL, prefix);
    q.addSort(DEPARTMENT_ID_PROPERTY, SortDirection.ASCENDING);
    q.addSort(COURSE_ID_PROPERTY, SortDirection.ASCENDING);
    PreparedQuery pq = datastore.prepare(q); 
    List<Entity> results = pq.asList(FetchOptions.Builder.withLimit(10));
    List<CourseInformationObject> ciol = new ArrayList<CourseInformationObject>();
    for(Iterator<Entity> i = results.iterator(); i.hasNext();) {
      Entity e = i.next();
      String courseId = (String)e.getProperty(COURSE_ID_PROPERTY);
      if(courseId.startsWith(prefix))
View Full Code Here
604
605
606
607
608
609
610
611
612
613
614
615
    q.addFilter(COURSE_ID_PROPERTY, FilterOperator.EQUAL, courseId);
    q.addFilter(SECTION_ID_PROPERTY, FilterOperator.GREATER_THAN_OR_EQUAL, prefix);
    q.addSort(DEPARTMENT_ID_PROPERTY, SortDirection.ASCENDING);
    q.addSort(COURSE_ID_PROPERTY, SortDirection.ASCENDING);
    q.addSort(SECTION_ID_PROPERTY, SortDirection.ASCENDING);
    PreparedQuery pq = datastore.prepare(q);
    List<Entity> results = pq.asList(FetchOptions.Builder.withLimit(10));
    List<SectionInformationObject> siol = new ArrayList<SectionInformationObject>();
    for(Iterator<Entity> i = results.iterator(); i.hasNext();){
      Entity e = i.next();
      String sectionId = (String)e.getProperty(SECTION_ID_PROPERTY);
      if(sectionId.startsWith(prefix))
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
98
99
 
  public static boolean verify(String key){
    Query q = new Query(ENTRY_KIND);
    q.addFilter(VERIFY_KEY_PROPERTY, FilterOperator.EQUAL, key);
    q.addFilter(ACTIVATED_PROPERTY, FilterOperator.EQUAL, false);
    PreparedQuery pq = datastore.prepare(q);
      try {
        Entity e = pq.asSingleEntity();
        if(e != null ) {
          e.setProperty(ACTIVATED_PROPERTY, true);
          datastore.put(e);
          return true;
        }
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
    q.setKeysOnly();
    q.addFilter(EMAIL_PROPERTY, FilterOperator.EQUAL, email);
    q.addFilter(DEPT_PROPERTY, FilterOperator.EQUAL, dept);
    q.addFilter(COURSE_PROPERTY, FilterOperator.EQUAL, course);
    q.addFilter(SECTION_PROPERTY, FilterOperator.EQUAL, section);
    PreparedQuery pq = datastore.prepare(q);
    Iterator<Entity> it = pq.asIterable().iterator();
    while(it.hasNext())
      datastore.delete(it.next().getKey());
   
  }
View Full Code Here
118
119
120
121
122
123
124
125
   
  }
 
  public static QueryResultIterator<Entity> getAll(){
    Query q = new Query(ENTRY_KIND);
    PreparedQuery pq = datastore.prepare(q);
    return pq.asQueryResultIterator();
  }
View Full Code Here
148
149
150
151
152
153
154
155
156
157
158
159
    }
    return false;
  }
 
  public boolean checkAccountExist(String email){
    PreparedQuery query=queryAccount(email);
    if(query.countEntities(FetchOptions.Builder.withDefaults())==0){
      return false;
    }
    return true;
   
  }
View Full Code Here
157
158
159
160
161
162
163
164
165
166
167
168
    return true;
   
  }
 
  public boolean activateAccount(String email, String authKey){
    PreparedQuery pq = queryAccount(email);
    Entity e = pq.asSingleEntity();
    if (e == null)
      return false;
    if(!e.getProperty(AUTHENTICATION_KEY_PROPERTY).equals(authKey))
      return false;
    if(e.getProperty(ACTIVATED_PROPERTY).equals(true))
View Full Code Here
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
  //Bi-directional subscription adding
  public boolean addSubscription(String from, String to){
    Query q_from = new Query(ACCOUNT_KIND);
    q_from.addFilter(ACCOUNT_ID_PROPERTY, FilterOperator.EQUAL, from);
    q_from.setKeysOnly();
    PreparedQuery pq_from = datastore.prepare(q_from);
    Entity e_from = pq_from.asSingleEntity();
   
    Query q_to = new Query(ACCOUNT_KIND);
    q_to.addFilter(ACCOUNT_ID_PROPERTY, FilterOperator.EQUAL, to);
    q_to.setKeysOnly();
    PreparedQuery pq_to = datastore.prepare(q_to);
    Entity e_to = pq_to.asSingleEntity();
   
    if(e_from == null || e_to == null)
      return false;
    Key k_from = e_from.getKey();
    Key k_to = e_to.getKey();
View Full Code Here
TOP

Related Classes of com.google.appengine.api.datastore.PreparedQuery

  • cl.loso.melon.server.util.Util
  • com.antonytrupe.server.battledisks.API
  • com.apps.datastore.AccountInformationDatastore
  • com.apps.datastore.NoSignupDatastore
  • com.apps.datastore.NotifierDatastore
  • com.apps.datastore.UBCCourseSpiderDatastore
  • com.divel.online.apps.News
  • com.dooapp.gaedo.google.datastore.DatastoreFinderServiceImpl
  • com.game.cloudymon.dal.EntityDAO
  • com.google.appengine.codelab.SessaoTests
    • 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.