def delete_geom(self): '''delete defined table relation from the config ''' if self.warningInfo(QApplication.translate('WorkspaceLoader',\ u"Are you sure you want to deleted selected geometry column from table (%s)") %self.tableName) == QMessageBox.Yes: selCols=self.tblLookup_2.selectionModel().selectedIndexes() if len(selCols)>0: item=selCols[1].data() element="geometryz" deleteColumn(self.profile,'table',self.tableName,element,'column',str(item)) self.loadTableRelations(self.tableName)
def deleteTableColumn(self): '''ensure we deleted the selected table column only by matching name entry in the config''' #try: if self.warningInfo(QApplication.translate('WorkspaceLoader',\ "You are about to delete selected column from table (%s)" )%self.tableName) == QMessageBox.Yes: selCols=self.tblEdit.selectionModel().selectedIndexes() if len(selCols)>0: item = selCols[0].data() element = "columns" if str(self.tableName).startswith('check'): deleteColumn(self.profile,'lookup',self.tableName,element,'name',str(item)) self.lookupColumnsTowidget(self.tableName) else: deleteColumn(self.profile,'table',self.tableName,element,'name',str(item)) try: deleteColumn(self.profile,'table',self.tableName,'constraints','column',str(item)) except Exception as ex: self.ErrorInfoMessage(str(ex.message)) self.loadTableColumns(self.tableName) else: return