XMMS2
|
The SQLite backend of medialib. More...
Functions | |
gboolean | xmms_sqlite_create (gboolean *create) |
sqlite3 * | xmms_sqlite_open () |
Open a database or create a new one. | |
gboolean | xmms_sqlite_exec (sqlite3 *sql, const char *query,...) |
A query that can't retrieve results. | |
gboolean | xmms_sqlite_query_table (sqlite3 *sql, xmms_medialib_row_table_method_t method, gpointer udata, xmms_error_t *error, const gchar *query,...) |
Execute a query to the database. | |
gboolean | xmms_sqlite_query_array (sqlite3 *sql, xmms_medialib_row_array_method_t method, gpointer udata, const gchar *query,...) |
gboolean | xmms_sqlite_query_int (sqlite3 *sql, gint32 *out, const gchar *query,...) |
void | xmms_sqlite_close (sqlite3 *sql) |
Close database and free all resources used. | |
void | xmms_sqlite_print_version (void) |
gchar * | sqlite_prepare_string (const gchar *input) |
The SQLite backend of medialib.
gchar* sqlite_prepare_string | ( | const gchar * | input | ) |
void xmms_sqlite_close | ( | sqlite3 * | sql | ) |
Close database and free all resources used.
Definition at line 793 of file sqlite.c.
Referenced by xmms_medialib_end().
gboolean xmms_sqlite_create | ( | gboolean * | create | ) |
This will create the sqlite_stats1 table which we fill out with good information about our indexes. Thanks to drh for these pointers!
Fill out sqlite_stats1
Create the tables and unique constraints
Create the views
Create the triggers
Create indices
Add the server source
Create a default playlist
Set database version
Definition at line 365 of file sqlite.c.
Referenced by xmms_medialib_init().
gboolean xmms_sqlite_exec | ( | sqlite3 * | sql, |
const char * | query, | ||
... | |||
) |
A query that can't retrieve results.
Definition at line 564 of file sqlite.c.
Referenced by _xmms_medialib_begin(), xmms_medialib_end(), xmms_medialib_entry_cleanup(), xmms_medialib_entry_property_set_int_source(), xmms_medialib_entry_property_set_str_source(), xmms_medialib_entry_remove(), xmms_medialib_source_to_id(), and xmms_sqlite_create().
sqlite3* xmms_sqlite_open | ( | void | ) |
void xmms_sqlite_print_version | ( | void | ) |
gboolean xmms_sqlite_query_array | ( | sqlite3 * | sql, |
xmms_medialib_row_array_method_t | method, | ||
gpointer | udata, | ||
const gchar * | query, | ||
... | |||
) |
Definition at line 747 of file sqlite.c.
Referenced by xmms_medialib_entry_property_get_str(), and xmms_medialib_entry_property_get_value().
gboolean xmms_sqlite_query_int | ( | sqlite3 * | sql, |
gint32 * | out, | ||
const gchar * | query, | ||
... | |||
) |
Definition at line 773 of file sqlite.c.
Referenced by xmms_medialib_entry_new_encoded(), xmms_medialib_entry_not_resolved_get(), xmms_medialib_entry_property_get_int(), xmms_medialib_num_not_resolved(), and xmms_medialib_source_to_id().
gboolean xmms_sqlite_query_table | ( | sqlite3 * | sql, |
xmms_medialib_row_table_method_t | method, | ||
gpointer | udata, | ||
xmms_error_t * | error, | ||
const gchar * | query, | ||
... | |||
) |
Execute a query to the database.
Definition at line 599 of file sqlite.c.
Referenced by xmms_medialib_select().