profilegroup.cpp

Go to the documentation of this file.

#include "libmythbase/mythdb.h"
#include "libmythui/mythuihelper.h"
 
#include "cardutil.h"
#include "profilegroup.h"
#include "recordingprofile.h"
#include "videosource.h"
 
QString ProfileGroupStorage::GetWhereClause(MSqlBindings &bindings) const
{
    QString idTag(":WHEREID");
    QString query("id = " + idTag);
 
    bindings.insert(idTag, m_parent.getProfileNum());
 
    return query;
}
 
QString ProfileGroupStorage::GetSetClause(MSqlBindings &bindings) const
{
    QString idTag(":SETID");
    QString colTag(":SET" + GetColumnName().toUpper());
 
    QString query("id = " + idTag + ", " +
            GetColumnName() + " = " + colTag);
 
    bindings.insert(idTag, m_parent.getProfileNum());
    bindings.insert(colTag, m_user->GetDBValue());
 
    return query;
}
 
void ProfileGroup::HostName::fillSelections()
{
    QStringList hostnames;
    ProfileGroup::getHostNames(&hostnames);
    for (const auto & hostname : qAsConst(hostnames))
        this->addSelection(hostname);
}
 
ProfileGroup::ProfileGroup()
{
    // This must be first because it is needed to load/save the other settings
    addChild(m_id = new ID());
    addChild(m_isDefault = new Is_default(*this));
 
    setLabel(tr("Profile Group"));
    addChild(m_name = new Name(*this));
    auto *cardInfo = new CardInfo(*this);
    addChild(cardInfo);
    CardType::fillSelections(cardInfo);
    m_host = new HostName(*this);
    addChild(m_host);
    m_host->fillSelections();
};
 
void ProfileGroup::loadByID(int profileId) {
    m_id->setValue(profileId);
    Load();
}
 
bool ProfileGroup::addMissingDynamicProfiles(void)
{
    // We need separate profiles for different V4L2 card types
    QStringList existing;
    MSqlQuery   query(MSqlQuery::InitCon());
    query.prepare("SELECT DISTINCT cardtype FROM profilegroups");
 
    if (!query.exec())
    {
        MythDB::DBError("ProfileGroup::createMissingDynamicProfiles", query);
        return false;
    }
 
    while (query.next())
        existing.push_back(query.value(0).toString());
 
 
    const std::array<const QString,4> profile_names {
        "Default", "Live TV", "High Quality", "Low Quality" };
 
    CardUtil::InputTypes cardtypes = CardUtil::GetInputTypes();
 
    for (auto Itype = cardtypes.begin();
         Itype != cardtypes.end(); ++Itype)
    {
        if (Itype.key().startsWith("V4L2:") && existing.indexOf(Itype.key()) == -1)
        {
            // Add dynamic profile group
            query.prepare("INSERT INTO profilegroups SET name = "
                          ":CARDNAME, cardtype = :CARDTYPE, is_default = 1;");
            query.bindValue(":CARDTYPE", Itype.key());
            query.bindValue(":CARDNAME", Itype.value());
            if (!query.exec())
            {
                MythDB::DBError("Unable to insert V4L2 profilegroup.", query);
                return false;
            }
 
            // get the id of the new profile group
            int groupid = query.lastInsertId().toInt();
 
            for (const auto & name : profile_names)
            {
                // insert the recording profiles
                query.prepare("INSERT INTO recordingprofiles SET name = "
                              ":NAME, profilegroup = :GROUPID;");
                query.bindValue(":NAME", name);
                query.bindValue(":GROUPID", groupid);
                if (!query.exec())
                {
                    MythDB::DBError("Unable to insert 'Default' "
                                    "recordingprofile.", query);
                    return false;
                }
            }
        }
    }
 
    return true;
}
 
void ProfileGroup::fillSelections(GroupSetting* setting)
{
    CardUtil::InputTypes cardtypes = CardUtil::GetInputTypes();
    QString     tid;
 
    MSqlQuery result(MSqlQuery::InitCon());
    result.prepare(
        "SELECT name, id, hostname, is_default, cardtype "
        "FROM profilegroups");
 
    if (!result.exec())
    {
        MythDB::DBError("ProfileGroup::fillSelections", result);
        return;
    }
 
    while (result.next())
    {
        QString name       = result.value(0).toString();
        QString id         = result.value(1).toString();
        QString hostname   = result.value(2).toString();
        bool    is_default = (bool) result.value(3).toInt();
        QString cardtype   = result.value(4).toString();
 
        // Only show default profiles that match installed cards
        // Workaround for #12481 in fixes/0.27
        bool have_cardtype = cardtypes.contains(cardtype);
        if (is_default && (cardtype == "TRANSCODE") && !have_cardtype)
        {
            tid = id;
        }
        else if (have_cardtype)
        {
            if (!hostname.isEmpty())
                name += QString(" (%1)").arg(result.value(2).toString());
 
            if (is_default)
            {
                setting->addChild(new RecordingProfileEditor(id.toInt(), name));
            }
            else
            {
                auto *profileGroup = new ProfileGroup();
                profileGroup->loadByID(id.toInt());
                profileGroup->setLabel(name);
                profileGroup->addChild(
                    new RecordingProfileEditor(id.toInt(), tr("Profiles")));
                setting->addChild(profileGroup);
            }
        }
    }
 
    if (!tid.isEmpty())
    {
        setting->addChild(new RecordingProfileEditor(tid.toInt(),
                                                     tr("Transcoders")));
    }
}
 
QString ProfileGroup::getName(int group)
{
    MSqlQuery result(MSqlQuery::InitCon());
    result.prepare("SELECT name from profilegroups WHERE id = :PROFILE_ID;");
    result.bindValue(":PROFILE_ID", group);
    if (result.exec() && result.next())
    {
        return result.value(0).toString();
    }
 
    return nullptr;
}
 
bool ProfileGroup::allowedGroupName(void)
{
    MSqlQuery result(MSqlQuery::InitCon());
    QString querystr = QString("SELECT DISTINCT id FROM profilegroups WHERE "
                            "name = '%1' AND hostname = '%2';")
                            .arg(getName(), m_host->getValue());
    result.prepare(querystr);
 
    return !(result.exec() && result.next());
}
 
void ProfileGroup::getHostNames(QStringList *hostnames)
{
    hostnames->clear();
 
    MSqlQuery result(MSqlQuery::InitCon());
 
    result.prepare("SELECT DISTINCT hostname from capturecard");
 
    if (result.exec())
    {
        while (result.next())
            hostnames->append(result.value(0).toString());
    }
}
 
void ProfileGroupEditor::Load(void)
{
    clearSettings();
    ProfileGroup::addMissingDynamicProfiles();
    ProfileGroup::fillSelections(this);
    StandardSetting::Load();
}