com.imageworks.migration

MysqlDatabaseAdapter

class MysqlDatabaseAdapter extends DatabaseAdapter

Linear Supertypes
DatabaseAdapter, AnyRef, Any
Ordering
  1. Alphabetic
  2. By inheritance
Inherited
  1. MysqlDatabaseAdapter
  2. DatabaseAdapter
  3. AnyRef
  4. Any
  1. Hide All
  2. Show all
Learn more about member selection
Visibility
  1. Public
  2. All

Instance Constructors

  1. new MysqlDatabaseAdapter(schemaNameOpt: Option[String])

Type Members

  1. sealed trait PrivilegeTarget extends AnyRef

    Definition Classes
    DatabaseAdapter
  2. case class TablePrivilegeTarget(tableName: String) extends PrivilegeTarget with Product with Serializable

    Definition Classes
    DatabaseAdapter

Value Members

  1. final def !=(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  2. final def !=(arg0: Any): Boolean

    Definition Classes
    Any
  3. final def ##(): Int

    Definition Classes
    AnyRef → Any
  4. final def ==(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  5. final def ==(arg0: Any): Boolean

    Definition Classes
    Any
  6. object SchemaPrivilegeTarget extends PrivilegeTarget with Product with Serializable

    Definition Classes
    DatabaseAdapter
  7. val addingForeignKeyConstraintCreatesIndex: Boolean

    This value is true if the database implicitly adds an index on the column that has a foreign key constraint added to it.

    This value is true if the database implicitly adds an index on the column that has a foreign key constraint added to it.

    The following SQL can be used to test the database. The last statement will fail with a message that there already is an index on the column.

    CREATE TABLE parent (pk INT PRIMARY KEY); CREATE TABLE child (pk INT PRIMARY KEY, pk_parent INT NOT NULL); ALTER TABLE child ADD CONSTRAINT idx_child_pk_parent FOREIGN KEY (pk_parent) REFERENCES parent (pk); CREATE INDEX idx_child_pk_parent ON child (pk_parent);

    Definition Classes
    MysqlDatabaseAdapterDatabaseAdapter
  8. def alterColumnSql(schemaNameOpt: Option[String], columnDefinition: ColumnDefinition): String

    Attributes
    protected
    Definition Classes
    MysqlDatabaseAdapterDatabaseAdapter
  9. def alterColumnSql(tableName: String, columnName: String, columnType: SqlType, options: ColumnOption*): String

    Different databases require different SQL to alter a column's definition.

    Different databases require different SQL to alter a column's definition. Uses the schemaNameOpt defined in the adapter.

    tableName

    the name of the table with the column

    columnName

    the name of the column

    columnType

    the type the column is being altered to

    options

    a possibly empty array of column options to customize the column

    returns

    the SQL to alter the column

    Definition Classes
    DatabaseAdapter
  10. def alterColumnSql(schemaNameOpt: Option[String], tableName: String, columnName: String, columnType: SqlType, options: ColumnOption*): String

    Different databases require different SQL to alter a column's definition.

    Different databases require different SQL to alter a column's definition.

    schemaNameOpt

    the optional schema name to qualify the table name

    tableName

    the name of the table with the column

    columnName

    the name of the column

    columnType

    the type the column is being altered to

    options

    a possibly empty array of column options to customize the column

    returns

    the SQL to alter the column

    Definition Classes
    DatabaseAdapter
  11. val alterTableDropForeignKeyConstraintPhrase: String

    The SQL keyword(s) or "phrase" used to drop a foreign key constraint.

    The SQL keyword(s) or "phrase" used to drop a foreign key constraint. For example, Derby, Oracle and PostgreSQL use

    ALTER TABLE child DROP CONSTRAINT idx_child_pk_parent; ^^^^^^^^^^

    while MySQL uses

    ALTER TABLE child DROP FOREIGN KEY idx_child_pk_parent; ^^^^^^^^^^^

    Definition Classes
    MysqlDatabaseAdapterDatabaseAdapter
  12. final def asInstanceOf[T0]: T0

    Definition Classes
    Any
  13. def clone(): AnyRef

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws()
  14. def columnDefinitionFactory(columnType: SqlType, characterSetOpt: Option[CharacterSet]): ColumnDefinition

    Concrete subclasses must define this method that returns a newly constructed, but uninitialized, concrete ColumnDefinition subclass for the given SQL data type and optional CharacterSet.

    Concrete subclasses must define this method that returns a newly constructed, but uninitialized, concrete ColumnDefinition subclass for the given SQL data type and optional CharacterSet.

    columnType

    the column's data type

    characterSetOpt

    an optional CharacterSet

    returns

    a newly constructed but uninitialized ColumnDefinition for the columnType

    Definition Classes
    MysqlDatabaseAdapterDatabaseAdapter
  15. final def eq(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  16. def equals(arg0: Any): Boolean

    Definition Classes
    AnyRef → Any
  17. def finalize(): Unit

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws()
  18. def generateCheckConstraintName(on: On, options: CheckOption*): (String, List[CheckOption])

    Given a check constraint, create a name for it, using a Name() if it is provided in the options.

    Given a check constraint, create a name for it, using a Name() if it is provided in the options.

    on

    the table and columns the check constraint is on

    options

    a varargs list of CheckOptions

    returns

    a two-tuple with the calculated name or the overridden name from a Name and the remaining options

    Definition Classes
    DatabaseAdapter
  19. final def getClass(): Class[_]

    Definition Classes
    AnyRef → Any
  20. def grantOnSchemaSql(grantees: Array[User], privileges: SchemaPrivilege*): String

    Grant one or more privileges to a schema.

    Grant one or more privileges to a schema.

    grantees

    one or more objects to grant the new privileges to

    privileges

    one or more SchemaPrivilege objects describing the types of privileges to grant

    returns

    the SQL to grant privileges

    Definition Classes
    DatabaseAdapter
  21. def grantOnSchemaSql(schemaName: String, grantees: Array[User], privileges: SchemaPrivilege*): String

    Grant one or more privileges to a schema.

    Grant one or more privileges to a schema.

    schemaName

    the name of the schema to grant privileges on

    grantees

    one or more objects to grant the new privileges to

    privileges

    one or more SchemaPrivilege objects describing the types of privileges to grant

    returns

    the SQL to grant privileges

    Definition Classes
    DatabaseAdapter
  22. def grantOnTableSql(tableName: String, grantees: Array[User], privileges: GrantPrivilegeType*): String

    Different databases have different limitations on the GRANT statement.

    Different databases have different limitations on the GRANT statement. Uses the schemaNameOpt defined in the adapter.

    tableName

    the name of the table with the index

    grantees

    one or more objects to grant the new privileges to

    privileges

    one or more GrantPrivilegeType objects describing the types of privileges to grant

    returns

    the SQL to grant privileges

    Definition Classes
    DatabaseAdapter
  23. def grantOnTableSql(schemaNameOpt: Option[String], tableName: String, grantees: Array[User], privileges: GrantPrivilegeType*): String

    Different databases have different limitations on the GRANT statement.

    Different databases have different limitations on the GRANT statement.

    schemaNameOpt

    the optional schema name to qualify the table name

    tableName

    the name of the table with the index

    grantees

    one or more objects to grant the new privileges to

    privileges

    one or more GrantPrivilegeType objects describing the types of privileges to grant

    returns

    the SQL to grant privileges

    Definition Classes
    DatabaseAdapter
  24. def hashCode(): Int

    Definition Classes
    AnyRef → Any
  25. final def isInstanceOf[T0]: Boolean

    Definition Classes
    Any
  26. def lockTableSql(schemaNameOpt: Option[String], tableName: String): String

    Different databases require different SQL to lock a table.

    Different databases require different SQL to lock a table.

    schemaNameOpt

    the optional schema name to qualify the table name

    tableName

    the name of the table to lock

    returns

    the SQL to lock the table

    Definition Classes
    MysqlDatabaseAdapterDatabaseAdapter
  27. def lockTableSql(tableName: String): String

    Different databases require different SQL to lock a table.

    Different databases require different SQL to lock a table.

    tableName

    the name of the table to lock

    returns

    the SQL to lock the table

    Definition Classes
    DatabaseAdapter
  28. final val logger: Logger

    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  29. final def ne(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  30. def newColumnDefinition(tableName: String, columnName: String, columnType: SqlType, options: ColumnOption*): ColumnDefinition

    Given a table name, column name and column data type, return a newly constructed and fully initialized ColumnDefinition.

    Given a table name, column name and column data type, return a newly constructed and fully initialized ColumnDefinition. The class of the returned ColumnDefinition only depends upon the input column data type.

    tableName

    the name of the table the column is in

    columnName

    the column's name

    columnType

    the data type of the column

    options

    a list of column options customizing the column

    returns

    a new ColumnDefinition

    Definition Classes
    DatabaseAdapter
  31. final def notify(): Unit

    Definition Classes
    AnyRef
  32. final def notifyAll(): Unit

    Definition Classes
    AnyRef
  33. def onDeleteSql(onDeleteOpt: Option[OnDelete]): String

    Return the SQL text in a foreign key relationship for an optional ON DELETE clause.

    Return the SQL text in a foreign key relationship for an optional ON DELETE clause.

    onDeleteOpt

    an Option[OnDelete]

    returns

    the SQL text to append to the SQL to create a foreign key relationship

    Definition Classes
    DatabaseAdapter
  34. def onUpdateSql(onUpdateOpt: Option[OnUpdate]): String

    Return the SQL text in a foreign key relationship for an optional ON UPDATE clause.

    Return the SQL text in a foreign key relationship for an optional ON UPDATE clause.

    onUpdateOpt

    an Option[OnUpdate]

    returns

    the SQL text to append to the SQL to create a foreign key relationship

    Definition Classes
    DatabaseAdapter
  35. val quoteCharacter: Char

    The character that is used to quote identifiers.

    The character that is used to quote identifiers.

    Definition Classes
    MysqlDatabaseAdapterDatabaseAdapter
  36. def quoteColumnName(columnName: String): String

    Quote a column name.

    Quote a column name.

    columnName

    the name of the column to quote

    returns

    a properly quoted column name

    Definition Classes
    DatabaseAdapter
  37. def quoteIndexName(schemaNameOpt: Option[String], indexName: String): String

    Quote an index name.

    Quote an index name.

    schemaNameOpt

    an optional schema name

    indexName

    the name of the index to quote

    returns

    a properly quoted index name

    Definition Classes
    DatabaseAdapter
  38. def quoteSchemaName(schemaName: String): String

    Quote a schema name.

    Quote a schema name.

    schemaName

    the name of the schema to quote

    returns

    a properly quoted schema name

    Definition Classes
    DatabaseAdapter
  39. def quoteTableName(tableName: String): String

    Quote a table name.

    Quote a table name. If the database adapter was provided with a default schema name, then the quoted table name is prepended with the quoted schema name along with a '.'.

    tableName

    the name of the table to quote

    returns

    the table name properly quoted for the database, prepended with the quoted schema name and a '.' if the database adapter was provided with a default schema name

    Definition Classes
    DatabaseAdapter
  40. def quoteTableName(schemaNameOpt: Option[String], tableName: String): String

    Quote a table name, prepending the quoted schema name to the quoted table name along with a '.

    Quote a table name, prepending the quoted schema name to the quoted table name along with a '.' if a schema name is provided.

    schemaNameOpt

    an optional schema name

    tableName

    the name of the table to quote

    returns

    the table name properly quoted for the database, prepended with the quoted schema name and a '.' if a schema name is provided

    Definition Classes
    DatabaseAdapter
  41. def removeColumnSql(tableName: String, columnName: String): String

    Different databases require different SQL to drop a column.

    Different databases require different SQL to drop a column. Uses the schemaNameOpt defined in the adapter.

    tableName

    the name of the table with the column

    columnName

    the name of the column

    returns

    the SQL to drop the column

    Definition Classes
    DatabaseAdapter
  42. def removeColumnSql(schemaNameOpt: Option[String], tableName: String, columnName: String): String

    Different databases require different SQL to drop a column.

    Different databases require different SQL to drop a column.

    schemaNameOpt

    the optional schema name to qualify the table name

    tableName

    the name of the table with the column

    columnName

    the name of the column

    returns

    the SQL to drop the column

    Definition Classes
    DatabaseAdapter
  43. def removeIndexSql(schemaNameOpt: Option[String], tableName: String, indexName: String): String

    Different databases require different SQL to drop an index.

    Different databases require different SQL to drop an index.

    schemaNameOpt

    the optional schema name to qualify the table name

    tableName

    the name of the table with the index

    indexName

    the name of the index

    returns

    the SQL to drop the index

    Definition Classes
    MysqlDatabaseAdapterDatabaseAdapter
  44. def removeIndexSql(tableName: String, indexName: String): String

    Different databases require different SQL to drop an index.

    Different databases require different SQL to drop an index. Uses the schemaNameOpt defined in the adapter.

    tableName

    the name of the table with the index

    indexName

    the name of the index

    returns

    the SQL to drop the index

    Definition Classes
    DatabaseAdapter
  45. def revokeOnSchemaSql(grantees: Array[User], privileges: SchemaPrivilege*): String

    Revoke one or more privileges from a schema.

    Revoke one or more privileges from a schema.

    grantees

    one or more objects to revoke the privileges from

    privileges

    one or more SchemaPrivilege objects describing the types of privileges to revoke

    returns

    the SQL to revoke privileges

    Definition Classes
    DatabaseAdapter
  46. def revokeOnSchemaSql(schemaName: String, grantees: Array[User], privileges: SchemaPrivilege*): String

    Revoke one or more privileges from a schema.

    Revoke one or more privileges from a schema.

    schemaName

    the name of the schema to revoke privileges from

    grantees

    one or more objects to revoke the privileges from

    privileges

    one or more SchemaPrivilege objects describing the types of privileges to revoke

    returns

    the SQL to revoke privileges

    Definition Classes
    DatabaseAdapter
  47. def revokeOnTableSql(tableName: String, grantees: Array[User], privileges: GrantPrivilegeType*): String

    Different databases have different limitations on the REVOKE statement.

    Different databases have different limitations on the REVOKE statement. Uses the schemaNameOpt defined in the adapter.

    tableName

    the name of the table with the index

    grantees

    one or more objects to revoke the privileges from

    privileges

    one or more GrantPrivilegeType objects describing the types of privileges to revoke

    returns

    the SQL to revoke privileges

    Definition Classes
    DatabaseAdapter
  48. def revokeOnTableSql(schemaNameOpt: Option[String], tableName: String, grantees: Array[User], privileges: GrantPrivilegeType*): String

    Different databases have different limitations on the REVOKE statement.

    Different databases have different limitations on the REVOKE statement.

    schemaNameOpt

    the optional schema name to qualify the table name

    tableName

    the name of the table with the index

    grantees

    one or more objects to revoke the privileges from

    privileges

    one or more GrantPrivilegeType objects describing the types of privileges to revoke

    returns

    the SQL to revoke privileges

    Definition Classes
    DatabaseAdapter
  49. val schemaNameOpt: Option[String]

    Definition Classes
    MysqlDatabaseAdapterDatabaseAdapter
  50. val supportsCheckConstraints: Boolean

    If the database supports table and column check constraints.

    If the database supports table and column check constraints.

    Definition Classes
    MysqlDatabaseAdapterDatabaseAdapter
  51. final def synchronized[T0](arg0: ⇒ T0): T0

    Definition Classes
    AnyRef
  52. def toString(): String

    Definition Classes
    AnyRef → Any
  53. val unquotedNameConverter: CasePreservingUnquotedNameConverter.type

    To properly quote table names the database adapter needs to know how the database treats unquoted names.

    To properly quote table names the database adapter needs to know how the database treats unquoted names.

    Definition Classes
    MysqlDatabaseAdapterDatabaseAdapter
  54. val userFactory: MysqlUserFactory.type

    A factory for creating User instances from a bare user name.

    A factory for creating User instances from a bare user name.

    Definition Classes
    MysqlDatabaseAdapterDatabaseAdapter
  55. val vendor: Mysql.type

    The vendor of the database.

    The vendor of the database.

    Definition Classes
    MysqlDatabaseAdapterDatabaseAdapter
  56. final def wait(): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws()
  57. final def wait(arg0: Long, arg1: Int): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws()
  58. final def wait(arg0: Long): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws()

Inherited from DatabaseAdapter

Inherited from AnyRef

Inherited from Any

Ungrouped