| /**************************************************************************** |
| ** |
| ** Copyright (C) 2016 The Qt Company Ltd. |
| ** Contact: https://www.qt.io/licensing/ |
| ** |
| ** This file is part of the demonstration applications of the Qt Toolkit. |
| ** |
| ** $QT_BEGIN_LICENSE:BSD$ |
| ** Commercial License Usage |
| ** Licensees holding valid commercial Qt licenses may use this file in |
| ** accordance with the commercial license agreement provided with the |
| ** Software or, alternatively, in accordance with the terms contained in |
| ** a written agreement between you and The Qt Company. For licensing terms |
| ** and conditions see https://www.qt.io/terms-conditions. For further |
| ** information use the contact form at https://www.qt.io/contact-us. |
| ** |
| ** BSD License Usage |
| ** Alternatively, you may use this file under the terms of the BSD license |
| ** as follows: |
| ** |
| ** "Redistribution and use in source and binary forms, with or without |
| ** modification, are permitted provided that the following conditions are |
| ** met: |
| ** * Redistributions of source code must retain the above copyright |
| ** notice, this list of conditions and the following disclaimer. |
| ** * Redistributions in binary form must reproduce the above copyright |
| ** notice, this list of conditions and the following disclaimer in |
| ** the documentation and/or other materials provided with the |
| ** distribution. |
| ** * Neither the name of The Qt Company Ltd nor the names of its |
| ** contributors may be used to endorse or promote products derived |
| ** from this software without specific prior written permission. |
| ** |
| ** |
| ** THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS |
| ** "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT |
| ** LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR |
| ** A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT |
| ** OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, |
| ** SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT |
| ** LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, |
| ** DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY |
| ** THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT |
| ** (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE |
| ** OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE." |
| ** |
| ** $QT_END_LICENSE$ |
| ** |
| ****************************************************************************/ |
| |
| #include "browser.h" |
| #include "qsqlconnectiondialog.h" |
| |
| #include <QtWidgets> |
| #include <QtSql> |
| |
| Browser::Browser(QWidget *parent) |
| : QWidget(parent) |
| { |
| setupUi(this); |
| |
| table->addAction(insertRowAction); |
| table->addAction(deleteRowAction); |
| table->addAction(fieldStrategyAction); |
| table->addAction(rowStrategyAction); |
| table->addAction(manualStrategyAction); |
| table->addAction(submitAction); |
| table->addAction(revertAction); |
| table->addAction(selectAction); |
| |
| if (QSqlDatabase::drivers().isEmpty()) |
| QMessageBox::information(this, tr("No database drivers found"), |
| tr("This demo requires at least one Qt database driver. " |
| "Please check the documentation how to build the " |
| "Qt SQL plugins.")); |
| |
| emit statusMessage(tr("Ready.")); |
| } |
| |
| Browser::~Browser() |
| { |
| } |
| |
| void Browser::exec() |
| { |
| QSqlQueryModel *model = new QSqlQueryModel(table); |
| model->setQuery(QSqlQuery(sqlEdit->toPlainText(), connectionWidget->currentDatabase())); |
| table->setModel(model); |
| |
| if (model->lastError().type() != QSqlError::NoError) |
| emit statusMessage(model->lastError().text()); |
| else if (model->query().isSelect()) |
| emit statusMessage(tr("Query OK.")); |
| else |
| emit statusMessage(tr("Query OK, number of affected rows: %1").arg( |
| model->query().numRowsAffected())); |
| |
| updateActions(); |
| } |
| |
| QSqlError Browser::addConnection(const QString &driver, const QString &dbName, const QString &host, |
| const QString &user, const QString &passwd, int port) |
| { |
| static int cCount = 0; |
| |
| QSqlError err; |
| QSqlDatabase db = QSqlDatabase::addDatabase(driver, QString("Browser%1").arg(++cCount)); |
| db.setDatabaseName(dbName); |
| db.setHostName(host); |
| db.setPort(port); |
| if (!db.open(user, passwd)) { |
| err = db.lastError(); |
| db = QSqlDatabase(); |
| QSqlDatabase::removeDatabase(QString("Browser%1").arg(cCount)); |
| } |
| connectionWidget->refresh(); |
| |
| return err; |
| } |
| |
| void Browser::addConnection() |
| { |
| QSqlConnectionDialog dialog(this); |
| if (dialog.exec() != QDialog::Accepted) |
| return; |
| |
| if (dialog.useInMemoryDatabase()) { |
| QSqlDatabase::database("in_mem_db", false).close(); |
| QSqlDatabase::removeDatabase("in_mem_db"); |
| QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE", "in_mem_db"); |
| db.setDatabaseName(":memory:"); |
| if (!db.open()) |
| QMessageBox::warning(this, tr("Unable to open database"), tr("An error occurred while " |
| "opening the connection: ") + db.lastError().text()); |
| QSqlQuery q("", db); |
| q.exec("drop table Movies"); |
| q.exec("drop table Names"); |
| q.exec("create table Movies (id integer primary key, Title varchar, Director varchar, Rating number)"); |
| q.exec("insert into Movies values (0, 'Metropolis', 'Fritz Lang', '8.4')"); |
| q.exec("insert into Movies values (1, 'Nosferatu, eine Symphonie des Grauens', 'F.W. Murnau', '8.1')"); |
| q.exec("insert into Movies values (2, 'Bis ans Ende der Welt', 'Wim Wenders', '6.5')"); |
| q.exec("insert into Movies values (3, 'Hardware', 'Richard Stanley', '5.2')"); |
| q.exec("insert into Movies values (4, 'Mitchell', 'Andrew V. McLaglen', '2.1')"); |
| q.exec("create table Names (id integer primary key, Firstname varchar, Lastname varchar, City varchar)"); |
| q.exec("insert into Names values (0, 'Sala', 'Palmer', 'Morristown')"); |
| q.exec("insert into Names values (1, 'Christopher', 'Walker', 'Morristown')"); |
| q.exec("insert into Names values (2, 'Donald', 'Duck', 'Andeby')"); |
| q.exec("insert into Names values (3, 'Buck', 'Rogers', 'Paris')"); |
| q.exec("insert into Names values (4, 'Sherlock', 'Holmes', 'London')"); |
| connectionWidget->refresh(); |
| } else { |
| QSqlError err = addConnection(dialog.driverName(), dialog.databaseName(), dialog.hostName(), |
| dialog.userName(), dialog.password(), dialog.port()); |
| if (err.type() != QSqlError::NoError) |
| QMessageBox::warning(this, tr("Unable to open database"), tr("An error occurred while " |
| "opening the connection: ") + err.text()); |
| } |
| } |
| |
| void Browser::showTable(const QString &t) |
| { |
| QSqlTableModel *model = new CustomModel(table, connectionWidget->currentDatabase()); |
| model->setEditStrategy(QSqlTableModel::OnRowChange); |
| model->setTable(connectionWidget->currentDatabase().driver()->escapeIdentifier(t, QSqlDriver::TableName)); |
| model->select(); |
| if (model->lastError().type() != QSqlError::NoError) |
| emit statusMessage(model->lastError().text()); |
| |
| table->setModel(model); |
| table->setEditTriggers(QAbstractItemView::DoubleClicked|QAbstractItemView::EditKeyPressed); |
| connect(table->selectionModel(), &QItemSelectionModel::currentRowChanged, |
| this, &Browser::currentChanged); |
| |
| updateActions(); |
| } |
| |
| void Browser::showMetaData(const QString &t) |
| { |
| QSqlRecord rec = connectionWidget->currentDatabase().record(t); |
| QStandardItemModel *model = new QStandardItemModel(table); |
| |
| model->insertRows(0, rec.count()); |
| model->insertColumns(0, 7); |
| |
| model->setHeaderData(0, Qt::Horizontal, "Fieldname"); |
| model->setHeaderData(1, Qt::Horizontal, "Type"); |
| model->setHeaderData(2, Qt::Horizontal, "Length"); |
| model->setHeaderData(3, Qt::Horizontal, "Precision"); |
| model->setHeaderData(4, Qt::Horizontal, "Required"); |
| model->setHeaderData(5, Qt::Horizontal, "AutoValue"); |
| model->setHeaderData(6, Qt::Horizontal, "DefaultValue"); |
| |
| for (int i = 0; i < rec.count(); ++i) { |
| QSqlField fld = rec.field(i); |
| model->setData(model->index(i, 0), fld.name()); |
| model->setData(model->index(i, 1), fld.typeID() == -1 |
| ? QString(QMetaType::typeName(fld.type())) |
| : QString("%1 (%2)").arg(QMetaType::typeName(fld.type())).arg(fld.typeID())); |
| model->setData(model->index(i, 2), fld.length()); |
| model->setData(model->index(i, 3), fld.precision()); |
| model->setData(model->index(i, 4), fld.requiredStatus() == -1 ? QVariant("?") |
| : QVariant(bool(fld.requiredStatus()))); |
| model->setData(model->index(i, 5), fld.isAutoValue()); |
| model->setData(model->index(i, 6), fld.defaultValue()); |
| } |
| |
| table->setModel(model); |
| table->setEditTriggers(QAbstractItemView::NoEditTriggers); |
| |
| updateActions(); |
| } |
| |
| void Browser::insertRow() |
| { |
| QSqlTableModel *model = qobject_cast<QSqlTableModel *>(table->model()); |
| if (!model) |
| return; |
| |
| QModelIndex insertIndex = table->currentIndex(); |
| int row = insertIndex.row() == -1 ? 0 : insertIndex.row(); |
| model->insertRow(row); |
| insertIndex = model->index(row, 0); |
| table->setCurrentIndex(insertIndex); |
| table->edit(insertIndex); |
| } |
| |
| void Browser::deleteRow() |
| { |
| QSqlTableModel *model = qobject_cast<QSqlTableModel *>(table->model()); |
| if (!model) |
| return; |
| |
| QModelIndexList currentSelection = table->selectionModel()->selectedIndexes(); |
| for (int i = 0; i < currentSelection.count(); ++i) { |
| if (currentSelection.at(i).column() != 0) |
| continue; |
| model->removeRow(currentSelection.at(i).row()); |
| } |
| |
| updateActions(); |
| } |
| |
| void Browser::updateActions() |
| { |
| QSqlTableModel * tm = qobject_cast<QSqlTableModel *>(table->model()); |
| bool enableIns = tm; |
| bool enableDel = enableIns && table->currentIndex().isValid(); |
| |
| insertRowAction->setEnabled(enableIns); |
| deleteRowAction->setEnabled(enableDel); |
| |
| fieldStrategyAction->setEnabled(tm); |
| rowStrategyAction->setEnabled(tm); |
| manualStrategyAction->setEnabled(tm); |
| submitAction->setEnabled(tm); |
| revertAction->setEnabled(tm); |
| selectAction->setEnabled(tm); |
| |
| if (tm) { |
| QSqlTableModel::EditStrategy es = tm->editStrategy(); |
| fieldStrategyAction->setChecked(es == QSqlTableModel::OnFieldChange); |
| rowStrategyAction->setChecked(es == QSqlTableModel::OnRowChange); |
| manualStrategyAction->setChecked(es == QSqlTableModel::OnManualSubmit); |
| } |
| } |
| |
| void Browser::about() |
| { |
| QMessageBox::about(this, tr("About"), tr("The SQL Browser demonstration " |
| "shows how a data browser can be used to visualize the results of SQL" |
| "statements on a live database")); |
| } |
| |
| void Browser::on_fieldStrategyAction_triggered() |
| { |
| QSqlTableModel * tm = qobject_cast<QSqlTableModel *>(table->model()); |
| if (tm) |
| tm->setEditStrategy(QSqlTableModel::OnFieldChange); |
| } |
| |
| void Browser::on_rowStrategyAction_triggered() |
| { |
| QSqlTableModel * tm = qobject_cast<QSqlTableModel *>(table->model()); |
| if (tm) |
| tm->setEditStrategy(QSqlTableModel::OnRowChange); |
| } |
| |
| void Browser::on_manualStrategyAction_triggered() |
| { |
| QSqlTableModel * tm = qobject_cast<QSqlTableModel *>(table->model()); |
| if (tm) |
| tm->setEditStrategy(QSqlTableModel::OnManualSubmit); |
| } |
| |
| void Browser::on_submitAction_triggered() |
| { |
| QSqlTableModel * tm = qobject_cast<QSqlTableModel *>(table->model()); |
| if (tm) |
| tm->submitAll(); |
| } |
| |
| void Browser::on_revertAction_triggered() |
| { |
| QSqlTableModel * tm = qobject_cast<QSqlTableModel *>(table->model()); |
| if (tm) |
| tm->revertAll(); |
| } |
| |
| void Browser::on_selectAction_triggered() |
| { |
| QSqlTableModel * tm = qobject_cast<QSqlTableModel *>(table->model()); |
| if (tm) |
| tm->select(); |
| } |
| |