SQLite
[XMMSServer]

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)

Detailed Description

The SQLite backend of medialib.


Function Documentation

gchar* sqlite_prepare_string ( const gchar *  input  ) 

Definition at line 809 of file sqlite.c.

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,
  ... 
)
sqlite3* xmms_sqlite_open ( void   ) 

Open a database or create a new one.

Definition at line 513 of file sqlite.c.

void xmms_sqlite_print_version ( void   ) 

Definition at line 800 of file sqlite.c.

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


Generated on Tue Feb 23 18:14:36 2010 for XMMS2 by  doxygen 1.6.1