aboutsummaryrefslogtreecommitdiffstats
path: root/plugins/datasource/sqltabledatasource.h
blob: f47845fdba8de52e1050425ab81442ee38df0a18 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
/****************************************************************************
**
** Copyright (C) 2016 Pelagicore AG
** Contact: http://www.qt.io/ or http://www.pelagicore.com/
**
** This file is part of the Neptune IVI UI.
**
** $QT_BEGIN_LICENSE:GPL3-PELAGICORE$
** Commercial License Usage
** Licensees holding valid commercial Pelagicore Neptune IVI UI
** licenses may use this file in accordance with the commercial license
** agreement provided with the Software or, alternatively, in accordance
** with the terms contained in a written agreement between you and
** Pelagicore. For licensing terms and conditions, contact us at:
** http://www.pelagicore.com.
**
** GNU General Public License Usage
** Alternatively, this file may be used under the terms of the GNU
** General Public License version 3 as published by the Free Software
** Foundation and appearing in the file LICENSE.GPLv3 included in the
** packaging of this file. Please review the following information to
** ensure the GNU General Public License version 3 requirements will be
** met: http://www.gnu.org/licenses/gpl-3.0.html.
**
** $QT_END_LICENSE$
**
** SPDX-License-Identifier: GPL-3.0
**
****************************************************************************/

#ifndef SQLTABLEDATASOURCE_H
#define SQLTABLEDATASOURCE_H

#include <QtCore/QAbstractItemModel>
#include <QtSql/QSqlDatabase>
#include <QtQml/QQmlParserStatus>

class SqlTableModel;

class SqlTableDataSource : public QObject, public QQmlParserStatus
{
    Q_OBJECT
    Q_INTERFACES(QQmlParserStatus)
    Q_PROPERTY(QString database READ database WRITE setDatabase NOTIFY databaseChanged)
    Q_PROPERTY(QString table READ table WRITE setTable NOTIFY tableChanged)
    Q_PROPERTY(QString filter READ filter WRITE setFilter NOTIFY filterChanged)
    Q_PROPERTY(QObject* model READ model NOTIFY modelChanged)
    Q_PROPERTY(int count READ count NOTIFY countChanged)
    Q_PROPERTY(QString storageLocation READ storageLocation CONSTANT)
    Q_PROPERTY(Status status READ status NOTIFY statusChanged)
    Q_ENUMS(Status)

public:
    enum Status { Null, Loading, Ready, Error };
    explicit SqlTableDataSource(QObject *parent = 0);

    QString table() const;
    void setTable(QString tableName);

    QString database() const;
    void setDatabase(QString databaseName);

    QAbstractItemModel* model() const;
    int count() const;
    Status status() const;
    void setStatus(Status status);
    QString filter() const;

    Q_INVOKABLE QVariantMap get(int index) const;
    // parser status
    void classBegin();
    void componentComplete();

    QString storageLocation() const;

public slots:
    void setFilter(QString filter);

signals:
    void tableChanged(QString table);
    void databaseChanged(QString database);
    void countChanged(int count);
    void statusChanged(Status status);
    void modelChanged(QObject* model);
    void filterChanged(QString arg);

private:
    void updateModel();
private:
    QString m_tableName;
    QString m_databaseName;
    QSqlDatabase m_database;
    SqlTableModel* m_model;
    Status m_status;
    QString m_filter;
    bool m_componentCompleted;
};

#endif // SQLTABLEDATASOURCE_H