com.websudos.morpheus

sql

package sql

Linear Supertypes
SQLOperatorSet, MaterialisedPrimitives, DefaultImportsDefinition, CreateImplicits, DefaultSQLEngines, DefaultForeignKeyConstraints, ModifyImplicits, JoinImplicits, LowPriorityImplicits, AnyRef, Any
Ordering
  1. Alphabetic
  2. By inheritance
Inherited
  1. sql
  2. SQLOperatorSet
  3. MaterialisedPrimitives
  4. DefaultImportsDefinition
  5. CreateImplicits
  6. DefaultSQLEngines
  7. DefaultForeignKeyConstraints
  8. ModifyImplicits
  9. JoinImplicits
  10. LowPriorityImplicits
  11. AnyRef
  12. Any
  1. Hide All
  2. Show all
Learn more about member selection
Visibility
  1. Public
  2. All

Type Members

  1. type Autoincrement = keys.Autoincrement

    Definition Classes
    DefaultImportsDefinition

  2. type BaseTable[Owner <: BaseTable[Owner, Record], Record] = dsl.BaseTable[Owner, Record]

    Definition Classes
    DefaultImportsDefinition

  3. type BlobColumn[Owner <: BaseTable[Owner, Record], Record] = column.BlobColumn[Owner, Record]

    Definition Classes
    DefaultImportsDefinition

  4. type CharColumn[Owner <: BaseTable[Owner, Record], Record] = column.CharColumn[Owner, Record]

    Definition Classes
    DefaultImportsDefinition

  5. type ForeignKey[Owner <: BaseTable[Owner, Record], Record, T1 <: BaseTable[T1, _]] = column.ForeignKey[Owner, Record, T1]

    Definition Classes
    DefaultImportsDefinition

  6. type Index[Owner <: BaseTable[Owner, Record], Record] = column.Index[Owner, Record]

    Definition Classes
    DefaultImportsDefinition

  7. type IntColumn[Owner <: BaseTable[Owner, Record], Record] = column.IntColumn[Owner, Record]

    Definition Classes
    DefaultImportsDefinition

  8. implicit class JoinColumn[T] extends AnyRef

    Definition Classes
    JoinImplicits

  9. type LongBlobColumn[Owner <: BaseTable[Owner, Record], Record] = column.LongBlobColumn[Owner, Record]

    Definition Classes
    DefaultImportsDefinition

  10. type LongColumn[Owner <: BaseTable[Owner, Record], Record] = column.PrimitiveColumn[Owner, Record, Long]

    Definition Classes
    DefaultImportsDefinition

  11. type LongTextColumn[Owner <: BaseTable[Owner, Record], Record] = column.LongTextColumn[Owner, Record]

    Definition Classes
    DefaultImportsDefinition

  12. type MediumBlobColumn[Owner <: BaseTable[Owner, Record], Record] = column.MediumBlobColumn[Owner, Record]

    Definition Classes
    DefaultImportsDefinition

  13. type MediumIntColumn[Owner <: BaseTable[Owner, Record], Record] = column.MediumIntColumn[Owner, Record]

    Definition Classes
    DefaultImportsDefinition

  14. type MediumTextColumn[Owner <: BaseTable[Owner, Record], Record] = column.MediumTextColumn[Owner, Record]

    Definition Classes
    DefaultImportsDefinition

  15. implicit class ModifyColumn[RR] extends AbstractModifyColumn[RR]

    Definition Classes
    ModifyImplicits

  16. type NotNull = keys.NotNull

    Definition Classes
    DefaultImportsDefinition

  17. implicit class OrderingColumn[RR] extends AbstractOrderingColumn[RR]

    Definition Classes
    ModifyImplicits

  18. type PrimaryKey[ValueType] = keys.PrimaryKey[ValueType]

    Definition Classes
    DefaultImportsDefinition

  19. type PrimitiveColumn[Owner <: BaseTable[Owner, Record], Record, ValueType] = column.PrimitiveColumn[Owner, Record, ValueType]

    Definition Classes
    DefaultImportsDefinition

  20. type Result = morpheus.Result

    Definition Classes
    DefaultImportsDefinition

  21. type Row = morpheus.Row

    Definition Classes
    DefaultImportsDefinition

  22. type SQLPrimitive[T] = morpheus.SQLPrimitive[T]

    Definition Classes
    DefaultImportsDefinition

  23. abstract class SQLTable[Owner <: BaseTable[Owner, Record], Record] extends BaseTable[Owner, Record] with SelectTable[Owner, Record, AbstractRootSelectQuery, AbstractSelectSyntaxBlock]

  24. implicit class SelectColumnRequired[Owner <: dsl.BaseTable[Owner, Record], Record, T] extends SelectColumn[T]

    Definition Classes
    ModifyImplicits

  25. type SmallIntColumn[Owner <: BaseTable[Owner, Record], Record] = column.SmallIntColumn[Owner, Record]

    Definition Classes
    DefaultImportsDefinition

  26. type Table[Owner <: BaseTable[Owner, Record], Record] = SQLTable[Owner, Record]

  27. type TextColumn[Owner <: BaseTable[Owner, Record], Record] = column.TextColumn[Owner, Record]

    Definition Classes
    DefaultImportsDefinition

  28. type TinyBlobColumn[Owner <: BaseTable[Owner, Record], Record] = column.TinyBlobColumn[Owner, Record]

    Definition Classes
    DefaultImportsDefinition

  29. type TinyIntColumn[Owner <: BaseTable[Owner, Record], Record] = column.TinyIntColumn[Owner, Record]

    Definition Classes
    DefaultImportsDefinition

  30. type TinyTextColumn[Owner <: BaseTable[Owner, Record], Record] = column.TinyTextColumn[Owner, Record]

    Definition Classes
    DefaultImportsDefinition

  31. type UniqueKey[ValueType] = keys.UniqueKey[ValueType]

    Definition Classes
    DefaultImportsDefinition

  32. type VarcharColumn[Owner <: BaseTable[Owner, Record], Record] = column.VarcharColumn[Owner, Record]

    Definition Classes
    DefaultImportsDefinition

  33. type YearColumn[Owner <: BaseTable[Owner, Record], Record] = column.YearColumn[Owner, Record]

    Definition Classes
    DefaultImportsDefinition

  34. type Zerofill[ValueType] = keys.Zerofill[ValueType]

    Definition Classes
    DefaultImportsDefinition

