aboutsummaryrefslogtreecommitdiffstats
path: root/SQLiteStudio3/coreSQLiteStudio/plugins/scriptingsql.h
blob: 7b8fd3b1b6d62cc4296beb47e027bb7d1583df7f (plain) (blame)
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
#ifndef SCRIPTINGSQL_H
#define SCRIPTINGSQL_H

#include "builtinplugin.h"
#include "scriptingplugin.h"

class ScriptingSql : public BuiltInPlugin, public DbAwareScriptingPlugin
{
    Q_OBJECT

    SQLITESTUDIO_PLUGIN_TITLE("SQL scripting")
    SQLITESTUDIO_PLUGIN_DESC("SQL scripting support.")
    SQLITESTUDIO_PLUGIN_VERSION(10000)
    SQLITESTUDIO_PLUGIN_AUTHOR("sqlitestudio.pl")

    public:
        class SqlContext : public Context
        {
            public:
                QString errorText;
                QHash<QString,QVariant> variables;
        };

        ScriptingSql();
        ~ScriptingSql();

        QString getLanguage() const;
        Context* createContext();
        void releaseContext(Context* context);
        void resetContext(Context* context);
        QVariant evaluate(Context* context, const QString& code, const QList<QVariant>& args, Db* db, bool locking);
        QVariant evaluate(const QString& code, const QList<QVariant>& args, Db* db, bool locking, QString* errorMessage);
        void setVariable(Context* context, const QString& name, const QVariant& value);
        QVariant getVariable(Context* context, const QString& name);
        bool hasError(Context* context) const;
        QString getErrorMessage(Context* context) const;
        QString getIconPath() const;
        bool init();
        void deinit();

    private:
        QList<Context*> contexts;
        Db* memDb = nullptr;
};

#endif // SCRIPTINGSQL_H