archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/model/xml/ModelToXMLConverter.java

   1 package com.quantum.model.xml;
   2
   3 import com.quantum.Messages;
   4 import com.quantum.model.Bookmark;
   5 import com.quantum.model.Column;
   6 import com.quantum.model.Entity;
   7 import com.quantum.model.Schema;
   8 import com.quantum.sql.metadata.MetaDataXMLInterface;
   9
  10 import org.w3c.dom.Document;
  11 import org.w3c.dom.Element;
  12 import org.w3c.dom.Text;
  13
  14 /**
  15  * @author BC
  16  */
  17 public class ModelToXMLConverter {
  18
  19     private static final ModelToXMLConverter instance = new ModelToXMLConverter();
  20
  21     private ModelToXMLConverter() {
  22     }
  23
  24     public static ModelToXMLConverter getInstance() {
  25         return ModelToXMLConverter.instance;
  26     }
  27
  28     public void createRoot(Document document) {
  29         document.appendChild(document.createElement("SAVED_DATA"));
  30     }
  31
  32     public void convert(Element bookmarkRoot, Bookmark b) {
  33         Document document = bookmarkRoot.getOwnerDocument();
  34         Element bookmark = MetaDataXMLInterface.createElementText(bookmarkRoot,"bookmark", ""); //$NON-NLS-1$ //$NON-NLS-2$
  35         MetaDataXMLInterface.createElementText(bookmark,"name", b.getName()); //$NON-NLS-1$
  36         MetaDataXMLInterface.createElementText(bookmark,"username", b.getUsername()); //$NON-NLS-1$
  37         MetaDataXMLInterface.createElementText(bookmark,"password", b.getPassword()); //$NON-NLS-1$
  38         MetaDataXMLInterface.createElementText(bookmark,"prompt", b.getPromptForPassword() ? "true" : "false"); //$NON-NLS-1$
  39         MetaDataXMLInterface.createElementText(bookmark,"connect", b.getConnect()); //$NON-NLS-1$
  40                 MetaDataXMLInterface.createElementText(bookmark,"autoCommit", b.isAutoCommit() ? "true" : "false"); //$NON-NLS-1$
  41                 MetaDataXMLInterface.createElementText(bookmark,"autoCommitPreference", b.getAutoCommitPreference()); //$NON-NLS-1$
  42         MetaDataXMLInterface.createElementText(bookmark,"driver", b.getDriver()); //$NON-NLS-1$
  43         MetaDataXMLInterface.createElementText(bookmark,"type", b.getType()); //$NON-NLS-1$
  44                 MetaDataXMLInterface.createElementText(bookmark,"driverLocation", b.getDriverFile()); //$NON-NLS-1$
  45         Element otherSchemas = (Element) bookmark.appendChild(document.createElement(Messages.getString("ExportXMLAction.OtherSchemas"))); //$NON-NLS-1$
  46         Schema[] schemas = b.getSchemas();
  47         for (int i = 0, length = (schemas == null) ? 0 : schemas.length;
  48             i < length;
  49             i++) {
  50             if (!schemas[i].isDefault()) {
  51                 MetaDataXMLInterface.createElementText(
  52                     otherSchemas,Messages.getString("ExportXMLAction.SchemaName"), schemas[i].getName()); //$NON-NLS-1$
  53             }
  54         }
  55         Entity[] quickList = b.getQuickListEntries();
  56         Element quickListEntity = document.createElement("quickList");
  57         for (int j = 0, length = (quickList == null) ? 0 : quickList.length;
  58             j < length;
  59             j++) {
  60             ModelToXMLConverter.getInstance().convert(quickListEntity, quickList[j]);
  61         }
  62         bookmark.appendChild(quickListEntity);
  63         convertQueryList(b, bookmark);
  64     }
  65
  66
  67     public void convert(Element parent, Entity entity) {
  68         convert(parent, entity, true);
  69     }
  70     public void convert(Element parent, Entity entity, boolean recurse) {
  71         Document document = parent.getOwnerDocument();
  72         Element element = document.createElement(getEntityDOMNodeName(entity));
  73         element.setAttribute("name", entity.getName());
  74         if (entity.getSchema() != null) {
  75             element.setAttribute("schema", entity.getSchema());
  76         }
  77         if (recurse) {
  78             convert(element, entity.getColumns());
  79         }
  80         parent.appendChild(element);
  81     }
  82
  83     public void convert(Element element, Column[] columns) {
  84         for (int i = 0, length = (columns == null) ? 0 : columns.length;
  85             i < length;
  86             i++) {
  87             convert(element, columns[i]);
  88         }
  89     }
  90
  91     public void convert(Element parent, Column column) {
  92         Document document = parent.getOwnerDocument();
  93         Element element = document.createElement("column");
  94         element.setAttribute("name", column.getName());
  95         element.setAttribute("type", column.getTypeName());
  96         element.setAttribute("primaryKey", column.isPrimaryKey() ? "true" : "false");
  97         element.setAttribute("nullable", column.isNullable() ? "true" : "false");
  98         if (column.isNumeric()) {
  99             if (column.getSize() > 0) {
 100                 element.setAttribute("size", String.valueOf(column.getSize()));
 101             }
 102             if (column.getNumberOfFractionalDigits() > 0) {
 103                 element.setAttribute("numberOfFractionalDigits", String.valueOf(column.getNumberOfFractionalDigits()));
 104             }
 105         } else {
 106             if (column.getSize() > 0) {
 107                 element.setAttribute("size", String.valueOf(column.getSize()));
 108             }
 109         }
 110                 if (column.getRemarks().length() > 0)
 111                         MetaDataXMLInterface.createElementText(element, "remarks", column.getRemarks());
 112         parent.appendChild(element);
 113     }
 114
 115
 116     public String getEntityDOMNodeName(Entity entity) {
 117         if (Entity.TABLE_TYPE.equals(entity.getType())) {
 118             return "table";
 119         } else if (Entity.VIEW_TYPE.equals(entity.getType())) {
 120             return "view";
 121         } else if (Entity.SEQUENCE_TYPE.equals(entity.getType())) {
 122             return "sequence";
 123         } else {
 124             return "unknown";
 125         }
 126     }
 127
 128     public void convertQueryList(
 129         Bookmark bookmark,
 130         Element parent) {
 131
 132         Document document = parent.getOwnerDocument();
 133         String[] queryList = bookmark.getQueries();
 134         Element queryListEntity = document.createElement("queryList");
 135         for (int j = 0, length = (queryList == null) ? 0 : queryList.length;
 136             j < length;
 137             j++) {
 138             Element query = document.createElement("query");
 139
 140             // will have more possibilities later
 141             Element queryString = document.createElement("queryString");
 142             Text queryText = document.createTextNode(queryList[j]);
 143             queryString.appendChild(queryText);
 144             query.appendChild(queryString);
 145             queryListEntity.appendChild(query);
 146         }
 147         parent.appendChild(queryListEntity);
 148     }
 149
 150 }