Abstract Value Members

  1. implicit abstract def columnToQueryColumn[T](col: AbstractColumn[T])(implicit arg0: SQLPrimitive[T]): AbstractQueryColumn[T]

    Definition Classes
    DefaultImportsDefinition

Concrete Value Members

  1. object Archive extends SQLEngine with Product with Serializable

    Definition Classes
    DefaultSQLEngines

  2. object BDB extends SQLEngine with Product with Serializable

    Definition Classes
    DefaultSQLEngines

  3. object BerkleyDB extends SQLEngine with Product with Serializable

    Definition Classes
    DefaultSQLEngines

  4. object Blackhole extends SQLEngine with Product with Serializable

    Definition Classes
    DefaultSQLEngines

  5. implicit def Boolean2booleanNullConflict(x: Null): Boolean

    Definition Classes
    LowPriorityImplicits

  6. implicit def Byte2byteNullConflict(x: Null): Byte

    Definition Classes
    LowPriorityImplicits

  7. object CSV extends SQLEngine with Product with Serializable

    Definition Classes
    DefaultSQLEngines

  8. object Cascade extends ForeignKeyConstraint with Product with Serializable

    Definition Classes
    DefaultForeignKeyConstraints

  9. implicit def Character2charNullConflict(x: Null): Char

    Definition Classes
    LowPriorityImplicits

  10. implicit object DatePrimitive extends DefaultDatePrimitive

    Definition Classes
    MaterialisedPrimitives

  11. implicit object DateTimePrimitive extends DefaultDateTimePrimitive

    Definition Classes
    MaterialisedPrimitives

  12. implicit def Double2doubleNullConflict(x: Null): Double

    Definition Classes
    LowPriorityImplicits

  13. implicit object DoublePrimitive extends DefaultDoublePrimitive

    Definition Classes
    MaterialisedPrimitives

  14. object Example extends SQLEngine with Product with Serializable

    Definition Classes
    DefaultSQLEngines

  15. object Federated extends SQLEngine with Product with Serializable

    Definition Classes
    DefaultSQLEngines

  16. implicit def Float2floatNullConflict(x: Null): Float

    Definition Classes
    LowPriorityImplicits

  17. implicit object FloatPrimitive extends DefaultFloatPrimitive

    Definition Classes
    MaterialisedPrimitives

  18. object Heap extends SQLEngine with Product with Serializable

    Definition Classes
    DefaultSQLEngines

  19. object InnoBase extends SQLEngine with Product with Serializable

    Definition Classes
    DefaultSQLEngines

  20. object InnoDB extends SQLEngine with Product with Serializable

    Definition Classes
    DefaultSQLEngines

  21. implicit object IntPrimitive extends DefaultIntPrimitive

    Definition Classes
    MaterialisedPrimitives

  22. implicit def Integer2intNullConflict(x: Null): Int

    Definition Classes
    LowPriorityImplicits

  23. implicit def Long2longNullConflict(x: Null): Long

    Definition Classes
    LowPriorityImplicits

  24. implicit object LongPrimitive extends DefaultLongPrimitive

    Definition Classes
    MaterialisedPrimitives

  25. object Memory extends SQLEngine with Product with Serializable

    Definition Classes
    DefaultSQLEngines

  26. object Merge extends SQLEngine with Product with Serializable

    Definition Classes
    DefaultSQLEngines

  27. object NDB extends SQLEngine with Product with Serializable

    Definition Classes
    DefaultSQLEngines

  28. object NDBCluster extends SQLEngine with Product with Serializable

    Definition Classes
    DefaultSQLEngines

  29. object NoAction extends ForeignKeyConstraint with Product with Serializable

    Definition Classes
    DefaultForeignKeyConstraints

  30. object Restrict extends ForeignKeyConstraint with Product with Serializable

    Definition Classes
    DefaultForeignKeyConstraints

  31. object SetNull extends ForeignKeyConstraint with Product with Serializable

    Definition Classes
    DefaultForeignKeyConstraints

  32. implicit def Short2shortNullConflict(x: Null): Short

    Definition Classes
    LowPriorityImplicits

  33. implicit object StringPrimitive extends DefaultStringPrimitive

    Definition Classes
    MaterialisedPrimitives

  34. object ascii extends AsciiOperator

    Definition Classes
    SQLOperatorSet

  35. implicit def assignmentToQuery[T <: dsl.BaseTable[T, _], R, G <: GroupBind, O <: OrderBind, L <: LimitBind, C <: ChainBind, AC <: AssignBind, Status <: StatusBind](assignment: AssignmentsQuery[T, R, UpdateType, G, O, L, C, AC, Status]): Query[T, R, UpdateType, G, O, L, C, AssignChainned, Terminated]

    Definition Classes
    ModifyImplicits

  36. object bin extends BinOperator

    Definition Classes
    SQLOperatorSet

  37. object bitLength extends BitLengthOperator

    Definition Classes
    SQLOperatorSet

  38. implicit def booleanWrapper(x: Boolean): RichBoolean

    Definition Classes
    LowPriorityImplicits
    Annotations
    @inline()

  39. implicit def byteWrapper(x: Byte): RichByte

    Definition Classes
    LowPriorityImplicits
    Annotations
    @inline()

  40. object charLength extends CharLengthOperator

    Definition Classes
    SQLOperatorSet

  41. implicit def charWrapper(c: Char): RichChar

    Definition Classes
    LowPriorityImplicits
    Annotations
    @inline()

  42. object characterLength extends CharacterLengthOperator

    Definition Classes
    SQLOperatorSet

  43. object concat extends ConcatOperator

    Definition Classes
    SQLOperatorSet

  44. object concatWs extends ConcatWsOperator

    Definition Classes
    SQLOperatorSet

  45. implicit def createQueryToQuery[T <: dsl.BaseTable[T, _], R, G <: GroupBind, O <: OrderBind, L <: LimitBind, C <: ChainBind, AC <: AssignBind, Status <: StatusBind](assignment: CreateQuery[T, R, CreateType, G, O, L, C, AC, Status]): Query[T, R, CreateType, G, O, L, C, AC, Terminated]

    Definition Classes
    ModifyImplicits

  46. implicit def doubleWrapper(x: Double): RichDouble

    Definition Classes
    LowPriorityImplicits
    Annotations
    @inline()

  47. object exists extends ExistsOperator

    Definition Classes
    SQLOperatorSet

  48. implicit def fallbackStringCanBuildFrom[T]: CanBuildFrom[String, T, IndexedSeq[T]]

    Definition Classes
    LowPriorityImplicits

  49. implicit def floatWrapper(x: Float): RichFloat

    Definition Classes
    LowPriorityImplicits
    Annotations
    @inline()

  50. implicit def genericWrapArray[T](xs: Array[T]): WrappedArray[T]

    Definition Classes
    LowPriorityImplicits

  51. implicit def insertQueryToQuery[T <: dsl.BaseTable[T, _], R, G <: GroupBind, O <: OrderBind, L <: LimitBind, C <: ChainBind, AC <: AssignBind, Status <: StatusBind](assignment: InsertQuery[T, R, InsertType, G, O, L, C, AC, Status]): Query[T, R, InsertType, G, O, L, C, AC, Terminated]

    Definition Classes
    ModifyImplicits

  52. implicit def intWrapper(x: Int): RichInt

    Definition Classes
    LowPriorityImplicits
    Annotations
    @inline()

  53. implicit def longWrapper(x: Long): RichLong

    Definition Classes
    LowPriorityImplicits
    Annotations
    @inline()

  54. object notExists extends NotExistsOperator

    Definition Classes
    SQLOperatorSet

  55. implicit def queryInsertQuery[T <: dsl.BaseTable[T, _], R, G <: GroupBind, O <: OrderBind, L <: LimitBind, C <: ChainBind, AC <: AssignBind, Status <: StatusBind](query: Query[T, R, InsertType, G, O, L, C, AC, Status]): InsertQuery[T, R, InsertType, G, O, L, C, AC, Status]

    Definition Classes
    ModifyImplicits

  56. implicit def queryToAssignmentsQuery[T <: dsl.BaseTable[T, _], R, G <: GroupBind, O <: OrderBind, L <: LimitBind, C <: ChainBind, AC <: AssignBind, Status <: StatusBind](query: Query[T, R, UpdateType, G, O, L, C, AC, Status]): AssignmentsQuery[T, R, UpdateType, G, O, L, C, AC, Status]

    Definition Classes
    ModifyImplicits

  57. implicit def queryToCreateQuery[T <: dsl.BaseTable[T, _], R, G <: GroupBind, O <: OrderBind, L <: LimitBind, C <: ChainBind, AC <: AssignBind, Status <: StatusBind](query: Query[T, R, CreateType, G, O, L, C, AC, Status]): CreateQuery[T, R, CreateType, G, O, L, C, AC, Status]

    Definition Classes
    ModifyImplicits

  58. implicit def queryToSelectQuery[T <: dsl.BaseTable[T, _], R, G <: GroupBind, O <: OrderBind, L <: LimitBind, C <: ChainBind, AC <: AssignBind, Status <: StatusBind](query: Query[T, R, SelectType, G, O, L, C, AC, Status]): SelectQuery[T, R, SelectType, G, O, L, C, AC, Status]

    Definition Classes
    ModifyImplicits

  59. implicit def rootCreateQueryToCreateQuery[T <: dsl.BaseTable[T, _], R](root: RootCreateQuery[T, R]): CreateQuery[T, R, CreateType, Ungroupped, Unordered, Unlimited, Unchainned, AssignUnchainned, Unterminated]

    This defines an implicit conversion from a RootInsertQuery to an InsertQuery, making the INSERT syntax block invisible to the end user.

    This defines an implicit conversion from a RootInsertQuery to an InsertQuery, making the INSERT syntax block invisible to the end user. This allows chaining a "value" method call directly after "Table.insert".

    T

    The table owning the record.

    R

    The record type.

    root

    The RootSelectQuery to convert.

    returns

    An executable SelectQuery.

    Definition Classes
    CreateImplicits

  60. implicit def rootCreateQueryToQuery[T <: dsl.BaseTable[T, _], R](root: RootCreateQuery[T, R]): Query[T, R, CreateType, Ungroupped, Unordered, Unlimited, Unchainned, AssignUnchainned, Unterminated]

    Definition Classes
    ModifyImplicits

  61. implicit def rootDeleteQueryToDeleteQuery[T <: dsl.BaseTable[T, _], R](root: RootDeleteQuery[T, R]): Query[T, R, DeleteType, Ungroupped, Unordered, Unlimited, Unchainned, AssignUnchainned, Unterminated]

    This defines an implicit conversion from a RootUpdateQuery to an UpdateQuery, making the UPDATE syntax block invisible to the end user.

    This defines an implicit conversion from a RootUpdateQuery to an UpdateQuery, making the UPDATE syntax block invisible to the end user. Much like a decision block, a UpdateSyntaxBlock needs a decision branch to follow, may that be nothing, LOW_PRIORITY or IGNORE.

    The one catch is that this form of "exit" from an un-executable RootUpdateQuery will directly translate the query to an "UPDATE tableName" query, meaning no UPDATE operators will be used in the default serialisation.

    The simple assumption made here is that since the user didn't use any other provided method, such as "lowPriority" or "ignore" the desired behaviour is a full select.

    T

    The table owning the record.

    R

    The record type.

    root

    The RootSelectQuery to convert.

    returns

    An executable SelectQuery.

    Definition Classes
    ModifyImplicits

  62. implicit def rootInsertQueryToInsertQuery[T <: dsl.BaseTable[T, _], R](root: RootInsertQuery[T, R]): InsertQuery[T, R, InsertType, Ungroupped, Unordered, Unlimited, Unchainned, AssignUnchainned, Unterminated]

    This defines an implicit conversion from a RootInsertQuery to an InsertQuery, making the INSERT syntax block invisible to the end user.

    This defines an implicit conversion from a RootInsertQuery to an InsertQuery, making the INSERT syntax block invisible to the end user. This allows chaining a "value" method call directly after "Table.insert".

    T

    The table owning the record.

    R

    The record type.

    root

    The RootSelectQuery to convert.

    returns

    An executable SelectQuery.

    Definition Classes
    ModifyImplicits

  63. implicit def rootInsertQueryToQuery[T <: dsl.BaseTable[T, _], R](root: RootInsertQuery[T, R]): Query[T, R, InsertType, Ungroupped, Unordered, Unlimited, Unchainned, AssignUnchainned, Unterminated]

    This defines an implicit conversion from a RootInsertQuery to an InsertQuery, making the INSERT syntax block invisible to the end user.

    This defines an implicit conversion from a RootInsertQuery to an InsertQuery, making the INSERT syntax block invisible to the end user. This is used to automatically "exit" the INSERT syntax block with the default "INSERT INTO" option, while picking no other SQL options such as IGNORE or LOW_PRIORITY.

    This is making the following queries equivalent: - Table.insert.into.queryString = "INSERT INTO table" - Table.insert = "INSERT INTO table"

    T

    The table owning the record.

    R

    The record type.

    root

    The RootSelectQuery to convert.

    returns

    An executable SelectQuery.

    Definition Classes
    ModifyImplicits

  64. implicit def rootSelectQueryToSelectQuery[T <: dsl.BaseTable[T, _], R](root: AbstractRootSelectQuery[T, R]): Query[T, R, SelectType, Ungroupped, Unordered, Unlimited, Unchainned, AssignUnchainned, Unterminated]

    This defines an implicit conversion from a RootSelectQuery to a SelectQuery, making the SELECT syntax block invisible to the end user.

    This defines an implicit conversion from a RootSelectQuery to a SelectQuery, making the SELECT syntax block invisible to the end user. Much like a decision block, a SelectSyntaxBlock needs a decision branch to follow, may that be DISTINCT, ALL or DISTINCTROW as per the SQL spec.

    The one catch is that this form of "exit" from an un-executable RootSelectQuery will directly translate the query to a "SELECT fields* FROM tableName" query, meaning no SELECT operators will be used in the serialisation.

    The simple assumption made here is that since the user didn't use any other provided method, such as "all", "distinct" or "distinctrow", the desired behaviour is a full select.

    T

    The table owning the record.

    R

    The record type.

    root

    The RootSelectQuery to convert.

    returns

    An executable SelectQuery.

    Definition Classes
    ModifyImplicits

  65. implicit def rootUpdateQueryToAssignQuery[T <: dsl.BaseTable[T, _], R](root: RootUpdateQuery[T, R]): AssignmentsQuery[T, R, UpdateType, Ungroupped, Unordered, Unlimited, Unchainned, AssignUnchainned, Unterminated]

    Definition Classes
    ModifyImplicits

  66. implicit def rootUpdateQueryToUpdateQuery[T <: dsl.BaseTable[T, _], R](root: RootUpdateQuery[T, R]): Query[T, R, UpdateType, Ungroupped, Unordered, Unlimited, Unchainned, AssignUnchainned, Unterminated]

    This defines an implicit conversion from a RootUpdateQuery to an UpdateQuery, making the UPDATE syntax block invisible to the end user.

    This defines an implicit conversion from a RootUpdateQuery to an UpdateQuery, making the UPDATE syntax block invisible to the end user. Much like a decision block, a UpdateSyntaxBlock needs a decision branch to follow, may that be nothing, LOW_PRIORITY or IGNORE.

    The one catch is that this form of "exit" from an un-executable RootUpdateQuery will directly translate the query to an "UPDATE tableName" query, meaning no UPDATE operators will be used in the default serialisation.

    The simple assumption made here is that since the user didn't use any other provided method, such as "lowPriority" or "ignore" the desired behaviour is a full select.

    T

    The table owning the record.

    R

    The record type.

    root

    The RootSelectQuery to convert.

    returns

    An executable SelectQuery.

    Definition Classes
    ModifyImplicits

  67. implicit def selectOperatorClauseToSelectColumn[T](clause: SelectOperatorClause[T]): SelectColumn[T]

    Definition Classes
    ModifyImplicits

  68. implicit def selectQueryToQuery[T <: dsl.BaseTable[T, _], R, G <: GroupBind, O <: OrderBind, L <: LimitBind, C <: ChainBind, AC <: AssignBind, Status <: StatusBind](assignment: SelectQuery[T, R, SelectType, G, O, L, C, AC, Status]): Query[T, R, SelectType, G, O, L, C, AC, Terminated]

    Definition Classes
    ModifyImplicits

  69. implicit def shortWrapper(x: Short): RichShort

    Definition Classes
    LowPriorityImplicits
    Annotations
    @inline()

  70. implicit def unwrapString(ws: WrappedString): String

    Definition Classes
    LowPriorityImplicits

  71. implicit def wrapBooleanArray(xs: Array[Boolean]): WrappedArray[Boolean]

    Definition Classes
    LowPriorityImplicits

  72. implicit def wrapByteArray(xs: Array[Byte]): WrappedArray[Byte]

    Definition Classes
    LowPriorityImplicits

  73. implicit def wrapCharArray(xs: Array[Char]): WrappedArray[Char]

    Definition Classes
    LowPriorityImplicits

  74. implicit def wrapDoubleArray(xs: Array[Double]): WrappedArray[Double]

    Definition Classes
    LowPriorityImplicits

  75. implicit def wrapFloatArray(xs: Array[Float]): WrappedArray[Float]

    Definition Classes
    LowPriorityImplicits

  76. implicit def wrapIntArray(xs: Array[Int]): WrappedArray[Int]

    Definition Classes
    LowPriorityImplicits

  77. implicit def wrapLongArray(xs: Array[Long]): WrappedArray[Long]

    Definition Classes
    LowPriorityImplicits

  78. implicit def wrapRefArray[T <: AnyRef](xs: Array[T]): WrappedArray[T]

    Definition Classes
    LowPriorityImplicits

  79. implicit def wrapShortArray(xs: Array[Short]): WrappedArray[Short]

    Definition Classes
    LowPriorityImplicits

  80. implicit def wrapString(s: String): WrappedString

    Definition Classes
    LowPriorityImplicits

  81. implicit def wrapUnitArray(xs: Array[Unit]): WrappedArray[Unit]

    Definition Classes
    LowPriorityImplicits

Inherited from SQLOperatorSet

Inherited from MaterialisedPrimitives

Inherited from DefaultImportsDefinition

Inherited from CreateImplicits

Inherited from DefaultSQLEngines

Inherited from DefaultForeignKeyConstraints

Inherited from ModifyImplicits

Inherited from JoinImplicits

Inherited from LowPriorityImplicits

Inherited from AnyRef

Inherited from Any

Ungrouped