org.squeryl.adapters

MySQLAdapter

class MySQLAdapter extends DatabaseAdapter

Linear Supertypes
DatabaseAdapter, AnyRef, Any
Known Subclasses
Ordering
  1. Alphabetic
  2. By inheritance
Inherited
  1. MySQLAdapter
  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 MySQLAdapter()

Type Members

  1. class Zip[T] extends AnyRef

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

    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. def aliasExport(parentOfTarget: QueryableExpressionNode, target: SelectElement): String

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

    Definition Classes
    DatabaseAdapter
  8. final def asInstanceOf[T0]: T0

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

    Definition Classes
    DatabaseAdapter
  10. def bigDecimalTypeDeclaration: String

    Definition Classes
    DatabaseAdapter
  11. def binaryTypeDeclaration: String

    Definition Classes
    MySQLAdapterDatabaseAdapter
  12. def booleanTypeDeclaration: String

    Definition Classes
    DatabaseAdapter
  13. def clone(): AnyRef

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

    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
  15. def convertFromUuidForJdbc(u: UUID): AnyRef

    Definition Classes
    DatabaseAdapter
  16. def convertParamsForJdbc(params: Iterable[AnyRef]): Iterable[AnyRef]

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

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

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

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

    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
  19. def convertToUuidForJdbc(rs: ResultSet, i: Int): UUID

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

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

    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  22. def currenSession: Session

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

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

    Definition Classes
    DatabaseAdapter
  25. def dateTypeDeclaration: String

    Definition Classes
    DatabaseAdapter
  26. def doubleArrayTypeDeclaration: String

    Definition Classes
    DatabaseAdapter
  27. def doubleTypeDeclaration: String

    Definition Classes
    DatabaseAdapter
  28. def dropForeignKeyStatement(foreignKeyTable: Table[_], fkName: String, session: Session): Unit

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

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

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

    Definition Classes
    AnyRef → Any
  32. def exec[A](s: Session, sw: StatementWriter)(block: (Iterable[AnyRef]) ⇒ A): A

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

    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
  34. def executeQuery(s: Session, sw: StatementWriter): (ResultSet, PreparedStatement)

    Definition Classes
    DatabaseAdapter
  35. def executeUpdate(s: Session, sw: StatementWriter): (Int, PreparedStatement)

    Definition Classes
    DatabaseAdapter
  36. def executeUpdateAndCloseStatement(s: Session, sw: StatementWriter): Int

    Definition Classes
    DatabaseAdapter
  37. def executeUpdateForInsert(s: Session, sw: StatementWriter, ps: PreparedStatement): Int

    Definition Classes
    DatabaseAdapter
  38. def failureOfStatementRequiresRollback: Boolean

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

    Definition Classes
    DatabaseAdapter
  40. def fillParamsInto(params: Iterable[AnyRef], s: PreparedStatement): Unit

    Definition Classes
    DatabaseAdapter
  41. def finalize(): Unit

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws()
  42. def floatTypeDeclaration: String

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

    Definition Classes
    DatabaseAdapter
  44. def generateAlmostUniqueSuffixWithHash(s: String): String

    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
  45. final def getClass(): Class[_]

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

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

    Definition Classes
    AnyRef → Any
  48. def intArrayTypeDeclaration: String

    Definition Classes
    DatabaseAdapter
  49. def intTypeDeclaration: String

    Definition Classes
    DatabaseAdapter
  50. def isFullOuterJoinSupported: Boolean

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

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

    Figures out from the SQLException (ex.

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

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

    Definition Classes
    MySQLAdapterDatabaseAdapter
  54. def jdbcDoubleArrayCreationType: String

    Definition Classes
    DatabaseAdapter
  55. def jdbcIntArrayCreationType: String

    Definition Classes
    DatabaseAdapter
  56. def jdbcLongArrayCreationType: String

    Definition Classes
    DatabaseAdapter
  57. def longArrayTypeDeclaration: String

    Definition Classes
    DatabaseAdapter
  58. def longTypeDeclaration: String

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

    Definition Classes
    AnyRef
  60. final def notify(): Unit

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

    Definition Classes
    AnyRef
  62. def nvlToken: String

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

    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
  64. def postDropTable(t: Table[_]): Unit

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

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

    Definition Classes
    DatabaseAdapter
  67. def quoteName(s: String): String

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

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

    Definition Classes
    DatabaseAdapter
  70. def stringTypeDeclaration: String

    Definition Classes
    DatabaseAdapter
  71. def supportsAutoIncrementInColumnDeclaration: Boolean

    Definition Classes
    DatabaseAdapter
  72. def supportsForeignKeyConstraints: Boolean

    Foreign key constraints are not supported,

    Foreign key constraints are not supported,

    MySQL has some pre requisites for creating a foreign key constraint one of which is :

    -> The foreign key can be self referential (referring to the same table). When you add a foreign key constraint to a table using ALTER TABLE, remember to create the required indexes first.

    http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html

    Apparently there are other pre requisites, because creating foreign key constraints still gives :

    Time Action Response Duration / Fetch 0 1 18:26:25 alter table CourseSubscription add constraint CourseSubscriptionFK3 foreign key (courseId) references Course(id) Error Code: 1005 Can't create table 'test.#sql-57c_42' (errno: 150)

    http://bytes.com/topic/mysql/answers/865699-cant-create-table-errno-150-foreign-key-constraints

    Definition Classes
    MySQLAdapterDatabaseAdapter
  73. final def synchronized[T0](arg0: ⇒ T0): T0

    Definition Classes
    AnyRef
  74. def timestampTypeDeclaration: String

    Definition Classes
    MySQLAdapterDatabaseAdapter
  75. def toString(): String

    Definition Classes
    AnyRef → Any
  76. def uuidTypeDeclaration: String

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

    Definition Classes
    DatabaseAdapter
  78. final def wait(): Unit

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

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

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

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

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

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

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

    Definition Classes
    DatabaseAdapter
  86. def writeDelete[T](t: Table[T], whereClause: Option[ExpressionNode], sw: StatementWriter): Unit

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

    Definition Classes
    MySQLAdapterDatabaseAdapter
  88. def writeDropTable(tableName: String): String

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

    Definition Classes
    DatabaseAdapter
  90. def writeEndOfQueryHint(qen: QueryExpressionElements, sw: StatementWriter): Unit

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

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

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

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

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

    Definition Classes
    DatabaseAdapter
  96. def writePaginatedQueryDeclaration(qen: QueryExpressionElements, sw: StatementWriter): Unit

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

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

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

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

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

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

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

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

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

    Definition Classes
    DatabaseAdapter

Inherited from DatabaseAdapter

Inherited from AnyRef

Inherited from Any

Ungrouped