n
April 30, 2019, 12:47 p.m.

Architecture Model / View

Hello everyone I am new here so please forgive my language differences. I am working on a learner note management software. I created a database in my software but I am stuck at the level of the information view of the database. Here is the code

Fencene.h

#ifndef FENCENE_H
#define FENCENE_H

#include <QObject>
#include <QWidget>
#include <QGridLayout>
#include <QComboBox>
#include <QPushButton>
#include <QFormLayout>
#include <QTextEdit>
#include <QSpinBox>
#include <QGroupBox>
#include <QRadioButton>
#include <QtSql/QSqlDatabase>
#include <QMessageBox>
#include <QtSql/QSqlTableModel>
#include <QSqlQuery>
#include "logindb.h"

namespace Ui {
class FenCene;
}

class FenCene : public QWidget
{
    Q_OBJECT

public:
    explicit FenCene(QWidget *parent = nullptr, LoginDB *login = nullptr);
    ~FenCene();

private:
    Ui::FenCene *ui;
//    QSqlDatabase *db; //for my database.
    LoginDB *login;
//    QSqlTableModel *model; //join table and database
    QSqlQueryModel *model; //My problem is that I want to display some information from the SQLITE Database in view # 1.


public slots:
    void newfiledb(); // Connected to NouveauDialog in FenPrincipale.cpp
};

#endif // FENCENE_H

fencene.cpp

#include "fencene.h"
#include "ui_fencene.h"
#include <QDir>
#include <QDebug>
#include <QSqlRelationalTableModel>

FenCene::FenCene(QWidget *parent, LoginDB *loginDB) :
    QWidget(parent),
    ui(new Ui::FenCene),
    login(loginDB)
{
    ui->setupUi(this);
}


FenCene::~FenCene()
{
    delete ui;
}

