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
|
#ifndef HTMLEXPORT_H
#define HTMLEXPORT_H
#include "htmlexport_global.h"
#include "plugins/genericexportplugin.h"
#include "config_builder.h"
CFG_CATEGORIES(HtmlExportConfig,
CFG_CATEGORY(HtmlExport,
CFG_ENTRY(QString, Format, "compress")
CFG_ENTRY(bool, PrintRowNum, true)
CFG_ENTRY(bool, PrintHeader, true)
CFG_ENTRY(bool, PrintDataTypes, true)
CFG_ENTRY(bool, DontEscapeHtml, false)
CFG_ENTRY(int, ByteLengthLimit, 10000)
)
)
class HTMLEXPORTSHARED_EXPORT HtmlExport : public GenericExportPlugin
{
Q_OBJECT
SQLITESTUDIO_PLUGIN("htmlexport.json")
public:
QString getFormatName() const;
ExportManager::StandardConfigFlags standardOptionsToEnable() const;
QString getExportConfigFormName() const;
CfgMain* getConfig();
void validateOptions();
QString defaultFileExtension() const;
bool beforeExportQueryResults(const QString& query, QList<QueryExecutor::ResultColumnPtr>& columns,
const QHash<ExportManager::ExportProviderFlag,QVariant> providedData);
bool exportQueryResultsRow(SqlResultsRowPtr row);
bool exportTable(const QString& database, const QString& table, const QStringList& columnNames, const QString& ddl, SqliteCreateTablePtr createTable,
const QHash<ExportManager::ExportProviderFlag,QVariant> providedData);
bool exportVirtualTable(const QString& database, const QString& table, const QStringList& columnNames, const QString& ddl, SqliteCreateVirtualTablePtr createTable,
const QHash<ExportManager::ExportProviderFlag,QVariant> providedData);
bool exportTableRow(SqlResultsRowPtr data);
bool beforeExportDatabase(const QString& database);
bool exportIndex(const QString& database, const QString& name, const QString& ddl, SqliteCreateIndexPtr createIndex);
bool exportTrigger(const QString& database, const QString& name, const QString& ddl, SqliteCreateTriggerPtr createTrigger);
bool exportView(const QString& database, const QString& name, const QString& ddl, SqliteCreateViewPtr view);
bool afterExportQueryResults();
bool afterExportTable();
bool afterExport();
bool init();
void deinit();
private:
bool beginDoc(const QString& title);
bool exportDataRow(SqlResultsRowPtr data);
void setupConfig();
void incrIndent();
void decrIndent();
void updateIndent();
void writeln(const QString& str);
QString escape(const QString& str);
static QString compressCss(QString css);
CFG_LOCAL_PERSISTABLE(HtmlExportConfig, cfg)
bool indent = false;
int indentDepth = 0;
QString indentStr;
QString newLineStr;
QString codecName;
int currentDataRow = 0;
QList<DataType> columnTypes;
bool printRownum = false;
bool printHeader = false;
bool printDatatypes = false;
int byteLengthLimit = 0;
};
#endif // HTMLEXPORT_H
|
