abstract class CRUD[T, PrimaryKeyType] extends JdbcProfileComponent[DbAppConfig]

Created by chris on 9/8/16. This is an abstract actor that can be used to implement any sort of actor that accesses a Postgres database. It creates read, update, upsert, and delete methods for your actor to call. You are responsible for the create function. You also need to specify the table and the database you are connecting to.

Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. CRUD
  2. JdbcProfileComponent
  3. Logging
  4. AnyRef
  5. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. Protected

Instance Constructors

  1. new CRUD()(implicit ec: ExecutionContext, appConfig: DbAppConfig)

Abstract Value Members

  1. abstract def createAll(ts: Vector[T]): Future[Vector[T]]
  2. abstract def findAll(ts: Vector[T]): slick.jdbc.JdbcProfile.API.Query[slick.jdbc.JdbcProfile.API.Table[_], T, Seq]
    Attributes
    protected
  3. abstract def findByPrimaryKeys(ids: Vector[PrimaryKeyType]): slick.jdbc.JdbcProfile.API.Query[slick.jdbc.JdbcProfile.API.Table[T], T, Seq]

    Finds the rows that correlate to the given primary keys

    Finds the rows that correlate to the given primary keys

    Attributes
    protected
  4. abstract val table: slick.jdbc.JdbcProfile.API.TableQuery[_ <: slick.jdbc.JdbcProfile.API.Table[T]]

    The table inside our database we are inserting into

