SQL

Hooks

swatch_mysql_config_loaded

Called as soon as all config entries has been loaded from database.

swatch_mysql_connected

Called as soon a mysql database connected. Called instantly with sqlite. Rather use swatch_mysql_config_loaded

Functions

Use below functions only after swatch_mysql_connected hook

sWatch.query

Executes sql query

Arguments

1. (String) query

sWatch.selectQuery

Arguments

1. (String) query

2. (Function) callback (optional)

Returns

1. (Callback)(Table) data - inside callback

Example

Internal code to load config from database

local query = "SELECT * FROM `swatch_config`"
sWatch.selectQuery(query, function(data)
    data = data or {}
    for _, row in pairs(data) do
        configCache[row.key] = {}
        configCache[row.key].value = dataTypesLoad[row.data_type](row.value)
    end
end)

sWatch.sqlEscape

Uses for sql flatfile sql.SQLStr and mysql:escape for mysql.

Arguments

1. (String) valueToEscape

Returns

1. (String) escapedValue