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

Expand file tree

ExportSqlDialog.cpp

Copy path

More file actions

Latest commit

History

95 lines (82 loc) · 3.2 KB

ExportSqlDialog.cpp

Copy path

File metadata and controls

95 lines (82 loc) · 3.2 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

#include "ExportSqlDialog.h"

#include "ui_ExportSqlDialog.h"

#include "sqlitedb.h"

#include "PreferencesDialog.h"

#include "sqlitetablemodel.h"

#include "sqlite.h"

#include "FileDialog.h"

#include <QFile>

#include <QMessageBox>

#include <QSettings>

static QString sSettingsGroup("exportsql");

static QString sSettingsInsertColNames("insertcolnames");

static QString sSettingsInsertMultiple("insertmultiple");

ExportSqlDialog::ExportSqlDialog(DBBrowserDB* db, QWidget* parent, const QString& selection)

: QDialog(parent),

ui(new Ui::ExportSqlDialog),

pdb(db)

{

// Create UI

ui->setupUi(this);

QSettings settings(QApplication::organizationName(), QApplication::organizationName());

settings.beginGroup(sSettingsGroup);

ui->checkColNames->setChecked(settings.value(sSettingsInsertColNames, false).toBool());

ui->checkMultiple->setChecked(settings.value(sSettingsInsertMultiple, false).toBool());

// Get list of tables to export

objectMap objects = pdb->getBrowsableObjects();

for(objectMap::ConstIterator i=objects.begin();i!=objects.end();++i) {

ui->listTables->addItem(new QListWidgetItem(QIcon(QString(":icons/%1").arg(i.value().gettype())), i.value().getname()));

}

// Sort list of tables and select the table specified in the

// selection parameter or all tables if table not specified

ui->listTables->model()->sort(0);

if(selection.isEmpty())

{

for (int i = 0; i < ui->listTables->count(); ++i)

ui->listTables->item(i)->setSelected(true);

}

else

{

QList<QListWidgetItem*> items = ui->listTables->findItems(selection, Qt::MatchExactly);

ui->listTables->setCurrentItem(items.at(0));

}

ui->listTables->setFocus();

}

ExportSqlDialog::~ExportSqlDialog()

{

delete ui;

}

void ExportSqlDialog::accept()

{

if(ui->listTables->selectedItems().isEmpty())

{

QMessageBox::warning(this, QApplication::applicationName(),

tr("Please select at least 1 table."));

return;

}

QString fileName = FileDialog::getSaveFileName(

this,

tr("Choose a filename to export"),

tr("Text files(*.sql *.txt)"));

if(fileName.isEmpty())

return;

// save settings

QSettings settings(QApplication::organizationName(), QApplication::organizationName());

settings.beginGroup(sSettingsGroup);

settings.setValue(sSettingsInsertColNames, ui->checkColNames->isChecked());

settings.setValue(sSettingsInsertMultiple, ui->checkMultiple->isChecked());

settings.endGroup();

QStringList tables;

foreach (const QListWidgetItem * item, ui->listTables->selectedItems())

tables.push_back(item->text());

bool dumpOk = pdb->dump(fileName,

tables,

ui->checkColNames->isChecked(),

ui->checkMultiple->isChecked(),

ui->checkSchemaOnly->isChecked());

if (dumpOk)

QMessageBox::information(this, QApplication::applicationName(), tr("Export completed."));

else

QMessageBox::warning(this, QApplication::applicationName(), tr("Export cancelled or failed."));

QDialog::accept();

}