QList<QMap<QString, QString> > DatabaseManager::getSeries() {
QList<QMap<QString, QString> > allSeries;
if (m_db.isOpen()) {
this->startTransaction();
QSqlQuery query(m_db);
query.exec(QString("SELECT banner, poster, seriesName, status, id, overview, imdbID, rating, genre FROM Series ORDER BY seriesName;"));
this->commit();
if (query.isSelect()) {
while (query.next()) {
QMap<QString, QString> temp;
QString banner = query.value(0).toString();
temp["banner"] = banner;
QString poster = query.value(1).toString();
temp["poster"] = poster;
QString seriesName = query.value(2).toString();
temp["seriesName"] = seriesName;
QString status = query.value(3).toString();
temp["status"] = status;
int id = query.value(4).toInt();
QString idstring = QString::number(id);
temp["id"] = idstring;
QString overview = query.value(5).toString();
overview.replace("''","'");
temp["overview"] = overview;
QString imdbId = query.value(6).toString();
temp["imdbId"] = imdbId;
QString rating = query.value(7).toString();
temp["rating"] = rating;
QString genre = query.value(8).toString();
temp["genre"] = genre;
int watched = watchedCount(id);
QString watchedCount = QString::number(watched);
temp["watchedCount"] = watchedCount;
int total = totalCount(id);
QString totalCount = QString::number(total);
temp["totalCount"] = totalCount;
allSeries.append(temp);
}
}
}
return allSeries;
}
QList<QVariantMap> DatabaseManager::getSeries()
{
QList<QVariantMap> allSeries;
if (m_db.isOpen()) {
this->startTransaction();
QSqlQuery query(m_db);
query.exec(QString("SELECT banner, poster, seriesName, status, id, overview, imdbID, rating, genre "
"FROM Series "
"ORDER BY seriesName;"));
this->commit();
if (query.isSelect()) {
while (query.next()) {
QVariantMap temp;
auto banner = query.value(0).toString();
temp["banner"] = banner;
auto poster = query.value(1).toString();
temp["poster"] = poster;
auto seriesName = query.value(2).toString();
seriesName.replace("''", "'");
temp["seriesName"] = seriesName;
auto status = query.value(3).toString();
temp["status"] = status;
auto id = query.value(4).toInt();
auto idString = QString::number(id);
temp["id"] = idString;
auto overview = query.value(5).toString();
overview.replace("''", "'");
temp["overview"] = overview;
auto imdbId = query.value(6).toString();
temp["imdbId"] = imdbId;
auto rating = query.value(7).toString();
temp["rating"] = rating;
auto genre = query.value(8).toString();
temp["genre"] = genre;
auto watched = watchedCount(id);
auto watchedCount = QString::number(watched);
temp["watchedCount"] = watchedCount;
auto total = totalCount(id);
auto totalCount = QString::number(total);
temp["totalCount"] = totalCount;
allSeries.append(temp);
}
}
}
return allSeries;
}
