uk.ac.ed.epcc.webapp.jdbc

Class MysqlSQLContext

java.lang.Object

uk.ac.ed.epcc.webapp.jdbc.MysqlSQLContext

All Implemented Interfaces:

Contexed, SQLContext

public class MysqlSQLContext
extends java.lang.Object
implements SQLContext

Constructor Summary

Constructors

Constructor and Description
MysqlSQLContext(AppContext ctx, DatabaseService serv, java.sql.Connection conn)

Method Summary

Modifier and Type	Method and Description
void	close() Clean up internal state
DateSQLExpression	convertToDate(SQLExpression<? extends java.lang.Number> val, long res) Convert a Number SQLExpression to a date.
SQLExpression<? extends java.lang.Number>	convertToMilliseconds(SQLExpression<java.util.Date> expr) Convert a Date SQLExpression to milliseconds
SQLExpression<? extends java.lang.Number>	dateDifference(long resolution, SQLExpression<java.util.Date> start, SQLExpression<java.util.Date> end) generate a SQLExpression for the difference between two dates.
java.sql.Connection	getConnection() Get a database connection for the current context
java.lang.String	getConnectionHost() Get an identifying string for the database host we are connected to.
AppContext	getContext()
FieldTypeVisitor	getCreateVisitor(java.lang.StringBuilder sb, java.util.List<java.lang.Object> args) Get a FieldTypeVisitor used to generate table specifications.
DatabaseService	getService() get the DatabaseService
SQLExpression<java.lang.String>	hashFunction(Hash h, SQLExpression<java.lang.String> arg) Generate a SQL hash function.
boolean	isReadOnly() Is this a read-only connection
java.lang.StringBuilder	quote(java.lang.StringBuilder sb, java.lang.String name) Quote a field or table name
java.lang.StringBuilder	quoteQualified(java.lang.StringBuilder sb, java.lang.String table, java.lang.String name) Quote a field or table name

Methods inherited from class java.lang.Object

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

Methods inherited from interface uk.ac.ed.epcc.webapp.jdbc.SQLContext

convertToSeconds

Constructor Detail

MysqlSQLContext

public MysqlSQLContext(AppContext ctx,
                       DatabaseService serv,
                       java.sql.Connection conn)

Method Detail

getConnection

public java.sql.Connection getConnection()

Description copied from interface: SQLContext

Get a database connection for the current context

Specified by:

getConnection in interface SQLContext

Returns:

quote

public java.lang.StringBuilder quote(java.lang.StringBuilder sb,
                                     java.lang.String name)

Description copied from interface: SQLContext

Quote a field or table name

Specified by:

quote in interface SQLContext

Parameters:

sb - StringBuilder

Returns:

modified StringBuilder

quoteQualified

public java.lang.StringBuilder quoteQualified(java.lang.StringBuilder sb,
                                              java.lang.String table,
                                              java.lang.String name)

Description copied from interface: SQLContext

Quote a field or table name

Specified by:

quoteQualified in interface SQLContext

Parameters:

sb - StringBuilder

Returns:

modified StringBuilder

convertToMilliseconds

public SQLExpression<? extends java.lang.Number> convertToMilliseconds(SQLExpression<java.util.Date> expr)

Description copied from interface: SQLContext

Convert a Date SQLExpression to milliseconds

Specified by:

convertToMilliseconds in interface SQLContext

Returns:

SQLExpression

dateDifference

public SQLExpression<? extends java.lang.Number> dateDifference(long resolution,
                                                                SQLExpression<java.util.Date> start,
                                                                SQLExpression<java.util.Date> end)

Description copied from interface: SQLContext

generate a SQLExpression for the difference between two dates.

Specified by:

dateDifference in interface SQLContext

Parameters:

resolution - size of time unit (in milliseconds)

Returns:

SQLExpression

convertToDate

public DateSQLExpression convertToDate(SQLExpression<? extends java.lang.Number> val,
                                       long res)

Description copied from interface: SQLContext

Convert a Number SQLExpression to a date.

Specified by:

convertToDate in interface SQLContext

res - resolution in milliseconds

Returns:

SQLExpression

getCreateVisitor

public FieldTypeVisitor getCreateVisitor(java.lang.StringBuilder sb,
                                         java.util.List<java.lang.Object> args)

Description copied from interface: SQLContext

Get a FieldTypeVisitor used to generate table specifications.

Specified by:

getCreateVisitor in interface SQLContext

Parameters:

sb - StringBuilder to add SQL fragments to

args - List query parameters

Returns:

FieldTypeVisitor

close

public void close()
           throws java.sql.SQLException

Description copied from interface: SQLContext

Clean up internal state

Specified by:

close in interface SQLContext

Throws:

java.sql.SQLException

getContext

public AppContext getContext()

Specified by:

getContext in interface Contexed

hashFunction

public SQLExpression<java.lang.String> hashFunction(Hash h,
                                                    SQLExpression<java.lang.String> arg)
                                             throws CannotUseSQLException

Description copied from interface: SQLContext

Generate a SQL hash function.

Specified by:

hashFunction in interface SQLContext

Parameters:

h - Hash algorithm to apply

arg - SQLExpression to hash

Returns:

SQLExpression

Throws:

CannotUseSQLException

getConnectionHost

public java.lang.String getConnectionHost()

Description copied from interface: SQLContext

Get an identifying string for the database host we are connected to.

Specified by:

getConnectionHost in interface SQLContext

Returns:

getService

public DatabaseService getService()

Description copied from interface: SQLContext

get the DatabaseService

Specified by:

getService in interface SQLContext

Returns:

isReadOnly

public boolean isReadOnly()

Description copied from interface: SQLContext

Is this a read-only connection

Specified by:

isReadOnly in interface SQLContext

Returns: