Up to date

This page is up to date for Godot 4.3. If you still find outdated information, please open an issue.

SQLiteQuery¶

Class for executing SQL queries on an SQLite database.

Description¶

A class that allows you to execute SQL queries on an SQLite database. It provides methods for both single and batch execution of queries. It also provides a method to retrieve the column names from the last executed query and a method to get the last error message, if any.

Properties¶

Array	arguments	`[]`
String	query	`""`

Methods¶

Array[SQLiteQueryResult]	batch_execute(rows: Array[Array])
SQLiteQueryResult	execute(arguments: Array = [])
Array[SQLiteColumnSchema]	get_columns()
String	get_last_error_message() const

Property Descriptions¶

Array arguments = [] 🔗

void set_arguments(value: Array)
Array get_arguments()

Arguments for the query.

String query = "" 🔗

String get_query()

The query executed.

Method Descriptions¶

Array[SQLiteQueryResult] batch_execute(rows: Array[Array]) 🔗

Executes a batch of SQL queries. The queries are provided as an array of strings. Returns the result of the last query in the batch.

SQLiteQueryResult execute(arguments: Array = []) 🔗

Executes a single SQL query. The query is provided as a string. If the query requires arguments, they can be provided as an array. Returns the result of the query.

Array[SQLiteColumnSchema] get_columns() 🔗

Returns an array of column names from the last executed query.

String get_last_error_message() const 🔗

Returns the last error message, if any. If there was no error, returns an empty string.