Examples of org.caffinitas.mapper.core.PersistenceSession.executeQuery()

Class org.caffinitas.mapper.core.PersistenceSession

Examples of org.caffinitas.mapper.core.PersistenceSession.executeQuery()

org.caffinitas.mapper.core.PersistenceSession.executeQuery()
Execute the given parameterized query. Convinience for {@link #executeQueryAsync(QueryBinder)}. {@link ReadFuture#getUninterruptibly()}. @param queryBinder parameterized query binder @param < T> entity (base) type @return result list


            // as named query


            queryBinder = session.createNamedQueryBinder(TpcInheritB.class, null, "byIds");
            queryBinder.setList("id", Arrays.asList(11, 12, 13, 21, 22, 23));
            result = session.executeQuery(queryBinder);


            Assert.assertNotNull(result);
            Assert.assertEquals(result.size(), 3);
        } finally {session.close();}
    }

View Full Code Here

            queryBinder.setInt("id1", 41);
            queryBinder.setInt("id2", 42);
            queryBinder.setInt("id3", 43);
            queryBinder.setInt("id4", 44);
            queryBinder.setInt("id5", 45);
            List<TpcInheritB> result = session.executeQuery(queryBinder);


            Assert.assertNotNull(result);
            Assert.assertTrue(result.isEmpty());


            // as named query

View Full Code Here

            queryBinder.setInt("id1", 41);
            queryBinder.setInt("id2", 42);
            queryBinder.setInt("id3", 43);
            queryBinder.setInt("id4", 44);
            queryBinder.setInt("id5", 45);
            result = session.executeQuery(queryBinder);


            Assert.assertNotNull(result);
            Assert.assertTrue(result.isEmpty());


            // insert data

View Full Code Here

            queryBinder.setInt("id1", 41);
            queryBinder.setInt("id2", 42);
            queryBinder.setInt("id3", 43);
            queryBinder.setInt("id4", 44);
            queryBinder.setInt("id5", 45);
            result = session.executeQuery(queryBinder);


            Assert.assertNotNull(result);
            Assert.assertEquals(result.size(), 2);


            // as named query

View Full Code Here

            queryBinder.setInt("id1", 41);
            queryBinder.setInt("id2", 42);
            queryBinder.setInt("id3", 43);
            queryBinder.setInt("id4", 44);
            queryBinder.setInt("id5", 45);
            result = session.executeQuery(queryBinder);


            Assert.assertNotNull(result);
            Assert.assertEquals(result.size(), 2);
        } finally {session.close();}
    }

View Full Code Here

    public void singleTable_root() throws Exception {
        PersistenceSession session = persistenceManager.createSession();
        try {
            QueryBinder<StBaseEntity> queryBinder = session.createQueryBinder(StBaseEntity.class, null, "id in :id", null);
            queryBinder.setList("id", Arrays.asList(1, 2, 3));
            List<StBaseEntity> result = session.executeQuery(queryBinder);


            Assert.assertNotNull(result);
            Assert.assertTrue(result.isEmpty());


            // as named query

View Full Code Here


            // as named query


            queryBinder = session.createNamedQueryBinder(StBaseEntity.class, null, "byIds");
            queryBinder.setList("id", Arrays.asList(1, 2, 3));
            result = session.executeQuery(queryBinder);


            Assert.assertNotNull(result);
            Assert.assertTrue(result.isEmpty());


            // insert data

View Full Code Here


            // again


            queryBinder = session.createQueryBinder(StBaseEntity.class, null, "id in :id", null);
            queryBinder.setList("id", Arrays.asList(11, 12, 13));
            result = session.executeQuery(queryBinder);


            Assert.assertNotNull(result);
            Assert.assertEquals(result.size(), 3);


            // as named query

View Full Code Here


            // as named query


            queryBinder = session.createNamedQueryBinder(StBaseEntity.class, null, "byIds");
            queryBinder.setList("id", Arrays.asList(11, 12, 13));
            result = session.executeQuery(queryBinder);


            Assert.assertNotNull(result);
            Assert.assertEquals(result.size(), 3);
        } finally {session.close();}
    }

View Full Code Here

    public void singleTable_atB() throws Exception {
        PersistenceSession session = persistenceManager.createSession();
        try {
            QueryBinder<StInheritB> queryBinder = session.createQueryBinder(StInheritB.class, null, "id in :id", null);
            queryBinder.setList("id", Arrays.asList(1, 2, 3));
            List<StInheritB> result = session.executeQuery(queryBinder);


            Assert.assertNotNull(result);
            Assert.assertTrue(result.isEmpty());


            // as named query

View Full Code Here

0 1 2

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.