001: //=== Copyright (C) 2001-2007 Food and Agriculture Organization of the
002: //=== United Nations (FAO-UN), United Nations World Food Programme (WFP)
003: //=== and United Nations Environment Programme (UNEP)
004: //===
005: //=== This program is free software; you can redistribute it and/or modify
006: //=== it under the terms of the GNU General Public License as published by
007: //=== the Free Software Foundation; either version 2 of the License, or (at
008: //=== your option) any later version.
009: //===
010: //=== This program is distributed in the hope that it will be useful, but
011: //=== WITHOUT ANY WARRANTY; without even the implied warranty of
012: //=== MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
013: //=== General Public License for more details.
014: //===
015: //=== You should have received a copy of the GNU General Public License
016: //=== along with this program; if not, write to the Free Software
017: //=== Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301, USA
018: //===
019: //=== Contact: Jeroen Ticheler - FAO - Viale delle Terme di Caracalla 2,
020: //=== Rome - Italy. email: geonetwork@osgeo.org
021: //==============================================================================
022:
023: package org.fao.geonet.apps.trash;
024:
025: import jeeves.utils.*;
026: import jeeves.resources.dbms.*;
027:
028: import org.jdom.*;
029:
030: import java.util.*;
031:
032: public class Transform {
033: public static void main(String args[]) {
034: // check args
035: if (args.length != 4) {
036: System.err
037: .println("usage: transform table field template config");
038: System.exit(1);
039: }
040: // get args
041: String table = args[0];
042: String field = args[1];
043: String templateFile = args[2];
044: String configFile = args[3];
045:
046: DbmsPool pool = null;
047: Dbms dbms = null;
048: try {
049: // get dbms pool and open dbms connection
050: pool = Util.getDbmsPool(configFile);
051: dbms = (Dbms) pool.open();
052:
053: // get id list from table
054: Element result = dbms.select("SELECT id, " + field
055: + " FROM " + table);
056:
057: // loop on ids
058: System.out.println("transforming records"); // DEBUG
059: List records = result.getChildren("record");
060: for (int i = 0; i < records.size(); i++) {
061: Element record = (Element) records.get(i);
062:
063: // get id
064: String sId = record.getChildText("id");
065: int id = Integer.parseInt(sId);
066:
067: // get and transform field
068: String sField = record.getChildText(field);
069: String newField = applyTemplate(sField, templateFile);
070: // System.out.println("- new field is " + newField); // DEBUG
071:
072: // save transformed field
073:
074: dbms.execute("UPDATE " + table + " SET " + field
075: + " = ? WHERE id = ?", newField,
076: new Integer(id));
077: System.out.println("- record " + id + " saved"); // DEBUG
078: }
079: // commit changes
080: System.out.println("saving changes"); // DEBUG
081: pool.close(dbms);
082: System.out.println("database closed, exiting"); // DEBUG
083: System.exit(0);
084: } catch (Exception e) {
085: e.printStackTrace();
086:
087: // possibly abort the transaction
088: if (pool != null && dbms != null)
089: try {
090: System.out.println("aborting changes"); // DEBUG
091: pool.abort(dbms);
092: System.out.println("database closed"); // DEBUG
093: } catch (Exception e2) {
094: e2.printStackTrace();
095: }
096: System.out.println("exiting"); // DEBUG
097: System.exit(1);
098: }
099: }
100:
101: private static String applyTemplate(String source,
102: String templateFile) throws Exception {
103: Element xml = Xml.loadString(source, false);
104: Element result = Xml.transform(xml, templateFile);
105: return Xml.getString(result);
106: }
107: }
|