Provides auto-commit session block.
Provides auto-commit session block.
return type
block
result value
Returns auto-commit session.
Provides auto-commit session block.
Provides auto-commit session block.
return type
block
result value
Begins a new transaction.
Begins a new transaction.
Begins a new transaction if the other one does not already start.
Begins a new transaction if the other one does not already start.
Close the connection.
Close the connection.
Commits the current transaction.
Commits the current transaction.
Returns the current transaction.
Returns the current transaction. If the transaction has not started yet, IllegalStateException will be thrown.
tx
Returns describe style string value for the table
Returns describe style string value for the table
table name (with schema optionally)
described information
Returns all the column names on the matched table name
Returns all the column names on the matched table name
Returns table information if exists
Returns table information if exists
table name (with schema optionally)
table information
Returns all the table information that match the pattern
Returns all the table information that match the pattern
table name pattern (with schema optionally)
table information
Returns is the current transaction already started.
Returns is the current transaction is active.
Returns is the current transaction hasn't started yet.
Provides local-tx session block.
Provides local-tx session block.
return type
block
result value
Provides local-tx session block.
Provides local-tx session block.
return type
block
result value
Logger
Logger
Starts a new transaction and returns it.
Provides read-only session block.
Provides read-only session block.
return type
block
result value
Returns read-only session.
Provides read-only session block.
Provides read-only session block.
return type
block
result value
Rolls back the current transaction.
Rolls back the current transaction.
Rolls back the current transaction if the transaction is still active.
Rolls back the current transaction if the transaction is still active.
Returns table name list
Returns table name list
table name pattern
table types
table name list
Returns the current transaction.
Returns the current transaction. If the transaction has not started yet, IllegalStateException will be thrown.
tx
Provides within-tx session block.
Provides within-tx session block.
return type
block
result value
Returns within-tx session.
Provides within-tx session block.
Provides within-tx session block.
return type
block
result value
Basic Database Accessor
Using DBSession:
import scalikejdbc._ case class User(id: Int, name: String) using(connectionPool(context).borrow()) { conn => val users = DB(conn) readOnly { session => session.list("select * from user") { rs => User(rs.int("id"), rs.string("name")) } } DB(conn) autoCommit { session => session.update("insert into user values (?,?)", 123, "Alice") } DB(conn) localTx { session => session.update("insert into user values (?,?)", 123, "Alice") } }Using SQL:
import scalikejdbc._ case class User(id: Int, name: String) using(ConnectionPool.borrow()) { conn => val users = DB(conn) readOnly { session => SQL("select * from user").map { rs => User(rs.int("id"), rs.string("name")) }.list.apply() } DB(conn) autoCommit { session => SQL("insert into user values (?,?)").bind(123, "Alice").update.apply() } DB(conn) localTx { session => SQL("insert into user values (?,?)").bind(123, "Alice").update.apply() } }