#include "dbtestgui.h"
#include <QtSql\QSqldatabase>
//#include <Qsql>
#include <QTableView>
#include <QSqlQuery>
#include <QDebug>

dbTestGUI::dbTestGUI(QWidget *parent)
	: QMainWindow(parent)
{
	
	QSqlDatabase db = QSqlDatabase::addDatabase("QPSQL");
	db.setHostName("localhost");
	db.setDatabaseName("testdb");
	if (!db.open("tester", "aaa"))
		qDebug() << "failed to open DB conn";
	else
		qDebug() << "DB conn opened";
	model = new QSqlQueryModel(this);
	QSqlQuery q;
	q.prepare("SELECT * FROM tab1 where ival > ?");
	q.addBindValue(100);
	q.exec();
	qDebug() << q.executedQuery();

	model->setQuery(q);

	QTableView *v = new QTableView(this);
	this->setCentralWidget(v);
	v->setSizeAdjustPolicy(QAbstractScrollArea::AdjustToContents);
	v->setModel(model);
	v->show();



}

dbTestGUI::~dbTestGUI()
{
	QSqlDatabase db = QSqlDatabase::database();
	db.close();
	QSqlDatabase::removeDatabase(QSqlDatabase::database().connectionName()); //this line causes error
}