def Main():
cgiEnv = lib_oracle.OracleEnv()
oraPackageBody = cgiEnv.m_entity_id_dict["PackageBody"]
oraSchema = cgiEnv.m_entity_id_dict["Schema"]
grph = cgiEnv.GetGraph()
node_oraPackageBody = oracle_package_body.MakeUri( cgiEnv.m_oraDatabase, oraSchema, oraPackageBody )
node_oraSchema = oracle_schema.MakeUri( cgiEnv.m_oraDatabase, oraSchema )
grph.add( ( node_oraSchema, pc.property_oracle_package_body, node_oraPackageBody ) )
# TYPE = "VIEW", "TABLE", "PACKAGE BODY"
sql_query = "select owner,name,type from all_dependencies where REFERENCED_TYPE = 'PACKAGE BODY' AND REFERENCED_NAME = '"\
+ oraPackageBody + "' and referenced_owner='" + oraSchema + "'"
DEBUG("sql_query=%s", sql_query )
result = lib_oracle.ExecuteQuery( cgiEnv.ConnectStr(), sql_query)
for row in result:
lib_oracle.AddDependency( grph, row, node_oraPackageBody, cgiEnv.m_oraDatabase, True )
sql_query_inv = "select referenced_owner,referenced_name,referenced_type from all_dependencies where type='PACKAGE BODY' and NAME = '"\
+ oraPackageBody + "' and OWNER='" + oraSchema + "'"
DEBUG("sql_query_inv=%s", sql_query_inv )
result_inv = lib_oracle.ExecuteQuery( cgiEnv.ConnectStr(), sql_query_inv)
for row in result_inv:
lib_oracle.AddDependency( grph, row, node_oraPackageBody, cgiEnv.m_oraDatabase, False )
cgiEnv.OutCgiRdf("LAYOUT_SPLINE")
def Main():
cgiEnv = lib_oracle.OracleEnv()
oraView = cgiEnv.m_entity_id_dict["View"]
oraSchema = cgiEnv.m_entity_id_dict["Schema"]
oraDatabase = cgiEnv.m_entity_id_dict["Db"]
grph = cgiEnv.GetGraph()
node_oraView = oracle_view.MakeUri(oraDatabase, oraSchema, oraView)
node_oraSchema = oracle_schema.MakeUri(oraDatabase, oraSchema)
grph.add((node_oraSchema, pc.property_oracle_view, node_oraView))
# TYPE = "VIEW", "TABLE", "PACKAGE BODY"
sql_query = "select owner,name,type from all_dependencies where REFERENCED_TYPE = 'VIEW' AND REFERENCED_NAME = '" + oraView + "' and referenced_owner='" + oraSchema + "'"
sys.stderr.write("sql_query=%s\n" % sql_query)
result = lib_oracle.ExecuteQuery(cgiEnv.ConnectStr(), sql_query)
for row in result:
lib_oracle.AddDependency(grph, row, node_oraView, oraDatabase, True)
sql_query_inv = "select referenced_owner,referenced_name,referenced_type from all_dependencies where type='VIEW' and NAME = '" + oraView + "' and OWNER='" + oraSchema + "'"
sys.stderr.write("sql_query_inv=%s\n" % sql_query_inv)
result_inv = lib_oracle.ExecuteQuery(cgiEnv.ConnectStr(), sql_query_inv)
for row in result_inv:
lib_oracle.AddDependency(grph, row, node_oraView, oraDatabase, False)
cgiEnv.OutCgiRdf("LAYOUT_RECT")
def Main():
cgiEnv = lib_oracle.OracleEnv()
ora_table = cgiEnv.m_entity_id_dict["Table"]
ora_schema = cgiEnv.m_entity_id_dict["Schema"]
ora_database = cgiEnv.m_entity_id_dict["Db"]
grph = cgiEnv.GetGraph()
# TYPE = "VIEW", "TABLE", "PACKAGE BODY" etc...
sql_query = "select owner,name,type from all_dependencies where REFERENCED_TYPE = 'TABLE' AND REFERENCED_NAME = '" \
+ ora_table + "' and referenced_owner='" + ora_schema + "'"
logging.debug("sql_query=%s", sql_query)
node_ora_table = oracle_table.MakeUri(ora_database, ora_schema, ora_table)
node_ora_schema = oracle_schema.MakeUri(ora_database, ora_schema)
grph.add((node_ora_schema, pc.property_oracle_table, node_ora_table))
result = lib_oracle.ExecuteQuery(cgiEnv.ConnectStr(), sql_query)
for row in result:
lib_oracle.AddDependency(grph, row, node_ora_table, ora_database, True)
cgiEnv.OutCgiRdf("LAYOUT_RECT")
