Callable

Class

DataFaucet 1.0 Beta

FRAMES

datafaucet.system
Class datamanager

WEB-INF.cftags.component
        datafaucet.system.kernel
            datafaucet.system.datamanager

public class datamanager
extends kernel
extends kernel

Constructor Summary
`init()`

Method Summary
`any`	`DBCall(string methodname, any source)` returns a query containing information about the columns for a given database table
`struct`	`DBMetaData(any source, [boolean reload='false'])` returns the java metadata for a given datasource, with some data massaging for convenience
`void`	`debug([string datasource=''])`
`any`	`getCacheManager()`
`query`	`getCatalogs(any source)` returns a query containing a list of catalogs in the database server
`query`	`getColumns(any source, string tablename, [boolean reload='false'])` returns a query containing information about the columns for a given database table
`private any`	`getConnection(any source)`
`private any`	`getDSCache(string datasource)`
`private any`	`getDSService()`
`string`	`getDefaultCatalog(any source)`
`string`	`getDriverName(any source)` returns a string from the JDBC connection indication the name of the drivers in use
`query`	`getExportedKeys(any source, string tablename, [boolean reload='false'])` returns a query containing information about the primary key column(s) exported by a specified table
`struct`	`getForeignKeys(any source, string tablename, [boolean reload='false'])`
`query`	`getImportedKeys(any source, string tablename, [boolean reload='false'])` returns a query containing information about the foreign key columns imported by a specified table
`query`	`getIndexes(any source, string tablename, [boolean unique='false'], [boolean approx='true'])` returns a query containing information about the primary key column(s) exported by a specified table
`numeric`	`getLoadTime()`
`any`	`getMissingMethodParser()`
`query`	`getPrimaryKeys([any source], string tablename, [boolean reload='false'])` returns a query containing information about the primary key column(s) for a specified table
`query`	`getProcParams(any source, string procedure, [boolean reload='false'])` returns a query containing information about the parameters for a given stored procedure
`query`	`getProcedures([string source='primary'], [string procedures='%'])` returns a query containing information about the columns for a given database table
`private any`	`getSQLMetaData(any source)`
`struct`	`getSQLTypes(any sqltypes)`
`query`	`getSchemas(any source)` returns a query containing a list of schemas in the database server
`string`	`getServerName(any source)` returns a string from the JDBC connection indication the name of the drivers in use
`string`	`getServerVersion(any source)` returns a string from the JDBC connection indication the version of the drivers in use
`private any`	`getSettings(string datasource)`
`query`	`getTables(any source, [string tablename='%'], [string types='table,view'])` returns a query containing information about the columns for a given database table
`any`	`getValidator()`
`any`	`isModified(numeric before='[runtime expression]')`
`string`	`jdbcType(string typeid)`
`string`	`readOnly(any source, string tablename, [string columns=''])` sets a readonly flag for multiple columns in a given table in the table-column metadata - returns a comma delimited list of the columns flagged
`any`	`reset([string datasource=''])`
`any`	`resultSetToQuery(any resultset, [string addcolumns=''])` returns a query from a Java ResultSet object
`any`	`setCacheManager(any CacheManager)`

Methods inherited from class datafaucet.system.kernel
`arg, componentExists, getDataFaucet, getFaucetObject, getFile, getFileModified, getObject, getPlumbing, getTransaction, getTransactionManager, newTransaction, parseDate, setTransaction`

Methods inherited from class WEB-INF.cftags.component

Constructor Detail

init

public init()

Method Detail

DBCall

public any DBCall(string methodname, any source)

returns a query containing information about the columns for a given database table

DBMetaData

public struct DBMetaData(any source, [boolean reload='false'])

returns the java metadata for a given datasource, with some data massaging for convenience

debug

public void debug([string datasource=''])

Parameters:: datasource

getCacheManager

public any getCacheManager()

getCatalogs

public query getCatalogs(any source)

returns a query containing a list of catalogs in the database server

getColumns

public query getColumns(any source, string tablename, [boolean reload='false'])

returns a query containing information about the columns for a given database table

getConnection

private any getConnection(any source)

Parameters:: source

getDSCache

private any getDSCache(string datasource)

Parameters:: datasource

getDSService

private any getDSService()

getDefaultCatalog

public string getDefaultCatalog(any source)

Parameters:: source

getDriverName

public string getDriverName(any source)

returns a string from the JDBC connection indication the name of the drivers in use

getExportedKeys

public query getExportedKeys(any source, string tablename, [boolean reload='false'])

returns a query containing information about the primary key column(s) exported by a specified table

getForeignKeys

public struct getForeignKeys(any source, string tablename, [boolean reload='false'])

Parameters:: source; tablename; reload

getImportedKeys

public query getImportedKeys(any source, string tablename, [boolean reload='false'])

returns a query containing information about the foreign key columns imported by a specified table

getIndexes

public query getIndexes(any source, string tablename, [boolean unique='false'], [boolean approx='true'])

returns a query containing information about the primary key column(s) exported by a specified table

getLoadTime

public numeric getLoadTime()

getMissingMethodParser

public any getMissingMethodParser()

getPrimaryKeys

public query getPrimaryKeys([any source], string tablename, [boolean reload='false'])

returns a query containing information about the primary key column(s) for a specified table

getProcParams

public query getProcParams(any source, string procedure, [boolean reload='false'])

returns a query containing information about the parameters for a given stored procedure

getProcedures

public query getProcedures([string source='primary'], [string procedures='%'])

returns a query containing information about the columns for a given database table

getSQLMetaData

private any getSQLMetaData(any source)

Parameters:: source

getSQLTypes

public struct getSQLTypes(any sqltypes)

Parameters:: sqltypes

getSchemas

public query getSchemas(any source)

returns a query containing a list of schemas in the database server

getServerName

public string getServerName(any source)

returns a string from the JDBC connection indication the name of the drivers in use

getServerVersion

public string getServerVersion(any source)

returns a string from the JDBC connection indication the version of the drivers in use

getSettings

private any getSettings(string datasource)

Parameters:: datasource

getTables

public query getTables(any source, [string tablename='%'], [string types='table,view'])

returns a query containing information about the columns for a given database table

getValidator

public any getValidator()

isModified

public any isModified(numeric before='[runtime expression]')

Parameters:: before

jdbcType

public string jdbcType(string typeid)

Parameters:: typeid

readOnly

public string readOnly(any source, string tablename, [string columns=''])

sets a readonly flag for multiple columns in a given table in the table-column metadata - returns a comma delimited list of the columns flagged

reset

public any reset([string datasource=''])

Parameters:: datasource

resultSetToQuery

public any resultSetToQuery(any resultset, [string addcolumns=''])

returns a query from a Java ResultSet object

setCacheManager

public any setCacheManager(any CacheManager)

Parameters:: CacheManager

Overview

Package