// Database 作为池:隐式 acquire/release + 池统计 + 池上开事务。
///|
/// 池的观测数据。
#derive(Eq, Debug)
pub(all) struct PoolStats {
acquire_count : Int64
acquire_wait_count : Int64
acquire_wait_duration_ms : Int64
}
///|
/// 池统计快照。
pub fn Database::stats(self : Database) -> PoolStats {
self.stats
}
///|
/// 池上限。
pub fn Database::max_conns(self : Database) -> Int {
self.max_conns
}
// ---------------------------------------------------------------------------
// 隐式 acquire/release:Database 本身实现 QueryExecutor
// ---------------------------------------------------------------------------
///|
pub impl QueryExecutor for Database with query(
self : Database,
sql : String,
params? : Array[&ToValue],
) -> &Rows raise TursoError {
let conn = self.connect()
errdefer conn.close()
// Rows 读完(或 close)时把连接还回池
conn.open_rows(sql, params?, release=conn)
}
///|
pub impl QueryExecutor for Database with query_one(
self : Database,
sql : String,
params? : Array[&ToValue],
) -> Row raise TursoError {
let conn = self.connect()
defer conn.close()
conn.query_one(sql, params?)
}
///|
pub impl QueryExecutor for Database with execute(
self : Database,
sql : String,
params? : Array[&ToValue],
) -> ExecResult raise TursoError {
let conn = self.connect()
defer conn.close()
conn.execute(sql, params?)
}
///|
pub extend Database with QueryExecutor::{query, query_one, execute}
// ---------------------------------------------------------------------------
// 池上开事务:仍然复用同一个 DbTx,commit/rollback 时把连接还回池
// ---------------------------------------------------------------------------
///|
pub impl TxBeginner for Database with begin_tx(
self : Database,
opts? : TxOptions,
) -> DbTx raise TursoError {
let conn = self.connect()
errdefer conn.close()
conn.begin_tx_internal(opts?, release_pool_conn=true)
}
///|
pub extend Database with TxBeginner::{begin_tx}