query.declareImports("import java.lang.String"); query.setResult("tableName"); query.setResultClass(java.lang.String.class); if (maxTables >= 0) { query.setRange(0, maxTables);
/** * Gets partition names from the table via ORM (JDOQL) name filter. * @param dbName Database name. * @param tblName Table name. * @param partNames Partition names to get the objects for. * @return Resulting partitions. */ private List<Partition> getPartitionsViaOrmFilter(String catName, String dbName, String tblName, List<String> partNames) throws MetaException { if (partNames.isEmpty()) { return new ArrayList<>(); } ObjectPair<Query, Map<String, String>> queryWithParams = getPartQueryWithParams(catName, dbName, tblName, partNames); Query query = queryWithParams.getFirst(); query.setResultClass(MPartition.class); query.setClass(MPartition.class); query.setOrdering("partitionName ascending"); @SuppressWarnings("unchecked") List<MPartition> mparts = (List<MPartition>)query.executeWithMap(queryWithParams.getSecond()); List<Partition> partitions = convertToParts(catName, dbName, tblName, mparts); if (query != null) { query.closeAll(); } return partitions; }
@VisibleForTesting List<MPath> getMPaths() throws Exception { return tm.executeTransaction(pm -> { long currentSnapshotID = getCurrentAuthzPathsSnapshotID(pm); Query query = pm.newQuery("SQL", "SELECT p.PATH_NAME FROM AUTHZ_PATH p " + "JOIN AUTHZ_PATHS_MAPPING a ON a.AUTHZ_OBJ_ID = p.AUTHZ_OBJ_ID " + "WHERE a.AUTHZ_SNAPSHOT_ID = ?" ); query.setResultClass(MPath.class); return (List<MPath>) query.execute(currentSnapshotID); }); }
query.declareImports("import java.lang.String"); query.setResult("tableName"); query.setResultClass(java.lang.String.class); if (maxTables >= 0) { query.setRange(0, maxTables);
query.declareImports("import java.lang.String"); query.setResult("tableName"); query.setResultClass(java.lang.String.class); if (maxTables >= 0) { query.setRange(0, maxTables);
query.declareImports("import java.lang.String"); query.setResult("tableName"); query.setResultClass(java.lang.String.class); if (maxTables >= 0) { query.setRange(0, maxTables);
private Query createQuery(boolean forCount) { SQLSerializer serializer = new SQLSerializer(configuration); if (union != null) { serializer.serializeUnion(union, queryMixin.getMetadata(), unionAll); } else { serializer.serialize(queryMixin.getMetadata(), forCount); } // create Query if (logger.isDebugEnabled()) { logger.debug(serializer.toString()); } Query query = persistenceManager.newQuery("javax.jdo.query.SQL",serializer.toString()); orderedConstants = serializer.getConstants(); queries.add(query); if (!forCount) { List<? extends Expression<?>> projection = queryMixin.getMetadata().getProjection(); if (projection.get(0) instanceof FactoryExpression) { this.projection = (FactoryExpression<?>)projection.get(0); } } else { query.setResultClass(Long.class); } return query; }
query.declareImports("import java.lang.String"); query.setResult("tableName"); query.setResultClass(java.lang.String.class); if (maxTables >= 0) { query.setRange(0, maxTables);
private List<MPartition> getMPartitionsViaOrmFilter(String dbName, String tblName, List<String> partNames, Out<Query> out) { ObjectPair<Query, Map<String, String>> queryWithParams = getPartQueryWithParams(dbName, tblName, partNames); Query query = out.val = queryWithParams.getFirst(); query.setResultClass(MPartition.class); query.setClass(MPartition.class); query.setOrdering("partitionName ascending"); @SuppressWarnings("unchecked") List<MPartition> result = (List<MPartition>)query.executeWithMap(queryWithParams.getSecond()); return result; }
private List<MPartition> getMPartitionsViaOrmFilter(String dbName, String tblName, List<String> partNames, Out<Query> out) { ObjectPair<Query, Map<String, String>> queryWithParams = getPartQueryWithParams(dbName, tblName, partNames); Query query = out.val = queryWithParams.getFirst(); query.setResultClass(MPartition.class); query.setClass(MPartition.class); query.setOrdering("partitionName ascending"); @SuppressWarnings("unchecked") List<MPartition> result = (List<MPartition>)query.executeWithMap(queryWithParams.getSecond()); return result; }
/** * Gets partition names from the table via ORM (JDOQL) name filter. * @param dbName Database name. * @param tblName Table name. * @param partNames Partition names to get the objects for. * @return Resulting partitions. */ private List<Partition> getPartitionsViaOrmFilter(String catName, String dbName, String tblName, List<String> partNames) throws MetaException { if (partNames.isEmpty()) { return new ArrayList<>(); } ObjectPair<Query, Map<String, String>> queryWithParams = getPartQueryWithParams(catName, dbName, tblName, partNames); Query query = queryWithParams.getFirst(); query.setResultClass(MPartition.class); query.setClass(MPartition.class); query.setOrdering("partitionName ascending"); @SuppressWarnings("unchecked") List<MPartition> mparts = (List<MPartition>)query.executeWithMap(queryWithParams.getSecond()); List<Partition> partitions = convertToParts(catName, dbName, tblName, mparts); if (query != null) { query.closeAll(); } return partitions; }
public Map<Integer, ProjectGroupSummary> getProjectsSummary() { PersistenceManager pm = getPersistenceManager(); Transaction tx = pm.currentTransaction(); try { tx.begin(); Extent extent = pm.getExtent( Project.class ); Query query = pm.newQuery( extent ); query.setResult( "projectGroup.id as projectGroupId, state as projectState, count(state) as size" ); query.setResultClass( ProjectSummaryResult.class ); query.setGrouping( "projectGroup.id, state" ); List<ProjectSummaryResult> results = (List<ProjectSummaryResult>) query.execute(); Map<Integer, ProjectGroupSummary> summaries = processProjectGroupSummary( results ); tx.commit(); return summaries; } finally { rollback( tx ); } }
q.setResultClass(EmpWrapper.class); Collection<EmpWrapper> infos = (Collection<EmpWrapper>) q.execute (new Float (30000.)); Iterator<EmpWrapper> it = infos.iterator();
q.setResultClass(EmpInfo.class); Collection<EmpInfo> infos = (Collection<EmpInfo>) q.execute (new Float (30000.)); Iterator<EmpInfo> it = infos.iterator();
query.setResultClass(resultCls);
q.declareParameters ("String deptName"); q.setResult("name, salary, boss as reportsTo"); q.setResultClass(Info.class); Collection<Info> names = (Collection<Info>) q.execute("R&D"); Iterator<Info> it = names.iterator();
q.declareParameters ("String deptName"); q.setResult("new Info(name, salary, boss)"); q.setResultClass(Info.class); Collection<Info> names = (Collection<Info>) q.execute("R&D"); Iterator<Info> it = names.iterator();
/** * 14.10.14 Selection of a Single Field * This query returns a single field of a single Employee. */ @Test public void testQuery_14_10_14() { PersistenceManager pm = TestTools.openPM(); pm.currentTransaction().begin(); Query q = pm.newQuery (Employee.class, "name == empName"); q.declareParameters ("String empName"); q.setResult("salary"); q.setResultClass(Float.class); q.setUnique(true); Float salary = (Float) q.execute ("Michael"); // <query name="single"> // [!CDATA[ // select unique new Float(salary) // where dept.name == :deptName // ]] // </query> assertNotNull(salary); //assertEquals(40001., salary); assertTrue(Math.abs(40001. - salary) < 0.00001); TestTools.closePM(pm); }
query.setResultClass(resultCls);