Concrete 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. implicit val appConfig: DbAppConfig
    Definition Classes
    CRUDJdbcProfileComponent
  5. final def asInstanceOf[T0]: T0
    Definition Classes
    Any
  6. def clone(): AnyRef
    Attributes
    protected[lang]
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.CloneNotSupportedException]) @native()
  7. def count(): Future[Int]

    Returns number of rows in the table

  8. def create(t: T): Future[T]

    create a record in the database

    create a record in the database

    t

    - the record to be inserted

    returns

    the inserted record

  9. lazy val database: slick.jdbc.JdbcProfile.API.Database

    The database we are connecting to

    The database we are connecting to

    Definition Classes
    JdbcProfileComponent
  10. lazy val dbConfig: DatabaseConfig[JdbcProfile]

    The configuration details for connecting/using the database for our projects that require database connections

    The configuration details for connecting/using the database for our projects that require database connections

    Definition Classes
    JdbcProfileComponent
  11. def debug(mkr: Marker, msg: => Any, t: => Throwable): Unit
    Attributes
    protected
    Definition Classes
    Logging
  12. def debug(msg: => Any, t: => Throwable): Unit
    Attributes
    protected
    Definition Classes
    Logging
  13. def debug(msg: => Any): Unit
    Attributes
    protected
    Definition Classes
    Logging
  14. def delete(t: T): Future[Int]

    delete the corresponding record in the database

    delete the corresponding record in the database

    t

    - the record to be deleted

    returns

    int - the number of rows affected by the deletion

  15. def deleteAll(): Future[Int]

    delete all records from the table

  16. final def eq(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  17. def equals(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef → Any
  18. def error(mkr: Marker, msg: => Any, t: => Throwable): Unit
    Attributes
    protected
    Definition Classes
    Logging
  19. def error(msg: => Any, t: => Throwable): Unit
    Attributes
    protected
    Definition Classes
    Logging
  20. def error(msg: => Any): Unit
    Attributes
    protected
    Definition Classes
    Logging
  21. def finalize(): Unit
    Attributes
    protected[lang]
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.Throwable])
  22. def find(t: T): slick.jdbc.JdbcProfile.API.Query[slick.jdbc.JdbcProfile.API.Table[_], T, Seq]

    return the row that corresponds with this record

    return the row that corresponds with this record

    t

    - the row to find

    returns

    query - the sql query to find this record

    Attributes
    protected
  23. def findAll(): Future[Vector[T]]

    Finds all elements in the table

  24. def findByPrimaryKey(id: PrimaryKeyType): slick.jdbc.JdbcProfile.API.Query[slick.jdbc.JdbcProfile.API.Table[_], T, Seq]

    return all rows that have a certain primary key

    return all rows that have a certain primary key

    returns

    Query object corresponding to the selected rows

    Attributes
    protected
  25. final def getClass(): Class[_ <: AnyRef]
    Definition Classes
    AnyRef → Any
    Annotations
    @native()
  26. def hashCode(): Int
    Definition Classes
    AnyRef → Any
    Annotations
    @native()
  27. def info(mkr: Marker, msg: => Any, t: => Throwable): Unit
    Attributes
    protected
    Definition Classes
    Logging
  28. def info(msg: => Any, t: => Throwable): Unit
    Attributes
    protected
    Definition Classes
    Logging
  29. def info(msg: => Any): Unit
    Attributes
    protected
    Definition Classes
    Logging
  30. def isDebugEnabled: Boolean
    Attributes
    protected
    Definition Classes
    Logging
  31. def isErrorEnabled: Boolean
    Attributes
    protected
    Definition Classes
    Logging
  32. def isInfoEnabled: Boolean
    Attributes
    protected
    Definition Classes
    Logging
  33. final def isInstanceOf[T0]: Boolean
    Definition Classes
    Any
  34. def isTraceEnabled: Boolean
    Attributes
    protected
    Definition Classes
    Logging
  35. def isWarnEnabled: Boolean
    Attributes
    protected
    Definition Classes
    Logging
  36. def logger: Logger
    Attributes
    protected
    Definition Classes
    Logging
  37. def loggerName: String
    Attributes
    protected
    Definition Classes
    Logging
  38. final def ne(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  39. final def notify(): Unit
    Definition Classes
    AnyRef
    Annotations
    @native()
  40. final def notifyAll(): Unit
    Definition Classes
    AnyRef
    Annotations
    @native()
  41. lazy val numThreads: Int
    Definition Classes
    JdbcProfileComponent
  42. lazy val password: String
    Definition Classes
    JdbcProfileComponent
  43. lazy val profile: JdbcProfile
    Definition Classes
    JdbcProfileComponent
  44. def read(id: PrimaryKeyType): Future[Option[T]]

    read a record from the database

    read a record from the database

    id

    - the id of the record to be read

    returns

    Option[T] - the record if found, else none

  45. def safeDatabase: SafeDatabase

    Binding to the actual database itself, this is what is used to run querys

  46. val schemaName: Option[String]
  47. def startHikariLogger(interval: Duration): HikariLogging

    Starts the background logger for hikari

    Starts the background logger for hikari

    interval

    - how often hikari logs database connection pool information

    Attributes
    protected
    Definition Classes
    JdbcProfileComponent
  48. def stopHikariLogger(): Unit
    Attributes
    protected
    Definition Classes
    JdbcProfileComponent
  49. final def synchronized[T0](arg0: => T0): T0
    Definition Classes
    AnyRef
  50. implicit def tableQuerySafeSubtypeCast[SpecificT <: AbstractTable[_], SomeT <: SpecificT](tableQuery: slick.jdbc.JdbcProfile.API.TableQuery[SomeT]): slick.jdbc.JdbcProfile.API.TableQuery[SpecificT]

    We need to cast from TableQuery's of internal types (e.g.

    We need to cast from TableQuery's of internal types (e.g. AddressDAO#AddressTable) to external versions of them (e.g. AddressDAO().table). You'll notice that although the latter is a subtype of the first, this requires a cast since TableQuery is not covariant in its type parameter.

    However, since Query is covariant in its first type parameter, I believe the cast from TableQuery[T1] to TableQuery[T2] will always be safe so long as T1 is a subtype of T2 AND T1#TableElementType is equal to T2#TableElementType.

    The above conditions are always the case when this is called within DAOs as it is only ever used for things of the form TableQuery[XDAO().table] -> TableQuery[XDAO#XTable].

    Attributes
    protected
  51. def toString(): String
    Definition Classes
    AnyRef → Any
  52. def trace(mkr: Marker, msg: => Any, t: => Throwable): Unit
    Attributes
    protected
    Definition Classes
    Logging
  53. def trace(msg: => Any, t: => Throwable): Unit
    Attributes
    protected
    Definition Classes
    Logging
  54. def trace(msg: => Any): Unit
    Attributes
    protected
    Definition Classes
    Logging
  55. def update(t: T): Future[T]

    Update the corresponding record in the database

  56. def updateAll(ts: Vector[T]): Future[Vector[T]]
  57. def upsert(t: T): Future[T]

    insert the record if it does not exist, update it if it does

    insert the record if it does not exist, update it if it does

    t

    - the record to inserted / updated

    returns

    t - the record that has been inserted / updated

  58. def upsertAll(ts: Vector[T]): Future[Vector[T]]

    Upserts all of the given ts in the database, then returns the upserted values

  59. lazy val username: String
    Definition Classes
    JdbcProfileComponent
  60. final def wait(): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.InterruptedException])
  61. final def wait(arg0: Long, arg1: Int): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.InterruptedException])
  62. final def wait(arg0: Long): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.InterruptedException]) @native()
  63. def warn(mkr: Marker, msg: => Any, t: => Throwable): Unit
    Attributes
    protected
    Definition Classes
    Logging
  64. def warn(msg: => Any, t: => Throwable): Unit
    Attributes
    protected
    Definition Classes
    Logging
  65. def warn(msg: => Any): Unit
    Attributes
    protected
    Definition Classes
    Logging

Inherited from Logging

Inherited from AnyRef

Inherited from Any

Ungrouped