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