mariadb connect file: Difference between revisions
From Onset Developer Wiki
Created page with "{{Info|Function|Server|1.0}} {{Notice|This function is provided by the official MariaDB plugin.}} {{FuncDescription|__EDIT_ME__}} {{FuncSyntax|mariadb_connect_file(file_..." |
No edit summary |
||
Line 2: | Line 2: | ||
{{Notice|This function is provided by the official [[MariaDB]] plugin.}} | {{Notice|This function is provided by the official [[MariaDB]] plugin.}} | ||
{{FuncDescription| | {{FuncDescription|Connect}} | ||
{{FuncSyntax|mariadb_connect_file(file_name)}} | {{FuncSyntax|mariadb_connect_file(file_name)}} | ||
{{FuncParameters}} | {{FuncParameters}} | ||
{{FuncParam|file_name| | {{FuncParam|file_name|The file name with the mariaDB credentials.}} | ||
{{FuncReturnValue| | {{FuncReturnValue|Returns an identifier/ handle to the new database connection. '''false''' on error.}} | ||
== Example == | == Example == | ||
<syntaxhighlight lang="Lua"> | |||
AddEvent("OnPackageStart", function() | |||
mariadb_log(SQL_LOGL) | |||
sql = mariadb_connect_file("horizon/sql_config.txt") | |||
if (sql ~= false) then | |||
print("MariaDB: Connected.") | |||
else | |||
print("MariaDB: Connection failed. See mariadb_log file") | |||
-- Immediately stop the server if we cannot connect | |||
ServerExit() | |||
end | |||
end) | |||
</syntaxhighlight> | |||
{{RelatedFunctions}} | {{RelatedFunctions}} | ||
{{Template:MariaDBFunctions}} |
Revision as of 09:52, 19 November 2019
Description
Connect
Syntax
mariadb_connect_file(file_name)
Parameters
- file_name
The file name with the mariaDB credentials.
Return Value
- Returns an identifier/ handle to the new database connection. false on error.
Example
AddEvent("OnPackageStart", function()
mariadb_log(SQL_LOGL)
sql = mariadb_connect_file("horizon/sql_config.txt")
if (sql ~= false) then
print("MariaDB: Connected.")
else
print("MariaDB: Connection failed. See mariadb_log file")
-- Immediately stop the server if we cannot connect
ServerExit()
end
end)
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