edu.iastate.anthill.indus.datasource.schema
Class Schema

java.lang.Object
  edu.iastate.anthill.indus.datasource.schema.Schema

All Implemented Interfaces:

Configable

public class Schema

extends java.lang.Object

implements Configable

Since:

1.0 2004-10-10 1.1 2005-03-25 : add attDBTypeList, toSQL(), modify related functions

Author:

Jie Bao

Field Summary

(package private) java.util.Map	attDBTypeList
(package private) java.util.Map	attTypeList
protected java.lang.String	name

Constructor Summary

Schema()

Schema(java.lang.String name)

Method Summary

boolean	addAttribute(java.lang.String name, java.lang.String type, java.lang.String dbtype)
static Schema	buildFromDBTable(java.sql.Connection conn, java.lang.String tableName, java.lang.String newSchemaName) This method returns a resultset containing the schema information for a particular table.
void	clear()
boolean	deleteAttribute(java.lang.String name)
void	fromGUI(java.lang.String name, javax.swing.table.DefaultTableModel model)
void	fromXML(java.lang.String datatypeinXML)
int	getAttibuteCount()
java.util.Map	getAttList()
java.lang.String	getDBType(java.lang.String name) Get the database type
java.lang.String	getName()
java.lang.String	getType(java.lang.String name)
java.util.Set	getTypeSet() Get the set of all types
void	setName(java.lang.String name)
java.lang.String	toSQL(java.lang.String tableName, java.util.Vector pk, java.util.Map additionalColumn) Generate a table creation SQL sentence
java.lang.String	toString()
void	toTable(javax.swing.table.DefaultTableModel model)
java.lang.String	toXML()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

name

protected java.lang.String name

attTypeList

java.util.Map attTypeList

attDBTypeList

java.util.Map attDBTypeList

Constructor Detail

Schema

public Schema(java.lang.String name)

Schema

public Schema()

Method Detail

toSQL

public java.lang.String toSQL(java.lang.String tableName,
                              java.util.Vector pk,
                              java.util.Map additionalColumn)

Generate a table creation SQL sentence

Returns:

String

Since:

2005-03-25

toString

public java.lang.String toString()

Specified by:

toString in interface Configable

addAttribute

public boolean addAttribute(java.lang.String name,
                            java.lang.String type,
                            java.lang.String dbtype)

deleteAttribute

public boolean deleteAttribute(java.lang.String name)

getType

public java.lang.String getType(java.lang.String name)

getDBType

public java.lang.String getDBType(java.lang.String name)

Get the database type

Parameters:

name - String

Returns:

String

Since:

2005-03-25

getTypeSet

public java.util.Set getTypeSet()

Get the set of all types

Returns:

Set

Since:

2004-10-11

getAttibuteCount

public int getAttibuteCount()

toXML

public java.lang.String toXML()

Specified by:

toXML in interface Configable

clear

public void clear()

fromXML

public void fromXML(java.lang.String datatypeinXML)

Specified by:

fromXML in interface Configable

fromGUI

public void fromGUI(java.lang.String name,
                    javax.swing.table.DefaultTableModel model)

Parameters:

name - String

model - DefaultTableModel model.addColumn("AttributeName"); model.addColumn("Type"); model.addColumn("DatabaseType");

toTable

public void toTable(javax.swing.table.DefaultTableModel model)

buildFromDBTable

public static Schema buildFromDBTable(java.sql.Connection conn,
                                      java.lang.String tableName,
                                      java.lang.String newSchemaName)

This method returns a resultset containing the schema information for a particular table.

Returns:

the resultset.

Throws:

java.lang.Exception - Since - 1:37:15 PM, Mar 23, 2005

getAttList

public java.util.Map getAttList()

getName

public java.lang.String getName()

setName

public void setName(java.lang.String name)