sqlite_query

From Liberty Unleashed Wiki
Jump to: navigation, search
Home   |   Squirrel Scripting   |   Server Functions   |   Server Events   |   Client Functions   |   Client Events
Note: This function requires the external module lu_sqlite.

This function executes a query to a SQLite database. The function returns a pointer to a result struct or null if the query does not return any values. The query result should always be freed using sqlite_free to avoid any memory leaks.

Syntax

  1. UserPointer sqlite_query( UserPointer database, string query )

Arguments

  • database - This is a pointer to a previously opened database
  • query - This is the query to be executed in SQL language

Example

This will carry out the required query when 'quey' is entered into the server console.

  1.  
  2. function onScriptLoad()
  3. {
  4. LoadModule( "lu_sqlite" );
  5. pSQDatabase <- sqlite_open( "database.sqlite" );
  6. return 1;
  7. }
  8.  
  9. function onConsoleInput( szCommand, szText )
  10. {
  11. if ( szCommand == "query" )
  12. {
  13. local query = sqlite_query( pSQDatabase, "SELECT Foo FROM Bar WHERE FooBar='" + szText + "'" );
  14. }
  15.  
  16. return 1;
  17. }
  18.  

Notes

The function LoadModule and sqlite_open and event onScriptLoad and onConsoleInput were used in this example. More info about them in the corresponding pages.

For a larger example, check the SQLite database example from the wiki tutorials.

Related Functions

These functions are provided by the official module lu_sqlite.

Personal tools
Namespaces

Variants
Actions
Navigation
scripting
Toolbox