Mercurial > prosody-hg
comparison util/sql.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 | edd006093533 |
| children |
comparison
equal
deleted
inserted
replaced
| 13964:36d361722889 | 13966:e7c52d0b0e0d |
|---|---|
| 242 log("error", "Error in SQL transaction: %s", ret); | 242 log("error", "Error in SQL transaction: %s", ret); |
| 243 end | 243 end |
| 244 end | 244 end |
| 245 return ok, ret, b, c; | 245 return ok, ret, b, c; |
| 246 end | 246 end |
| 247 engine.write_transaction = engine.transaction; -- TODO can you signal intent to write upfront in pg or mysql? | |
| 247 function engine:_create_index(index) | 248 function engine:_create_index(index) |
| 248 local sql = "CREATE INDEX \""..index.name.."\" ON \""..index.table.."\" ("; | 249 local sql = "CREATE INDEX \""..index.name.."\" ON \""..index.table.."\" ("; |
| 249 if self.params.driver ~= "MySQL" then | 250 if self.params.driver ~= "MySQL" then |
| 250 sql = sql:gsub("^CREATE INDEX", "%1 IF NOT EXISTS"); | 251 sql = sql:gsub("^CREATE INDEX", "%1 IF NOT EXISTS"); |
| 251 end | 252 end |