source: src/mvc/activity.cpp @ 5d7c9e5

/*
 * activity.cpp
 *
 *  Created on: Dec 27, 2009
 *      Author: Pavol Korinek
 */

#include "activity.h"

QString const Activity::sTableName = QString("activity");
int const Activity::sTableColCount = 2;

QSqlRecord const Activity::sColumns = Activity::toRecord(QList<QSqlField>()
    << QSqlField("id", QVariant::Int)
    << QSqlField("name", QVariant::String));

QList<Activity> Activity::getAll()
{
    QSqlQuery query;
    query.prepare(selectQuery());
    return load(query);
}

QMap<int, Activity>* Activity::mIdToActivity = 0;

void Activity::updateActivityMap()
{
    if (mIdToActivity)
    {
        delete mIdToActivity;
    }
    mIdToActivity = new QMap<int, Activity>;
    QList<Activity> activityList = Activity::getAll();
    Activity activity;
    for (int id = 0; id < activityList.count(); ++id) {
        activity = activityList.at(id);
        mIdToActivity->insert(activity.id(), activity);
    }
}

QString Activity::getActivityName(int id)
{
    QString name = mIdToActivity->value(id).name();
    if (name == "") {
        qDebug() << QString("Error: undefined activity name for id %1").arg(id);
    }
    return name;
}