SQLite

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

Definition at line 747 of file sqlite.c.

Referenced by xmms_medialib_entry_property_get_str(), and xmms_medialib_entry_property_get_value().

xmms_sqlite_query_int()

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

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