개발노트: Pyqt5 sqlite manager 샘플코드 편집

== PYQT5를 이용한 SQLITE DB 관리 샘플 == === main.py === <source lang=python> #!/usr/bin/python3 # This software is distributed under the GNU Lesser General Public License (https://www.gnu.org/licenses/lgpl-3.0.en.html) # WARNING: This is not a software to be used in production. I write this software for teaching purposes. # TO DO: There lots of things to be done. This is experimental software and will never finish. But I will do the followings first: # 1) Save SQL Query as view - done 2017/04/11 # 2) Modify Table is not implemented. Will implement whenever I find time # 3) Editing SQLite parameters # 4) Creating Index # 5) SQL syntax highlight # 6) Currently all changes done on database. Write Changes, Revert Changes # 7) …. # 8) Those features queried by users import sys import os from PyQt5 import QtWidgets, QtCore, QtGui, Qt, QtSql, uic TYPE_DICT={1:"BOOLEAN", 2:"INTEGER",6:"NUMERIC", 10:"TEXT", 12:"BLOB"} from functools import partial app = QtWidgets.QApplication(sys.argv) __appname__='PyQt SqLite Database Browser' class ModifyTableDialog(QtWidgets.QDialog, uic.loadUiType('modify_table_dialog.ui')[0]): def __init__(self, parent=None, *args): super(ModifyTableDialog, self).__init__(*args) self.parent=parent self.setupUi(self) self.model=self.tableWidget.model() self.buttonBox.buttons()[0].setEnabled(False) self.commandLinkButton_2.setEnabled(False) self.rc_count=0 self.ai_button_group=QtWidgets.QButtonGroup() def update_code_text(self): data = [] pk_fields=[] pk_auto=False for row in range(self.model.rowCount()): auto_incr= '' field_name = self.tableWidget.item(row,0).text() field_type='' field_not='' if self.tableWidget.cellWidget(row,1): field_type = self.tableWidget.cellWidget(row,1).currentText() if self.tableWidget.cellWidget(row,4): field_not_item = self.tableWidget.cellWidget(row,2) if self.tableWidget.cellWidget(row,2).isChecked(): field_not = ' NOT NULL' if self.tableWidget.cellWidget(row,3).isChecked(): pk_fields.append(field_name) if self.tableWidget.cellWidget(row,4).isChecked(): auto_incr = ' PRIMARY KEY AUTOINCREMENT' pk_auto=True data.append((field_name,field_type, field_not, auto_incr)) if pk_auto : pk_fields=[] sql_lines=[] for r in data: sql_lines.append( ' `%s` `%s` %s %s' % (r[0], r[1], r[2], r[3])) if pk_fields: sql_lines.append(' PRIMARY KEY('+','.join(pk_fields)+')') self.query='CREATE TABLE `%s` (\n' % self.lineEdit.text() self.query +=',\n'.join(sql_lines) self.query +='\n)' self.textEdit.setText(self.query) if self.lineEdit.text() and sql_lines: self.buttonBox.buttons()[0].setEnabled(True) else: self.buttonBox.buttons()[0].setEnabled(False) @QtCore.pyqtSlot(str) def on_lineEdit_textChanged(self): self.update_code_text() @QtCore.pyqtSlot('QTableWidgetItem*') def on_tableWidget_itemClicked(self, item): pass @QtCore.pyqtSlot(int, int) def on_tableWidget_cellClicked(self, r, c): pass @QtCore.pyqtSlot() def on_tableWidget_itemSelectionChanged(self): self.commandLinkButton_2.setEnabled(True) @QtCore.pyqtSlot('QTableWidgetItem*') def on_tableWidget_itemChanged(self, item): self.update_code_text() @QtCore.pyqtSlot() def on_commandLinkButton_2_clicked(self): sm=self.tableWidget.selectionModel() r=sm.selectedRows()[0].row() self.tableWidget.removeRow(r) self.tableWidget.update() self.update_code_text() @QtCore.pyqtSlot() def on_commandLinkButton_clicked(self): rc=self.tableWidget.rowCount() self.tableWidget.insertRow(rc) self.tableWidget.setItem(rc, 0, QtWidgets.QTableWidgetItem("Field%d" % self.rc_count)) self.rc_count+=1 type_combo = QtWidgets.QComboBox() for t in TYPE_DICT.values(): type_combo.addItem(t) self.tableWidget.setCellWidget(rc, 1, type_combo) type_combo.currentIndexChanged.connect(self.update_code_text) if rc==0: type_combo.setCurrentIndex(1) else: type_combo.setCurrentIndex(3) not_check_box=QtWidgets.QCheckBox() self.tableWidget.setCellWidget(rc, 2, not_check_box) not_check_box.clicked.connect(self.update_code_text) pk_check_box=QtWidgets.QCheckBox() self.tableWidget.setCellWidget(rc, 3, pk_check_box) pk_check_box.clicked.connect(self.clear_primary_key) ai_check_box=QtWidgets.QCheckBox() self.tableWidget.setCellWidget(rc, 4, ai_check_box) self.ai_button_group.addButton(ai_check_box) ai_check_box.clicked.connect(self.make_primary_key) def make_primary_key(self): for row in range(self.model.rowCount()): ai=self.tableWidget.cellWidget(row,4) if ai: pk=self.tableWidget.cellWidget(row,3) if ai.isChecked(): pk.setChecked(True) type_combo=self.tableWidget.cellWidget(row,1) type_combo.setCurrentIndex(1) else: pk.setChecked(False) self.update_code_text() def clear_primary_key(self): self.ai_button_group.setExclusive(False) for row in range(self.model.rowCount()): ai=self.tableWidget.cellWidget(row,4) ai.setChecked(False) self.ai_button_group.setExclusive(True) self.update_code_text() @QtCore.pyqtSlot() def on_buttonBox_accepted(self): if not self.parent.execute_query(self.query): self.parent.update_tables_table() self.close() @QtCore.pyqtSlot() def on_buttonBox_rejected(self): self.close() class MainWindow(QtWidgets.QMainWindow, uic.loadUiType('mainwindow.ui')[0]): selectedTable=None work_directory=os.path.dirname(os.path.realpath(__file__)) current_database_file='' current_database=None def __init__(self, *args): super(MainWindow, self).__init__(*args) QtCore.QCoreApplication.setOrganizationName("mbaser") QtCore.QCoreApplication.setOrganizationDomain("foo.org") QtCore.QCoreApplication.setApplicationVersion("0.0.1") self.current_database = QtSql.QSqlDatabase.addDatabase('QSQLITE') self.setupUi(self) self.tree_model=QtGui.QStandardItemModel() self.treeView.setModel(self.tree_model) self.settings=QtCore.QSettings() self.recent_files=self.settings.value('recent_files',[]) self.update_recent_files() def setTitle(self, title=None): t_str="PyQt SqLite" if title: t_str += ' [%s]' % title self.setWindowTitle(t_str) @QtCore.pyqtSlot() def on_actionAbout_triggered(self): QtWidgets.QMessageBox.about(self, "About this software","This software is written for teaching purposes. Don't use in production!!! My purpose is to demonstrate how PyQt widgets can be used to develop software.\n\n Main developer: Mustafa Baser <mbaser@mail.com>") @QtCore.pyqtSlot() def on_commandLinkButton_clicked(self): dialog=ModifyTableDialog(self) dialog.exec_() @QtCore.pyqtSlot() def on_commandLinkButton_3_clicked(self): if self.selectedTable: result=QtWidgets.QMessageBox.question(self, "Warning", "You are just deleting %s %s. You will lost all the data in %s. Dou you want to delete?" % ( self.selectedTable[1], self.selectedTable[0], self.selectedTable[0] )) if result==QtWidgets.QMessageBox.Yes: self.current_database.exec("DROP %s `%s`" % (self.selectedTable[0], self.selectedTable[1])) if not self.error_check(self.current_database): self.update_tables_table() @QtCore.pyqtSlot('QModelIndex', int) def on_treeView_expanded(self, ind): pass @QtCore.pyqtSlot('QModelIndex') def on_treeView_clicked(self, ind): item=self.tree_model.itemFromIndex(ind.sibling(0,0)) if hasattr(item,"tableType"): self.selectedTable=(item.tableType,ind.sibling(ind.row(),0).data()) self.commandLinkButton_2.setEnabled(True) self.commandLinkButton_3.setEnabled(True) else: self.commandLinkButton_2.setEnabled(False) self.commandLinkButton_3.setEnabled(False) def update_tables_table(self): self.tree_model.clear() self.tree_model.setHorizontalHeaderLabels(['Name', 'Type','Schema']) for typ in ('table','view'): q=self.current_database.exec("SELECT name FROM sqlite_master WHERE type = '%s'" % typ) self.error_check(self.current_database) tables=[] while q.next(): tables.append(q.value(0)) tab_par = QtGui.QStandardItem('%ss (%d)' % (typ.title(),len(tables))) for tb in tables: if typ=='table': c_icon="sc_inserttable.png" else: c_icon="sc_dbviewtablenames.png" self.comboBox.addItem(QtGui.QIcon("icons/"+c_icon), tb) tb_name=QtGui.QStandardItem(tb) tb_name.tableType=typ tb_type=QtGui.QStandardItem(typ.title()) q=self.current_database.exec("SELECT sql FROM sqlite_master WHERE tbl_name = '%s' AND type = '%s'" % (tb,typ)) tb_schema_str='' if q.next(): tb_schema_str=q.value(0) tb_schema_str=tb_schema_str.replace("\n", " ") tb_schema_str=tb_schema_str.replace("\t", " ") tb_schema=QtGui.QStandardItem(tb_schema_str) driver=self.current_database.driver() rec=driver.record(tb) for i in range(rec.count()): col_name=QtGui.QStandardItem(rec.field(i).name()) type_id=rec.field(i).type() if type_id in TYPE_DICT: type_str=TYPE_DICT[type_id] else: type_str=str(type_id) col_type=QtGui.QStandardItem(type_str) tb_name.appendRow([col_name, col_type]) tab_par.appendRow([tb_name, tb_type, tb_schema]) self.tree_model.appendRow(tab_par) def error_check(self, model): error = model.lastError() if error.isValid(): self.show_warning(error.text()) return True @QtCore.pyqtSlot() def on_queryExecButton_pressed(self): self.queryTableView.setModel(QtSql.QSqlQueryModel()) query = self.queryTextEdit.toPlainText() model = self.queryTableView.model() model.setQuery(query) self.error_check(model) @QtCore.pyqtSlot(str) def on_comboBox_currentIndexChanged(self,tbl_name): if tbl_name: model = QtSql.QSqlTableModel() model.setTable('"'+tbl_name+'"') model.setEditStrategy(QtSql.QSqlTableModel.OnFieldChange) model.select() self.error_check(model) self.tableView.setModel(model) def show_warning(self, text): QtWidgets.QMessageBox.warning(self, "Info", "Could not execute query. Error message from database engine is:\n"+ text) @QtCore.pyqtSlot() def on_newRecordButton_pressed(self): model = self.tableView.model() model.submitAll() result=model.insertRows(model.rowCount(), 1) if not result: self.error_check(model) @QtCore.pyqtSlot() def on_reloadTableButton_pressed(self): self.tableView.model().select() @QtCore.pyqtSlot() def on_deleteRecordButton_pressed(self): model = self.tableView.model() model.removeRow(self.tableView.currentIndex().row()) model.select() @QtCore.pyqtSlot() def on_actionClose_triggered(self): self.closeDatabase() @QtCore.pyqtSlot() def on_actionExit_triggered(self): self.close() @QtCore.pyqtSlot() def on_actionNew_triggered(self): save_file_dialog=QtWidgets.QFileDialog.getSaveFileName(self, "Name of new database", self.work_directory) if save_file_dialog[0]: self.loadDatabase(save_file_dialog[0]) @QtCore.pyqtSlot() def on_actionOpen_triggered(self): self.fileDialog = QtWidgets.QFileDialog(self) self.fileDialog.setDirectory(self.work_directory) result=self.fileDialog.getOpenFileName() if result[0]: self.loadDatabase(result[0]) @QtCore.pyqtSlot() def on_saveQueryAsView_pressed(self): model = self.queryTableView.model() if model: if model.rowCount(): view_name, result = QtWidgets.QInputDialog.getText(self, __appname__, 'Enter vieww name:') if result: query = self.queryTextEdit.toPlainText() query = 'CREATE VIEW {0} AS\n{1}'.format(view_name, query) if not self.execute_query(query): self.update_tables_table() def closeDatabase(self): if self.current_database: if self.current_database.isOpen(): self.tree_model.clear() self.comboBox.clear() tbm=self.tableView.model() tbm.clear() self.current_database.close() self.setTitle() self.commandLinkButton.setEnabled(False) self.actionClose.setEnabled(False) print('Clearing "Execute SQL Widgets"') #clear "Execute SQL Widgets" self.queryTextEdit.clear() tableModel=self.queryTableView.model() if tableModel: tableModel.clear() self.queryTableView.setModel(None) self.queryResultText.clear() def loadDatabase(self, db_file, *args): self.closeDatabase() self.tree_model.removeRows(0, self.tree_model.rowCount()) self.work_directory=os.path.dirname(db_file) self.current_database_file=os.path.basename(db_file) self.current_database.setDatabaseName(db_file) if self.current_database.open(): self.commandLinkButton.setEnabled(True) self.actionClose.setEnabled(True) self.setTitle(db_file) self.update_tables_table() if db_file in self.recent_files: self.recent_files.remove(db_file) self.recent_files.insert(0,db_file) self.update_recent_files() def update_recent_files(self): self.menuOpen_Recent.clear() for i, rc in enumerate(self.recent_files): recent_file_action=QtWidgets.QAction('&%d %s' % (i+1, rc), self, triggered=partial(self.loadDatabase, rc)) self.menuOpen_Recent.addAction(recent_file_action) def execute_query(self, query): self.current_database.exec(query) return self.error_check(self.current_database) def closeEvent(self, event): self.settings.setValue('recent_files', self.recent_files) self.closeDatabase() main = MainWindow() main.show() sys.exit(app.exec_()) </source> === modify_table_dialog.ui === <source lang=xml> <?xml version="1.0" encoding="UTF-8"?> <ui version="4.0"> <class>Dialog</class> <widget class="QDialog" name="Dialog"> <property name="geometry"> <rect> <x>0</x> <y>0</y> <width>625</width> <height>505</height> </rect> </property> <property name="windowTitle"> <string>Modify Table</string> </property> <layout class="QGridLayout" name="gridLayout_2"> <item row="3" column="0"> <widget class="QDialogButtonBox" name="buttonBox"> <property name="standardButtons"> <set>QDialogButtonBox::Cancel|QDialogButtonBox::Ok</set> </property> </widget> </item> <item row="0" column="0"> <layout class="QGridLayout" name="gridLayout"> <item row="0" column="0"> <widget class="QGroupBox" name="groupBox"> <property name="maximumSize"> <size> <width>16777215</width> <height>70</height> </size> </property> <property name="title"> <string>Table</string> </property> <layout class="QVBoxLayout" name="verticalLayout_2"> <item> <layout class="QGridLayout" name="gridLayout_3"> <item row="0" column="0"> <widget class="QLineEdit" name="lineEdit"/> </item> </layout> </item> </layout> </widget> </item> <item row="1" column="0"> <widget class="QGroupBox" name="groupBox_2"> <property name="title"> <string>Fields</string> </property> <layout class="QGridLayout" name="gridLayout_5"> <item row="1" column="0"> <widget class="QTableWidget" name="tableWidget"> <property name="selectionMode"> <enum>QAbstractItemView::SingleSelection</enum> </property> <property name="selectionBehavior"> <enum>QAbstractItemView::SelectRows</enum> </property> <attribute name="horizontalHeaderStretchLastSection"> <bool>true</bool> </attribute> <attribute name="verticalHeaderVisible"> <bool>false</bool> </attribute> <attribute name="verticalHeaderStretchLastSection"> <bool>false</bool> </attribute> <column> <property name="text"> <string>Name</string> </property> </column> <column> <property name="text"> <string>Type</string> </property> </column> <column> <property name="text"> <string>Not</string> </property> </column> <column> <property name="text"> <string>PK</string> </property> </column> <column> <property name="text"> <string>AI</string> </property> </column> <column> <property name="text"> <string>Check</string> </property> </column> </widget> </item> <item row="0" column="0"> <layout class="QGridLayout" name="gridLayout_4"> <item row="0" column="0"> <widget class="QCommandLinkButton" name="commandLinkButton"> <property name="text"> <string>Add field</string> </property> </widget> </item> <item row="0" column="1"> <widget class="QCommandLinkButton" name="commandLinkButton_2"> <property name="text"> <string>Remove field</string> </property> </widget> </item> <item row="0" column="2"> <spacer name="horizontalSpacer"> <property name="orientation"> <enum>Qt::Horizontal</enum> </property> <property name="sizeHint" stdset="0"> <size> <width>40</width> <height>20</height> </size> </property> </spacer> </item> </layout> </item> <item row="2" column="0"> <widget class="QTextEdit" name="textEdit"> <property name="readOnly"> <bool>true</bool> </property> </widget> </item> </layout> </widget> </item> </layout> </item> </layout> </widget> <resources/> <connections/> </ui> </source> === mainwindow.ui === <source lang=xml> <?xml version="1.0" encoding="UTF-8"?> <ui version="4.0"> <class>MainWindow</class> <widget class="QMainWindow" name="MainWindow"> <property name="geometry"> <rect> <x>0</x> <y>0</y> <width>691</width> <height>499</height> </rect> </property> <property name="windowTitle"> <string>PyQt SqLite</string> </property> <property name="windowIcon"> <iconset> <normaloff>icons/db.png</normaloff>icons/db.png</iconset> </property> <widget class="QWidget" name="centralWidget"> <layout class="QGridLayout" name="gridLayout_2"> <item row="0" column="1"> <widget class="QTabWidget" name="gridTabWidget"> <property name="currentIndex"> <number>0</number> </property> <widget class="QWidget" name="gridTabWidgetPage1"> <attribute name="title"> <string>Tables</string> </attribute> <layout class="QGridLayout" name="gridLayout_3"> <item row="0" column="3"> <spacer name="horizontalSpacer"> <property name="orientation"> <enum>Qt::Horizontal</enum> </property> <property name="sizeHint" stdset="0"> <size> <width>40</width> <height>20</height> </size> </property> </spacer> </item> <item row="0" column="1"> <widget class="QCommandLinkButton" name="commandLinkButton_2"> <property name="enabled"> <bool>false</bool> </property> <property name="text"> <string>Modify Table</string> </property> <property name="icon"> <iconset> <normaloff>icons/lc_dbtableedit.png</normaloff>icons/lc_dbtableedit.png</iconset> </property> </widget> </item> <item row="0" column="2"> <widget class="QCommandLinkButton" name="commandLinkButton_3"> <property name="enabled"> <bool>false</bool> </property> <property name="text"> <string>Delete Table</string> </property> <property name="icon"> <iconset> <normaloff>icons/lc_dbtabledelete.png</normaloff>icons/lc_dbtabledelete.png</iconset> </property> </widget> </item> <item row="0" column="0"> <widget class="QCommandLinkButton" name="commandLinkButton"> <property name="enabled"> <bool>false</bool> </property> <property name="text"> <string>Create Table</string> </property> <property name="icon"> <iconset> <normaloff>icons/lc_dbnewtable.png</normaloff>icons/lc_dbnewtable.png</iconset> </property> </widget> </item> <item row="2" column="0" colspan="4"> <widget class="QTreeView" name="treeView"/> </item> </layout> </widget> <widget class="QWidget" name="tab"> <attribute name="title"> <string>Browse</string> </attribute> <layout class="QGridLayout" name="gridLayout_4"> <item row="0" column="0"> <layout class="QGridLayout" name="gridLayout"> <item row="0" column="0"> <widget class="QLabel" name="label"> <property name="text"> <string>Table:</string> </property> </widget> </item> <item row="0" column="1"> <widget class="QComboBox" name="comboBox"> <property name="sizePolicy"> <sizepolicy hsizetype="Expanding" vsizetype="Fixed"> <horstretch>0</horstretch> <verstretch>0</verstretch> </sizepolicy> </property> <property name="minimumSize"> <size> <width>150</width> <height>0</height> </size> </property> </widget> </item> </layout> </item> <item row="0" column="3"> <widget class="QPushButton" name="newRecordButton"> <property name="text"> <string>New Record</string> </property> <property name="icon"> <iconset> <normaloff>icons/sc_newrecord.png</normaloff>icons/sc_newrecord.png</iconset> </property> </widget> </item> <item row="0" column="4"> <widget class="QPushButton" name="deleteRecordButton"> <property name="text"> <string>Delete Record</string> </property> <property name="icon"> <iconset> <normaloff>icons/sc_deleterecord.png</normaloff>icons/sc_deleterecord.png</iconset> </property> </widget> </item> <item row="0" column="2"> <spacer name="horizontalSpacer_2"> <property name="orientation"> <enum>Qt::Horizontal</enum> </property> <property name="sizeHint" stdset="0"> <size> <width>40</width> <height>20</height> </size> </property> </spacer> </item> <item row="0" column="1"> <widget class="QPushButton" name="reloadTableButton"> <property name="text"> <string/> </property> <property name="icon"> <iconset> <normaloff>icons/sc_refresh.png</normaloff>icons/sc_refresh.png</iconset> </property> </widget> </item> <item row="1" column="0" colspan="5"> <widget class="QTableView" name="tableView"/> </item> </layout> </widget> <widget class="QWidget" name="tab_2"> <attribute name="title"> <string>Execute SQL</string> </attribute> <layout class="QGridLayout" name="gridLayout_6"> <item row="0" column="0" colspan="3"> <layout class="QGridLayout" name="gridLayout_5"> <item row="0" column="0"> <widget class="QPushButton" name="queryExecButton"> <property name="text"> <string/> </property> <property name="icon"> <iconset> <normaloff>icons/lc_sbaexecutesql.png</normaloff>icons/lc_sbaexecutesql.png</iconset> </property> </widget> </item> <item row="0" column="1"> <spacer name="horizontalSpacer_3"> <property name="orientation"> <enum>Qt::Horizontal</enum> </property> <property name="sizeHint" stdset="0"> <size> <width>40</width> <height>20</height> </size> </property> </spacer> </item> <item row="1" column="0" colspan="2"> <widget class="QTextEdit" name="queryTextEdit"/> </item> </layout> </item> <item row="3" column="0"> <widget class="QTextEdit" name="queryResultText"> <property name="readOnly"> <bool>true</bool> </property> </widget> </item> <item row="2" column="0" colspan="3"> <widget class="QTableView" name="queryTableView"/> </item> <item row="3" column="1"> <widget class="QPushButton" name="saveQueryAsView"> <property name="text"> <string/> </property> <property name="icon"> <iconset> <normaloff>icons/lc_dbnewviewsql.png</normaloff>icons/lc_dbnewviewsql.png</iconset> </property> </widget> </item> <item row="1" column="0"> <spacer name="verticalSpacer"> <property name="orientation"> <enum>Qt::Vertical</enum> </property> <property name="sizeHint" stdset="0"> <size> <width>20</width> <height>40</height> </size> </property> </spacer> </item> </layout> </widget> </widget> </item> </layout> </widget> <widget class="QMenuBar" name="menuBar"> <property name="geometry"> <rect> <x>0</x> <y>0</y> <width>691</width> <height>19</height> </rect> </property> <widget class="QMenu" name="menuFile"> <property name="title"> <string>&amp;File</string> </property> <widget class="QMenu" name="menuOpen_Recent"> <property name="title"> <string>Open &amp;Recent</string> </property> </widget> <addaction name="separator"/> <addaction name="separator"/> <addaction name="actionNew"/> <addaction name="actionOpen"/> <addaction name="menuOpen_Recent"/> <addaction name="actionClose"/> <addaction name="separator"/> <addaction name="actionExit"/> </widget> <widget class="QMenu" name="menuEdit"> <property name="title"> <string>&amp;Edit</string> </property> <addaction name="actionCreate_Tables"/> <addaction name="actionEdit_Table"/> <addaction name="actionModify_Table"/> </widget> <widget class="QMenu" name="menuHelp"> <property name="title"> <string>&amp;Help</string> </property> <addaction name="actionAbout"/> </widget> <addaction name="menuFile"/> <addaction name="menuEdit"/> <addaction name="menuHelp"/> </widget> <widget class="QToolBar" name="mainToolBar"> <attribute name="toolBarArea"> <enum>TopToolBarArea</enum> </attribute> <attribute name="toolBarBreak"> <bool>false</bool> </attribute> <addaction name="separator"/> <addaction name="actionOpen"/> <addaction name="actionNew"/> <addaction name="actionClose"/> </widget> <widget class="QStatusBar" name="statusBar"/> <action name="actionNew"> <property name="icon"> <iconset> <normalon>icons/lc_newdoc.png</normalon> </iconset> </property> <property name="text"> <string>&amp;New</string> </property> <property name="shortcut"> <string>Ctrl+N</string> </property> </action> <action name="actionOpen"> <property name="icon"> <iconset> <normaloff>icons/lc_open.png</normaloff>icons/lc_open.png</iconset> </property> <property name="text"> <string>&amp;Open</string> </property> <property name="shortcut"> <string>Ctrl+O</string> </property> </action> <action name="actionExit"> <property name="icon"> <iconset> <normaloff>icons/lc_quit.png</normaloff>icons/lc_quit.png</iconset> </property> <property name="text"> <string>&amp;Quit</string> </property> <property name="shortcut"> <string>Ctrl+Q</string> </property> </action> <action name="actionCreate_Tables"> <property name="text"> <string>&amp;Create Table</string> </property> <property name="shortcut"> <string>Ctrl+T</string> </property> </action> <action name="actionEdit_Table"> <property name="text"> <string>E&amp;dit Table</string> </property> <property name="shortcut"> <string>Ctrl+E</string> </property> </action> <action name="actionModify_Table"> <property name="text"> <string>&amp;Modify Table</string> </property> <property name="shortcut"> <string>Ctrl+M</string> </property> </action> <action name="actionSave"> <property name="icon"> <iconset> <normalon>icons/sc_save.png</normalon> </iconset> </property> <property name="text"> <string>Close</string> </property> <property name="shortcut"> <string>Ctrl+S</string> </property> </action> <action name="actionClose"> <property name="enabled"> <bool>false</bool> </property> <property name="icon"> <iconset> <normaloff>icons/lc_closedoc.png</normaloff>icons/lc_closedoc.png</iconset> </property> <property name="text"> <string>Close</string> </property> <property name="shortcut"> <string>Ctrl+C</string> </property> </action> <action name="actionAbout"> <property name="text"> <string>&amp;About</string> </property> </action> </widget> <layoutdefault spacing="6" margin="11"/> <resources/> <connections/> </ui> </source> [[category:python]]