DB Session
This class provides readOnly/autoCommit/localTx/withinTx blocks and session objects.
import scalikejdbc._
val userIdList = DB autoCommit { session: DBSession =>
session.list("select * from user") { rs => rs.int("id") }
}
Attributes
- Companion
- object
- Source
- DBSession.scala
- Graph
-
- Supertypes
- Known subtypes
-
class ActiveSessionclass AutoSessionobject AutoSession.typeclass NamedAutoSessionobject NoSession.typeobject ReadOnlyAutoSession.typeclass ReadOnlyNamedAutoSessionShow all
Members list
Type members
Inherited types
Attributes
- Inherited from:
- LoanPattern
- Source
- LoanPattern.scala
Value members
Concrete methods
Executes java.sql.PreparedStatement#executeBatch().
Executes java.sql.PreparedStatement#executeBatch().
Value parameters
- paramsList
-
list of parameters
- template
-
SQL template
Attributes
- Returns
-
count list
- Source
- DBSession.scala
Executes java.sql.PreparedStatement#executeBatch() and returns numeric generated keys.
Executes java.sql.PreparedStatement#executeBatch() and returns numeric generated keys.
Value parameters
- paramsList
-
list of parameters
- template
-
SQL template
Attributes
- Returns
-
generated keys
- Source
- DBSession.scala
Executes java.sql.PreparedStatement#executeBatch() and returns numeric generated keys.
Executes java.sql.PreparedStatement#executeBatch() and returns numeric generated keys.
Value parameters
- key
-
generated key name
- paramsList
-
list of parameters
- template
-
SQL template
Attributes
- Returns
-
generated keys
- Source
- DBSession.scala
Close the connection.
Returns query result as any Collection object.
Returns query result as any Collection object.
Type parameters
- A
-
return type
- C
-
return collection type
Value parameters
- extract
-
extract function
- params
-
parameters
- template
-
SQL template
Attributes
- Returns
-
result as C[A]
- Source
- DBSession.scala
Executes java.sql.PreparedStatement#execute().
Executes java.sql.PreparedStatement#execute().
Value parameters
- params
-
parameters
- template
-
SQL template
Attributes
- Returns
-
flag
- Source
- DBSession.scala
Executes java.sql.PreparedStatement#executeLargeUpdate().
Executes java.sql.PreparedStatement#executeLargeUpdate().
Value parameters
- params
-
parameters
- template
-
SQL template
Attributes
- Returns
-
result count
- Source
- DBSession.scala
Executes java.sql.PreparedStatement#executeUpdate().
Executes java.sql.PreparedStatement#executeUpdate().
Value parameters
- params
-
parameters
- template
-
SQL template
Attributes
- Returns
-
result count
- Source
- DBSession.scala
Executes java.sql.PreparedStatement#execute().
Executes java.sql.PreparedStatement#execute().
Value parameters
- after
-
after filter
- before
-
before filter
- params
-
parameters
- template
-
SQL template
Attributes
- Returns
-
flag
- Source
- DBSession.scala
Set fetchSize for this session.
Set fetchSize for this session.
Value parameters
- fetchSize
-
fetch size
Attributes
- Returns
-
this
- Source
- DBSession.scala
Attributes
- Source
- DBSession.scala
Returns fetchSize for this session.
Returns the first row optionally.
Returns the first row optionally.
Type parameters
- A
-
return type
Value parameters
- extract
-
extract function
- params
-
parameters
- template
-
SQL template
Attributes
- Returns
-
result optionally
- Source
- DBSession.scala
folding into one value.
folding into one value.
Value parameters
- op
-
function
- params
-
parameters
- template
-
SQL template
- z
-
initial value
Attributes
- Returns
-
folded value
- Source
- DBSession.scala
Applies side-effect to each row iteratively.
Applies side-effect to each row iteratively.
Value parameters
- f
-
function
- params
-
parameters
- template
-
SQL template
Attributes
- Returns
-
result as list
- Source
- DBSession.scala
Returns query result as scala.collection.Iterable object.
Returns query result as scala.collection.Iterable object.
Type parameters
- A
-
return type
Value parameters
- extract
-
extract function
- params
-
parameters
- template
-
SQL template
Attributes
- Returns
-
result as iterable
- Source
- DBSession.scala
Executes java.sql.PreparedStatement#executeLargeBatch().
Executes java.sql.PreparedStatement#executeLargeBatch().
Value parameters
- paramsList
-
list of parameters
- template
-
SQL template
Attributes
- Returns
-
count list
- Source
- DBSession.scala
Executes java.sql.PreparedStatement#executeLargeUpdate().
Executes java.sql.PreparedStatement#executeLargeUpdate().
Value parameters
- after
-
after filter
- before
-
before filter
- generatedKeyName
-
generated key name
- params
-
parameters
- returnGeneratedKeys
-
is generated keys required
- template
-
SQL template
Attributes
- Returns
-
result count
- Source
- DBSession.scala
Executes java.sql.PreparedStatement#executeLargeUpdate().
Executes java.sql.PreparedStatement#executeLargeUpdate().
Value parameters
- after
-
after filter
- before
-
before filter
- params
-
parameters
- template
-
SQL template
Attributes
- Returns
-
result count
- Source
- DBSession.scala
Executes java.sql.PreparedStatement#executeLargeUpdate().
Executes java.sql.PreparedStatement#executeLargeUpdate().
Value parameters
- after
-
after filter
- before
-
before filter
- params
-
parameters
- returnGeneratedKeys
-
is generated keys required
- template
-
SQL template
Attributes
- Returns
-
result count
- Source
- DBSession.scala
Returns query result as scala.List object.
Returns query result as scala.List object.
Type parameters
- A
-
return type
Value parameters
- extract
-
extract function
- params
-
parameters
- template
-
SQL template
Attributes
- Returns
-
result as list
- Source
- DBSession.scala
Set queryTimeout to this session.
Set queryTimeout to this session.
Value parameters
- seconds
-
query timeout seconds
Attributes
- Returns
-
this
- Source
- DBSession.scala
Attributes
- Source
- DBSession.scala
Returns queryTimeout for this session.
Returns queryTimeout for this session.
Attributes
- Returns
-
query timeout seconds
- Source
- DBSession.scala
Returns single result optionally. If the result is not single, scalikejdbc.TooManyRowsException will be thrown.
Returns single result optionally. If the result is not single, scalikejdbc.TooManyRowsException will be thrown.
Type parameters
- A
-
return type
Value parameters
- extract
-
extract function
- params
-
parameters
- template
-
SQL template
Attributes
- Returns
-
result optionally
- Source
- DBSession.scala
Set tags to this session.
Returns tags for this session.
Attributes
- Source
- DBSession.scala
Attributes
- Source
- DBSession.scala
Returns current transaction if exists.
Executes java.sql.PreparedStatement#executeUpdate().
Executes java.sql.PreparedStatement#executeUpdate().
Value parameters
- params
-
parameters
- template
-
SQL template
Attributes
- Returns
-
result count
- Source
- DBSession.scala
Executes java.sql.PreparedStatement#executeUpdate() and returns the generated key.
Executes java.sql.PreparedStatement#executeUpdate() and returns the generated key.
Value parameters
- params
-
parameters
- template
-
SQL template
Attributes
- Returns
-
generated key as a long value
- Source
- DBSession.scala
Executes java.sql.PreparedStatement#executeUpdate() and returns the generated key.
Executes java.sql.PreparedStatement#executeUpdate() and returns the generated key.
Value parameters
- key
-
name
- params
-
parameters
- template
-
SQL template
Attributes
- Returns
-
generated key as a long value
- Source
- DBSession.scala
Executes java.sql.PreparedStatement#executeUpdate().
Executes java.sql.PreparedStatement#executeUpdate().
Value parameters
- after
-
after filter
- before
-
before filter
- generatedKeyName
-
generated key name
- params
-
parameters
- returnGeneratedKeys
-
is generated keys required
- template
-
SQL template
Attributes
- Returns
-
result count
- Source
- DBSession.scala
Executes java.sql.PreparedStatement#executeUpdate().
Executes java.sql.PreparedStatement#executeUpdate().
Value parameters
- after
-
after filter
- before
-
before filter
- params
-
parameters
- template
-
SQL template
Attributes
- Returns
-
result count
- Source
- DBSession.scala
Executes java.sql.PreparedStatement#executeUpdate().
Executes java.sql.PreparedStatement#executeUpdate().
Value parameters
- after
-
after filter
- before
-
before filter
- params
-
parameters
- returnGeneratedKeys
-
is generated keys required
- template
-
SQL template
Attributes
- Returns
-
result count
- Source
- DBSession.scala
Inherited methods
Guarantees a Closeable resource will be closed after being passed to a block that takes the resource as a parameter and returns a Future.
Guarantees a Closeable resource will be closed after being passed to a block that takes the resource as a parameter and returns a Future.
Attributes
- Inherited from:
- LoanPattern
- Source
- LoanPattern.scala
Attributes
- Inherited from:
- LoanPattern
- Source
- LoanPattern.scala
Abstract fields
is read-only session
Concrete fields
Connection
Inherited fields
Logger