com.partnersoft.sql

Class MySqlDialect

java.lang.Object

com.partnersoft.sql.GenericSqlDialect

com.partnersoft.sql.MySqlDialect

All Implemented Interfaces:

Lib, SqlDialect

Direct Known Subclasses:

SqliteDialect

public class MySqlDialect
extends GenericSqlDialect

SqlDialect for MySql databases.

Copyright 2010 Partner Software, Inc.

Author:

Rich Stepanski

Constructor Summary

Constructors

Constructor and Description
MySqlDialect()

Method Summary

Methods

Modifier and Type	Method and Description
java.lang.String	cogTypeToSqlType(CogType type) Helper for converting from a CogType to a Sql flavor specific data type.
java.lang.String	createTable(CogSchema schema, CogStructureType tableType) Returns complete Sql create table statement.
java.lang.String	describeTable(java.lang.String tableName, java.lang.String databaseName) Returns sql for describing a table.
java.lang.String	describleTableColumnKey() Returns key name for column name found in describe table ResultSet
java.lang.String	describleTableTypeKey() Returns key name for column type found in describe table ResultSet
boolean	isDescribeTableSupported() Returns true if this flavor of sql supports describe table via sql statments.
boolean	isListDatabasesSupported() Returns true if this flavor of sql supports list databases via sql statements.
boolean	isListTablesSupported() Returns true if this flavor of sql supports list tables via sql statements.
java.lang.String	listDatabases() Returns sql for listing databases If isDescribeTableSupported() returns false, should throw an UnsupportedOperationException
java.lang.String	listTables(java.lang.String databaseName) Returns sql for listing table names in database.
java.lang.String	selectSql(DataRecordQuery query, CogStructureType tableType) Returns complete Sql select statement.
java.lang.String	sqlTypeToCogType(java.lang.String sqlType) Helper for converting from a Sql data type to a Cog value type.

Methods inherited from class com.partnersoft.sql.GenericSqlDialect

addColumn, alterColumn, createTableFromSelect, dbToObject, dropColumn, handleSorts, isAlterColumnSupported, listFields, objectToDb, objectToDbSql, parseFilter, renameTable

Methods inherited from class java.lang.Object

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

Constructor Detail

MySqlDialect

public MySqlDialect()

Method Detail

selectSql

public java.lang.String selectSql(DataRecordQuery query,
                         CogStructureType tableType)

Description copied from interface: SqlDialect

Returns complete Sql select statement.

Specified by:

selectSql in interface SqlDialect

Overrides:

selectSql in class GenericSqlDialect

Parameters:

query - - Query describing select statement.

tableType - - CogStructureType defining table. Type name is assumed to be table name.

Returns:

Sql select statement for passed query.

cogTypeToSqlType

public java.lang.String cogTypeToSqlType(CogType type)

Description copied from interface: SqlDialect

Helper for converting from a CogType to a Sql flavor specific data type. Default returns the CogPrimitiveType's sqlType, or VARCHAR(255)

Specified by:

cogTypeToSqlType in interface SqlDialect

Overrides:

cogTypeToSqlType in class GenericSqlDialect

Parameters:

type - - CogType to convert to Sql type.

Returns:

Sql flavor specific data type for the passed cog type.

sqlTypeToCogType

public java.lang.String sqlTypeToCogType(java.lang.String sqlType)

Description copied from interface: SqlDialect

Helper for converting from a Sql data type to a Cog value type.

Specified by:

sqlTypeToCogType in interface SqlDialect

Overrides:

sqlTypeToCogType in class GenericSqlDialect

Parameters:

sqlType - - String representing sql type (ie, varchar(255))

Returns:

Cog value type that matches sql type

createTable

public java.lang.String createTable(CogSchema schema,
                           CogStructureType tableType)

Description copied from interface: SqlDialect

Returns complete Sql create table statement.

Specified by:

createTable in interface SqlDialect

Overrides:

createTable in class GenericSqlDialect

Parameters:

schema - - Schema defining column types.

tableType - - CogStructureType defining table. Type name is assumed to be table name.

Returns:

Sql create table statement for passed schema and cog type.

isListTablesSupported

public boolean isListTablesSupported()

Description copied from interface: SqlDialect

Returns true if this flavor of sql supports list tables via sql statements. False if it does not.

Specified by:

isListTablesSupported in interface SqlDialect

Overrides:

isListTablesSupported in class GenericSqlDialect

Returns:

True if list tables is supported via sql statements, false otherwise

isDescribeTableSupported

public boolean isDescribeTableSupported()

Description copied from interface: SqlDialect

Returns true if this flavor of sql supports describe table via sql statments. False if it does not.

Specified by:

isDescribeTableSupported in interface SqlDialect

Overrides:

isDescribeTableSupported in class GenericSqlDialect

Returns:

True if describe tables is supported via sql statements, false otherwise.

isListDatabasesSupported

public boolean isListDatabasesSupported()

Description copied from interface: SqlDialect

Returns true if this flavor of sql supports list databases via sql statements. False if it does not.

Specified by:

isListDatabasesSupported in interface SqlDialect

Overrides:

isListDatabasesSupported in class GenericSqlDialect

Returns:

True if list databases is supported via sql statements, false otherwise

listDatabases

public java.lang.String listDatabases()

Description copied from interface: SqlDialect

Returns sql for listing databases If isDescribeTableSupported() returns false, should throw an UnsupportedOperationException

Specified by:

listDatabases in interface SqlDialect

Overrides:

listDatabases in class GenericSqlDialect

Returns:

Sql for listing databases

listTables

public java.lang.String listTables(java.lang.String databaseName)

Description copied from interface: SqlDialect

Returns sql for listing table names in database. If isListTablesSupported() returns false, throws an UnsupportedOperationException

Specified by:

listTables in interface SqlDialect

Overrides:

listTables in class GenericSqlDialect

Parameters:

databaseName - - Name of database to list tables from

Returns:

Sql for listing table names

describeTable

public java.lang.String describeTable(java.lang.String tableName,
                             java.lang.String databaseName)

Description copied from interface: SqlDialect

Returns sql for describing a table. if isDescribeTableSupported() returns false, throws an UnsupportedOperationException

Specified by:

describeTable in interface SqlDialect

Overrides:

describeTable in class GenericSqlDialect

Parameters:

tableName - - Name of table to describe

databaseName - - Name of database containing table

Returns:

Sql for describing a table

describleTableColumnKey

public java.lang.String describleTableColumnKey()

Description copied from interface: SqlDialect

Returns key name for column name found in describe table ResultSet

Specified by:

describleTableColumnKey in interface SqlDialect

Overrides:

describleTableColumnKey in class GenericSqlDialect

Returns:

key name for column name

describleTableTypeKey

public java.lang.String describleTableTypeKey()

Description copied from interface: SqlDialect

Returns key name for column type found in describe table ResultSet

Specified by:

describleTableTypeKey in interface SqlDialect

Overrides:

describleTableTypeKey in class GenericSqlDialect

Returns:

key name for column type