ERXSQLHelper.MySQLSQLHelper Class Reference

Inherits er::extensions::jdbc::ERXSQLHelper.

Collaboration diagram for ERXSQLHelper.MySQLSQLHelper:

[legend]

List of all members.

Public Member Functions
String	externalTypeForJDBCType (JDBCAdaptor adaptor, int jdbcType)
String	limitExpressionForSQL (EOSQLExpression expression, EOFetchSpecification fetchSpecification, String sql, long start, long end)
String	sqlForCreateIndex (String indexName, String tableName, ColumnIndex...columnIndexes)
String	sqlForCreateUniqueIndex (String indexName, String tableName, ColumnIndex...columnIndexes)
String	sqlForRegularExpressionQuery (String key, String value)
int	varcharLargeColumnWidth ()
int	varcharLargeJDBCType ()
Protected Member Functions
Pattern	commentPattern ()
Private Member Functions
void	_appendIndexColNames (StringBuffer sql, ColumnIndex...columnIndexes)

---

Member Function Documentation

void _appendIndexColNames	(	StringBuffer	sql,
		ColumnIndex...	columnIndexes
	)			[private]

Pattern commentPattern

(

)

[protected]

Returns a pattern than matches lines that start with "--".

Returns:

regex pattern that indicates this line is an SQL comment

Reimplemented from ERXSQLHelper.

String externalTypeForJDBCType	(	JDBCAdaptor	adaptor,
		int	jdbcType
	)

We know better than EOF.

For any other case, we pass it up to the default impl.

Parameters:

	adaptor	the adaptor to retrieve an external type for
	jdbcType	the JDBC type number

Returns:

a guess at the external type name to use

Reimplemented from ERXSQLHelper.

String limitExpressionForSQL	(	EOSQLExpression	expression,
		EOFetchSpecification	fetchSpecification,
		String	sql,
		long	start,
		long	end
	)

Reimplemented from ERXSQLHelper.

String sqlForCreateIndex	(	String	indexName,
		String	tableName,
		ColumnIndex...	columnIndexes
	)

Returns the SQL expression for creating an index on the given set of columns

Parameters:

	indexName	the name of the index to create
	tableName	the name of the containing table
	columnIndexes	the list of columns to index on

Returns:

a SQL expression

Reimplemented from ERXSQLHelper.

String sqlForCreateUniqueIndex	(	String	indexName,
		String	tableName,
		ColumnIndex...	columnIndexes
	)

Returns the SQL expression for creating a unique index on the given set of columns

Parameters:

	indexName	the name of the index to create
	tableName	the name of the containing table
	columnIndexes	the list of columns to index on

Returns:

a SQL expression

Reimplemented from ERXSQLHelper.

String sqlForRegularExpressionQuery	(	String	key,
		String	value
	)

Returns the SQL expression for a regular expression query.

Parameters:

	key
	value

Returns:

the regex SQL

Reimplemented from ERXSQLHelper.

int varcharLargeColumnWidth

(

)

Returns the width that should be used for a varcharLarge column in migrations.

Returns:

the width that should be used for a varcharLarge column in migrations

Reimplemented from ERXSQLHelper.

int varcharLargeJDBCType

(

)

Returns the JDBCType that should be used for a varcharLarge column in migrations.

Returns:

the JDBCType that should be used for a varcharLarge column in migrations

Reimplemented from ERXSQLHelper.

---

The documentation for this class was generated from the following file:

• /opt/source/Wonder/Frameworks/Core/ERExtensions/Sources/er/extensions/jdbc/ERXSQLHelper.java