DbIsConnected: Difference between revisions
Jump to navigation
Jump to search
Complete Lua function catalog |
Document upcoming 0.1.4 database recovery; organize wiki navigation |
||
| Line 32: | Line 32: | ||
[[Category:Server Functions]] | [[Category:Server Functions]] | ||
[[Category:Database Functions]] | [[Category:Database Functions]] | ||
== Recovery from 0.1.4 == | |||
'''Since 0.1.4 (in development; not in public 0.1.3).''' See [[MySQL connection recovery]], [[dbReconnect]], [[dbGetConnectionState]] and [[onDatabaseConnectionStateChange]]. This function returns last-observed connection health, not a live network ping. A dead connection is marked unavailable when a worker observes the failure. | |||
Latest revision as of 10:51, 19 September 2026
dbIsConnected
Checks whether a resource-owned database connection is still open.
Syntax
bool dbIsConnected(DatabaseConnection connection)
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
connection |
DatabaseConnection |
yes | The connection to inspect. |
Returns
Returns true when the connection is valid and connected; otherwise returns false.
Examples
Verify the connection before executing a query:
if dbIsConnected(db) then
dbExec(db, "UPDATE players SET online = ?", true)
end
Notes
- Available only in server-side resource scripts.
Recovery from 0.1.4
Since 0.1.4 (in development; not in public 0.1.3). See MySQL connection recovery, dbReconnect, dbGetConnectionState and onDatabaseConnectionStateChange. This function returns last-observed connection health, not a live network ping. A dead connection is marked unavailable when a worker observes the failure.