void FenCene::newfiledb()
{
    /*QString path = QDir::homePath() + "/CEN.db";*/ // Home-Directory of User + Name of Database File
    // We maybe can create a subfolder in HomeDir and put .db file there later.

    //    qDebug() << path; // Output in Console to check Path to DB-File

    if(login->conOpen())
    {
        QSqlQuery query(login->db);
        query.exec("CREATE TABLE IF NOT EXISTS Student "
                   "(id INTEGER PRIMARY KEY, "
                   "name VARCHAR(30), "
                   "prename VARCHAR(50), "
                   "sex VARCHAR(1), "
                   "classID INTEGER, "
                   "FOREIGN KEY(classID) REFERENCES Class)");
        query.exec("INSERT INTO Student VALUES(NULL, 'Name0', 'Prenom0', 'M', 0)");
        query.exec("INSERT INTO Student VALUES(NULL, 'Name1', 'Prenom1', 'F', 0)");
        query.exec("INSERT INTO Student VALUES(NULL, 'Name2', 'Prenom2', 'M', 0)");


        query.exec("CREATE TABLE IF NOT EXISTS Class "         //The list of classes is in Qnouveaudialogue.ui
                   "(id INTEGER PRIMARY KEY, "                    //The name of a class is: choice (combox2) + choice (combox4) + choice (combox5).
                   "name VARCHAR(20), "          //Example: 6èmeMC1.
                   "classteacher INTEGER, "
                   "FOREIGN KEY(classteacher) REFERENCES Teacher)");
        query.exec("INSERT INTO Class VALUES(NULL, '6èmeMC1', 0)");
        query.exec("INSERT INTO Class VALUES(NULL, '6èmeMC1', 0)");
        query.exec("INSERT INTO Class VALUES(NULL, '6èmeMC1', 1)");


        query.exec("CREATE TABLE IF NOT EXISTS Teacher"   //I suggested that the teacher's name not be in the database.
                   "(id INTEGER PRIMARY KEY, "    //It's useless but I respect your instructions in the code so I put it in it.
                   "name VARCHAR(30), "
                   "prename VARCHAR(50), "
                   "sex VARCHAR(1))");
        query.exec("INSERT INTO teacher VALUES(NULL, 'NomTeacher0', 'PrenomTeacher0', 'M')");
        query.exec("INSERT INTO teacher VALUES(NULL, 'NomTeacher1', 'PrenomTeacher1', 'M')");
        query.exec("INSERT INTO teacher VALUES(NULL, 'NomTeacher2', 'PrenomTeacher2', 'M')");


        query.exec("CREATE TABLE IF NOT EXISTS Course" //(0 for Science, 1 for Litterature, 2 for Autres)
                   "(id INTEGER PRIMARY KEY, "
                   "name VARCHAR(30), "
                   "groupID INTEGER, "
                   "teacherID INTEGER, "
                   "FOREIGN KEY(groupID) REFERENCES CourseGroup, "
                   "FOREIGN KEY(teacherID) REFERENCES Teacher)");
        query.exec("INSERT INTO Course VALUES(NULL, 'CommunicationEcrite', 0, 0)"); //The list of course are in the Qnouveaudialogue
        query.exec("INSERT INTO Course VALUES(NULL, 'Lecture', 1, 0)");              //This is the combox 2
        query.exec("INSERT INTO Course VALUES(NULL, 'Anglais', 1, 0)");
        query.exec("INSERT INTO Course VALUES(NULL, 'Espagnol', 1, 0)");
        query.exec("INSERT INTO Course VALUES(NULL, 'Allemand', 1, 0)");
        query.exec("INSERT INTO Course VALUES(NULL, 'Arabe', 1, 0)");
        query.exec("INSERT INTO Course VALUES(NULL, 'Histoiregeographie', 1, 0)");
        query.exec("INSERT INTO Course VALUES(NULL, 'Philosophie', 1, 0)");
        query.exec("INSERT INTO Course VALUES(NULL, 'Mathematiques', 0, 0)");
        query.exec("INSERT INTO Course VALUES(NULL, 'PCT', 0, 0)");
        query.exec("INSERT INTO Course VALUES(NULL, 'SVT', 0, 0)");
        query.exec("INSERT INTO Course VALUES(NULL, 'EPS', 2, 0)");
        query.exec("INSERT INTO Course VALUES(NULL, 'Conduite', 1, 0)");


        query.exec("CREATE TABLE IF NOT EXISTS Coursegroup"
                   "(id INTEGER PRIMARY KEY, "
                   "name VARCHAR(20))");
        query.exec("INSERT INTO Coursegroup VALUES(NULL, 'Science')");
        query.exec("INSERT INTO Coursegroup VALUES(NULL, 'Littérature')");
        query.exec("INSERT INTO Coursegroup VALUES(NULL, 'Autres')");


        query.exec("CREATE TABLE IF NOT EXISTS Grade"   // What do I have to put in this table? // This is the table which stores the students' grades
                   "(id INTEGER PRIMARY KEY, "          // Its connected to student (by the student ID) and the course (by the courseID)
                   "studentID INTEGER, "
                   "courseID INTEGER, "
                   "gradeName VARCHAR(10), "          // the "Name" of the grade is for "Notei1-5" and "Noted1-2", so you can save, which grade it is
                   "grade INTEGER, "                       // the grade value
                   "comment VARCHAR(100), "
                   "FOREIGN KEY(studentID) REFERENCES Student, "
                   "FOREIGN KEY(courseID) REFERENCES Course)");                 // additional / optional comment from teacher on this grade / note
        query.exec("INSERT INTO Grade VALUES(NULL, 0, 3, 'Test', 2, 'Comment')");  // ID N°3 FOR Espagnol
        query.exec("INSERT INTO Grade VALUES(NULL, 0, 3, 'Test2', 3, 'Comment')");
        query.exec("INSERT INTO Grade VALUES(NULL, 0, 3, 'Test3', 4, 'Comment5')");


        //// We need SQL_RelationalTableModel later to display data correctly (JOIN Tables)
        ////    QSqlRelationalTableModel *model = new QSqlRelationalTableModel(this);

        model = new QSqlQueryModel(this);
        query.exec("SELECT * FROM Student");
        model->setQuery(query);
        ui->tableView->setModel(model);
    }

    // Next I will change this function here. At the moment it still creates new tables every time and inserts our test data.

    // dont need to close in every function. DB can be connected until we dont want to view / select / delete or insert data
//    login->conClose();
}





Here is the image of the view I want to display. The view

I specify that the columns "Moy Interro", "Moy Sem", "Moy Coef", "Mention" will be empty and are not stcoké in the database. Thanks for your help.

We recommend hosting TIMEWEB
We recommend hosting TIMEWEB
Stable hosting, on which the social network EVILEG is located. For projects on Django we recommend VDS hosting.
3

Hello.

It is a little bit difficult table. I can try to advice direction in this case.

Did you see this example https://evileg.com/en/post/67/

And can you show result of this code?

model = new QSqlQueryModel(this);
query.exec("SELECT * FROM Student");
model->setQuery(query);
ui->tableView->setModel(model);

I mean picture.

n

Hello Евгений Легоцкой Thank you for your reply. I would like to understand. So I have to create the tableview in Qt designer? And after the connected to the database?

I will study the example that you have proposed tonight. Thanks again... Nafab

