XMMS2
Functions

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. More...
 
gboolean xmms_sqlite_exec (sqlite3 *sql, const char *query,...)
 A query that can't retrieve results. More...
 
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. More...
 
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. More...
 
void xmms_sqlite_print_version (void)
 
gchar * sqlite_prepare_string (const gchar *input)
 

Detailed Description

The SQLite backend of medialib.

Function Documentation

◆ sqlite_prepare_string()

gchar* sqlite_prepare_string ( const gchar *  input)

Definition at line 809 of file sqlite.c.

◆ xmms_sqlite_close()

void xmms_sqlite_close ( sqlite3 *  sql)

Close database and free all resources used.

Definition at line 793 of file sqlite.c.

◆ xmms_sqlite_create()

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.

◆ xmms_sqlite_exec()

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_entry_cleanup(), xmms_medialib_entry_remove(), and xmms_medialib_source_to_id().

◆ xmms_sqlite_open()

sqlite3* xmms_sqlite_open ( void  )

Open a database or create a new one.

Definition at line 513 of file sqlite.c.

◆ xmms_sqlite_print_version()

void xmms_sqlite_print_version ( void  )

Definition at line 800 of file sqlite.c.

◆ xmms_sqlite_query_array()

gboolean xmms_sqlite_query_array ( sqlite3 *  sql,
xmms_medialib_row_array_method_t  method,
gpointer  udata,
const gchar *  query,
  ... 
)

◆ xmms_sqlite_query_int()

gboolean xmms_sqlite_query_int ( sqlite3 *  sql,
gint32 *  out,
const gchar *  query,
  ... 
)

◆ xmms_sqlite_query_table()

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().