def Main():
cgiEnv = lib_oracle.OracleEnv()
oraSchema = cgiEnv.m_entity_id_dict["Schema"]
grph = cgiEnv.GetGraph()
sql_query = "SELECT OBJECT_NAME,STATUS,CREATED FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'PACKAGE BODY' AND OWNER = '" + oraSchema + "'"
DEBUG("sql_query=%s", sql_query)
node_oraschema = oracle_schema.MakeUri(cgiEnv.m_oraDatabase, oraSchema)
result = lib_oracle.ExecuteQuery(cgiEnv.ConnectStr(), sql_query)
num_package_bodies = len(result)
DEBUG("num_package_bodies=%d", num_package_bodies)
for row in result:
packageBodyName = str(row[0])
# sys.stderr.write("tableName=%s\n" % tableName )
nodePackageBody = oracle_package_body.MakeUri(cgiEnv.m_oraDatabase,
oraSchema,
packageBodyName)
grph.add(
(node_oraschema, pc.property_oracle_package_body, nodePackageBody))
lib_oracle.AddLiteralNotNone(grph, nodePackageBody, "Status", row[1])
lib_oracle.AddLiteralNotNone(grph, nodePackageBody, "Creation", row[2])
# It cannot work if there are too many tables.
# cgiEnv.OutCgiRdf("LAYOUT_RECT")
cgiEnv.OutCgiRdf("LAYOUT_RECT", [pc.property_oracle_package_body])
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()
ora_schema = cgiEnv.m_entity_id_dict["Schema"]
grph = cgiEnv.GetGraph()
sql_query = "SELECT OBJECT_NAME,STATUS,CREATED FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'PACKAGE BODY' AND OWNER = '" + ora_schema + "'"
logging.debug("sql_query=%s", sql_query)
node_oraschema = oracle_schema.MakeUri(cgiEnv.m_oraDatabase, ora_schema)
result = lib_oracle.ExecuteQuery(cgiEnv.ConnectStr(), sql_query)
num_package_bodies = len(result)
logging.debug("num_package_bodies=%d", num_package_bodies)
for row in result:
package_body_name = str(row[0])
node_package_body = oracle_package_body.MakeUri(
cgiEnv.m_oraDatabase, ora_schema, package_body_name)
grph.add((node_oraschema, pc.property_oracle_package_body,
node_package_body))
lib_oracle.AddLiteralNotNone(grph, node_package_body, "Status", row[1])
lib_oracle.AddLiteralNotNone(grph, node_package_body, "Creation",
row[2])
cgiEnv.OutCgiRdf("LAYOUT_RECT", [pc.property_oracle_package_body])
def AddInfo(grph, node, entity_ids_arr):
# TODO: SPECIAL. Imported here to avoid circular inclusions, see oracle/package_body/__init__.py
from sources_types.oracle import schema as oracle_schema
from sources_types.oracle import package_body as oracle_package_body
argDb = entity_ids_arr[0]
argSchema = entity_ids_arr[1]
argPackage = entity_ids_arr[2]
# TODO: PROBLEM, WHAT IF THE PACKAGE BODY DOES NOT EXIST ???
nodePackageBody = oracle_package_body.MakeUri(argDb, argSchema, argPackage)
grph.add((node, lib_common.MakeProp("Associated package body"),
nodePackageBody))
node_oraschema = oracle_schema.MakeUri(argDb, argSchema)
grph.add((node_oraschema, pc.property_oracle_package, node))
def AddDependency(grph, row, nodeRoot, oraDatabase, direction):
depOwner = str(row[0])
depName = str(row[1])
depType = str(row[2])
if depType == "TABLE":
nodeObject = oracle_table.MakeUri(oraDatabase, depOwner, depName)
elif depType == "VIEW":
nodeObject = oracle_view.MakeUri(oraDatabase, depOwner, depName)
elif depType == "PACKAGE":
nodeObject = oracle_package.MakeUri(oraDatabase, depOwner, depName)
elif depType == "PACKAGE BODY":
nodeObject = oracle_package_body.MakeUri(oraDatabase, depOwner,
depName)
elif depType == "SYNONYM":
nodeObject = oracle_synonym.MakeUri(oraDatabase, depOwner, depName)
elif depType == "TYPE":
nodeObject = oracle_type.MakeUri(oraDatabase, depOwner, depName)
elif depType == "SEQUENCE":
nodeObject = oracle_sequence.MakeUri(oraDatabase, depOwner, depName)
elif depType == "LIBRARY":
nodeObject = oracle_library.MakeUri(oraDatabase, depOwner, depName)
elif depType == "PROCEDURE":
nodeObject = oracle_procedure.MakeUri(oraDatabase, depOwner, depName)
elif depType == "FUNCTION":
nodeObject = oracle_function.MakeUri(oraDatabase, depOwner, depName)
elif depType == "TRIGGER":
nodeObject = oracle_trigger.MakeUri(oraDatabase, depOwner, depName)
else:
lib_common.ErrorMessageHtml(
"Unknown dependency depType=%s depName=%s" % (depType, depName))
return
if direction == True:
grph.add((nodeRoot, pc.property_oracle_depends, nodeObject))
else:
grph.add((nodeObject, pc.property_oracle_depends, nodeRoot))