FilesExpand file tree

master

/

SqlExecutionArea.cpp

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

116 lines (99 loc) · 3.23 KB

master

/

SqlExecutionArea.cpp

Copy path

Top

File metadata and controls

• Code
• Blame

116 lines (99 loc) · 3.23 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

#include "SqlExecutionArea.h"

#include "ui_SqlExecutionArea.h"

#include "sqltextedit.h"

#include "ExtendedTableWidget.h"

#include "SQLiteSyntaxHighlighter.h"

#include "sqlitetablemodel.h"

#include "sqlitedb.h"

#include "PreferencesDialog.h"

#include "ExportCsvDialog.h"

#include <QMenu>

#include <QInputDialog>

#include <QMessageBox>

SqlExecutionArea::SqlExecutionArea(QWidget* parent, DBBrowserDB* _db) :

QWidget(parent),

db(_db),

ui(new Ui::SqlExecutionArea)

{

// Create UI

ui->setupUi(this);

// Set font

QFont logfont("Monospace");

logfont.setStyleHint(QFont::TypeWriter);

logfont.setPointSize(PreferencesDialog::getSettingsValue("log", "fontsize").toInt());

ui->editErrors->setFont(logfont);

// Create model

model = new SqliteTableModel(this, db, PreferencesDialog::getSettingsValue("db", "prefetchsize").toInt());

ui->tableResult->setModel(model);

// Create popup menu for save button

menuPopupSave = new QMenu(this);

menuPopupSave->addAction(ui->actionExportCsv);

menuPopupSave->addAction(ui->actionSaveAsView);

ui->buttonSave->setMenu(menuPopupSave);

}

SqlExecutionArea::~SqlExecutionArea()

{

delete ui;

}

void SqlExecutionArea::setTableNames(const QStringList& tables)

{

ui->editEditor->syntaxHighlighter()->setTableNames(tables);

}

QString SqlExecutionArea::getSql() const

{

return ui->editEditor->toPlainText().trimmed();

}

QString SqlExecutionArea::getSelectedSql() const

{

return ui->editEditor->textCursor().selectedText().trimmed().replace(QChar(0x2029), '\n');

}

void SqlExecutionArea::finishExecution(const QString& result)

{

ui->editErrors->setText(result);

// Set column widths according to their contents but make sure they don't exceed a certain size

ui->tableResult->resizeColumnsToContents();

for(int i=0;i<model->columnCount();i++)

{

if(ui->tableResult->columnWidth(i) > 300)

ui->tableResult->setColumnWidth(i, 300);

}

}

SqlTextEdit* SqlExecutionArea::getEditor()

{

return ui->editEditor;

}

QTextEdit* SqlExecutionArea::getResultView()

{

return ui->editErrors;

}

void SqlExecutionArea::enableSaveButton(bool enable)

{

ui->buttonSave->setEnabled(enable);

}

void SqlExecutionArea::saveAsCsv()

{

ExportCsvDialog dialog(db, this, model->query());

dialog.exec();

}

void SqlExecutionArea::saveAsView()

{

// Let the user select a name for the new view and make sure it doesn't already exist

QString name;

while(true)

{

name = QInputDialog::getText(this, qApp->applicationName(), tr("Please specify the view name")).trimmed();

if(name.isEmpty())

break;

if(!db->getObjectByName(name).getname().isEmpty())

QMessageBox::warning(this, qApp->applicationName(), tr("There is already an object with that name. Please choose a different name."));

else

break;

}

if(name.isEmpty())

return;

// Create the view

if(db->executeSQL(QString("CREATE VIEW `%1` AS %2;").arg(name).arg(model->query())))

QMessageBox::information(this, qApp->applicationName(), tr("View successfully created."));

else

QMessageBox::warning(this, qApp->applicationName(), tr("Error creating view: %1").arg(db->lastErrorMessage));

}