Yes, You can to create TableView in Qt Designer. Just find Table View object and add it to form. But you should add model to table view in c++ code.

And yes, you can add table view and models after database connection.

Comments

Only authorized users can post comments.
Please, Log in or Sign up
How to become an author?

Contribute to the evolution of the EVILEG community.

Learn how to become a site author.

Learn it
Donate

Good day, Dear Users!!!

I am Evgenii Legotckoi, developer of EVILEG. And it is my hobby project, which helps to learn programming another programmers and developers

If the site helped you, and you want also support the development of the site, than you can donate by following ways

PayPalYandex.Money
Timeweb

Let me recommend you the excellent hosting on which EVILEG is located.

For many years, Timeweb has been proving his stability.

For projects on Django I recommend VDS hosting

View Hosting Timeweb
g
May 29, 2020, 2:32 p.m.
glushchenkoin

C ++ - Test 004. Pointers, Arrays and Loops

  • Result:40points,
  • Rating points-8
AS
May 26, 2020, 11:29 a.m.
Artem Sun-Dun-Chan

C ++ - Test 004. Pointers, Arrays and Loops

  • Result:50points,
  • Rating points-4
MN
May 25, 2020, 11:33 a.m.
Mitja Nagibin

C ++ - Test 004. Pointers, Arrays and Loops

  • Result:50points,
  • Rating points-4
Last comments
May 29, 2020, 1 p.m.
Evgenij Legotskoj

Django - Tutorial 023. Like Dislike system using GenericForeignKey

Думал так, но похоже что нет. {{ post.votes.likes.user.username }} Это же QuerySet будет, а не отдельный единственный объект {% for vote in post.votes %} {{ vote.user.username …
May 29, 2020, 11:43 a.m.
Vladislav Melenchuk

Django - Tutorial 023. Like Dislike system using GenericForeignKey

А как получить имя пользователя, который поставил лайк? Думал так, но похоже что нет. {{ post.votes.likes.user.username }}
May 29, 2020, 6:30 a.m.
Evgenij Legotskoj

Qt/C++ - Lesson 039. How to paint stroke in QSqlTableModel by value in the column?

У меня работает. Исправлял в проекте, который приложен к статье. А что происходит в вашем коде, с учётом места вызова этого кода, я знать не могу ;) Дебажьте и добавляйте условия, кото…
MA
May 29, 2020, 6:27 a.m.
Mihail A

Qt/C++ - Lesson 039. How to paint stroke in QSqlTableModel by value in the column?

QModelIndexList rowIndexes = ui->tableView->selectionModel()->selectedRows(); model->removeRows(rowIndexes.first().row(), rowIndexes.size()); model-&…
May 29, 2020, 6:14 a.m.
Evgenij Legotskoj

Django - Tutorial 036. How to add authentication through social networks. VKontakte

Неправильно прописали URL, на который возвращается ответ от OAuth ВКонтакте. Настраивайте ваше приложение в консоли разработчика ВКонтакте
Now discuss on the forum
DK
May 29, 2020, 1:27 p.m.
Dzhon Kofi

QMap<> какой ключ лучше

это ясно. Вопрос в том, как быстро мапа будет отрабатывать, если ключом будет QModelIndex. Какой параметр индекса возьмет за ключ. И вот насколько это будет медленнее или быстрее, чем QString пр…
DK
May 29, 2020, 11:10 a.m.
Dzhon Kofi

QModelIndex становится не действительным, но валидный

Привет. Есть проблема с индексом и для меня это чистая магия: Сначала, что делаю: на вьюхе есть редактируемые ячейки. Пользователь редактирует одну, потом внезапно решает не сохраниться и ш…
May 29, 2020, 7:52 a.m.
Vladimir Sergeevich

Масштабирование двумя пальцами на мобильных платформах

Я планировал описать этот момент на блоге, но никак руки не доходят (уже год). Летом дойдут. Тем не менее, у меня в репозитории лежит рабочий код игрушки "пазлы", где есть все это. …
May 29, 2020, 6:51 a.m.
Evgenij Legotskoj

Графическое ускорение

Зависит от платформы и поддерживаемых технологий. В QML в первую очередь используется OpenGL и отрисовка производится средствами GPU. Но может переключаться на использование CPU и прог…
IP
May 29, 2020, 1:55 a.m.
Igor' Poroshin

QTablwView + QSqlQueryModel скрыть пустой столбец

Да, понятно. В данном случае лучше использовать серверную процедуру (если такие поддерживаются), в которой будет проверяться наличие всех пустых строк у нужного столбца и вызываться соответ…
About
Services
© EVILEG 2015-2020
Recommend hosting TIMEWEB