X-Git-Url: http://git.phpeclipse.com

diff --git a/archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/view/subset/ObjectNode.java b/archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/view/subset/ObjectNode.java
new file mode 100644
index 0000000..149135f
--- /dev/null
+++ b/archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/view/subset/ObjectNode.java
@@ -0,0 +1,167 @@
+package com.quantum.view.subset;
+
+import com.quantum.IQuantumConstants;
+import com.quantum.Messages;
+import com.quantum.model.Entity;
+import com.quantum.model.EntityHolder;
+import com.quantum.sql.metadata.MetaDataXMLInterface;
+import com.quantum.sql.metadata.ObjectMetaData;
+
+import org.w3c.dom.Document;
+import org.w3c.dom.Element;
+
+/**
+ * Defines a node for the Subset. It contains an editable ObjectMetaData 
+ * where you can erase columns you are not interested in. 
+ * @author jparrai
+ *
+ */
+public class ObjectNode implements Comparable, EntityHolder {
+	private SubsetNode parent = null;
+	private ObjectMetaData metadata = null;
+	private int order = 0;
+    private Entity entity;
+	
+	public ObjectNode(SubsetNode parent, ObjectMetaData metadata, String bookmark, String name, String schema) {
+		this.parent = parent;
+		this.metadata = metadata;
+        this.entity = new EntitySubset(name, schema, bookmark);
+	}
+	
+	public ObjectNode(){
+	}
+	public String getType(){
+		return IQuantumConstants.View;
+	}
+
+	/* (non-Javadoc)
+	 * @see com.quantum.view.bookmark.TreeNode#getChildren()
+	 * We consider the columns of the metadata to be the children.
+	 */
+	public Object[] getChildren() {
+//		if (metadata != null && ColumnMetaData.getColumnsMetaDataNode(metadata, this) != null) {
+//			return ColumnMetaData.getColumnsMetaDataNode(metadata, this).toArray();
+//		} else {
+			return SubsetRoot.EMPTY_ARRAY;
+//		}
+	}
+
+	public Object getParent() {
+		return parent;
+	}
+
+	public boolean hasChildren() {
+//		if (metadata == null) return false;
+//		return (ColumnMetaData.getColumnsMetaDataNode(metadata, this) != null && 
+//				ColumnMetaData.getColumnsMetaDataNode(metadata, this).size() > 0);
+        return false;
+	}
+	
+	public String getName() {
+		return this.entity.getName();
+	}
+	
+	public String toString() {
+		return getName();
+	}
+
+	public int compareTo(Object o) {
+		if (o instanceof ObjectNode) {
+			ObjectNode node = (ObjectNode) o;
+			if (node.getOrder() > getOrder()) return -1;
+			if (node.getOrder() < getOrder()) return 1;
+			// If the order is the same, we use alphabetical order 
+			return getEntity().getCondQualifiedName().compareTo(
+                node.getEntity().getCondQualifiedName());
+		} else throw new ClassCastException();
+	}
+	
+	public void setObjectMetadata(ObjectMetaData metadata) {
+		this.metadata = metadata;
+	}
+	/**
+	 * @return
+	 */
+	public ObjectMetaData getMetaData() {
+		return metadata;
+	}
+
+	/**
+	 * @return The order of this ObjectNode inside the SubsetNode
+	 */
+	public int getOrder() {
+		return order;
+	}
+	/**
+	 * Sets an ordering (inside the SubsetNode) to the ObjectNode
+	 * @param i
+	 */
+	public void setOrder(int i) {
+		order = i;
+	}
+
+	/* (non-Javadoc)
+	 * @see java.lang.Object#equals(java.lang.Object)
+	 */
+	public boolean equals(Object obj) {
+		if (!(obj instanceof ObjectNode)) return false;
+		return (getEntity().getCondQualifiedName().equals(
+            ((ObjectNode) obj).getEntity().getCondQualifiedName()));
+	}
+	
+	/**
+	 * Imports one ObjectNode from an XMLDocument. There must be a tag for the Table Name, another for the Bookmark
+	 * name and other for the metadata. The complement function is exportXML()
+	 * @param root Document to get the data from
+	 * @param parent The SubsetNode to which to add the new ObjectNode
+	 * @return The newly created ObjectNode, or null if some error.
+	 */
+	public static ObjectNode importXML(Element root, SubsetNode parent){
+		// Get the name tag value into objName
+		String objName = MetaDataXMLInterface.getElementText(root, Messages.getString("ExportXMLAction.TableName")); //$NON-NLS-1$
+		String objSchema = MetaDataXMLInterface.getElementText(root, Messages.getString("ExportXMLAction.SchemaName")); //$NON-NLS-1$
+		if (objName == "") return null;	 //$NON-NLS-1$
+		// Get the bookmark tag value into objName
+		String bookmarkName = MetaDataXMLInterface.getElementText(root, Messages.getString("ExportXMLAction.BookmarkName")); //$NON-NLS-1$
+		if (bookmarkName == "") return null; //$NON-NLS-1$
+		ObjectMetaData metadata = new ObjectMetaData();
+		// The rest of the tags go to be the metadata
+		MetaDataXMLInterface.xmlToMetaData(metadata, root);
+		// We can finally create the new ObjectNode with the collected data
+		ObjectNode objectNode = new ObjectNode(parent, metadata, bookmarkName, objName, objSchema);
+		return objectNode;					
+	}
+	
+	/**
+	 * Exports an ObjectNode to an XMLDocument. The complement function is importXML()
+	 * @param root	Document to write the XML tags to
+	 */
+	public void exportXML(Element root){
+		Document doc = root.getOwnerDocument();
+		Element sub = (Element) root.appendChild(doc.createElement(Messages.getString("ExportXMLAction.Table"))); //$NON-NLS-1$
+		MetaDataXMLInterface.createElementText(sub,Messages.getString("ExportXMLAction.TableName"), getEntity().getName()); //$NON-NLS-1$
+		MetaDataXMLInterface.createElementText(sub,Messages.getString("ExportXMLAction.SchemaName"), getEntity().getSchema()); //$NON-NLS-1$
+		MetaDataXMLInterface.createElementText(sub,Messages.getString("ExportXMLAction.BookmarkName"), getEntity().getBookmark().getName()); //$NON-NLS-1$
+		if (this.metadata != null)
+			MetaDataXMLInterface.metaDataToXML(this.metadata, doc, sub);
+	}
+
+	/**
+	 * Generates a query with all the columns in the metadata of the ObjectNode.
+	 * "SELECT *" would not be valid because you can have less columns in the ObjectNode than in the table or view.
+	 * @return	String with the Query
+	 */
+	public String getQuery() {
+		String result = new String(""); //$NON-NLS-1$
+		result = "SELECT " + metadata.getColumnsString() + " FROM " + getEntity().getCondQualifiedName(); //$NON-NLS-1$ //$NON-NLS-2$
+		return result;
+	}
+
+    /**
+     * @see com.quantum.model.EntityHolder#getEntity()
+     */
+    public Entity getEntity() {
+        return this.entity;
+    }
+
+}