def getDataInVoice():
db=returnDBConnection.returnDB()
cur = db.cursor()
cid=AddCustomer.getCID()
cur.execute("SELECT cid,firstname,lastname FROM customer WHERE cid="+cid)
result=cur.fetchall()
return result
def getIID():
db=returnDBConnection.returnDB()
cur = db.cursor()
query = "SELECT COUNT(*) from invoice"
cur.execute(query) #execute query separately
res = cur.fetchone()
total_rows = res[0] #total rows
return str(total_rows)
def getMeasureId(self):
db=returnDBConnection.returnDB()
cur = db.cursor()
query = "SELECT COUNT(*) from measurement"
cur.execute(query) #execute query separately
res = cur.fetchone()
total_rows = res[0] #total rows
return str(total_rows)
def SaveMeasure(self):
db=returnDBConnection.returnDB()
cur = db.cursor()
cur.execute('''INSERT into measurement (me_iid)
values (%s)''',
(self.me_iid))
print "Successfully added"
# Commit your changes in the database
db.commit()
# disconnect from server
db.close()
def saveInVoice(self):
db=returnDBConnection.returnDB()
cur = db.cursor()
cur.execute('''INSERT into invoice (iv_cid,submitdata,requiredate,quantity,price)
values (%s, %s, %s, %s, %s)''',
(self.iv_cid,self.submitdata, self.requiredate,self.quantity,self.price))
print "Successfully added"
# Commit your changes in the database
db.commit()
# disconnect from server
db.close()
def saveToDB(self):
db=returnDBConnection.returnDB()
cur = db.cursor()
cur.execute('''INSERT into customer (firstname,lastname,age,contactnumber,address)
values (%s, %s, %s, %s, %s)''',
(self.firstname, self.lastname,self.age,self.contactnumber,self.address))
print "Successfully added"
# Commit your changes in the database
db.commit()
# disconnect from server
db.close()
def getFLNames():
db=returnDBConnection.returnDB()
cur = db.cursor()
cur.execute("SELECT firstname,lastname,iid FROM customer,invoice WHERE iv_cid=cid AND iid="+AddInVoice.getIID())
result=cur.fetchall()
return result
def InVoiceList():
db=returnDBConnection.returnDB()
cur = db.cursor()
cur.execute("SELECT iid,firstname,lastname,submitdata,requiredate,quantity,price FROM customer,invoice WHERE iv_cid=cid")
result=cur.fetchall()
return result
def searchCustomers(self):
db=returnDBConnection.returnDB()
cur = db.cursor()
cur.execute("SELECT * FROM customer")
result=cur.fetchall()
return result
