Exemplos de DBUtils.executeUpdateQuery em Python

Exemplo n.º 1

Arquivo: Core.py Projeto: hiddenshadow/pythonProject

	def setRemWelCalToAgent(self,agentId, rem, allocatingStatus, welCalStatusToPick,host,user,password,database,port):
		qry = 'UPDATE welcome_calls SET agent_id='+str(agentId)+',status='+str(allocatingStatus)+' WHERE '
		qry = qry + self.getMultipleStatusQryStr(welCalStatusToPick)
		qry = qry + ' limit '+str(rem)
		logging.debug(qry)
		updatedCount = DBUtils.executeUpdateQuery(qry, host, user, password, database, port)
		return updatedCount

Exemplo n.º 2

Arquivo: test.py Projeto: hiddenshadow/pythonProject

def testSetup():
    updateQuery = 'UPDATE welcome_calls SET status=4,agent_id=100 where id=2'
    DBUtils.executeUpdateQuery(updateQuery)