def get_db(connection_name, table_name=None):
""" Get a DBCon object and abort if connection or table does not exist """
if connection_name not in g._dbconfigs:
abort(404, "Database not found")
db = DBCon(g._dbconfigs[connection_name])
# non-viewable tables reported as not-found
if table_name is not None:
if not db.table_is_viewable(table_name):
abort(404, "Table not found")
return db
def delspecific(self):
ch = DBCon.delfromdb(3, self)
if ch == 1:
msg_box = QMessageBox()
msg_box.setIcon(QMessageBox.Information)
msg_box.setText("Successfully deleted record")
msg_box.setWindowIcon(QIcon('crm.png'))
msg_box.setWindowTitle("Deleted Records")
msg_box.setStandardButtons(QMessageBox.Ok | QMessageBox.Cancel)
retval = msg_box.exec_()
self.lineEdit_5.setText("")
elif ch == 2:
msg_box = QMessageBox()
msg_box.setIcon(QMessageBox.Information)
msg_box.setText("No user exists with given E-mail Address")
msg_box.setWindowIcon(QIcon('crm.png'))
msg_box.setWindowTitle("No User Found")
msg_box.setStandardButtons(QMessageBox.Ok | QMessageBox.Cancel)
retval = msg_box.exec_()
self.lineEdit_5.setText("")
else:
msg_box = QMessageBox()
msg_box.setIcon(QMessageBox.Warning)
msg_box.setText("Problem With Database....")
msg_box.setWindowIcon(QIcon('crm.png'))
msg_box.setWindowTitle("Restart Database")
msg_box.setStandardButtons(QMessageBox.Ok | QMessageBox.Cancel)
retval = msg_box.exec_()
def addtodb(self):
print("in addtoDB")
if self.lineEdit_2.text() == "":
msg_box = QMessageBox()
msg_box.setIcon(QMessageBox.Warning)
msg_box.setText("Enter Customer Name")
msg_box.setWindowIcon(QIcon('crm.png'))
msg_box.setWindowTitle("Name not Specified")
msg_box.setStandardButtons(QMessageBox.Ok | QMessageBox.Cancel)
retval = msg_box.exec_()
return
elif not Validator.checkemail(self.lineEdit_3.text()):
msg_box = QMessageBox()
msg_box.setIcon(QMessageBox.Warning)
msg_box.setText("Enter Valid Email Address")
msg_box.setWindowIcon(QIcon('crm.png'))
msg_box.setWindowTitle("Incorrect Email-id")
msg_box.setStandardButtons(QMessageBox.Ok | QMessageBox.Cancel)
retval = msg_box.exec_()
return
elif not Validator.checkmob(self.lineEdit_4.text()):
msg_box = QMessageBox()
msg_box.setIcon(QMessageBox.Warning)
msg_box.setText("Enter Valid Mobile Number")
msg_box.setWindowIcon(QIcon('crm.png'))
msg_box.setWindowTitle("Incorrect Mobile No.")
msg_box.setStandardButtons(QMessageBox.Ok | QMessageBox.Cancel)
retval = msg_box.exec_()
return
else:
print("calling init")
ch = DBCon.dbinitop(self)
if ch == 1:
msg_box = QMessageBox()
msg_box.setIcon(QMessageBox.Information)
msg_box.setText("Customer added to System successfully")
msg_box.setWindowIcon(QIcon('crm.png'))
msg_box.setWindowTitle("Added Customer")
msg_box.setStandardButtons(QMessageBox.Ok | QMessageBox.Cancel)
retval = msg_box.exec_()
self.lineEdit_2.setText("")
self.lineEdit_3.setText("")
self.lineEdit_4.setText("")
else:
msg_box = QMessageBox()
msg_box.setIcon(QMessageBox.Warning)
msg_box.setText("Problem With Database....")
msg_box.setWindowIcon(QIcon('crm.png'))
msg_box.setWindowTitle("Restart Database")
msg_box.setStandardButtons(QMessageBox.Ok | QMessageBox.Cancel)
retval = msg_box.exec_()
def showall(self):
str = DBCon.selectfromdb(1, self)
if str == "failed":
msg_box = QMessageBox()
msg_box.setIcon(QMessageBox.Warning)
msg_box.setText("Problem With Database....")
msg_box.setWindowIcon(QIcon('crm.png'))
msg_box.setWindowTitle("Restart Database")
msg_box.setStandardButtons(QMessageBox.Ok | QMessageBox.Cancel)
retval = msg_box.exec_()
else:
msg_box = QMessageBox()
msg_box.setIcon(QMessageBox.Warning)
msg_box.setText(str)
msg_box.setWindowIcon(QIcon('crm.png'))
msg_box.setWindowTitle("Customer Details")
msg_box.setStandardButtons(QMessageBox.Ok | QMessageBox.Cancel)
retval = msg_box.exec_()
def delall(self):
ch = DBCon.delfromdb(4, self)
if ch == 1:
msg_box = QMessageBox()
msg_box.setIcon(QMessageBox.Information)
msg_box.setText("Successfully deleted all records from System")
msg_box.setWindowIcon(QIcon('crm.png'))
msg_box.setWindowTitle("Deleted Records")
msg_box.setStandardButtons(QMessageBox.Ok | QMessageBox.Cancel)
retval = msg_box.exec_()
else:
msg_box = QMessageBox()
msg_box.setIcon(QMessageBox.Warning)
msg_box.setText("Problem With Database....")
msg_box.setWindowIcon(QIcon('crm.png'))
msg_box.setWindowTitle("Restart Database")
msg_box.setStandardButtons(QMessageBox.Ok | QMessageBox.Cancel)
retval = msg_box.exec_()
def sendmailall(self):
print("mailing")
ch = DBCon.dbpickup(1, self)
if ch == 1:
msg_box = QMessageBox()
msg_box.setIcon(QMessageBox.Information)
msg_box.setText("Advertisement E-mails sent successfully")
msg_box.setWindowIcon(QIcon('crm.png'))
msg_box.setWindowTitle("Advertisement Sent")
msg_box.setStandardButtons(QMessageBox.Ok | QMessageBox.Cancel)
retval = msg_box.exec_()
else:
msg_box = QMessageBox()
msg_box.setIcon(QMessageBox.Warning)
msg_box.setText("Problem With Database....")
msg_box.setWindowIcon(QIcon('crm.png'))
msg_box.setWindowTitle("Restart Database")
msg_box.setStandardButtons(QMessageBox.Ok | QMessageBox.Cancel)
retval = msg_box.exec_()
def delall(self, btn):
DBCon.delfromdb(4)
def delprevmonth(self, btn):
DBCon.delfromdb(2)
def delprevyear(self, btn):
DBCon.delfromdb(1)
def sendmail(self):
if self.all_chbox.isChecked():
print("mailing")
DBCon.dbpickup()
self.all_chbox.setChecked(False)