Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def UpdateEvent(self,Eid,Ename="",Edescription="",dates =[]):
- self.EstablishConnection()
- try:
- query = "UPDATE Event SET "
- if Ename != "" and Edescription != "" :
- query += "Ename = "+Ename+", Edescription = "+Edescription
- elif Ename != "" :
- query += "Ename = " + Ename
- else :
- query += "Edescription = "+Edescription
- query += " WHERE Eid = "+Eid
- self.cursor.execute(query)
- if dates!=[]:
- for i in dates:
- query ="UPDATE EventDates SET " + "Edate = " + i + " WHERE Eid = "+Eid
- self.cursor.execute(query)
- self.CloseConnection()
- return True
- except :
- self.CloseConnection()
- return False
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement