Package talonsoalbi_at_gmail_dot_com.ssoxmatch.db

Class DBEntry

java.lang.Object

talonsoalbi_at_gmail_dot_com.ssoxmatch.db.DBEntry

public class DBEntry
extends Object

Database entry class, to get the list of column names and format for a given table, with a query like:

 SELECT column_name, data_type FROM information_schema.columns WHERE table_name = ...
 

Author:

talonso

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static enum	DBEntry.FORMAT	Database formats for the columns

Constructor Summary

Constructors

Constructor	Description
DBEntry(String n, DBEntry.FORMAT f)	Constructor

Method Summary

Modifier and Type	Method	Description
DBEntry.FORMAT	getFormat()	Returns the entry format
String	getName()	Returns the entry name
static ArrayList<DBEntry>	parseQueryResults(StringBuilder s)	Parse the results of a query of type
void	setFormat(DBEntry.FORMAT format)	Sets the entry format
void	setName(String name)	Sets the entry name

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

DBEntry

public DBEntry(String n,
 DBEntry.FORMAT f)

Constructor

Parameters:

n - Name

f - Format

Method Details

getFormat

public DBEntry.FORMAT getFormat()

Returns the entry format

Returns:

the format

setFormat

public void setFormat(DBEntry.FORMAT format)

Sets the entry format

Parameters:

format - the format to set

getName

public String getName()

Returns the entry name

Returns:

the name

setName

public void setName(String name)

Sets the entry name

Parameters:

name - the name to set

parseQueryResults

public static ArrayList<DBEntry> parseQueryResults(StringBuilder s)

Parse the results of a query of type

 SELECT column_name, data_type FROM information_schema.columns WHERE table_name = ...
 

, identifying the column names and their data types

Parameters:

s - The query results

Returns:

The list of database entries