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)
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 77 of file smartplaylist.cpp.

Referenced by getCriteriaSQL(), and SmartPLCriteriaRow::operatorChanged().

static SmartPLField* lookupField

(

QString

name

)

[static]

Definition at line 87 of file smartplaylist.cpp.

Referenced by SmartPLCriteriaRow::fieldChanged(), getCriteriaSQL(), getOrderBySQL(), SmartPLCriteriaRow::getSQL(), getSQLFieldName(), SmartPLCriteriaRow::initValues(), SmartPLCriteriaRow::operatorChanged(), and SmartPLCriteriaRow::saveToDatabase().

QString formattedFieldValue

(

const QVariant &

value

)

Definition at line 97 of file smartplaylist.cpp.

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

QString evaluateDateValue

(

QString

sDate

)

Definition at line 110 of file smartplaylist.cpp.

Referenced by getCriteriaSQL().

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

Definition at line 138 of file smartplaylist.cpp.

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

QString getOrderBySQL

(

QString

orderByFields

)

Definition at line 224 of file smartplaylist.cpp.

Referenced by Playlist::fillSonglistFromSmartPlaylist(), and SmartPlaylistEditor::getOrderByClause().

QString getSQLFieldName

(

QString

fieldName

)

Definition at line 258 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 34 of file smartplaylist.cpp.

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 },
}

Definition at line 61 of file smartplaylist.cpp.

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

Definition at line 74 of file smartplaylist.cpp.

Referenced by SmartPLCriteriaRow::getOperatorList(), lookupOperator(), and SmartPLCriteriaRow::SmartPLCriteriaRow().

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

Definition at line 75 of file smartplaylist.cpp.