Python getName Examples

Example #1

File: UMSservices.py Project: rkumar181298/UMS-multiclient-chatting-server

	def updateprofile(user):		
		db=DBconnection.connect()
		cursor=db.cursor()
		query='update usermaster set name=%s,email=%s,contact=%s,address=%s,gender=%s where userid=%s'
		values=[]
		values.append(user.getName())
		values.append(user.getEmail())
		values.append(user.getContact())
		values.append(user.getAddress())
		values.append(user.getGender())
		values.append(user.getUserid())
		cursor.execute(query,values)
		if(cursor.rowcount==1):
			db.commit()
			cursor.close()
			return True
		else:
			db.commit()
			cursor.close()
			return False

Example #2

File: UMSservices.py Project: rkumar181298/UMS-multiclient-chatting-server

	def add(user):
		try:
			db=DBconnection.connect()
			cursor=db.cursor()
			query='insert into usermaster(username,password,usertype,userstatus,name,email,contact,address,gender) values(%s,%s,%s,%s,%s,%s,%s,%s,%s)'
			values=[]
			values.append(user.getUsername())
			values.append(user.getPassword())
			values.append(user.getUsertype())
			values.append(user.getUserstatus())
			values.append(user.getName())
			values.append(user.getEmail())
			values.append(user.getContact())
			values.append(user.getAddress())
			values.append(user.getGender())
			cursor.execute(query,values)
			if(cursor.rowcount==1):
				db.commit()
				cursor.close()
				return True
		except:
			cursor.close()
			db.commit()
			return False