Metacat

  public static Vector<String> getAllDocidsByType(String doctype, boolean includeRevs, int serverLocation) throws SQLException {

			sb.append("WHERE true ");

				sb.append("AND doctype LIKE ? ");

			if (serverLocation > 0) {

				sb.append("AND server_location = ' " + serverLocation + "' ");

			}

				sb.append("WHERE true ");

					sb.append("AND doctype LIKE ?");

				if (serverLocation > 0) {

					sb.append("AND server_location = ' " + serverLocation + "' ");

				}

        // do not include ORE or data, but can generate SystemMetadata for ALL records

        int serverLocation = -1;

        	// get list of ALL docids at ALL server locations

            List<String> idList = DBUtil.getAllDocidsByType(null, true, serverLocation);

package edu.ucsb.nceas.metacat.admin.upgrade;

/**

 *  '$RCSfile$'

 *    Purpose: A Class for upgrading the database to version 1.5

 *  Copyright: 2000 Regents of the University of California and the

 *             National Center for Ecological Analysis and Synthesis

 *    Authors: Saurabh Garg

 *

 *   '$Author$'

 *     '$Date$'

 * '$Revision$'

 *

 * This program is free software; you can redistribute it and/or modify

 * it under the terms of the GNU General Public License as published by

 * the Free Software Foundation; either version 2 of the License, or

 * (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

 */

import java.util.List;

import org.apache.commons.logging.Log;

import org.apache.commons.logging.LogFactory;

import edu.emory.mathcs.backport.java.util.Collections;

import edu.ucsb.nceas.metacat.DBUtil;

import edu.ucsb.nceas.metacat.admin.AdminException;

import edu.ucsb.nceas.metacat.dataone.SystemMetadataFactory;

import edu.ucsb.nceas.metacat.properties.PropertyService;

import edu.ucsb.nceas.utilities.SortedProperties;

public class GenerateORE implements UpgradeUtilityInterface {

	private static Log log = LogFactory.getLog(GenerateORE.class);

    public boolean upgrade() throws AdminException {

        boolean success = true;

        // include ORE, data, for this server only

        boolean includeOre = true;

        boolean downloadData = true;

        int serverLocation = 1;

        try {

        	// get only local ids for this server

            List<String> idList = DBUtil.getAllDocidsByType(null, true, serverLocation);

            Collections.sort(idList);

            // generate based on this list

            SystemMetadataFactory.generateSystemMetadata(idList, includeOre, downloadData);

		} catch (Exception e) {

			String msg = "Problem generating missing system metadata: " + e.getMessage();

			log.error(msg, e);

			success = false;

			throw new AdminException(msg);

		}

    	return success;

    }

    public static void main(String [] ags){

        try {

        	// set up the properties based on the test/deployed configuration of the workspace

        	SortedProperties testProperties = 

				new SortedProperties("test/test.properties");

			testProperties.load();

			String metacatContextDir = testProperties.getProperty("metacat.contextDir");

			PropertyService.getInstance(metacatContextDir + "/WEB-INF");

			// now run it

            GenerateORE upgrader = new GenerateORE();

	        upgrader.upgrade();

        } catch (Exception ex) {

            System.out.println("Exception:" + ex.getMessage());

            ex.printStackTrace();

        }

    }

}