QueryDSL
scalikejdbc.QueryDSLFeature.QueryDSL
object QueryDSL
Prefix object to avoid name conflict.
withSQL { QueryDSL.select.from(User as u).where.eq(u.id, 123) }
Attributes
- Source
- QueryDSLFeature.scala
- Graph
-
- Supertypes
-
class Objecttrait Matchableclass Any
- Self type
-
QueryDSL.type
Members list
Type members
Classlikes
object delete
Query Interface for delete query.
Query Interface for delete query.
implicit val session = AutoSession
val (u, c) = (User.syntax("u"), User.column)
withSQL { delete.from(User as u).where.eq(u.id, 1) }.update.apply()
applyUpdate { delete.from(User).where.eq(c.id, 1) }
Attributes
- Source
- QueryDSLFeature.scala
- Supertypes
-
class Objecttrait Matchableclass Any
- Self type
-
delete.type
object deleteFrom
Attributes
- Source
- QueryDSLFeature.scala
- Supertypes
-
class Objecttrait Matchableclass Any
- Self type
-
deleteFrom.type
object insert
Query Interface for insert query.
Query Interface for insert query.
implicit val session = AutoSession
val (u, c) = (User.syntax("u"), User.column)
withSQL { insert.into(User).columns(c.id, c.name, c.createdAt).values(1, "Alice", DateTime.now) }.update.apply()
applyUpdate { insert.into(User).values(2, "Bob", DateTime.now) }
Attributes
- Source
- QueryDSLFeature.scala
- Supertypes
-
class Objecttrait Matchableclass Any
- Self type
-
insert.type
object insertInto
Attributes
- Source
- QueryDSLFeature.scala
- Supertypes
-
class Objecttrait Matchableclass Any
- Self type
-
insertInto.type
object select
Query Interface for select query.
Query Interface for select query.
implicit val session = AutoSession
val u = User.syntax("u")
val user = withSQL { select.from(User).where.eq.(u.id, 123) }.map(User(u.resultName)).single.apply()
val userIdAndName = withSQL {
select(u.result.id, u.result.name).from(User).where.eq.(u.id, 123)
}.map(User(u.resultName)).single.apply()
Attributes
- Source
- QueryDSLFeature.scala
- Supertypes
-
class Objecttrait Matchableclass Any
- Self type
-
select.type
object selectFrom
Attributes
- Source
- QueryDSLFeature.scala
- Supertypes
-
class Objecttrait Matchableclass Any
- Self type
-
selectFrom.type
object update
Query Interface for update query.
Query Interface for update query.
implicit val session = AutoSession
val u = User.syntax("u")
withSQL { update(User as u).set(u.name -> "Chris", u.updatedAt -> DateTime.now).where.eq(u.id, 1) }.update.apply()
applyUpdate { update(User as u).set(u.name -> "Dennis").where.eq(u.id, 1) }
Attributes
- Source
- QueryDSLFeature.scala
- Supertypes
-
class Objecttrait Matchableclass Any
- Self type
-
update.type
In this article