diff options
Diffstat (limited to 'smubermodel.cpp')
| -rw-r--r-- | smubermodel.cpp | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/smubermodel.cpp b/smubermodel.cpp index 784904a..9bb8195 100644 --- a/smubermodel.cpp +++ b/smubermodel.cpp @@ -21,12 +21,14 @@ SmUberModel::SmUberModel(QObject *parent) : QObject(parent), mSeriesModel(0), mF mDb.setUserName("shemov"); mDb.setPassword("shemov"); mDb.setDatabaseName("shemov2"); + mDb.open(); mSeriesPartsQuery = new QSqlQuery(mDb); - mSeriesPartsQuery->prepare("SELECT iseriespart_id, iseriespart, iseries_id, iquality FROM seriesparts WHERE iseries_id = :id ORDER BY iseriespart"); + mSeriesPartsQuery->prepare("SELECT iseriesparts_id, iseriespart, iseries_id, iquality FROM seriesparts WHERE iseries_id = :id ORDER BY iseriespart"); //series model QStringList seriesHeaders = QStringList() << tr("Name") << tr("Quality") << tr("Id"); mSeriesModel = new SmTreeModel(seriesHeaders, this); + populateSeriesmodel(); } SmUberModel::~SmUberModel(){ @@ -39,14 +41,14 @@ void SmUberModel::populateSeriesmodel(){ while(seriesQuery.next()){ QList<QVariant> seriesData; seriesData << seriesQuery.value(1) << QVariant() << seriesQuery.value(0); - SmTreeItem *seriesItem = new SmTreeItem(seriesData); + SmTreeItem *seriesItem = new SmTreeItem(seriesData, root); root->appendChild(seriesItem); mSeriesPartsQuery->bindValue(":id", seriesQuery.value(0)); mSeriesPartsQuery->exec(); while(mSeriesPartsQuery->next()){ QList<QVariant> partsData; QString title = QString("%1 %2").arg(seriesData.at(0).toString()).arg(mSeriesPartsQuery->value(1).toInt()); - partsData << title << mSeriesPartsQuery->value(2) << mSeriesPartsQuery->value(0); + partsData << title << mSeriesPartsQuery->value(3) << mSeriesPartsQuery->value(0); seriesItem->appendChild(new SmTreeItem(partsData, seriesItem)); } } |