qtforum.de

Code: Alles auswählen

#include <QApplication>
#include <QMainWindow>
#include <QTableView>
#include <QSqlQuery>
#include <QSqlQueryModel>
#include <QSortFilterProxyModel>

int main(int argc, char *argv[])
{	    
    //create test data
	QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
	db.setDatabaseName(":memory");
	db.open();
	QSqlQuery query(QSqlDatabase::database());
	//clean up before
	query.exec("DELETE FROM testtable");
	query.exec("DROP TABLE testtable");
	//new table and some manually created rows
	query.exec("CREATE TABLE testtable(col1 INTEGER, col2 INTEGER, col3 INTEGER)");
	query.exec("INSERT INTO testtable VALUES(1234, random(), random())");
	query.exec("INSERT INTO testtable VALUES(4567, random(), random())");
	query.exec("INSERT INTO testtable VALUES(3456, random(), random())");
	query.exec("INSERT INTO testtable VALUES(2345, random(), random())");
	//300 automatically generated data rows
	for(int i = 0; i < 300; i++)
	{
		int c1 = 5000 + i;
		int c2 = rand() % 2000 + 1000;
		int c3 = rand() % 2000 + 1000;
		query.prepare("INSERT INTO testtable (col1, col2, col3) VALUES(:col1, :col2, :col3)");
		query.bindValue(":col1", c1);
		query.bindValue(":col2", c2);
		query.bindValue(":col3", c3);
		query.exec();
	}
	//a last manually data set that should appear in row 2 if sorted
	query.exec("INSERT INTO testtable VALUES(1357, random(), random())");
	
	//create table model
	QSqlQueryModel* sqlQueryModel = new QSqlQueryModel();
	sqlQueryModel->setQuery("SELECT * FROM testtable", QSqlDatabase::database());
	
	//create proxy model
	QSortFilterProxyModel* sortFilterProxyModel = new QSortFilterProxyModel();
	sortFilterProxyModel->setSourceModel(sqlQueryModel);
    sortFilterProxyModel->sort(0);
    
    //create GUI and connect with data
    QApplication app(argc, argv);
    QMainWindow *mainWindow = new QMainWindow();
    QTableView* tableView = new QTableView();
    mainWindow->setCentralWidget(tableView);
    tableView->setModel(sortFilterProxyModel);
    
    mainWindow->showMaximized();
    return app.exec();
}

Code: Alles auswählen

SOURCES +=  main.cpp
TEMPLATE = app
LANGUAGE = C++
CONFIG += qt warn_on debug_and_release
TARGET = test
QT += sql

Code: Alles auswählen

int QSqlQueryModel::rowCount ( const QModelIndex & parent = QModelIndex() ) const [virtual]

Reimplemented from QAbstractItemModel::rowCount().

If the database supports returning the size of a query (see QSqlDriver::hasFeature()), the amount of rows of the current query is returned. Otherwise, returns the amount of rows currently cached on the client.