1#ifndef CHANNELSETTINGS_H
2#define CHANNELSETTINGS_H
23 QString table =
"channel") :
24 m_field(
std::move(field)), m_table(
std::move(table))
36 QString querystr = QString(
"SELECT %1 FROM %2")
37 .arg(m_field, m_table);
49 if (tmpfloor <= query.
value(0).toInt())
50 tmpfloor = query.
value(0).toInt() + 1;
52 return floor<tmpfloor?tmpfloor:floor;
100 uint default_sourceid,
bool add_freqid);
103 static void onAirGuideChanged(
bool fValue);
104 void sourceChanged(
const QString &sourceid);
137 void Load(
void)
override;
138 void Save(
void)
override;
144 std::vector<TransTextEditSetting*>
m_pids;
145 std::vector<TransMythUIComboBoxSetting*>
m_sids;
146 std::vector<TransMythUICheckBoxSetting*>
m_pcrs;
148 static const uint kMaxPIDs = 10;
158 static QStringList GetFormats(
void);
ChannelDBStorage(StorageUser *_user, const ChannelID &_id, const QString &_name)
QString GetWhereClause(MSqlBindings &bindings) const override
QString GetSetClause(MSqlBindings &bindings) const override
ChannelID(QString field="chanid", QString table="channel")
const QString & getField(void) const
int findHighest(int floor=1000)
std::vector< TransMythUICheckBoxSetting * > m_pcrs
std::vector< TransTextEditSetting * > m_pids
std::vector< TransMythUIComboBoxSetting * > m_sids
virtual void Save(const QString &)
IPTVChannelDBStorage(StorageUser *_user, const ChannelID &_id, const QString &_name)
QString GetSetClause(MSqlBindings &bindings) const override
QString GetWhereClause(MSqlBindings &bindings) const override
QSqlQuery wrapper that fetches a DB connection from the connection pool.
bool prepare(const QString &query)
QSqlQuery::prepare() is not thread safe in Qt <= 3.3.2.
QVariant value(int i) const
bool isActive(void) const
bool exec(void)
Wrap QSqlQuery::exec() so we can display SQL.
bool next(void)
Wrap QSqlQuery::next() so we can display the query results.
static MSqlQueryInfo InitCon(ConnectionReuse _reuse=kNormalConnection)
Only use this in combination with MSqlQuery constructor.
static void DBError(const QString &where, const MSqlQuery &query)
void setVisible(bool visible)
QMap< QString, QVariant > MSqlBindings
typedef for a map of string -> string bindings for generic queries.