@Override public List<Plugin> getAllPlugins() { return (List<Plugin>) transactionTemplate.execute((TransactionCallback) transactionStatus -> { Query query = sessionFactory.getCurrentSession().createQuery("FROM " + Plugin.class.getSimpleName()); query.setCacheable(true); return query.list(); }); }
public List<Cargo> findAll() { return getSession().createQuery("from Cargo").list(); }
/** * Call setEntity() on a cacheable query - see FORGE-265 */ public List listEventsOfOrganizer(Person organizer) { Session session = sessionFactory.getCurrentSession(); session.beginTransaction(); Query query = session.createQuery("from Event ev where ev.organizer = :organizer"); query.setCacheable(true); query.setEntity("organizer", organizer); List result = query.list(); session.getTransaction().commit(); return result; }
assertTrue( s.createFilter( master1.getIncoming(), "where this.id > 0 and this.name is not null" ) .list() .size() == 2 ); Iterator iter = master1.getIncoming().iterator(); int i=0; while ( iter.hasNext() ) { Master m = (Master) iter.next(); assertTrue( "outgoing", m.getOutgoing().size()==1 ); assertTrue( "outgoing", m.getOutgoing().contains(master1) );
Query q = s.createQuery("from Simple s"); List list = q.setCacheable(true).list(); assertTrue( list.size()==1 ); t.commit(); q = s.createQuery("from Simple s"); list = q.setCacheable(true).list(); assertTrue( list.size()==1 ); t.commit(); q = s.createQuery("from Simple s"); list = q.setCacheable(true).list(); assertTrue( list.size()==2 ); t.commit(); t = s.beginTransaction(); q = s.createQuery("from Simple s"); list = q.setCacheable(true).list(); assertTrue( list.size()==2 ); Iterator i = list.iterator(); while ( i.hasNext() ) s.delete( i.next() ); t.commit(); s.close();
Query query = s.createQuery("from HighestBid b where b.name = :name"); query.setParameter( "name", "widget", StringType.INSTANCE ); HighestBid highestBid = (HighestBid) query.list().iterator().next();
protected List getCountedStudentGradeRecords(final Long gradebookId, final String studentId) throws HibernateException { return getSessionFactory().getCurrentSession().createQuery( "select agr from AssignmentGradeRecord as agr, GradebookAssignment as asn where agr.studentId = :studentid and agr.gradableObject = asn and asn.removed is false and asn.notCounted is false and asn.gradebook.id = :gradebookid and asn.ungraded is false") .setString("studentid", studentId) .setLong("gradebookid", gradebookId) .list(); }
@Test public void test2ndLevelSubClass() throws Exception { Session s = openSession(); Transaction tx = s.beginTransaction(); A320b a = new A320b(); a.setJavaEmbeddedVersion( "Elephant" ); a.setNbrOfSeats( 300 ); s.persist( a ); tx.commit(); s.close(); s = openSession(); tx = s.beginTransaction(); Query q = s.createQuery( "from " + A320.class.getName() + " as a where a.javaEmbeddedVersion = :version" ); q.setString( "version", "Elephant" ); List a320s = q.list(); assertNotNull( a320s ); assertEquals( 1, a320s.size() ); tx.commit(); s.close(); }
Query q = s.createQuery("from Simple s where s.name=?"); q.setCacheable(true); q.setString(0, "Simple 1"); assertTrue( q.list().size()==1 ); assertTrue( q.list().size()==1 ); assertTrue( q.list().size()==1 ); q = s.createQuery("from Simple s where s.name=:name"); q.setCacheable(true); q.setString("name", "Simple 1"); assertTrue( q.list().size()==1 ); simple = (Simple) q.list().get(0); q.setString("name", "Simple 2"); assertTrue( q.list().size()==0 ); assertTrue( q.list().size()==0 ); simple.setName("Simple 2"); assertTrue( q.list().size()==1 ); assertTrue( q.list().size()==1 ); t.commit(); s.close(); q = s.createQuery("from Simple s where s.name=:name"); q.setString("name", "Simple 2"); q.setCacheable(true); assertTrue( q.list().size()==1 ); assertTrue( q.list().size()==1 ); t.commit(); s.close();
public Modifications getModificationsFor(final MaterialInstance materialInstance, final Pagination pagination) { String key = materialModificationsWithPaginationKey(materialInstance); String subKey = materialModificationsWithPaginationSubKey(pagination); Modifications modifications = (Modifications) goCache.get(key, subKey); if (modifications == null) { synchronized (key) { modifications = (Modifications) goCache.get(key, subKey); if (modifications == null) { List<Modification> modificationsList = (List<Modification>) getHibernateTemplate().execute((HibernateCallback) session -> { Query q = session.createQuery("FROM Modification WHERE materialId = ? ORDER BY id DESC"); q.setFirstResult(pagination.getOffset()); q.setMaxResults(pagination.getPageSize()); q.setLong(0, materialInstance.getId()); return q.list(); }); if (!modificationsList.isEmpty()) { modifications = new Modifications(modificationsList); goCache.put(key, subKey, modifications); } } } } return modifications; }
protected void txFragment(Session session) throws Exception { FlushMode flushMode = session.getFlushMode(); session.setFlushMode(FlushMode.COMMIT); StringBuffer sql = new StringBuffer(); sql.append("from ").append(DataProviderImpl.class.getName()).append(" as instance "); sql.append("where instance.id = :id"); Query query = session.createQuery(sql.toString()); if (id != null) query.setLong("id", id.longValue()); query.setCacheable(true); results.addAll(query.list()); session.setFlushMode(flushMode); }}.execute(); if (results.size() > 0) return (DataProviderImpl) results.get(0);
@SuppressWarnings("unchecked") public Set<PackageDependency> getPackageDependencies(String className) { final Query query = getSession().getNamedQuery("getPackageDependencies"); query.setCacheable(true); query.setString("className", className); final List<PackageDependency> results = query.list(); if (results != null) { return new HashSet<PackageDependency>(results); } return null; }
s.save( bar2 ); Query q = s.createQuery("select bar, b from Bar bar left join bar.baz baz left join baz.cascadingBars b where bar.name like 'Bar%'"); list = q.list(); if ( !(getDialect() instanceof SAPDBDialect) ) assertTrue( list.size()==2 ); q = s.createQuery("select bar, b from Bar bar left join bar.baz baz left join baz.cascadingBars b where ( bar.name in (:nameList) or bar.name in (:nameList) ) and bar.string = :stringVal"); HashSet nameList = new HashSet(); nameList.add( "bar" ); q.setParameterList( "nameList", nameList ); q.setParameter( "stringVal", "a string" ); list = q.list(); if ( !(getDialect() instanceof SAPDBDialect) ) assertTrue( list.size()==2 ); assertTrue( result != null ); q = s.createQuery("select bar, b from Bar bar left join bar.baz baz left join baz.cascadingBars b where bar.name like :name and b.name like :name"); q.setString( "name", "Bar%" ); list = q.list(); assertTrue( list.size()==1 ); q = s.createQuery("select bar from Bar bar order by ((bar.x - :valueX)*(bar.x - :valueX))"); q.setInteger( "valueX", bar.getX() + 1 ); list = q.list(); assertTrue( ((Bar) list.get( 0 )).getX() == bar.getX() ); q.setInteger( "valueX", bar2.getX() + 1 ); list = q.list(); assertTrue( ((Bar)list.get(0)).getX() == bar2.getX());
cOrig.getProxyOwner(), cOrig.getNonLazyOwner(), cOrig.getLazyDataPoints().iterator().next(), cOrig.getNonLazyJoinDataPoints().iterator().next(), cOrig.getNonLazySelectDataPoints().iterator().next() List list = s.createFilter( c.getLazyDataPoints(), "" ) .setMaxResults( 1 ) .list(); assertEquals( 1, list.size() ); assertFalse( s.isReadOnly( list.get( 0 ) ) ); list = s.createFilter( c.getNonLazyJoinDataPoints(), "" ) .setMaxResults( 1 ) .list(); assertEquals( 1, list.size() ); assertFalse( s.isReadOnly( list.get( 0 ) ) ); list = s.createFilter( c.getNonLazySelectDataPoints(), "" ) .setMaxResults( 1 ) .list(); assertEquals( 1, list.size() ); assertFalse( s.isReadOnly( list.get( 0 ) ) );
protected List getCountedStudentGradeRecords(Long gradebookId, String studentId) throws HibernateException { return getSessionFactory().getCurrentSession().createQuery( "select agr from AssignmentGradeRecord as agr, GradebookAssignment as asn where agr.studentId = :studentid and agr.gradableObject = asn and asn.removed is false and asn.notCounted is false and asn.gradebook.id = :gradebookid and asn.ungraded is false") .setString("studentid", studentId) .setLong("gradebookid", gradebookId) .list(); }
@SuppressWarnings("unchecked") public List<User> getAll() { return getSession().createQuery("from User").list(); }
/** * Call setEntity() on a cacheable query - see FORGE-265 */ public List listEventsOfOrganizer(Person organizer) { Session session = sessionFactory.getCurrentSession(); session.beginTransaction(); Query query = session.createQuery("from Event ev where ev.organizer = :organizer"); query.setCacheable(true); query.setEntity("organizer", organizer); List result = query.list(); session.getTransaction().commit(); return result; }
s = openSession(); tx = s.beginTransaction(); Query q = s.createQuery( "from Being h where h.identity = :name1 or h.identity = :name2" ); q.setString("name1", "marc"); q.setString("name2", "steve"); final List result = q.list(); assertEquals( 2, result.size() ); s.delete( result.get(0) );