Public Member Functions | Static Public Member Functions | Static Public Attributes | List of all members
sbLocalDatabaseSQL Class Reference

#include <sbLocalDatabaseSQL.h>

Public Member Functions

nsString MediaItemSelect ()
 
nsString LibraryMediaItemSelect ()
 

Static Public Member Functions

static nsString SecondaryPropertySelect ()
 
static nsString MediaItemsFtsAllDelete ()
 
static nsString MediaItemsFtsAllInsert ()
 
static nsString LibraryMediaItemsPropertiesSelect ()
 
static nsString PropertiesTableInsert ()
 
static nsString PropertiesSelect ()
 
static nsString PropertiesInsert ()
 
static nsString PropertiesDelete ()
 

Static Public Attributes

static const int MediaItemBindCount = 50
 
static const int SecondaryPropertyBindCount = 50
 

Detailed Description

A collection of SQL statements. Most members are static as they cheaply return the strings. A few are more expensive so we cache the results in the instance. So for those you'll need to keep an instance of the class around.

Definition at line 39 of file sbLocalDatabaseSQL.h.

Member Function Documentation

nsString sbLocalDatabaseSQL::LibraryMediaItemSelect ( )

SQL statement to return the library media item

Definition at line 129 of file sbLocalDatabaseSQL.cpp.

nsString sbLocalDatabaseSQL::LibraryMediaItemsPropertiesSelect ( )
static

Retrieves the list of properties for the library

Definition at line 122 of file sbLocalDatabaseSQL.cpp.

nsString sbLocalDatabaseSQL::MediaItemSelect ( )

Returns an SQL string that selects a single media item.

Definition at line 101 of file sbLocalDatabaseSQL.cpp.

Here is the caller graph for this function:

nsString sbLocalDatabaseSQL::MediaItemsFtsAllDelete ( )
static

Removes the items with id's matching those found in aRowIDs from the resource_properties_fts table

Definition at line 94 of file sbLocalDatabaseSQL.cpp.

Here is the caller graph for this function:

nsString sbLocalDatabaseSQL::MediaItemsFtsAllInsert ( )
static

Populates the resource_properties_fts from the resource_properties table for the ID's given in aRowIDs

Definition at line 114 of file sbLocalDatabaseSQL.cpp.

Here is the caller graph for this function:

nsString sbLocalDatabaseSQL::PropertiesDelete ( )
static

Removes a property given the item ID and property ID

Definition at line 160 of file sbLocalDatabaseSQL.cpp.

Here is the caller graph for this function:

nsString sbLocalDatabaseSQL::PropertiesInsert ( )
static

Inserts a property into the resource_properties table

Definition at line 152 of file sbLocalDatabaseSQL.cpp.

Here is the caller graph for this function:

nsString sbLocalDatabaseSQL::PropertiesSelect ( )
static

Returns all the properties in the system (property_id, property_name)

Definition at line 146 of file sbLocalDatabaseSQL.cpp.

nsString sbLocalDatabaseSQL::PropertiesTableInsert ( )
static

Inserts a property into the property table. The property name is the parameter.

Definition at line 139 of file sbLocalDatabaseSQL.cpp.

nsString sbLocalDatabaseSQL::SecondaryPropertySelect ( )
static

Selects secondary properties for the given media

Definition at line 80 of file sbLocalDatabaseSQL.cpp.

Here is the caller graph for this function:

Member Data Documentation

const int sbLocalDatabaseSQL::MediaItemBindCount = 50
static

Definition at line 88 of file sbLocalDatabaseSQL.h.

const int sbLocalDatabaseSQL::SecondaryPropertyBindCount = 50
static

Definition at line 89 of file sbLocalDatabaseSQL.h.

The documentation for this class was generated from the following files: