smartplaylist.cpp File Reference

Go to the source code of this file.

Classes
struct	SmartPLField
struct	SmartPLOperator

Functions
static SmartPLOperator *	lookupOperator (QString name)
static SmartPLField *	lookupField (QString name)
QString	formattedFieldValue (const QVariant &value)
static QString	evaluateDateValue (QString sDate)
QString	getCriteriaSQL (QString fieldName, QString operatorName, QString value1, QString value2)
QString	getOrderBySQL (QString orderByFields)
QString	getSQLFieldName (QString fieldName)

Variables
static SmartPLField	SmartPLFields []
static SmartPLOperator	SmartPLOperators []
static int	SmartPLOperatorsCount = sizeof(SmartPLOperators) / sizeof(SmartPLOperators[0])
static int	SmartPLFieldsCount = sizeof(SmartPLFields) / sizeof(SmartPLFields[0])

Function Documentation

static SmartPLOperator* lookupOperator ( QString  name )

static

Definition at line 87 of file smartplaylist.cpp.

Referenced by CriteriaRowEditor::enableSaveButton(), getCriteriaSQL(), CriteriaRowEditor::operatorChanged(), and SmartPLCriteriaRow::toString().

static SmartPLField* lookupField ( QString  name )

static

Definition at line 97 of file smartplaylist.cpp.

Referenced by CriteriaRowEditor::enableSaveButton(), CriteriaRowEditor::fieldChanged(), getCriteriaSQL(), getOrderBySQL(), getSQLFieldName(), CriteriaRowEditor::operatorChanged(), and CriteriaRowEditor::saveClicked().

QString formattedFieldValue

(

const QVariant &

value

)

Definition at line 107 of file smartplaylist.cpp.

Referenced by MusicCommon::byAlbum(), MusicCommon::byArtist(), MusicCommon::byGenre(), MusicCommon::byTitle(), MusicCommon::byYear(), and getCriteriaSQL().

static QString evaluateDateValue ( QString  sDate )

static

Definition at line 120 of file smartplaylist.cpp.

Referenced by getCriteriaSQL().

QString getCriteriaSQL	(	QString	fieldName,
		QString	operatorName,
		QString	value1,
		QString	value2
	)

Definition at line 148 of file smartplaylist.cpp.

Referenced by Playlist::fillSonglistFromSmartPlaylist(), and SmartPLCriteriaRow::getSQL().

QString getOrderBySQL

(

QString

orderByFields

)

Definition at line 241 of file smartplaylist.cpp.

Referenced by Playlist::fillSonglistFromSmartPlaylist().

QString getSQLFieldName

(

QString

fieldName

)

Definition at line 275 of file smartplaylist.cpp.

Variable Documentation

SmartPLField SmartPLFields[]

static

Initial value:

{
    { "",              "",                               ftString,   0,    0,    0 },
    { "Artist",        "music_artists.artist_name",      ftString,   0,    0,    0 },
    { "Album",         "music_albums.album_name",        ftString,   0,    0,    0 },
    { "Title",         "music_songs.name",               ftString,   0,    0,    0 },
    { "Genre",         "music_genres.genre",             ftString,   0,    0,    0 },
    { "Year",          "music_songs.year",               ftNumeric,  1900, 2099, 2000 },
    { "Track No.",     "music_songs.track",              ftNumeric,  0,    99,   0 },
    { "Rating",        "music_songs.rating",             ftNumeric,  0,    10,   0 },
    { "Play Count",    "music_songs.numplays",           ftNumeric,  0,    9999, 0 },
    { "Compilation",   "music_albums.compilation",       ftBoolean,  0,    0,    0 },
    { "Comp. Artist",  "music_comp_artists.artist_name", ftString,   0,    0,    0 },
    { "Last Play",     "FROM_DAYS(TO_DAYS(music_songs.lastplay))",
                                                         ftDate,     0,    0,    0 },
    { "Date Imported", "FROM_DAYS(TO_DAYS(music_songs.date_entered))",
                                                         ftDate,     0,    0,    0 },
}

Definition at line 42 of file smartplaylist.cpp.

Referenced by SmartPLOrderByDialog::getOrderByFields(), lookupField(), and CriteriaRowEditor::updateFields().

SmartPLOperator SmartPLOperators[]

static

Initial value:

{
    { "is equal to",      1,  false, true },
    { "is not equal to",  1,  false, true },
    { "is greater than",  1,  false, false },
    { "is less than",     1,  false, false },
    { "starts with",      1,  true,  false },
    { "ends with",        1,  true,  false },
    { "contains",         1,  true,  false },
    { "does not contain", 1,  true,  false },
    { "is between",       2,  false, false },
    { "is set",           0,  false, false },
    { "is not set",       0,  false, false },
}

Definition at line 69 of file smartplaylist.cpp.

Referenced by CriteriaRowEditor::getOperatorList(), lookupOperator(), and CriteriaRowEditor::updateOperators().

int SmartPLOperatorsCount = sizeof(SmartPLOperators) / sizeof(SmartPLOperators[0])

static

Definition at line 84 of file smartplaylist.cpp.

Referenced by CriteriaRowEditor::getOperatorList(), lookupOperator(), and CriteriaRowEditor::updateOperators().

int SmartPLFieldsCount = sizeof(SmartPLFields) / sizeof(SmartPLFields[0])

static

Definition at line 85 of file smartplaylist.cpp.

Referenced by SmartPLOrderByDialog::getOrderByFields(), lookupField(), and CriteriaRowEditor::updateFields().