c

org.squeryl.adapters

MySQLAdapter

class MySQLAdapter extends DatabaseAdapter

Linear Supertypes
DatabaseAdapter, AnyRef, Any
Known Subclasses
MySQLInnoDBAdapter
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. MySQLAdapter
  2. DatabaseAdapter
  3. AnyRef
  4. Any
  1. Hide All
  2. Show All
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: Any): Boolean
    Definition Classes
    AnyRef → Any
  2. final def ##(): Int
    Definition Classes
    AnyRef → Any
  3. final def ==(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  4. def aliasExport(parentOfTarget: QueryableExpressionNode, target: SelectElement): String
    Definition Classes
    DatabaseAdapter
  5. final def asInstanceOf[T0]: T0
    Definition Classes
    Any
  6. def bigDecimalTypeDeclaration(precision: Int, scale: Int): String
    Definition Classes
    DatabaseAdapter
  7. def bigDecimalTypeDeclaration: String
    Definition Classes
    DatabaseAdapter
  8. def binaryTypeDeclaration: String
    Definition Classes
    MySQLAdapter → DatabaseAdapter
  9. def booleanTypeDeclaration: String
    Definition Classes
    DatabaseAdapter
  10. def clone(): AnyRef
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  11. 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
  12. def convertFromUuidForJdbc(u: UUID): AnyRef
    Definition Classes
    DatabaseAdapter
  13. def convertParamsForJdbc(params: Iterable[AnyRef]): Iterable[AnyRef]
    Definition Classes
    DatabaseAdapter
  14. 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
  15. 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
  16. def convertToUuidForJdbc(rs: ResultSet, i: Int): UUID
    Definition Classes
    DatabaseAdapter
  17. def createSequenceName(fmd: FieldMetaData): String
    Definition Classes
    DatabaseAdapter
  18. def createStatement(conn: Connection): Statement
    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  19. def currenSession: Session
    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  20. def databaseTypeFor(c: Class[_]): String
    Definition Classes
    DatabaseAdapter
  21. def databaseTypeFor(fmd: FieldMetaData): String
    Definition Classes
    DatabaseAdapter
  22. def dateTypeDeclaration: String
    Definition Classes
    DatabaseAdapter
  23. def doubleTypeDeclaration: String
    Definition Classes
    DatabaseAdapter
  24. def dropForeignKeyStatement(foreignKeyTable: Table[_], fkName: String, session: Session): Unit
    Definition Classes
    DatabaseAdapter
  25. def dropTable(t: Table[_]): Unit
    Definition Classes
    DatabaseAdapter
  26. final def eq(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  27. def equals(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  28. def exec[A](s: Session, sw: StatementWriter)(block: (Iterable[AnyRef]) ⇒ A): A
    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  29. 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
  30. def executeQuery(s: Session, sw: StatementWriter): (ResultSet, PreparedStatement)
    Definition Classes
    DatabaseAdapter
  31. def executeUpdate(s: Session, sw: StatementWriter): (Int, PreparedStatement)
    Definition Classes
    DatabaseAdapter
  32. def executeUpdateAndCloseStatement(s: Session, sw: StatementWriter): Int
    Definition Classes
    DatabaseAdapter
  33. def executeUpdateForInsert(s: Session, sw: StatementWriter, ps: PreparedStatement): Int
    Definition Classes
    DatabaseAdapter
  34. def failureOfStatementRequiresRollback: Boolean
    Definition Classes
    DatabaseAdapter
  35. def fieldAlias(n: QueryableExpressionNode, fse: FieldSelectElement): String
    Definition Classes
    DatabaseAdapter
  36. def fillParamsInto(params: Iterable[AnyRef], s: PreparedStatement): Unit
    Definition Classes
    DatabaseAdapter
  37. def finalize(): Unit
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  38. def floatTypeDeclaration: String
    Definition Classes
    MySQLAdapter → DatabaseAdapter
  39. def foreignKeyConstraintName(foreignKeyTable: Table[_], idWithinSchema: Int): String
    Definition Classes
    DatabaseAdapter
  40. 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
  41. final def getClass(): Class[_]
    Definition Classes
    AnyRef → Any
  42. def getInsertableFields(fmd: Iterable[FieldMetaData]): Iterable[FieldMetaData]
    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  43. def hashCode(): Int
    Definition Classes
    AnyRef → Any
  44. def intTypeDeclaration: String
    Definition Classes
    DatabaseAdapter
  45. def isFullOuterJoinSupported: Boolean
    Definition Classes
    MySQLAdapter → DatabaseAdapter
  46. final def isInstanceOf[T0]: Boolean
    Definition Classes
    Any
  47. def isNotNullConstraintViolation(e: SQLException): Boolean

    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
  48. def isTableDoesNotExistException(e: SQLException): Boolean
    Definition Classes
    MySQLAdapter → DatabaseAdapter
  49. def longTypeDeclaration: String
    Definition Classes
    DatabaseAdapter
  50. final def ne(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  51. final def notify(): Unit
    Definition Classes
    AnyRef
  52. final def notifyAll(): Unit
    Definition Classes
    AnyRef
  53. def nvlToken: String
    Definition Classes
    DatabaseAdapter
  54. 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
  55. def postDropTable(t: Table[_]): Unit
    Definition Classes
    DatabaseAdapter
  56. def prepareStatement(conn: Connection, statement: String): PreparedStatement
    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  57. def quoteIdentifier(s: String): String
    Definition Classes
    DatabaseAdapter
  58. def quoteName(s: String): String
    Definition Classes
    DatabaseAdapter
  59. implicit def string2StatementWriter(s: String): StatementWriter
    Definition Classes
    DatabaseAdapter
  60. def stringTypeDeclaration(length: Int): String
    Definition Classes
    DatabaseAdapter
  61. def stringTypeDeclaration: String
    Definition Classes
    DatabaseAdapter
  62. def supportsAutoIncrementInColumnDeclaration: Boolean
    Definition Classes
    DatabaseAdapter
  63. 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
    MySQLAdapter → DatabaseAdapter
  64. final def synchronized[T0](arg0: ⇒ T0): T0
    Definition Classes
    AnyRef
  65. def timestampTypeDeclaration: String
    Definition Classes
    MySQLAdapter → DatabaseAdapter
  66. def toString(): String
    Definition Classes
    AnyRef → Any
  67. def uuidTypeDeclaration: String
    Definition Classes
    DatabaseAdapter
  68. def viewAlias(vn: ViewExpressionNode[_]): String
    Definition Classes
    DatabaseAdapter
  69. final def wait(): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  70. final def wait(arg0: Long, arg1: Int): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  71. final def wait(arg0: Long): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  72. def writeCaseStatement(toMatch: Option[ExpressionNode], cases: Iterable[(ExpressionNode, TypedExpressionNode[_])], otherwise: TypedExpressionNode[_], sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  73. def writeCastInvocation(e: TypedExpressionNode[_], sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  74. def writeColumnDeclaration(fmd: FieldMetaData, isPrimaryKey: Boolean, schema: Schema): String
    Definition Classes
    DatabaseAdapter
  75. def writeCompositePrimaryKeyConstraint(t: Table[_], cols: Iterable[FieldMetaData]): String
    Definition Classes
    DatabaseAdapter
  76. def writeConcatFunctionCall(fn: FunctionNode[_], sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  77. def writeConcatOperator(left: ExpressionNode, right: ExpressionNode, sw: StatementWriter): Unit
    Definition Classes
    MySQLAdapter → DatabaseAdapter
  78. def writeCreateTable[T](t: Table[T], sw: StatementWriter, schema: Schema): Unit
    Definition Classes
    DatabaseAdapter
  79. def writeDelete[T](t: Table[T], whereClause: Option[ExpressionNode], sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  80. def writeDropForeignKeyStatement(foreignKeyTable: Table[_], fkName: String): String
    Definition Classes
    MySQLAdapter → DatabaseAdapter
  81. def writeDropTable(tableName: String): String
    Definition Classes
    DatabaseAdapter
  82. def writeEndOfFromHint(qen: QueryExpressionElements, sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  83. def writeEndOfQueryHint(qen: QueryExpressionElements, sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  84. def writeForeignKeyDeclaration(foreignKeyTable: Table[_], foreignKeyColumnName: String, primaryKeyTable: Table[_], primaryKeyColumnName: String, referentialAction1: Option[ReferentialAction], referentialAction2: Option[ReferentialAction], fkId: Int): String
    Definition Classes
    MySQLAdapter → DatabaseAdapter
  85. def writeIndexDeclaration(columnDefs: Seq[FieldMetaData], name: Option[String], nameOfCompositeKey: Option[String], isUnique: Boolean): String

    Definition Classes
    DatabaseAdapter
  86. def writeInsert[T](o: T, t: Table[T], sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  87. def writeJoin(queryableExpressionNode: QueryableExpressionNode, sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  88. def writeNvlCall(left: ExpressionNode, right: ExpressionNode, sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  89. def writePaginatedQueryDeclaration(qen: QueryExpressionElements, sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  90. def writeQuery(qen: QueryExpressionElements, sw: StatementWriter, inverseOrderBy: Boolean, topHint: Option[String]): Unit
    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  91. def writeQuery(qen: QueryExpressionElements, sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  92. def writeRegexExpression(left: ExpressionNode, pattern: String, sw: StatementWriter): Unit
    Definition Classes
    MySQLAdapter → DatabaseAdapter
  93. def writeSelectElementAlias(se: SelectElement, sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  94. def writeUniquenessConstraint(t: Table[_], cols: Iterable[FieldMetaData]): String
    Definition Classes
    DatabaseAdapter
  95. def writeUpdate(t: Table[_], us: UpdateStatement, sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  96. def writeUpdate[T](o: T, t: Table[T], sw: StatementWriter, checkOCC: Boolean): Unit
    Definition Classes
    DatabaseAdapter
  97. def writeValue(o: AnyRef, fmd: FieldMetaData, sw: StatementWriter): String
    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  98. implicit def zipIterable[T](i: Iterable[T]): ZipIterable[T]
    Definition Classes
    DatabaseAdapter

Inherited from DatabaseAdapter

Inherited from AnyRef

Inherited from Any

Ungrouped