Class

org.squeryl.adapters

MySQLInnoDBAdapter

Related Doc: package adapters

Permalink

class MySQLInnoDBAdapter extends MySQLAdapter

Since MySQL 5.5 InnoDB has replaced MyISAM as the default storage engine. Thus, to take full advantage of the database abilities, new MySQL installs should use this Adapter. see: http://dev.mysql.com/doc/refman/5.5/en/innodb-default-se.html

Source
MySQLInnoDBAdapter.scala
Linear Supertypes
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. MySQLInnoDBAdapter
  2. MySQLAdapter
  3. DatabaseAdapter
  4. AnyRef
  5. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. All

Instance Constructors

  1. new MySQLInnoDBAdapter()

    Permalink

Type Members

  1. class Zip[T] extends AnyRef

    Permalink
    Definition Classes
    DatabaseAdapter
  2. class ZipIterable[T] extends AnyRef

    Permalink
    Definition Classes
    DatabaseAdapter

Value Members

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

    Permalink
    Definition Classes
    AnyRef → Any
  2. final def ##(): Int

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

    Permalink
    Definition Classes
    AnyRef → Any
  4. def aliasExport(parentOfTarget: QueryableExpressionNode, target: SelectElement): String

    Permalink
    Definition Classes
    DatabaseAdapter
  5. final def arrayCreationType(ptype: Class[_]): String

    Permalink
    Definition Classes
    DatabaseAdapter
  6. final def asInstanceOf[T0]: T0

    Permalink
    Definition Classes
    Any
  7. def bigDecimalTypeDeclaration(precision: Int, scale: Int): String

    Permalink
    Definition Classes
    DatabaseAdapter
  8. def bigDecimalTypeDeclaration: String

    Permalink
    Definition Classes
    DatabaseAdapter
  9. def binaryTypeDeclaration: String

    Permalink
    Definition Classes
    MySQLAdapterDatabaseAdapter
  10. def booleanTypeDeclaration: String

    Permalink
    Definition Classes
    DatabaseAdapter
  11. def clone(): AnyRef

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  12. def convertFromBooleanForJdbc(b: Boolean): Boolean

    Permalink

    unused at the moment, since all jdbc drivers adhere to the standard that : 1 == true, false otherwise.

    unused at the moment, since all jdbc drivers adhere to the standard that : 1 == true, false otherwise. If a new driver would not adhere to this, the call can be uncommented in method convertToJdbcValue

    Definition Classes
    DatabaseAdapter
  13. def convertFromUuidForJdbc(u: UUID): AnyRef

    Permalink
    Definition Classes
    DatabaseAdapter
  14. def convertToBooleanForJdbc(rs: ResultSet, i: Int): Boolean

    Permalink

    unused for the same reason as def convertFromBooleanForJdbc (see comment)

    unused for the same reason as def convertFromBooleanForJdbc (see comment)

    Definition Classes
    DatabaseAdapter
  15. def convertToJdbcValue(r: AnyRef): AnyRef

    Permalink

    Converts field instances so they can be fed, and understood by JDBC will not do conversion from None/Some, so @arg r should be a java primitive type or a CustomType

    Converts field instances so they can be fed, and understood by JDBC will not do conversion from None/Some, so @arg r should be a java primitive type or a CustomType

    Definition Classes
    DatabaseAdapter
  16. def convertToUuidForJdbc(rs: ResultSet, i: Int): UUID

    Permalink
    Definition Classes
    DatabaseAdapter
  17. def createSequenceName(fmd: FieldMetaData): String

    Permalink
    Definition Classes
    DatabaseAdapter
  18. def createStatement(conn: Connection): Statement

    Permalink
    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  19. def currenSession: AbstractSession

    Permalink
    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  20. def databaseTypeFor(fieldMapper: FieldMapper, c: Class[_]): String

    Permalink
    Definition Classes
    DatabaseAdapter
  21. def databaseTypeFor(fmd: FieldMetaData): String

    Permalink
    Definition Classes
    DatabaseAdapter
  22. def dateTypeDeclaration: String

    Permalink
    Definition Classes
    DatabaseAdapter
  23. def doubleArrayTypeDeclaration: String

    Permalink
    Definition Classes
    DatabaseAdapter
  24. def doubleTypeDeclaration: String

    Permalink
    Definition Classes
    DatabaseAdapter
  25. def dropForeignKeyStatement(foreignKeyTable: Table[_], fkName: String, session: AbstractSession): Unit

    Permalink
    Definition Classes
    DatabaseAdapter
  26. def dropTable(t: Table[_]): Unit

    Permalink
    Definition Classes
    DatabaseAdapter
  27. final def eq(arg0: AnyRef): Boolean

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

    Permalink
    Definition Classes
    AnyRef → Any
  29. def exec[A](s: AbstractSession, sw: StatementWriter)(block: (Iterable[StatementParam]) ⇒ A): A

    Permalink
    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  30. def execFailSafeExecute(sw: StatementWriter, silenceException: (SQLException) ⇒ Boolean): Unit

    Permalink

    Some methods like 'dropTable' issue their statement, and will silence the exception.

    Some methods like 'dropTable' issue their statement, and will silence the exception. For example dropTable will silence when isTableDoesNotExistException(theExceptionThrown). It must be used carefully, and an exception should not be silenced unless identified.

    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  31. def executeQuery(s: AbstractSession, sw: StatementWriter): (ResultSet, PreparedStatement)

    Permalink
    Definition Classes
    DatabaseAdapter
  32. def executeUpdate(s: AbstractSession, sw: StatementWriter): (Int, PreparedStatement)

    Permalink
    Definition Classes
    DatabaseAdapter
  33. def executeUpdateAndCloseStatement(s: AbstractSession, sw: StatementWriter): Int

    Permalink
    Definition Classes
    DatabaseAdapter
  34. def executeUpdateForInsert(s: AbstractSession, sw: StatementWriter, ps: PreparedStatement): Int

    Permalink
    Definition Classes
    DatabaseAdapter
  35. def failureOfStatementRequiresRollback: Boolean

    Permalink
    Definition Classes
    DatabaseAdapter
  36. def fieldAlias(n: QueryableExpressionNode, fse: FieldSelectElement): String

    Permalink
    Definition Classes
    DatabaseAdapter
  37. def fillParamsInto(params: Iterable[StatementParam], s: PreparedStatement): Unit

    Permalink
    Definition Classes
    DatabaseAdapter
  38. def finalize(): Unit

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  39. def floatTypeDeclaration: String

    Permalink
    Definition Classes
    MySQLAdapterDatabaseAdapter
  40. def foreignKeyConstraintName(foreignKeyTable: Table[_], idWithinSchema: Int): String

    Permalink
    Definition Classes
    DatabaseAdapter
  41. def generateAlmostUniqueSuffixWithHash(s: String): String

    Permalink

    This will create an probabilistically unique string of length no longer than 11 chars, it can be used to create "almost unique" names where uniqueness is not an absolute requirement, is not ,

    This will create an probabilistically unique string of length no longer than 11 chars, it can be used to create "almost unique" names where uniqueness is not an absolute requirement, is not ,

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

    Permalink
    Definition Classes
    AnyRef → Any
  43. def getInsertableFields(fmd: Iterable[FieldMetaData]): Iterable[FieldMetaData]

    Permalink
    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  44. def hashCode(): Int

    Permalink
    Definition Classes
    AnyRef → Any
  45. def intArrayTypeDeclaration: String

    Permalink
    Definition Classes
    DatabaseAdapter
  46. def intTypeDeclaration: String

    Permalink
    Definition Classes
    DatabaseAdapter
  47. def isFullOuterJoinSupported: Boolean

    Permalink
    Definition Classes
    MySQLAdapterDatabaseAdapter
  48. final def isInstanceOf[T0]: Boolean

    Permalink
    Definition Classes
    Any
  49. def isNotNullConstraintViolation(e: SQLException): Boolean

    Permalink

    Figures out from the SQLException (ex.: vendor specific error code) if it's cause is a NOT NULL constraint violation

    Figures out from the SQLException (ex.: vendor specific error code) if it's cause is a NOT NULL constraint violation

    Definition Classes
    DatabaseAdapter
  50. def isTableDoesNotExistException(e: SQLException): Boolean

    Permalink
    Definition Classes
    MySQLAdapterDatabaseAdapter
  51. def jdbcDoubleArrayCreationType: String

    Permalink
    Definition Classes
    DatabaseAdapter
  52. def jdbcIntArrayCreationType: String

    Permalink
    Definition Classes
    DatabaseAdapter
  53. def jdbcLongArrayCreationType: String

    Permalink
    Definition Classes
    DatabaseAdapter
  54. def jdbcStringArrayCreationType: String

    Permalink
    Definition Classes
    DatabaseAdapter
  55. def jdbcTypeConstantFor(c: Class[_]): Int

    Permalink
    Definition Classes
    DatabaseAdapter
  56. def longArrayTypeDeclaration: String

    Permalink
    Definition Classes
    DatabaseAdapter
  57. def longTypeDeclaration: String

    Permalink
    Definition Classes
    DatabaseAdapter
  58. final def ne(arg0: AnyRef): Boolean

    Permalink
    Definition Classes
    AnyRef
  59. final def notify(): Unit

    Permalink
    Definition Classes
    AnyRef
  60. final def notifyAll(): Unit

    Permalink
    Definition Classes
    AnyRef
  61. def nvlToken: String

    Permalink
    Definition Classes
    DatabaseAdapter
  62. def postCreateTable(t: Table[_], printSinkWhenWriteOnlyMode: Option[(String) ⇒ Unit]): Unit

    Permalink

    When @arg printSinkWhenWriteOnlyMode is not None, the adapter will not execute any statement, but only silently give it to the String=>Unit closure

    When @arg printSinkWhenWriteOnlyMode is not None, the adapter will not execute any statement, but only silently give it to the String=>Unit closure

    Definition Classes
    DatabaseAdapter
  63. def postDropTable(t: Table[_]): Unit

    Permalink
    Definition Classes
    DatabaseAdapter
  64. def prepareStatement(conn: Connection, statement: String): PreparedStatement

    Permalink
    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  65. def quoteIdentifier(s: String): String

    Permalink
    Definition Classes
    DatabaseAdapter
  66. def quoteName(s: String): String

    Permalink
    Definition Classes
    DatabaseAdapter
  67. def setParamInto(s: PreparedStatement, p: StatementParam, i: Int): Unit

    Permalink
    Definition Classes
    DatabaseAdapter
  68. implicit def string2StatementWriter(s: String): StatementWriter

    Permalink
    Definition Classes
    DatabaseAdapter
  69. def stringArrayTypeDeclaration: String

    Permalink
    Definition Classes
    DatabaseAdapter
  70. def stringTypeDeclaration(length: Int): String

    Permalink
    Definition Classes
    DatabaseAdapter
  71. def stringTypeDeclaration: String

    Permalink
    Definition Classes
    DatabaseAdapter
  72. def supportsAutoIncrementInColumnDeclaration: Boolean

    Permalink
    Definition Classes
    DatabaseAdapter
  73. def supportsCommonTableExpressions: Boolean

    Permalink
    Definition Classes
    DatabaseAdapter
  74. def supportsForeignKeyConstraints: Boolean

    Permalink

    InnoDB MySQL tables support foreign key constraints, see http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html

    InnoDB MySQL tables support foreign key constraints, see http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html

    Definition Classes
    MySQLInnoDBAdapterMySQLAdapterDatabaseAdapter
  75. def supportsUnionQueryOptions: Boolean

    Permalink
    Definition Classes
    DatabaseAdapter
  76. final def synchronized[T0](arg0: ⇒ T0): T0

    Permalink
    Definition Classes
    AnyRef
  77. def timestampTypeDeclaration: String

    Permalink
    Definition Classes
    MySQLAdapterDatabaseAdapter
  78. def toString(): String

    Permalink
    Definition Classes
    AnyRef → Any
  79. def uuidTypeDeclaration: String

    Permalink
    Definition Classes
    DatabaseAdapter
  80. def verifyDeleteByPK: Boolean

    Permalink

    Should we verify that when we delete by primary key the JDBC driver reports that no more than one row was affected? MonetDB in particular seems to act badly here

    Should we verify that when we delete by primary key the JDBC driver reports that no more than one row was affected? MonetDB in particular seems to act badly here

    returns

    true if we should throw an exception if the driver reports more than 1 affected row

    Definition Classes
    DatabaseAdapter
  81. def viewAlias(vn: ViewExpressionNode[_]): String

    Permalink
    Definition Classes
    DatabaseAdapter
  82. final def wait(): Unit

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

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

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  85. def writeColumnDeclaration(fmd: FieldMetaData, isPrimaryKey: Boolean, schema: Schema): String

    Permalink
    Definition Classes
    DatabaseAdapter
  86. def writeCompositePrimaryKeyConstraint(t: Table[_], cols: Iterable[FieldMetaData]): String

    Permalink
    Definition Classes
    DatabaseAdapter
  87. def writeConcatFunctionCall(fn: FunctionNode, sw: StatementWriter): Unit

    Permalink
    Definition Classes
    DatabaseAdapter
  88. def writeConcatOperator(left: ExpressionNode, right: ExpressionNode, sw: StatementWriter): Unit

    Permalink
    Definition Classes
    MySQLAdapterDatabaseAdapter
  89. def writeCreateTable[T](t: Table[T], sw: StatementWriter, schema: Schema): Unit

    Permalink
    Definition Classes
    DatabaseAdapter
  90. def writeCteReference(sw: StatementWriter, q: QueryExpressionElements): Unit

    Permalink
    Attributes
    protected[org.squeryl]
    Definition Classes
    DatabaseAdapter
  91. def writeDelete[T](t: Table[T], whereClause: Option[ExpressionNode], sw: StatementWriter): Unit

    Permalink
    Definition Classes
    DatabaseAdapter
  92. def writeDropForeignKeyStatement(foreignKeyTable: Table[_], fkName: String): String

    Permalink
    Definition Classes
    MySQLAdapterDatabaseAdapter
  93. def writeDropTable(tableName: String): String

    Permalink
    Definition Classes
    DatabaseAdapter
  94. def writeEndOfFromHint(qen: QueryExpressionElements, sw: StatementWriter): Unit

    Permalink
    Definition Classes
    DatabaseAdapter
  95. def writeEndOfQueryHint(isForUpdate: () ⇒ Boolean, qen: QueryExpressionElements, sw: StatementWriter): Unit

    Permalink
    Definition Classes
    DatabaseAdapter
  96. def writeForeignKeyDeclaration(foreignKeyTable: Table[_], foreignKeyColumnName: String, primaryKeyTable: Table[_], primaryKeyColumnName: String, referentialAction1: Option[ReferentialAction], referentialAction2: Option[ReferentialAction], fkId: Int): String

    Permalink
    Definition Classes
    MySQLAdapterDatabaseAdapter
  97. def writeIndexDeclaration(columnDefs: Seq[FieldMetaData], name: Option[String], nameOfCompositeKey: Option[String], isUnique: Boolean): String

    Permalink

    name

    the name specified in the Schema, when not None, it must be used as the name

    nameOfCompositeKey

    when not None, the column group forms a composite key, 'nameOfCompositeKey' can be used as part of the name to create a more meaningfull name for the constraint, when 'name' is None

    Definition Classes
    DatabaseAdapter
  98. def writeInsert[T](o: T, t: Table[T], sw: StatementWriter): Unit

    Permalink
    Definition Classes
    DatabaseAdapter
  99. def writeJoin(queryableExpressionNode: QueryableExpressionNode, sw: StatementWriter): Unit

    Permalink
    Definition Classes
    DatabaseAdapter
  100. def writeNvlCall(left: ExpressionNode, right: ExpressionNode, sw: StatementWriter): Unit

    Permalink
    Definition Classes
    DatabaseAdapter
  101. def writePaginatedQueryDeclaration(page: () ⇒ Option[(Int, Int)], qen: QueryExpressionElements, sw: StatementWriter): Unit

    Permalink
    Definition Classes
    DatabaseAdapter
  102. def writeQuery(qen: QueryExpressionElements, sw: StatementWriter, inverseOrderBy: Boolean, topHint: Option[String]): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  103. def writeQuery(qen: QueryExpressionElements, sw: StatementWriter): Unit

    Permalink
    Definition Classes
    DatabaseAdapter
  104. def writeRegexExpression(left: ExpressionNode, pattern: String, sw: StatementWriter): Unit

    Permalink
    Definition Classes
    MySQLAdapterDatabaseAdapter
  105. def writeSelectElementAlias(se: SelectElement, sw: StatementWriter): Unit

    Permalink
    Definition Classes
    DatabaseAdapter
  106. def writeUnionQueryOptions(qen: QueryExpressionElements, sw: StatementWriter): Unit

    Permalink
    Definition Classes
    DatabaseAdapter
  107. def writeUniquenessConstraint(t: Table[_], cols: Iterable[FieldMetaData]): String

    Permalink
    Definition Classes
    DatabaseAdapter
  108. def writeUpdate(t: Table[_], us: UpdateStatement, sw: StatementWriter): Unit

    Permalink
    Definition Classes
    DatabaseAdapter
  109. def writeUpdate[T](o: T, t: Table[T], sw: StatementWriter, checkOCC: Boolean): Unit

    Permalink
    Definition Classes
    DatabaseAdapter
  110. def writeValue(o: AnyRef, fmd: FieldMetaData, sw: StatementWriter): String

    Permalink
    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  111. implicit def zipIterable[T](i: Iterable[T]): ZipIterable[T]

    Permalink
    Definition Classes
    DatabaseAdapter

Inherited from MySQLAdapter

Inherited from DatabaseAdapter

Inherited from AnyRef

Inherited from Any

Ungrouped