Add Browse Table popop action to Database Structure tab

In the Database Structure tab of the main window, add a new action to the popup menu which open upon right clicking the tree view to allow directly changing to the Browse Data tab with the current table being selected automatically. See issue sqlitebrowser#246.
menggang20 · Apr 23, 2015 · dd8dd48 · dd8dd48
1 parent 4c77036
commit dd8dd48
Show file tree

Hide file tree

Showing 3 changed files with 48 additions and 3 deletions.
diff --git a/src/MainWindow.cpp b/src/MainWindow.cpp
@@ -103,6 +103,7 @@ void MainWindow::init()
 
     // Create popup menus
     popupTableMenu = new QMenu(this);
+    popupTableMenu->addAction(ui->actionEditBrowseTable);
     popupTableMenu->addAction(ui->editModifyTableAction);
     popupTableMenu->addAction(ui->editDeleteObjectAction);
     popupTableMenu->addSeparator();
@@ -980,6 +981,7 @@ void MainWindow::changeTreeSelection()
     // Just assume first that something's selected that can not be edited at all
     ui->editDeleteObjectAction->setEnabled(false);
     ui->editModifyTableAction->setEnabled(false);
+    ui->actionEditBrowseTable->setEnabled(false);
 
     if(!ui->dbTreeWidget->currentIndex().isValid())
         return;
@@ -1004,7 +1006,11 @@ void MainWindow::changeTreeSelection()
     } else if(type == "view" || type == "trigger" || type == "index") {
         ui->editDeleteObjectAction->setEnabled(true);
     }
-    ui->actionExportCsvPopup->setEnabled(type == "table" || type == "view");
+    if(type == "table" || type == "view")
+    {
+        ui->actionEditBrowseTable->setEnabled(true);
+        ui->actionExportCsvPopup->setEnabled(true);
+    }
 }
 
 void MainWindow::openRecentFile()
@@ -2082,3 +2088,15 @@ void MainWindow::editEncryption()
     }
 #endif
 }
+
+void MainWindow::switchToBrowseDataTab()
+{
+    if(!ui->dbTreeWidget->selectionModel()->hasSelection())
+        return;
+
+    QString tableToBrowse = ui->dbTreeWidget->model()->data(ui->dbTreeWidget->currentIndex().sibling(ui->dbTreeWidget->currentIndex().row(), 0)).toString();
+
+    ui->mainTab->setCurrentIndex(1);
+    ui->comboBrowseTable->setCurrentText(tableToBrowse);
+    ui->comboBrowseTable->activated(tableToBrowse);
+}
diff --git a/src/MainWindow.h b/src/MainWindow.h
@@ -174,6 +174,7 @@ private slots:
     void fileAttach();
     void updateFilter(int column, const QString& value);
     void editEncryption();
+    void switchToBrowseDataTab();
 };
 
 #endif
diff --git a/src/MainWindow.ui b/src/MainWindow.ui
@@ -310,8 +310,8 @@
             <rect>
              <x>0</x>
              <y>0</y>
-             <width>294</width>
-             <height>444</height>
+             <width>575</width>
+             <height>458</height>
             </rect>
            </property>
            <layout class="QFormLayout" name="formLayout">
@@ -1598,6 +1598,15 @@
     <string>Save SQL file</string>
    </property>
   </action>
+  <action name="actionEditBrowseTable">
+   <property name="icon">
+    <iconset resource="icons/icons.qrc">
+     <normaloff>:/icons/table</normaloff>:/icons/table</iconset>
+   </property>
+   <property name="text">
+    <string>&amp;Browse Table</string>
+   </property>
+  </action>
  </widget>
  <customwidgets>
   <customwidget>
@@ -2469,6 +2478,22 @@
     </hint>
    </hints>
   </connection>
+  <connection>
+   <sender>actionEditBrowseTable</sender>
+   <signal>triggered()</signal>
+   <receiver>MainWindow</receiver>
+   <slot>switchToBrowseDataTab()</slot>
+   <hints>
+    <hint type="sourcelabel">
+     <x>-1</x>
+     <y>-1</y>
+    </hint>
+    <hint type="destinationlabel">
+     <x>499</x>
+     <y>314</y>
+    </hint>
+   </hints>
+  </connection>
  </connections>
  <slots>
   <slot>fileOpen()</slot>
@@ -2522,5 +2547,6 @@
   <slot>fileAttach()</slot>
   <slot>editEncryption()</slot>
   <slot>saveSqlFileAs()</slot>
+  <slot>switchToBrowseDataTab()</slot>
  </slots>
 </ui>