Python getNewQuery Examples

Example #1

File: utilities.py Project: city-pulse/mskpulse.backend

def refresh_mysql_con(mysql_db):
	from PySQLPool import getNewQuery
	query = getNewQuery(mysql_db, commitOnEnd=True)
	query.Query('SET NAMES utf8mb4;')
	query.Query('SET CHARACTER SET utf8mb4;')
	query.Query('SET character_set_connection=utf8mb4;')
	query.Query('SET innodb_lock_wait_timeout = 300;')
	return mysql_db

Example #2

File: utilities.py Project: city-pulse/mskpulse.backend

def exec_mysql(cmd, connection):
	"""
	Unified function for MySQL interaction from multiple sources and threads.

	Args:
		cmd (str): command, to be executed.
		connection (PySQLPool.PySQLConnection): connection to the database object.
	"""
	from PySQLPool import getNewQuery
	from MySQLdb import OperationalError
	from logging import error
	query = getNewQuery(connection, commitOnEnd=True)
	try:
		result = query.Query(cmd)
	except OperationalError as e:
		error(e)
	else:
		return query.record, result