BasicJDBCIntrospector.java

package com.hackerdude.apps.sqlide.plugins.browser.browsejdbc;

import javax.swing.Icon;

import com.hackerdude.apps.sqlide.ProgramIcons;
import com.hackerdude.apps.sqlide.dataaccess.DatabaseProcess;
import com.hackerdude.apps.sqlide.pluginapi.BrowserExtensionPluginIF;
import com.hackerdude.apps.sqlide.pluginapi.NodeIDEBase;

/**
 * The Basic JDBC Introspector implements the base browser functionality,
 * including Catalogs, schemas, tables and columns.
 * <P>Basically anything about the database you can find out through straight
 * JDBC calls can be added here.
 *
 * 
 * @author David Martinez
 * @version 1.0
 */
public class BasicJDBCIntrospector implements BrowserExtensionPluginIF {

	/**
	 * Creates a basic introspector
	 */
	public BasicJDBCIntrospector() {

	}

	public void requestAddSubNodes(NodeIDEBase parentNode) {
		DatabaseProcess db = parentNode.getDatabaseProcess();
		if ( !(parentNode instanceof com.hackerdude.apps.sqlide.nodes.ItemServerNode) ) return;
//		System.out.println("Adding items for subnode of class "+parentNode.getClass().getName());

		/**
		 * Note: I'm assuming that if the JDBC name for the item does
		 * not exist, the node should not be there because that item type
		 * is not supported (for catalogs & schemas).
		 */
		NodeIDEBase theNode = null;
		try {
			theNode = new CategoryCatalogsNode(db);
			if ( theNode.toString() != null && ! theNode.toString().equals("") ) parentNode.add( theNode );
		}
		catch (Exception ex) {
		}
		try {
			theNode = new CategorySchemaNode(db); //  devicesNodes.elementAt(i);
			if ( theNode.toString() != null && ! theNode.toString().equals("") ) parentNode.add( theNode );
		}
		catch (Exception ex) {
		}

		/*
		   If the back-end does not support catalogs or schemas, then create
		   simple nodes with tables and stored procedures underneath the
		   connection. This is for the benefit of backends like
		   hypersonic which do not support this concept.
		 */

		/** @todo We need to add the list of objects that are outside catalogs/schemas,
		 for the benefit of those who don't have such concepts. */

		if ( parentNode.getChildCount() == 0 ) {
			parentNode.add(new CategoryTableNode(null, null, db));
			//			parentNode.add(new CategoryStoredProcedureNode(null, null, databaseProcess));
		}

	}

	public void initPlugin() {}

	public String getPluginName() { return "Basic JDBC Introspector"; }

	public String getPluginVersion() { return "0.0";}

	public void freePlugin() {}

	public String getPluginShortName() { return "JDBC Introspector"; }

	public Icon getPluginIcon() {
		return ProgramIcons.getInstance().findIcon("images/DataQuery.gif");
	}

}