Daviddoria: /* form.cpp */ Fixed - must use a pointer or the model goes out of scope

2011-12-11T15:36:34Z

‎form.cpp: Fixed - must use a pointer or the model goes out of scope

Daviddoria: Currently nothing is displayed in the listview

2011-12-11T14:17:24Z

Currently nothing is displayed in the listview

New page

==ListView.cpp==
<source lang="cpp">
#include <QApplication>
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
#include <QVariant>
#include <QFile>

#include <iostream>

#include "form.h"

int main(int argc, char *argv[])
{
QApplication app(argc, argv);

QFile::remove ("test.sqlite");

QSqlDatabase database = QSqlDatabase::addDatabase("QSQLITE");
database.setDatabaseName("test.sqlite");
if(!database.open())
{
std::cerr << "Could not open database" << std::endl;
std::cerr << "Last error: " << database.lastError().text().toStdString() << std::endl;
}

QSqlQuery createQuery;
bool createSuccess = createQuery.exec("create table AssociateTable "
"(id integer primary key, "
"AssociateName TEXT, "
"SocialSecurityNumber TEXT)");

if(createSuccess)
{
std::cout << "Table created successfully!" << std::endl;
}
else
{
std::cerr << "Could not create table." << std::endl;
std::cerr << "Last database error: " << database.lastError().text().toStdString() << std::endl;
std::cerr << "Last query error: " << createQuery.lastError().text().toStdString() << std::endl;
}

// Populate the table with default values
QSqlQuery insertQuery;
insertQuery.prepare("INSERT INTO AssociateTable (id, AssociateName, SocialSecurityNumber) "
"VALUES (:id, :AssociateName, :SocialSecurityNumber)");
insertQuery.bindValue(":id", 0);
insertQuery.bindValue(":AssociateName", "AssociateName");
insertQuery.bindValue(":SocialSecurityNumber", "SocialSecurityNumber");

bool insertSuccess = insertQuery.exec();
if(!insertSuccess)
{
std::cerr << "Could not insert values!" << std::endl;
std::cerr << "insertQuery last error: " << insertQuery.lastError().text().toStdString() << std::endl;
return -1;
}

MyForm form;

form.show();
return app.exec();
}

</source>

==form.h==
<source lang="cpp">
#ifndef ListView_H
#define ListView_H

#include "ui_ListView.h"

class MyForm : public QWidget, private Ui::Form
{
Q_OBJECT
public:
MyForm(QWidget *parent = 0);

public slots:

protected:
void showEvent ( QShowEvent * event );
};

#endif

</source>

==form.cpp==
<source lang="cpp">
#include "form.h"

#include <iostream>

#include <QSqlDatabase>
#include <QStringList>
#include <QSqlQuery>
#include <QDebug>
#include <QSqlError>
#include <QVariant>
#include <QSqlTableModel>
#include <QSqlRecord>

MyForm::MyForm(QWidget *parent) : QWidget(parent)
{
setupUi(this);
}

void MyForm::showEvent ( QShowEvent * event )
{
QSqlQuery selectQuery;
selectQuery.prepare("SELECT AssociateName FROM AssociateTable");

bool insertSuccess = selectQuery.exec();
if(!insertSuccess)
{
std::cerr << "Error selecting associates!" << std::endl;
std::cerr << "Last error: " << selectQuery.lastError().text().toStdString() << std::endl;
return;
}

QSqlTableModel tableModel;
tableModel.setTable("AssociateTable");

tableModel.select();

this->listView->setModel(&tableModel);
this->listView->setModelColumn(2);
}

</source>

==ListView.ui==
<source lang="text">
<?xml version="1.0" encoding="UTF-8"?>
<ui version="4.0">
<class>Form</class>
<widget class="QWidget" name="Form">
<property name="geometry">
<rect>
<x>0</x>
<y>0</y>
<width>772</width>
<height>624</height>
</rect>
</property>
<property name="windowTitle">
<string>Form</string>
</property>
<widget class="QPushButton" name="pushButton">
<property name="geometry">
<rect>
<x>330</x>
<y>450</y>
<width>91</width>
<height>27</height>
</rect>
</property>
<property name="text">
<string>PushButton</string>
</property>
</widget>
<widget class="QListView" name="listView">
<property name="geometry">
<rect>
<x>260</x>
<y>90</y>
<width>256</width>
<height>192</height>
</rect>
</property>
</widget>
</widget>
<resources/>
<connections/>
</ui>

</source>

==CMakeLists.txt==
<source lang="cmake">
cmake_minimum_required(VERSION 2.6)

PROJECT(ListView)

FIND_PACKAGE(Qt4 REQUIRED)
INCLUDE(${QT_USE_FILE})

QT4_WRAP_UI(UISrcs ListView.ui)
QT4_WRAP_CPP(MOCSrcs form.h)

include_directories(${include_directories} ${CMAKE_CURRENT_SOURCE_DIR} ${CMAKE_CURRENT_BINARY_DIR})
INCLUDE_DIRECTORIES(${QT_QTSQL_INCLUDE_DIR})

ADD_EXECUTABLE(ListView ListView.cpp form.h form.cpp ${MOCSrcs} ${UISrcs})
TARGET_LINK_LIBRARIES(ListView ${QT_LIBRARIES} ${QT_QTSQL_LIBRARY_RELEASE})

</source>

@@ Line 127: / Line 127: @@
-   QSqlTableModel tableModel;
+   QSqlTableModel* tableModel = new QSqlTableModel;
-   tableModel.setTable("AssociateTable");
+   tableModel->setTable("AssociateTable");
-   tableModel.select();
+   tableModel->select();
-   this->listView->setModel(&tableModel);
+   this->listView->setModel(tableModel);
    this->listView->setModelColumn(2);
+}

Qt/Databases/ListView - Revision history

Daviddoria: /* form.cpp */ Fixed - must use a pointer or the model goes out of scope

Daviddoria: Currently nothing is displayed in the listview