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
|