Mercurial > prosody-hg
comparison util/sqlite3.lua @ 13966:e7c52d0b0e0d
util.sql: Add API to start an explicit write transaction
This will be used in SQLite3 to BEGIN IMMEDIATE, which attempts to
acquire write locks immediately instead of when the first write
statement is started. Thus it would fail faster if the write lock is
already taken. Normally that should not occur but e.g. prosodyctl could
take it.
Investigating whether something similar is sensible in PostgreSQL, MySQL
is a future task.
| author | Kim Alvefur <zash@zash.se> |
|---|---|
| date | Mon, 19 Aug 2024 00:06:45 +0200 |
| parents | 844e7bf7b48a |
| children | 52e214142ac2 |
comparison
equal
deleted
inserted
replaced
| 13964:36d361722889 | 13966:e7c52d0b0e0d |
|---|---|
| 293 ok, ret = self:_transaction(...); | 293 ok, ret = self:_transaction(...); |
| 294 end | 294 end |
| 295 end | 295 end |
| 296 return ok, ret; | 296 return ok, ret; |
| 297 end | 297 end |
| 298 engine.write_transaction = engine.transaction; -- TODO BEGIN IMMEDATE | |
| 298 function engine:_create_index(index) | 299 function engine:_create_index(index) |
| 299 local sql = "CREATE INDEX IF NOT EXISTS \""..index.name.."\" ON \""..index.table.."\" ("; | 300 local sql = "CREATE INDEX IF NOT EXISTS \""..index.name.."\" ON \""..index.table.."\" ("; |
| 300 for i=1,#index do | 301 for i=1,#index do |
| 301 sql = sql.."\""..index[i].."\""; | 302 sql = sql.."\""..index[i].."\""; |
| 302 if i ~= #index then sql = sql..", "; end | 303 if i ~= #index then sql = sql..", "; end |