Package com.dotmarketing.common.db

Examples of com.dotmarketing.common.db.DotConnect.loadResult()


                dc.addParam(sortOrder);
                dc.addParam(filesMasks);
                dc.addParam(newFolderIdentifier);
                dc.addParam(defaultFileType);
                dc.addParam(modDate);
                dc.loadResult();

                // 5) update foreign tables references to the new real row
                dc.executeStatement("update structure set folder = '"+newFolderInode+"' where folder = 'TEMP_INODE'");
                dc.executeStatement("update permission set inode_id = '"+newFolderInode+"' where inode_id = 'TEMP_INODE'");
                dc.executeStatement("update permission_reference set asset_id = '"+newFolderInode+"' where asset_id = 'TEMP_INODE'");
View Full Code Here


            dc.setSQL("insert into inode values (?, ?, ?, ?) ");
            dc.addParam(newStructureInode);
            dc.addParam(owner);
            dc.addParam(idate);
            dc.addParam(type);
            dc.loadResult();

            // 4.2) insert real new STRUCTURE row
            dc.setSQL("insert into structure values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ");
            dc.addParam(newStructureInode);
            dc.addParam(name);
View Full Code Here

            dc.addParam(host);
            dc.addParam(folder);
            dc.addParam(expireDateVar);
            dc.addParam(publishDateVar);
            dc.addParam(modDate);
            dc.loadResult();

            // 5) update foreign tables references to the new real row
            dc.executeStatement("update container_structures set structure_id = '"+newStructureInode+"' where structure_id = 'TEMP_INODE'");
            dc.executeStatement("update contentlet set structure_inode = '"+newStructureInode+"' where structure_inode = 'TEMP_INODE'");
            dc.executeStatement("update field set structure_inode = '"+newStructureInode+"' where structure_inode = 'TEMP_INODE'");
View Full Code Here

            dc.addParam(archived);
            dc.addParam(mandatory);
            dc.addParam(isDefaultScheme);
            dc.addParam(entryActionId);
            dc.addParam(modDate);
            dc.loadResult();

            // 5) update foreign tables references to the new real row
            dc.executeStatement("update workflow_step set scheme_id = '"+newWorkflowId+"' where scheme_id = 'TEMP_INODE'");
            dc.executeStatement("update workflow_scheme_x_structure set scheme_id = '"+newWorkflowId+"' where scheme_id = 'TEMP_INODE'");
View Full Code Here

    DotConnect dc = new DotConnect();
    dc.setSQL(UPDATE_ENVIRONMENT);
    dc.addParam(environment.getName());
    dc.addParam(environment.getPushToAll().booleanValue());
    dc.addParam(environment.getId());
    dc.loadResult();
  }

  @Override
  public void deleteEnvironmentById(String id) throws DotDataException {
    DotConnect dc = new DotConnect();
View Full Code Here

  @Override
  public void deleteEnvironmentById(String id) throws DotDataException {
    DotConnect dc = new DotConnect();
    dc.setSQL(DELETE_ENVIRONMENT);
    dc.addParam(id);
    dc.loadResult();
  }

  @Override
  public Environment getEnvironmentByName(String name) throws DotDataException {
    DotConnect dc = new DotConnect();
View Full Code Here

    DotConnect dc = new DotConnect();
    dc.setSQL(DELETE_BUNDLE);
    dc.addParam(id);

    dc.loadResult();

  }

  @Override
  public void updateBundle(Bundle bundle) throws DotDataException {
View Full Code Here

    dc.addParam(bundle.getName());
    dc.addParam(bundle.getPublishDate());
    dc.addParam(bundle.getExpireDate());
    dc.addParam(bundle.getId());

    dc.loadResult();

  }

  @Override
  public void deleteAssetFromBundle(String assetId, String bundleId)
View Full Code Here

    DotConnect dc = new DotConnect();
    dc.setSQL(DELETE_ASSET_FROM_BUNDLE);
    dc.addParam(assetId);
    dc.addParam(bundleId);

    dc.loadResult();

  }

  @Override
  public void deleteBundleEnvironmentByEnvironment(String environmentId)
View Full Code Here

    DotConnect dc = new DotConnect();
    dc.setSQL(DELETE_BUNDLE_ENVIRONMENT_BY_ENV);
    dc.addParam(environmentId);

    dc.loadResult();

  }

  @Override
  public void deleteBundleEnvironmentByBundle(String bundleId)
View Full Code Here

TOP
Copyright © 2018 www.massapi.com. 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.