def db_query(sql, args=None, as_dict=False, using='default', force=False, debug=False):
"""
Execute raw select queries. Not tested or guaranteed to work with any
other type of query.
@param force boolean Defaults to False. Whether or not to force the named connection to be used.
"""
from ..import DEBUG
if args is None:
args = tuple()
if force is False:
using = getRealShardConnectionName(using)
# Execute the raw query.
cursor = connections()[using].cursor()
if DEBUG is True or debug is True:
logging.info(u'-- [DEBUG] DB_QUERY, using={0} ::\n{1}'.format(using, sql))
cursor.execute(sql, args)
res = _dictfetchall(cursor) if as_dict is True else cursor.fetchall()
cursor.close()
return res
def db_query(sql,
args=None,
as_dict=False,
using='default',
force=False,
debug=False):
"""
Execute raw select queries. Not tested or guaranteed to work with any
other type of query.
@param force boolean Defaults to False. Whether or not to force the named connection to be used.
"""
from .. import DEBUG
if args is None:
args = tuple()
if force is False:
using = getRealShardConnectionName(using)
# Execute the raw query.
cursor = connections()[using].cursor()
if DEBUG is True or debug is True:
logging.info(u'-- [DEBUG] DB_QUERY, using={0} ::\n{1}'.format(
using, sql))
cursor.execute(sql, args)
res = _dictfetchall(cursor) if as_dict is True else cursor.fetchall()
cursor.close()
return res
def handle(self, *args, **options):
self.stdout.write("Waiting for DB...")
db_conn = None
while not db_conn:
try:
db_conn = connections('default')
except OperationalError:
self.stdout.write('Database unavailable, waiting 1 second...')
time.sleep(1)
self.stdout.write(self.style.SUCESS('Database Availabe..!!'))
def db_exec(sql, args=None, using='default', force=False, debug=False):
"""
Execute a raw query on the requested database connection.
@param force boolean Defaults to False. Whether or not to force the named connection to be used.
"""
from ..import DEBUG
if args is None:
args = tuple()
if force is False:
using = getRealShardConnectionName(using)
if DEBUG is True or debug is True:
logging.info(u'-- [DEBUG] DB_EXEC, using={0} ::\n{1}'.format(using, sql))
cursor = connections()[using].cursor()
result = cursor.execute(sql, args)
cursor.close()
return result
def db_exec(sql, args=None, using='default', force=False, debug=False):
"""
Execute a raw query on the requested database connection.
@param force boolean Defaults to False. Whether or not to force the named connection to be used.
"""
from .. import DEBUG
if args is None:
args = tuple()
if force is False:
using = getRealShardConnectionName(using)
if DEBUG is True or debug is True:
logging.info(u'-- [DEBUG] DB_EXEC, using={0} ::\n{1}'.format(
using, sql))
cursor = connections()[using].cursor()
result = cursor.execute(sql, args)
cursor.close()
return result
def conn(self):
conn = connections(self.connDict)
logger.warn('LogTest {}'.format(conn))
print(conn)
return conn
