Packages

c

org.squeryl.adapters

PostgreSqlAdapter

class PostgreSqlAdapter extends DatabaseAdapter

Source
PostgreSqlAdapter.scala
Linear Supertypes
DatabaseAdapter, AnyRef, Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. PostgreSqlAdapter
  2. DatabaseAdapter
  3. AnyRef
  4. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. Protected

Instance Constructors

  1. new PostgreSqlAdapter()

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 arrayCreationType(ptype: Class[_]): String
    Definition Classes
    DatabaseAdapter
  6. final def asInstanceOf[T0]: T0
    Definition Classes
    Any
  7. def bigDecimalTypeDeclaration(precision: Int, scale: Int): String
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  8. def bigDecimalTypeDeclaration: String
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  9. def binaryTypeDeclaration: String
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  10. def booleanTypeDeclaration: String
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  11. def clone(): AnyRef
    Attributes
    protected[lang]
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.CloneNotSupportedException]) @native()
  12. 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
  13. def convertFromUuidForJdbc(u: UUID): AnyRef
    Definition Classes
    PostgreSqlAdapter → 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
    PostgreSqlAdapter → DatabaseAdapter
  17. def createSequenceName(fmd: FieldMetaData): String
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  18. def createStatement(conn: Connection): Statement
    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  19. def currenSession: AbstractSession
    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  20. def databaseTypeFor(fieldMapper: FieldMapper, c: Class[_]): String
    Definition Classes
    DatabaseAdapter
  21. def databaseTypeFor(fmd: FieldMetaData): String
    Definition Classes
    DatabaseAdapter
  22. def dateTypeDeclaration: String
    Definition Classes
    DatabaseAdapter
  23. def doubleArrayTypeDeclaration: String
    Definition Classes
    DatabaseAdapter
  24. def doubleTypeDeclaration: String
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  25. def dropForeignKeyStatement(foreignKeyTable: Table[_], fkName: String, session: AbstractSession): Unit
    Definition Classes
    DatabaseAdapter
  26. def dropTable(t: Table[_]): Unit
    Definition Classes
    DatabaseAdapter
  27. final def eq(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  28. def equals(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef → Any
  29. def exec[A](s: AbstractSession, sw: StatementWriter)(block: (Iterable[StatementParam]) => A): A
    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  30. 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
  31. def executeQuery(s: AbstractSession, sw: StatementWriter): (ResultSet, PreparedStatement)
    Definition Classes
    DatabaseAdapter
  32. def executeUpdate(s: AbstractSession, sw: StatementWriter): (Int, PreparedStatement)
    Definition Classes
    DatabaseAdapter
  33. def executeUpdateAndCloseStatement(s: AbstractSession, sw: StatementWriter): Int
    Definition Classes
    DatabaseAdapter
  34. def executeUpdateForInsert(s: AbstractSession, sw: StatementWriter, ps: PreparedStatement): Int
    Definition Classes
    DatabaseAdapter
  35. def failureOfStatementRequiresRollback: Boolean
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  36. def fieldAlias(n: QueryableExpressionNode, fse: FieldSelectElement): String
    Definition Classes
    DatabaseAdapter
  37. def fillParamsInto(params: Iterable[StatementParam], s: PreparedStatement): Unit
    Definition Classes
    DatabaseAdapter
  38. def finalize(): Unit
    Attributes
    protected[lang]
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.Throwable])
  39. def floatTypeDeclaration: String
    Definition Classes
    DatabaseAdapter
  40. def foreignKeyConstraintName(foreignKeyTable: Table[_], idWithinSchema: Int): String
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  41. 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
  42. final def getClass(): Class[_ <: AnyRef]
    Definition Classes
    AnyRef → Any
    Annotations
    @native()
  43. def getInsertableFields(fmd: Iterable[FieldMetaData]): Iterable[FieldMetaData]
    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  44. def hashCode(): Int
    Definition Classes
    AnyRef → Any
    Annotations
    @native()
  45. def intArrayTypeDeclaration: String
    Definition Classes
    DatabaseAdapter
  46. def intTypeDeclaration: String
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  47. def isFullOuterJoinSupported: Boolean
    Definition Classes
    DatabaseAdapter
  48. final def isInstanceOf[T0]: Boolean
    Definition Classes
    Any
  49. 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
  50. def isTableDoesNotExistException(e: SQLException): Boolean
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  51. def jdbcDoubleArrayCreationType: String
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  52. def jdbcIntArrayCreationType: String
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  53. def jdbcLongArrayCreationType: String
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  54. def jdbcStringArrayCreationType: String
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  55. def jdbcTypeConstantFor(c: Class[_]): Int
    Definition Classes
    DatabaseAdapter
  56. def longArrayTypeDeclaration: String
    Definition Classes
    DatabaseAdapter
  57. def longTypeDeclaration: String
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  58. final def ne(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  59. final def notify(): Unit
    Definition Classes
    AnyRef
    Annotations
    @native()
  60. final def notifyAll(): Unit
    Definition Classes
    AnyRef
    Annotations
    @native()
  61. def nvlToken: String
    Definition Classes
    DatabaseAdapter
  62. 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
    PostgreSqlAdapter → DatabaseAdapter
  63. def postDropTable(t: Table[_]): Unit
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  64. def prepareStatement(conn: Connection, statement: String): PreparedStatement
    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  65. def quoteIdentifier(s: String): String
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  66. def quoteName(s: String): String
    Definition Classes
    DatabaseAdapter
  67. def sequenceName(t: Table[_]): String
  68. def setParamInto(s: PreparedStatement, p: StatementParam, i: Int): Unit
    Definition Classes
    DatabaseAdapter
  69. implicit def string2StatementWriter(s: String): StatementWriter
    Definition Classes
    DatabaseAdapter
  70. def stringArrayTypeDeclaration: String
    Definition Classes
    DatabaseAdapter
  71. def stringTypeDeclaration(length: Int): String
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  72. def stringTypeDeclaration: String
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  73. def supportsAutoIncrementInColumnDeclaration: Boolean
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  74. def supportsCommonTableExpressions: Boolean
    Definition Classes
    DatabaseAdapter
  75. def supportsForeignKeyConstraints: Boolean
    Definition Classes
    DatabaseAdapter
  76. def supportsUnionQueryOptions: Boolean
    Definition Classes
    DatabaseAdapter
  77. final def synchronized[T0](arg0: => T0): T0
    Definition Classes
    AnyRef
  78. def timestampTypeDeclaration: String
    Definition Classes
    DatabaseAdapter
  79. def toString(): String
    Definition Classes
    AnyRef → Any
  80. def usePostgresSequenceNamingScheme: Boolean

    NB: You can override usePostgresSequenceNamingScheme to return true in a child class to change the sequence naming behavior to align with the default postgresql scheme.

  81. def uuidTypeDeclaration: String
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  82. def verifyDeleteByPK: Boolean

    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
  83. def viewAlias(vn: ViewExpressionNode[_]): String
    Definition Classes
    DatabaseAdapter
  84. final def wait(): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.InterruptedException])
  85. final def wait(arg0: Long, arg1: Int): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.InterruptedException])
  86. final def wait(arg0: Long): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.InterruptedException]) @native()
  87. def writeColumnDeclaration(fmd: FieldMetaData, isPrimaryKey: Boolean, schema: Schema): String
    Definition Classes
    DatabaseAdapter
  88. def writeCompositePrimaryKeyConstraint(t: Table[_], cols: Iterable[FieldMetaData]): String
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  89. def writeConcatFunctionCall(fn: FunctionNode, sw: StatementWriter): Unit
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  90. def writeConcatOperator(left: ExpressionNode, right: ExpressionNode, sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  91. def writeCreateTable[T](t: Table[T], sw: StatementWriter, schema: Schema): Unit
    Definition Classes
    DatabaseAdapter
  92. def writeCteReference(sw: StatementWriter, q: QueryExpressionElements): Unit
    Attributes
    protected[squeryl]
    Definition Classes
    DatabaseAdapter
  93. def writeDelete[T](t: Table[T], whereClause: Option[ExpressionNode], sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  94. def writeDropForeignKeyStatement(foreignKeyTable: Table[_], fkName: String): String
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  95. def writeDropTable(tableName: String): String
    Definition Classes
    DatabaseAdapter
  96. def writeEndOfFromHint(qen: QueryExpressionElements, sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  97. def writeEndOfQueryHint(isForUpdate: () => Boolean, qen: QueryExpressionElements, sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  98. def writeForeignKeyDeclaration(foreignKeyTable: Table[_], foreignKeyColumnName: String, primaryKeyTable: Table[_], primaryKeyColumnName: String, referentialAction1: Option[ReferentialAction], referentialAction2: Option[ReferentialAction], fkId: Int): String
    Definition Classes
    DatabaseAdapter
  99. def writeIndexDeclaration(columnDefs: Seq[FieldMetaData], name: Option[String], nameOfCompositeKey: Option[String], isUnique: Boolean): String

    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
  100. def writeInsert[T](o: T, t: Table[T], sw: StatementWriter): Unit
    Definition Classes
    PostgreSqlAdapter → DatabaseAdapter
  101. def writeJoin(queryableExpressionNode: QueryableExpressionNode, sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  102. def writeNvlCall(left: ExpressionNode, right: ExpressionNode, sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  103. def writePaginatedQueryDeclaration(page: () => Option[(Int, Int)], qen: QueryExpressionElements, sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  104. def writeQuery(qen: QueryExpressionElements, sw: StatementWriter, inverseOrderBy: Boolean, topHint: Option[String]): Unit
    Attributes
    protected
    Definition Classes
    DatabaseAdapter
  105. def writeQuery(qen: QueryExpressionElements, sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  106. def writeRegexExpression(left: ExpressionNode, pattern: String, sw: StatementWriter): ArrayBuffer[StatementParam]
    Definition Classes
    DatabaseAdapter
  107. def writeSelectElementAlias(se: SelectElement, sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  108. def writeUnionQueryOptions(qen: QueryExpressionElements, sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  109. def writeUniquenessConstraint(t: Table[_], cols: Iterable[FieldMetaData]): String
    Definition Classes
    DatabaseAdapter
  110. def writeUpdate(t: Table[_], us: UpdateStatement, sw: StatementWriter): Unit
    Definition Classes
    DatabaseAdapter
  111. def writeUpdate[T](o: T, t: Table[T], sw: StatementWriter, checkOCC: Boolean): Unit
    Definition Classes
    DatabaseAdapter
  112. def writeValue(o: AnyRef, fmd: FieldMetaData, sw: StatementWriter): String

    In the case custom DB type used it is beneficial to explicitly cast value to its type, because it invokes proper cast function.

    In the case custom DB type used it is beneficial to explicitly cast value to its type, because it invokes proper cast function. For example, it is possible to insert Scala String into a DB ENUM using dbType.

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

Inherited from DatabaseAdapter

Inherited from AnyRef

Inherited from Any

Ungrouped