I am having an issue with a school project. I am supposed to create a ballot server which can receive votes and tally then up. The storage is supposed to use SQL. One of the requirements is that I use a QSqlTableModel and QTableView to display the candidates and the amount of votes they current have. I am able to populate the table but am unable to view the data using a QSqlTableModel and QTableView. The window shows but it is completely empty.
The code is as follows:
qDebug() << database.open("awesomeUser", "awesomePassword");
model->setTable(tableName);
model->select();
model
->setHeaderData
(0, Qt
::Horizontal,
QObject::tr("Name"));
model
->setHeaderData
(1, Qt
::Horizontal,
QObject::tr("Votes"));
}
view->setModel(model);
view->setWindowTitle(title);
return view;
}
void server::votersTable(){
qDebug() << database.open("awesomeUser", "awesomePassword");
initializeModel(&model, "Candidates");
view->show();
}
void server::initializeModel(QSqlTableModel *model, const QString tableName){
qDebug() << database.open("awesomeUser", "awesomePassword");
model->setTable(tableName);
model->setEditStrategy(QSqlTableModel::OnManualSubmit);
model->select();
model->setHeaderData(0, Qt::Horizontal, QObject::tr("Name"));
model->setHeaderData(1, Qt::Horizontal, QObject::tr("Votes"));
}
QTableView* server::createView(const QString &title, QSqlTableModel *model){
QTableView *view = new QTableView;
view->setModel(model);
view->setWindowTitle(title);
return view;
}
void server::votersTable(){
qDebug() << database.open("awesomeUser", "awesomePassword");
QSqlTableModel model;
initializeModel(&model, "Candidates");
QTableView *view = createView(QObject::tr("Voters"), &model);
view->show();
}
To copy to clipboard, switch view to plain text mode
votersTable() is called from an on click signal from a button in the UI.
If anyone could tell me where I went wrong, I would very much appreciate it.
For reference, I know my Sql table has data inside. I run the following code:
{ query.exec("DROP TABLE Candidates"); query.exec("CREATE TABLE Candidates (candidate TEXT, votes INTEGER)"); query.exec("INSERT INTO Candidates (candidate, votes) VALUES ('Buggs_Bunny', 0)"); query.exec("INSERT INTO Candidates (candidate, votes) VALUES ('Daffy_Duck', 0)"); query.exec("INSERT INTO Candidates (candidate, votes) VALUES ('Road_Runner', 0)"); query.exec("INSERT INTO Candidates (candidate, votes) VALUES ('Wile_E_Coyote', 0)"); query.exec("SELECT candidate, votes FROM Candidates");
}
qDebug() << "Candidates: "; while(query.next()){ qDebug() << query.value(0).toString() << " " << query.value(1).toString(); }
{ query.exec("DROP TABLE Candidates"); query.exec("CREATE TABLE Candidates (candidate TEXT, votes INTEGER)"); query.exec("INSERT INTO Candidates (candidate, votes) VALUES ('Buggs_Bunny', 0)"); query.exec("INSERT INTO Candidates (candidate, votes) VALUES ('Daffy_Duck', 0)"); query.exec("INSERT INTO Candidates (candidate, votes) VALUES ('Road_Runner', 0)"); query.exec("INSERT INTO Candidates (candidate, votes) VALUES ('Wile_E_Coyote', 0)"); query.exec("SELECT candidate, votes FROM Candidates");
}
qDebug() << "Candidates: "; while(query.next()){ qDebug() << query.value(0).toString() << " " << query.value(1).toString(); }
To copy to clipboard, switch view to plain text mode
and receive the following output:
Candidates:
"Buggs_Bunny" "0"
"Daffy_Duck" "0"
"Road_Runner" "0"
"Wile_E_Coyote" "0"
Candidates:
"Buggs_Bunny" "0"
"Daffy_Duck" "0"
"Road_Runner" "0"
"Wile_E_Coyote" "0"
To copy to clipboard, switch view to plain text mode
I believe this is enough code to demonstrate the setup. For the complete code, pastebin has it at http://pastebin.com/r4tCtTcn
Please let me know if you can figure out whats going on with this. It would be greatly appreciated!
[Solved] QSqlTableModel issues..
Reply With Quote
Originally Posted by wysota
Bookmarks