Exemplo n.º 1
0
 def accept(self):
     if str(self.txtCol.text()).lower() == RESERVED_ID or str(self.txtCol.text()).lower() in self.defaults:
         self.ErrorInfoMessage(
             QApplication.translate(
                 "AttributeEditor", "(%s) " "is a reserved word and cannot be used for column name"
             )
             % (self.txtCol.text())
         )
         return
     if self.tableName == None:
         self.ErrorInfoMessage(QApplication.translate("AttributeEditor", "No selected table found"))
         return
     if UserData(self.cboDatatype) not in self.defaults and self.txtAttrib.text() == "":
         self.ErrorInfoMessage(QApplication.translate("AttributeEditor", "Attribute length is not given"))
         return
     if self.txtCol.text() == "":
         self.ErrorInfoMessage(QApplication.translate("AttributeEditor", "Column name is not given"))
         return
     if self.args != None:
         self.updateColumnData()
     if self.args == None:
         if table_column_exist(self.profile, self.tableName, formatColumnName(self.txtCol.text())):
             QMessageBox.critical(
                 self,
                 QApplication.translate("AttributeEditor", "Duplicate Column"),
                 QApplication.translate("AttributeEditor", "The entered column name already exist"),
             )
             return
         else:
             self.writeAttributeData()
     self.clearControls()
     self.close()
Exemplo n.º 2
0
 def autoCreatePrimaryKeyColumn(self,Node):
     """Allow automatic created of primary column in the table"""
     attrib = {
         'name' : 'id',
         'fullname' : 'Primary Key',
         'type' : 'serial',
         'size' : '',
         'key' : '1'
     }
     if table_column_exist(self.profile, self.table, 'id'):
         return
         QMessageBox.information(self, "ID exist", "Id exisit")
     else:
         writeTableColumn(attrib,self.profile,Node,self.table,'columns')