net.aditsu.depeche

Class MySQLProvider

java.lang.Object

net.aditsu.depeche.Provider

net.aditsu.depeche.MySQLProvider

All Implemented Interfaces:

Serializable

public class MySQLProvider
extends Provider

Provider implementation for MySQL

Author:

aditsu

See Also:

Serialized Form

Constructor Summary

Constructors

Constructor and Description
MySQLProvider(ConnSource cs) Creates a MySQLProvider using a connection source
MySQLProvider(String host, int port, String db, String user, String password) Creates a MySQLProvider using connection details including port number
MySQLProvider(String host, String db, String user, String password) Creates a MySQLProvider using connection details

Method Summary

Methods

Modifier and Type	Method and Description
static DSConnSource	createConnSource(String host, int port, String db, String user, String password) Creates a MySQL connection source
RawQuery	getColumnCommentQuery(String table, String column, String value) Returns a query for setting a comment on a table column
String	getCreateTableSQL(TableInfo tinfo) Returns an SQL command for creating a table given its information, with no constraints other than primary key
String	getDropFKeySQL(FKey fk) Returns an SQL command for dropping a foreign key constraint
long	getLongLastId(Conn conn) Returns the last generated auto-increment value in a given connection as a long value

Methods inherited from class net.aditsu.depeche.Provider

addColumn, addColumn, addFKey, addFKey, addUnique, addUnique, batchInsert, batchInsert, clearTable, close, createTable, createTable, createView, createView, dropColumn, dropColumn, dropFKey, dropFKey, dropTable, dropTable, dropView, dropView, execute, execute, filter, filter, filter, filterIn, getAddColumnSQL, getAddFKeySQL, getAddUniqueSQL, getAllTables, getAllViews, getColumnDesc, getCreateViewSQL, getDropColumnSQL, getDropTableSQL, getDropViewSQL, getEnumValues, getGenericTableDetails, getGenericTables, getLastId, getName, getProviderRef, getRecord, getRecord, getRecord, getRecord, getRecord, getRecord, getTableInfo, getTableInfo, getTableInfo, getTableInfo, getTables, getTableTypes, getUniqueConstraints, getViewDefinition, getViews, hasFlag, joinCondition, joinCondition, joinCondition, newRecord, newRecord, newRecord, query, query, query, query, query, quote, rawQuery, rawQuery, rawQuote, resolveTable, resolveTable, run, setColumnComment, setColumnComment, setName, setProviderRef, transaction

Methods inherited from class java.lang.Object

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

Constructor Detail

MySQLProvider

public MySQLProvider(ConnSource cs)

Creates a MySQLProvider using a connection source

MySQLProvider

public MySQLProvider(String host,
             String db,
             String user,
             String password)

Creates a MySQLProvider using connection details

MySQLProvider

public MySQLProvider(String host,
             int port,
             String db,
             String user,
             String password)

Creates a MySQLProvider using connection details including port number

Method Detail

createConnSource

public static DSConnSource createConnSource(String host,
                            int port,
                            String db,
                            String user,
                            String password)

Creates a MySQL connection source

getCreateTableSQL

public String getCreateTableSQL(TableInfo tinfo)

Description copied from class: Provider

Returns an SQL command for creating a table given its information, with no constraints other than primary key

Overrides:

getCreateTableSQL in class Provider

getLongLastId

public long getLongLastId(Conn conn)

Description copied from class: Provider

Returns the last generated auto-increment value in a given connection as a long value

Overrides:

getLongLastId in class Provider

getDropFKeySQL

public String getDropFKeySQL(FKey fk)

Description copied from class: Provider

Returns an SQL command for dropping a foreign key constraint

Overrides:

getDropFKeySQL in class Provider

getColumnCommentQuery

public RawQuery getColumnCommentQuery(String table,
                             String column,
                             String value)

Description copied from class: Provider

Returns a query for setting a comment on a table column

Overrides:

getColumnCommentQuery in class Provider