MythTV  master
Classes | Functions | Variables
smartplaylist.cpp File Reference
#include <unistd.h>
#include <iostream>
#include <QKeyEvent>
#include <QSqlDriver>
#include <QSqlField>
#include <utility>
#include <mythcontext.h>
#include <mythmainwindow.h>
#include <mythdb.h>
#include <mythuihelper.h>
#include <mythscreentype.h>
#include <mythuitext.h>
#include <mythuitextedit.h>
#include <mythuibuttonlist.h>
#include <mythuibutton.h>
#include <mythuispinbox.h>
#include <mythuicheckbox.h>
#include <mythdialogbox.h>
#include <mythdate.h>
#include <musicmetadata.h>
#include "musicdata.h"
#include "smartplaylist.h"
#include "musiccommon.h"
Include dependency graph for smartplaylist.cpp:

Go to the source code of this file.

Classes

struct  SmartPLField
 
struct  SmartPLOperator
 

Functions

static SmartPLOperatorlookupOperator (const QString &name)
 
static SmartPLFieldlookupField (const QString &name)
 
QString formattedFieldValue (const QVariant &value)
 
static QString evaluateDateValue (QString sDate)
 
QString getCriteriaSQL (const QString &fieldName, QString operatorName, QString value1, QString value2)
 
QString getOrderBySQL (const 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

◆ lookupOperator()

static SmartPLOperator* lookupOperator ( const QString &  name)
static

◆ lookupField()

static SmartPLField* lookupField ( const QString &  name)
static

◆ formattedFieldValue()

QString formattedFieldValue ( const QVariant &  value)

◆ evaluateDateValue()

static QString evaluateDateValue ( QString  sDate)
static

Definition at line 121 of file smartplaylist.cpp.

Referenced by getCriteriaSQL().

◆ getCriteriaSQL()

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

◆ getOrderBySQL()

QString getOrderBySQL ( const QString &  orderByFields)

◆ getSQLFieldName()

QString getSQLFieldName ( QString  fieldName)

Definition at line 276 of file smartplaylist.cpp.

Variable Documentation

◆ SmartPLFields

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

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

◆ SmartPLOperators

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

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

◆ SmartPLOperatorsCount

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

◆ SmartPLFieldsCount

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