class QueryBrowser(object):
########## initialization ##########
#initialize the class
def __init__(self, dbconfig):
if not isinstance(dbconfig, DataBaseConfiguration):
raise DatabaseConfigurationError, """The dbconfig input is not a valid """\
"""DataBaseConfiguration object."""
self.protocol = dbconfig.protocol
self.user_name = dbconfig.user_name
self.password = dbconfig.password
self.host_name = dbconfig.host_name
self.database_name = dbconfig.database_name
self.database_config_object = dbconfig
"""
self.engine = None
self.connection = None
self.result = None
self.query = None
self.metadata = None
self.table_name = None
self.session = None
self.class_name = None
self.database_config_object = None
"""
self.dbcon_obj = DataBaseConnection(dbconfig)
print self.dbcon_obj
########## initialization ends ##########
########## methods for mapping ##########
#separate function for mapper
def table_mapper(self, class_name, table_name):
"""
This method is used to create a mapper to the table in the database
Input:
Class name and Table name
Output:
Creates a table mapper object
"""
#before creating the mapper check if the table exists
self.table_name = table_name
self.class_name = class_name
table_flag = self.dbcon_obj.check_if_table_exists(table_name)
if table_flag:
#table exists
try:
#print 'table name is %s and class name is %s'%(table_name, class_name)
#load the table
new_table = Table(self.table_name, self.dbcon_obj.metadata, autoload=True)
#create mapper
class_name = class_name.upper()
mapper(eval(class_name), new_table)
#create an object for the mapper
self.temp_object = eval(class_name)()
#print the session and mapper object
#print 'the session object is %s and the mapper object is %s\n'%(self.dbcon_obj.session, self.temp_object)
return self.temp_object
except Exception, e:
print 'Failed to create mapper'
print e
#raise Exception
else:
class QueryBrowser(object):
########## initialization ##########
#initialize the class
def __init__(self, dbconfig):
if not isinstance(dbconfig, DataBaseConfiguration):
raise DatabaseConfigurationError, """The dbconfig input is not a valid """\
"""DataBaseConfiguration object."""
self.protocol = dbconfig.protocol
self.user_name = dbconfig.user_name
self.password = dbconfig.password
self.host_name = dbconfig.host_name
self.database_name = dbconfig.database_name
self.database_config_object = dbconfig
"""
self.engine = None
self.connection = None
self.result = None
self.query = None
self.metadata = None
self.table_name = None
self.session = None
self.class_name = None
self.database_config_object = None
"""
self.dbcon_obj = DataBaseConnection(dbconfig)
print self.dbcon_obj
########## initialization ends ##########
########## methods for mapping ##########
#separate function for mapper
def table_mapper(self, class_name, table_name):
"""
This method is used to create a mapper to the table in the database
Input:
Class name and Table name
Output:
Creates a table mapper object
"""
#before creating the mapper check if the table exists
self.table_name = table_name
self.class_name = class_name
table_flag = self.dbcon_obj.check_if_table_exists(table_name)
if table_flag:
#table exists
try:
#print 'table name is %s and class name is %s'%(table_name, class_name)
#load the table
new_table = Table(self.table_name,
self.dbcon_obj.metadata,
autoload=True)
#create mapper
class_name = class_name.upper()
mapper(eval(class_name), new_table)
#create an object for the mapper
self.temp_object = eval(class_name)()
#print the session and mapper object
#print 'the session object is %s and the mapper object is %s\n'%(self.dbcon_obj.session, self.temp_object)
return self.temp_object
except Exception, e:
print 'Failed to create mapper'
print e
#raise Exception
else:
