String queryFilterString = makeQueryFilterString(catName, dbName, null, filter, params); query = pm.newQuery(MTable.class); query.declareImports("import java.lang.String"); query.setResult("tableName"); query.setResultClass(java.lang.String.class);
public List<BuildResult> getAllBuildsForAProjectByDate( int projectId ) { PersistenceManager pm = getPersistenceManager(); Transaction tx = pm.currentTransaction(); try { tx.begin(); Query query = pm.newQuery( "SELECT FROM " + BuildResult.class.getName() + " WHERE project.id == projectId PARAMETERS int projectId ORDER BY endTime DESC" ); query.declareImports( "import java.lang.Integer" ); query.declareParameters( "Integer projectId" ); List result = (List) query.execute( new Integer( projectId ) ); result = (List) pm.detachCopyAll( result ); tx.commit(); return result; } finally { rollback( tx ); } }
public LocalRepository getLocalRepositoryByName( String name ) throws ContinuumStoreException { PersistenceManager pm = getPersistenceManager(); Transaction tx = pm.currentTransaction(); try { tx.begin(); Extent extent = pm.getExtent( LocalRepository.class, true ); Query query = pm.newQuery( extent ); query.declareImports( "import java.lang.String" ); query.declareParameters( "String name" ); query.setFilter( "this.name == name" ); Collection result = (Collection) query.execute( name ); if ( result.size() == 0 ) { tx.commit(); return null; } Object object = pm.detachCopy( result.iterator().next() ); tx.commit(); return (LocalRepository) object; } finally { rollback( tx ); } }
public Profile getProfileByName( String profileName ) throws ContinuumStoreException { PersistenceManager pm = getPersistenceManager(); Transaction tx = pm.currentTransaction(); try { tx.begin(); Extent extent = pm.getExtent( Profile.class, true ); Query query = pm.newQuery( extent ); query.declareImports( "import java.lang.String" ); query.declareParameters( "String name" ); query.setFilter( "this.name == name" ); Collection result = (Collection) query.execute( profileName ); if ( result.size() == 0 ) { tx.commit(); return null; } Object object = pm.detachCopy( result.iterator().next() ); tx.commit(); return (Profile) object; } finally { rollback( tx ); } }
public Schedule getScheduleByName( String name ) throws ContinuumStoreException { PersistenceManager pm = getPersistenceManager(); Transaction tx = pm.currentTransaction(); try { tx.begin(); Extent extent = pm.getExtent( Schedule.class, true ); Query query = pm.newQuery( extent ); query.declareImports( "import java.lang.String" ); query.declareParameters( "String name" ); query.setFilter( "this.name == name" ); Collection result = (Collection) query.execute( name ); if ( result.size() == 0 ) { tx.commit(); return null; } Object object = pm.detachCopy( result.iterator().next() ); tx.commit(); return (Schedule) object; } finally { rollback( tx ); } }
query.declareImports( "import java.lang.String" );
public List<BuildResult> getAllBuildsForAProjectByDate( int projectId ) { PersistenceManager pm = getPersistenceManager(); Transaction tx = pm.currentTransaction(); try { tx.begin(); Query query = pm.newQuery( "SELECT FROM " + BuildResult.class.getName() + " WHERE project.id == projectId PARAMETERS int projectId ORDER BY endTime DESC" ); query.declareImports( "import java.lang.Integer" ); query.declareParameters( "Integer projectId" ); List<BuildResult> result = (List<BuildResult>) query.execute( projectId ); result = (List<BuildResult>) pm.detachCopyAll( result ); tx.commit(); return result; } finally { rollback( tx ); } }
public BuildDefinitionTemplate getContinuumBuildDefinitionTemplateWithType( String type ) throws ContinuumStoreException { PersistenceManager pm = getPersistenceManager(); Transaction tx = pm.currentTransaction(); try { tx.begin(); Extent extent = pm.getExtent( BuildDefinitionTemplate.class, true ); Query query = pm.newQuery( extent ); query.declareImports( "import java.lang.String" ); query.declareParameters( "String type" ); query.setFilter( "continuumDefault == true && this.type == type" ); pm.getFetchPlan().addGroup( BUILD_TEMPLATE_BUILD_DEFINITIONS ); List result = (List) query.execute( type ); if ( result == null || result.isEmpty() ) { return null; } return (BuildDefinitionTemplate) pm.detachCopy( result.get( 0 ) ); } finally { tx.commit(); rollback( tx ); } }
public BuildDefinitionTemplate getContinuumBuildDefinitionTemplateWithType( String type ) throws ContinuumStoreException { PersistenceManager pm = getPersistenceManager(); Transaction tx = pm.currentTransaction(); try { tx.begin(); Extent extent = pm.getExtent( BuildDefinitionTemplate.class, true ); Query query = pm.newQuery( extent ); query.declareImports( "import java.lang.String" ); query.declareParameters( "String type" ); query.setFilter( "continuumDefault == true && this.type == type" ); pm.getFetchPlan().addGroup( BUILD_TEMPLATE_BUILD_DEFINITIONS ); List result = (List) query.execute( type ); if ( result == null || result.isEmpty() ) { return null; } return (BuildDefinitionTemplate) pm.detachCopy( result.get( 0 ) ); } finally { tx.commit(); rollback( tx ); } }
public List<BuildDefinition> getDefaultBuildDefinitionsForProjectGroup( int projectGroupId ) throws ContinuumStoreException { PersistenceManager pm = getPersistenceManager(); Transaction tx = pm.currentTransaction(); try { tx.begin(); Extent extent = pm.getExtent( ProjectGroup.class, true ); Query query = pm.newQuery( extent ); query.declareImports( "import " + BuildDefinition.class.getName() ); query.declareParameters( "int projectGroupId" ); query.setFilter( "this.id == projectGroupId && this.buildDefinitions.contains(buildDef) && buildDef.defaultForProject == true" ); query.declareVariables( "BuildDefinition buildDef" ); query.setResult( "buildDef" ); List<BuildDefinition> result = (List<BuildDefinition>) query.execute( projectGroupId ); result = (List<BuildDefinition>) pm.detachCopyAll( result ); tx.commit(); if ( result != null ) { return result; } } finally { rollback( tx ); } return new ArrayList<BuildDefinition>(); }
public List<DirectoryPurgeConfiguration> getDirectoryPurgeConfigurationsByType( String type ) { PersistenceManager pm = getPersistenceManager(); Transaction tx = pm.currentTransaction(); try { tx.begin(); Extent extent = pm.getExtent( DirectoryPurgeConfiguration.class, true ); Query query = pm.newQuery( extent ); query.declareImports( "import java.lang.String" ); query.declareParameters( "String type" ); query.setFilter( "this.directoryType == type" ); List result = (List) query.execute( type ); return result == null ? Collections.EMPTY_LIST : (List) pm.detachCopyAll( result ); } finally { tx.commit(); rollback( tx ); } }
public List<DistributedDirectoryPurgeConfiguration> getDistributedDirectoryPurgeConfigurationsByType( String type ) { PersistenceManager pm = getPersistenceManager(); Transaction tx = pm.currentTransaction(); try { tx.begin(); Extent extent = pm.getExtent( DistributedDirectoryPurgeConfiguration.class, true ); Query query = pm.newQuery( extent ); query.declareImports( "import java.lang.String" ); query.declareParameters( "String type" ); query.setFilter( "this.directoryType == type" ); List result = (List) query.execute( type ); return result == null ? Collections.EMPTY_LIST : (List) pm.detachCopyAll( result ); } finally { tx.commit(); rollback( tx ); } }
public List<DirectoryPurgeConfiguration> getDirectoryPurgeConfigurationsByLocation( String location ) { PersistenceManager pm = getPersistenceManager(); Transaction tx = pm.currentTransaction(); try { tx.begin(); Extent extent = pm.getExtent( DirectoryPurgeConfiguration.class, true ); Query query = pm.newQuery( extent ); query.declareImports( "import java.lang.String" ); query.declareParameters( "String location" ); query.setFilter( "this.location == location" ); List result = (List) query.execute( location ); return result == null ? Collections.EMPTY_LIST : (List) pm.detachCopyAll( result ); } finally { tx.commit(); rollback( tx ); } }
public List<LocalRepository> getLocalRepositoriesByLayout( String layout ) { PersistenceManager pm = getPersistenceManager(); Transaction tx = pm.currentTransaction(); try { tx.begin(); Extent extent = pm.getExtent( LocalRepository.class, true ); Query query = pm.newQuery( extent ); query.declareImports( "import java.lang.String" ); query.declareParameters( "String layout" ); query.setFilter( "this.layout == layout" ); List result = (List) query.execute( layout ); return result == null ? Collections.EMPTY_LIST : (List) pm.detachCopyAll( result ); } finally { tx.commit(); rollback( tx ); } }
private List findUsers( String searchField, String searchKey, boolean ascendingUsername ) { PersistenceManager pm = getPersistenceManager(); Transaction tx = pm.currentTransaction(); try { tx.begin(); Extent extent = pm.getExtent( JdoUser.class, true ); Query query = pm.newQuery( extent ); String ordering = ascendingUsername ? "username ascending" : "username descending"; query.setOrdering( ordering ); query.declareImports( "import java.lang.String" ); query.declareParameters( "String searchKey" ); query.setFilter( "this." + searchField + ".toLowerCase().indexOf(searchKey.toLowerCase()) > -1" ); List result = (List) query.execute( searchKey ); result = (List) pm.detachCopyAll( result ); tx.commit(); return result; } finally { rollback( tx ); } }
@SuppressWarnings("unchecked") private List<User> findUsers( String searchField, String searchKey, boolean ascendingUsername ) { PersistenceManager pm = getPersistenceManager(); Transaction tx = pm.currentTransaction(); try { tx.begin(); Extent extent = pm.getExtent( JdoUser.class, true ); Query query = pm.newQuery( extent ); String ordering = ascendingUsername ? "username ascending" : "username descending"; query.setOrdering( ordering ); query.declareImports( "import java.lang.String" ); query.declareParameters( "String searchKey" ); query.setFilter( "this." + searchField + ".toLowerCase().indexOf(searchKey.toLowerCase()) > -1" ); List<User> result = (List<User>) query.execute( searchKey ); result = (List<User>) pm.detachCopyAll( result ); tx.commit(); return result; } finally { rollback( tx ); } }
@SuppressWarnings("unchecked") private List<User> findUsers( String searchField, String searchKey, boolean ascendingUsername ) { PersistenceManager pm = getPersistenceManager(); Transaction tx = pm.currentTransaction(); try { tx.begin(); Extent extent = pm.getExtent( JdoUser.class, true ); Query query = pm.newQuery( extent ); String ordering = ascendingUsername ? "username ascending" : "username descending"; query.setOrdering( ordering ); query.declareImports( "import java.lang.String" ); query.declareParameters( "String searchKey" ); query.setFilter( "this." + searchField + ".toLowerCase().indexOf(searchKey.toLowerCase()) > -1" ); List<User> result = (List<User>) query.execute( searchKey ); result = (List<User>) pm.detachCopyAll( result ); tx.commit(); return result; } finally { rollback( tx ); } }
public List<BuildDefinitionTemplate> getBuildDefinitionTemplatesWithType( String type ) throws ContinuumStoreException { PersistenceManager pm = getPersistenceManager(); Transaction tx = pm.currentTransaction(); try { tx.begin(); Extent extent = pm.getExtent( BuildDefinitionTemplate.class, true ); Query query = pm.newQuery( extent ); query.declareImports( "import java.lang.String" ); query.declareParameters( "String type" ); query.setFilter( "this.type == type" ); pm.getFetchPlan().addGroup( BUILD_TEMPLATE_BUILD_DEFINITIONS ); List result = (List) query.execute( type ); return result == null ? Collections.EMPTY_LIST : (List) pm.detachCopyAll( result ); } finally { tx.commit(); rollback( tx ); } }
public List<BuildDefinitionTemplate> getBuildDefinitionTemplatesWithType( String type ) throws ContinuumStoreException { PersistenceManager pm = getPersistenceManager(); Transaction tx = pm.currentTransaction(); try { tx.begin(); Extent extent = pm.getExtent( BuildDefinitionTemplate.class, true ); Query query = pm.newQuery( extent ); query.declareImports( "import java.lang.String" ); query.declareParameters( "String type" ); query.setFilter( "this.type == type" ); pm.getFetchPlan().addGroup( BUILD_TEMPLATE_BUILD_DEFINITIONS ); List result = (List) query.execute( type ); return result == null ? Collections.EMPTY_LIST : (List) pm.detachCopyAll( result ); } finally { tx.commit(); rollback( tx ); } }
@SuppressWarnings("unchecked") public List<User> findUsersByQuery( UserQuery userQuery ) { JdoUserQuery uq = (JdoUserQuery) userQuery; PersistenceManager pm = getPersistenceManager(); Transaction tx = pm.currentTransaction(); try { tx.begin(); Extent extent = pm.getExtent( JdoUser.class, true ); Query query = pm.newQuery( extent ); String ordering = uq.getOrdering(); query.setOrdering( ordering ); query.declareImports( "import java.lang.String" ); query.declareParameters( uq.getParameters() ); query.setFilter( uq.getFilter() ); query.setRange( uq.getFirstResult(), uq.getMaxResults() < 0 ? Long.MAX_VALUE : uq.getFirstResult() + uq.getMaxResults() ); List<User> result = (List<User>) query.executeWithArray( uq.getSearchKeys() ); result = (List<User>) pm.detachCopyAll( result ); tx.commit(); return result; } finally { rollback( tx ); } }