dbmanager.h

Go to the documentation of this file.

#ifndef DBMANAGER_H
#define DBMANAGER_H

#ifdef _MSC_VER
#pragma once
#endif // _MSC_VER

#include "mattynote.h"
#include "queryconstructor.h"

#include <QMessageBox>
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QSqlRecord>
#include <QSqlTableModel>
#include <QSqlError>
#include <QString>

struct MattyNoteRow
{
    MattyNoteRow()
    {}

    MattyNoteRow(int NoteIdIncm, QString NoteTitleIncm, QString NoteTypeIncm,
            QString NoteTextIncm, QString EventTimeIncm, QString EventDateIncm,
            QString CrTimeIncm, QString CtDateIncm, int TypeIdIncm)
        : NoteId(NoteIdIncm),
          NoteTitle(NoteTitleIncm),
          NoteType(NoteTypeIncm),
          NoteText(NoteTextIncm),
          EventTime(EventTimeIncm),
          EventDate(EventDateIncm),
          CrTime(CrTimeIncm),
          CrDate(CtDateIncm),
          TypeId(TypeIdIncm)
    {}

    int NoteId;
    QString NoteTitle;
    QString NoteType;
    QString NoteText;
    QString EventTime;
    QString EventDate;
    QString CrTime;
    QString CrDate;
    int TypeId; // не работает в базе + потом при M:N вообще не нужен будет
};


struct MattyCssRow
{
    MattyCssRow()
    {}

    MattyCssRow(int RowIdIncm, QString DescriptionIncm, QString ElementsIncm,
            QString PropertyNameIncm, QString PropertyCustomValueIncm,
           QString PropertyDefaultValueIncm,
            int PropetyCustomValueUsedIncm, QString ImportantMarkIncm)
        : RowId(RowIdIncm),
          Description(DescriptionIncm),
          Elements(ElementsIncm),
          PropertyName(PropertyNameIncm),
          PropertyCustomValue(PropertyCustomValueIncm),
          PropertyDefaultValue(PropertyDefaultValueIncm),
          PropetyCustomValueUsed(PropetyCustomValueUsedIncm),
          ImportantMark(ImportantMarkIncm)
    {}

    int RowId;
    QString Description;
    QString Elements;
    QString PropertyName;
    QString PropertyCustomValue;
    QString PropertyDefaultValue;
    QString PropetyCustomValueUsed;
    QString ImportantMark;
};

enum CssTables { MainCss = 0, CustomCss };

class DbManager
{
public:
    DbManager();
    ~DbManager();
    static bool connected();
    static bool connect(const QString& path);
    static bool addNote(MattyNote & Note);
    static bool editNote(MattyNote & Note, int NoteId);
    static bool deleteNote(int NoteId);
    static MattyNoteRow showNote(int NoteId);
  //  static QVector<QStringList> showNotes();
    static QVector<MattyNoteRow> showNotes();
    static QVector<MattyNoteRow> showNotes(QMap<QString, QString> & Filter);
    static QSqlTableModel* getModel(const QString& path); // needtodelete wherever it's called
    static QStringList getTypes();
    static QString getTypeName(int TypeId);
    static int getTypeId(const QString & TypeName);
    static int getNoteCount();
   // static QVector<MattyCssRow> getCss(CssTables TableName);
    //static QVector<QStringList> getAllNotesOrderByCrDate();
    static void showIsNotOpenedError();
private:
    static QSqlDatabase MattyNotesDb;
    static QString PathToDb;
};

#endif // DBMANAGER_H