mariadb await query: Difference between revisions
From Onset Developer Wiki
No edit summary |
No edit summary |
||
| (One intermediate revision by one other user not shown) | |||
| Line 16: | Line 16: | ||
<syntaxhighlight lang="Lua"> | <syntaxhighlight lang="Lua"> | ||
function OnPackageStart() | function OnPackageStart() | ||
local result = mariadb_await_query(sql, "SELECT name FROM server") | local result = mariadb_await_query(sql, "SELECT name FROM server;") | ||
if mariadb_get_row_count() ~= 0 then | if mariadb_get_row_count() ~= 0 then | ||
| Line 28: | Line 28: | ||
{{RelatedFunctions}} | {{RelatedFunctions}} | ||
{{MariaDBFunctions}} | |||
Latest revision as of 09:21, 2 September 2020
Description
Executes a query immediately blocking the main thread until it completes execution. You should use mariadb_query most of the times.
Syntax
mariadb_await_query(handle_id, query_str [, use_result])
Parameters
- handle_id
Connection handle. - query_str
Query to execute. - use_result (optional)
Defaults to true. Set this to false if you are not interested in the results of the query.
Return Value
- Returns the active result set of the query executed. You must call mariadb_delete_result after you are done with the query to free the returned result set.
Example
function OnPackageStart()
local result = mariadb_await_query(sql, "SELECT name FROM server;")
if mariadb_get_row_count() ~= 0 then
print(mariadb_get_value_index(1, 1))
end
mariadb_delete_result(result)
end
AddEvent("OnPackageStart", OnPackageStart)
See also
- OnQueryError
- mariadb_log
- mariadb_connect
- mariadb_connect_file
- mariadb_close
- mariadb_unprocessed_queries
- mariadb_async_query
- mariadb_query
- mariadb_await_query
- mariadb_query_file
- mariadb_await_query_file
- mariadb_errno
- mariadb_error
- mariadb_escape_string
- mariadb_prepare
- mariadb_set_charset
- mariadb_get_charset
- mariadb_stat
- mariadb_get_row_count
- mariadb_get_field_count
- mariadb_get_result_count
- mariadb_get_field_name
- mariadb_set_result
- mariadb_get_value_index
- mariadb_get_value_index_int
- mariadb_get_value_index_float
- mariadb_get_value_name
- mariadb_get_value_name_int
- mariadb_get_value_name_float
- mariadb_save_result
- mariadb_delete_result
- mariadb_set_active_result
- mariadb_unset_active_result
- mariadb_is_any_result_active
- mariadb_is_valid_result
- mariadb_get_affected_rows
- mariadb_get_warning_count
- mariadb_get_insert_id
- mariadb_get_query_exec_time
- mariadb_get_query_string
- mariadb_get_row
- mariadb_get_assoc
