GeezerVison is showing github.com — sqlitebrowser/src/SqlExecutionArea.cpp at master · Processoriented/sqlitebrowser

Expand file tree

SqlExecutionArea.cpp

Copy path

More file actions

Latest commit

History

125 lines (106 loc) · 3.48 KB

SqlExecutionArea.cpp

Copy path

File metadata and controls

125 lines (106 loc) · 3.48 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

#include "SqlExecutionArea.h"

#include "ui_SqlExecutionArea.h"

#include "sqltextedit.h"

#include "ExtendedTableWidget.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);

// 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);

// Load settings

reloadSettings();

}

SqlExecutionArea::~SqlExecutionArea()

{

delete ui;

}

QString SqlExecutionArea::getSql() const

{

return ui->editEditor->text();

}

QString SqlExecutionArea::getSelectedSql() const

{

return ui->editEditor->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));

}

void SqlExecutionArea::reloadSettings()

{

// Reload editor settings

ui->editEditor->reloadSettings();

// Set font

QFont logfont(PreferencesDialog::getSettingsValue("editor", "font").toString());

logfont.setStyleHint(QFont::TypeWriter);

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

ui->editErrors->setFont(logfont);

// Apply horizontal/vertical tiling option

if(PreferencesDialog::getSettingsValue("editor", "horizontal_tiling").toBool())

ui->splitter->setOrientation(Qt::Horizontal);

else

ui->splitter->setOrientation(Qt::Vertical);

}