def test_oracle_query(self):
"""test oracle query
create test oracle db
get meta data
create select query on multiple table
create query builder and build querys
output in graph"""
_LOGGER.debug("test_oracle_query start")
test_db = UnittestDB()
metadata = test_db.read_from_oracle('oracle.sql')
process_dataset = find_table(metadata, 'ProcessedDataset')
app_exec = find_table(metadata, 'AppExecutable')
select_test = select([process_dataset.c.Name,
app_exec.c.ExecutableName])
query_builder = Schema(metadata.tables)
query = query_builder.build_query(select_test)
# print query
person = find_table(metadata, 'Person')
select_test = select([process_dataset.c.Name,
app_exec.c.ExecutableName, person.c.Name])
query_builder = Schema(metadata.tables)
query = query_builder.build_query(select_test)
dot = DotGraph(file("testOracleQuery.dot", "w"))
write_query_alchemy_graph(dot, query)
# print query
_LOGGER.debug("test_oracle_query finish")
def test_oracle_simple(self):
"""test oracle simple query"""
_LOGGER.debug("test_oracle_simple start")
test_db = UnittestDB()
metadata = test_db.read_from_oracle('oracle.sql')
process_dataset = find_table(metadata, 'ProcessedDataset')
# app_exec = find_table(metadata, 'AppExecutable')
person = find_table(metadata, 'Person')
select_test = select([person.c.Name])
query_builder = Schema(metadata.tables)
query = query_builder.build_query(select_test)
# print query
select_test = select([process_dataset.c.Name])
query_builder = Schema(metadata.tables)
query = query_builder.build_query(select_test)
# print query
_LOGGER.debug("test_oracle_simple finish")
def test_by_sql_file(self):
"""test by sql file"""
udb = UnittestDB()
metadata = udb.load_from_file('starting_db.yaml')
connection = self.engine.connect()
metadata.bind = connection
metadata.drop_all()
connection.close()
udb = UnittestDB()
metadata = udb.read_from_oracle('oracle.sql')
# for table in metadata.sorted_tables:
# print table.name
# for col in table.columns:
# print col
metadata.bind = self.engine
metadata.create_all()
udb.fill_tables(metadata, 10)
metadata.drop_all()
def test_oracle_write(self):
"""test oracle write"""
udb = UnittestDB()
metadata = udb.read_from_oracle('oracle.sql')
dot = DotGraph(file("oracle.dot", "w"))
write_sql_alchemy_graph(dot, metadata, set(['Person']))
