Java tutorial
/* ************************************************************************ ******************* CANADIAN ASTRONOMY DATA CENTRE ******************* ************** CENTRE CANADIEN DE DONNES ASTRONOMIQUES ************** * * (c) 2011. (c) 2011. * Government of Canada Gouvernement du Canada * National Research Council Conseil national de recherches * Ottawa, Canada, K1A 0R6 Ottawa, Canada, K1A 0R6 * All rights reserved Tous droits rservs * * NRC disclaims any warranties, Le CNRC dnie toute garantie * expressed, implied, or nonce, implicite ou lgale, * statutory, of any kind with de quelque nature que ce * respect to the software, soit, concernant le logiciel, * including without limitation y compris sans restriction * any warranty of merchantability toute garantie de valeur * or fitness for a particular marchande ou de pertinence * purpose. NRC shall not be pour un usage particulier. * liable in any event for any Le CNRC ne pourra en aucun cas * damages, whether direct or tre tenu responsable de tout * indirect, special or general, dommage, direct ou indirect, * consequential or incidental, particulier ou gnral, * arising from the use of the accessoire ou fortuit, rsultant * software. Neither the name de l'utilisation du logiciel. Ni * of the National Research le nom du Conseil National de * Council of Canada nor the Recherches du Canada ni les noms * names of its contributors may de ses participants ne peuvent * be used to endorse or promote tre utiliss pour approuver ou * products derived from this promouvoir les produits drivs * software without specific prior de ce logiciel sans autorisation * written permission. pralable et particulire * par crit. * * This file is part of the Ce fichier fait partie du projet * OpenCADC project. OpenCADC. * * OpenCADC is free software: OpenCADC est un logiciel libre ; * you can redistribute it and/or vous pouvez le redistribuer ou le * modify it under the terms of modifier suivant les termes de * the GNU Affero General Public la GNU Affero General Public * License as published by the License? telle que publie * Free Software Foundation, par la Free Software Foundation * either version 3 of the : soit la version 3 de cette * License, or (at your option) licence, soit ( votre gr) * any later version. toute version ultrieure. * * OpenCADC is distributed in the OpenCADC est distribu * hope that it will be useful, dans lespoir quil vous * but WITHOUT ANY WARRANTY; sera utile, mais SANS AUCUNE * without even the implied GARANTIE : sans mme la garantie * warranty of MERCHANTABILITY implicite de COMMERCIALISABILIT * or FITNESS FOR A PARTICULAR ni dADQUATION UN OBJECTIF * PURPOSE. See the GNU Affero PARTICULIER. Consultez la Licence * General Public License for Gnrale Publique GNU Affero * more details. pour plus de dtails. * * You should have received Vous devriez avoir reu une * a copy of the GNU Affero copie de la Licence Gnrale * General Public License along Publique GNU Affero avec * with OpenCADC. If not, see OpenCADC ; si ce nest * <http://www.gnu.org/licenses/>. pas le cas, consultez : * <http://www.gnu.org/licenses/>. * * $Revision: 5 $ * ************************************************************************ */ package ca.nrc.cadc.vosi; import ca.nrc.cadc.tap.schema.ColumnDesc; import ca.nrc.cadc.tap.schema.KeyColumnDesc; import ca.nrc.cadc.tap.schema.KeyDesc; import ca.nrc.cadc.tap.schema.TableDesc; import java.io.IOException; import java.io.InputStream; import java.io.InputStreamReader; import java.io.Reader; import java.util.List; import org.apache.log4j.Logger; import org.jdom2.Document; import org.jdom2.Element; import org.jdom2.JDOMException; import org.jdom2.Namespace; /** * * @author pdowler */ public class TableReader extends TableSetParser { private static final Logger log = Logger.getLogger(TableReader.class); private static final String TAP_TYPE = "vod:TAPType"; private static final String VOT_TYPE = "vod:VOTableType"; public TableReader() { this(true); } public TableReader(boolean enableSchemaValidation) { super(enableSchemaValidation); } public TableDesc read(InputStream istream) throws IOException, InvalidTableSetException { return read(new InputStreamReader(istream)); } public TableDesc read(Reader reader) throws IOException, InvalidTableSetException { try { Document doc = parse(reader); Element root = doc.getRootElement(); Namespace xsi = root.getNamespace("xsi"); return toTable("default", root, xsi); } catch (JDOMException ex) { throw new InvalidTableSetException("invalid content", ex); } } static TableDesc toTable(String schemaName, Element te, Namespace xsi) { String tn = te.getChildTextTrim("name"); TableDesc td = new TableDesc(schemaName, tn); List<Element> cols = te.getChildren("column"); for (Element ce : cols) { String cn = ce.getChildTextTrim("name"); Element dte = ce.getChild("dataType"); String dtt = dte.getAttributeValue("type", xsi); String dtv = dte.getTextTrim(); if (TAP_TYPE.equals(dtt)) dtv = "adql:" + dtv; else if (VOT_TYPE.equals(dtt)) dtv = "vot:" + dtv; Integer arraysize = null; String as = dte.getAttributeValue("size"); if (as != null) arraysize = new Integer(as); ColumnDesc cd = new ColumnDesc(tn, cn, dtv, arraysize); td.getColumnDescs().add(cd); } List<Element> keys = te.getChildren("foreignKey"); int i = 1; for (Element fk : keys) { String keyID = tn + "_key" + i; String tt = fk.getChildTextTrim("targetTable"); KeyDesc kd = new KeyDesc(keyID, tn, tt); List<Element> fkcols = fk.getChildren("fkColumn"); for (Element fkc : fkcols) { String fc = fkc.getChildTextTrim("fromColumn"); String tc = fkc.getChildTextTrim("targetColumn"); KeyColumnDesc kcd = new KeyColumnDesc(keyID, fc, tc); kd.getKeyColumnDescs().add(kcd); } td.getKeyDescs().add(kd); } return td; } }