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; }