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 Export {
033: public static void main(String args[]) {
034: // check args
035: if (args.length != 4) {
036: System.err
037: .println("usage: export 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: // print transformed field
073: System.out.println(newField);
074: }
075: // commit changes
076: pool.close(dbms);
077: System.out.println("database closed, exiting"); // DEBUG
078: System.exit(0);
079: } catch (Exception e) {
080: e.printStackTrace();
081:
082: // possibly abort the transaction
083: if (pool != null && dbms != null)
084: try {
085: pool.abort(dbms);
086: System.out.println("database closed"); // DEBUG
087: } catch (Exception e2) {
088: e2.printStackTrace();
089: }
090: System.out.println("exiting"); // DEBUG
091: System.exit(1);
092: }
093: }
094:
095: private static String applyTemplate(String source,
096: String templateFile) throws Exception {
097: Element xml = Xml.loadString(source, false);
098: Element result = Xml.transform(xml, templateFile);
099: return Xml.getString(result);
100: }
101: }
|