Made ArchiveTreeView work

Made ArchiveTreeView work and took a look at it. Right now flat
view seems to be the better alternative.

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