def execute_query(self, query, commit = False):
if self.params.db.verbose:
from time import time
st = time()
self.query_count += 1
retry_count = 0
retry_max = 10
sleep_time = 0.1
while retry_count < retry_max:
try:
dbobj = get_db_connection(self.params)
cursor = dbobj.cursor()
cursor.execute(query)
if commit:
dbobj.commit()
if self.params.db.verbose:
print 'Query % 6d SQLTime Taken = % 10.6f seconds' % (self.query_count, time() - st), query[:min(len(query),145)]
return cursor
except OperationalError, e:
if "Can't connect to MySQL server" not in str(e):
raise e
retry_count += 1
print "Couldn't connect to MYSQL, retry", retry_count
time.sleep(sleep_time)
sleep_time *= 2
except Exception, e:
print "Couldn't execute MYSQL query. Query:"
print query
print "Exception:"
print str(e)
raise e
def execute_query(self, query, commit = False):
if self.params.db.verbose:
from time import time
st = time()
self.query_count += 1
retry_count = 0
retry_max = 10
sleep_time = 0.1
while retry_count < retry_max:
try:
dbobj = get_db_connection(self.params)
cursor = dbobj.cursor()
cursor.execute(query)
if commit:
dbobj.commit()
if self.params.db.verbose:
et = time() - st
if et > 1:
print 'Query % 6d SQLTime Taken = % 10.6f seconds' % (self.query_count, et), query[:min(len(query),145)]
return cursor
except OperationalError, e:
if "Can't connect to MySQL server" not in str(e):
raise e
retry_count += 1
print "Couldn't connect to MYSQL, retry", retry_count
time.sleep(sleep_time)
sleep_time *= 2
except Exception, e:
print "Couldn't execute MYSQL query. Query:"
print query
print "Exception:"
print str(e)
raise e
def execute_query(self, query, commit=False):
if self.params.db.verbose:
from time import time
st = time()
self.query_count += 1
retry_count = 0
retry_max = 10
sleep_time = 0.1
while retry_count < retry_max:
try:
if self.dbobj is None or not commit:
self.dbobj = dbobj = get_db_connection(self.params)
else:
dbobj = self.dbobj
dbobj = get_db_connection(self.params)
cursor = dbobj.cursor()
cursor.execute(query)
if commit:
dbobj.commit()
if self.params.db.verbose:
et = time() - st
if et > 1:
print(
'Query % 6d SQLTime Taken = % 10.6f seconds' %
(self.query_count, et),
query[:min(len(query), 145)])
return cursor
except OperationalError as e:
if "Can't connect to MySQL server" not in str(e):
print(query)
raise e
retry_count += 1
print("Couldn't connect to MYSQL, retry", retry_count)
time.sleep(sleep_time)
sleep_time *= 2
except Exception as e:
print("Couldn't execute MYSQL query. Query:")
print(query)
print("Exception:")
print(str(e))
raise e
raise Sorry(
"Couldn't execute MYSQL query. Too many reconnects. Query: %s" %
query)
def __init__(self, params, drop_tables = False, verify_tables = False, **kwargs):
super(xfel_db_application, self).__init__(params, **kwargs)
dbobj = get_db_connection(params)
init_tables = initialize(params, dbobj)
if drop_tables:
init_tables.drop_tables()
if verify_tables and not init_tables.verify_tables():
init_tables.create_tables()
print('Creating experiment tables...')
if not init_tables.verify_tables():
raise Sorry("Couldn't create experiment tables")
self.columns_dict = init_tables.set_up_columns_dict(self)
def __init__(self, params, drop_tables = False, verify_tables = False):
self.params = params
self.query_count = 0
dbobj = get_db_connection(params)
self.init_tables = initialize(params, dbobj) # only place where a connection is held
if drop_tables:
self.drop_tables()
if verify_tables and not self.verify_tables():
self.create_tables()
print 'Creating experiment tables...'
if not self.verify_tables():
raise Sorry("Couldn't create experiment tables")
self.columns_dict = self.init_tables.set_up_columns_dict(self)
def __init__(self, params, drop_tables = False, verify_tables = False):
super(xfel_db_application, self).__init__(params)
self.query_count = 0
dbobj = get_db_connection(params)
self.init_tables = initialize(params, dbobj) # only place where a connection is held
if drop_tables:
self.drop_tables()
if verify_tables and not self.verify_tables():
self.create_tables()
print('Creating experiment tables...')
if not self.verify_tables():
raise Sorry("Couldn't create experiment tables")
self.columns_dict = self.init_tables.set_up_columns_dict(self)
def __getattr__(self, prop):
if prop == "dbobj":
return get_db_connection(self.params)
raise AttributeError("%s not found" % prop)
def __getattr__(self, prop):
if prop == "dbobj":
return get_db_connection(self.params)
raise AttributeError("%s not found"%prop)
