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
|
#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 FunctionInfo& funcInfo,
const QList<QVariant>& args, Db* db, bool locking);
QVariant evaluate(const QString& code, const FunctionInfo& funcInfo,
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:
void replaceNamedArgs(QString& sql, const FunctionInfo& funcInfo, const QList<QVariant>& args);
QList<Context*> contexts;
Db* memDb = nullptr;
};
#endif // SCRIPTINGSQL_H
|