def Main():
cgiEnv = lib_oracle.OracleEnv()
oraPackage = cgiEnv.m_entity_id_dict["Package"]
oraSchema = cgiEnv.m_entity_id_dict["Schema"]
grph = cgiEnv.GetGraph()
node_oraPackage = oracle_package.MakeUri(cgiEnv.m_oraDatabase, oraSchema,
oraPackage)
node_oraSchema = oracle_schema.MakeUri(cgiEnv.m_oraDatabase, oraSchema)
grph.add((node_oraSchema, pc.property_oracle_package, node_oraPackage))
# TODO: This is problematic as these could also be functions.
# TODO: But when joining with ALL_OBJECTS, most rows are gone. So what to do ?
sql_query = "select distinct procedure_name from all_procedures where object_type='PACKAGE' " \
"and owner='" + oraSchema + "' and object_name='" + oraPackage + "'"
DEBUG("sql_query=%s", sql_query)
result = lib_oracle.ExecuteQuery(cgiEnv.ConnectStr(), sql_query)
propProcToPackage = lib_common.MakeProp("Package")
for row in result:
procedureName = row[0]
procedureNode = oracle_procedure.MakeUri(cgiEnv.m_oraDatabase,
oraSchema, procedureName)
grph.add((node_oraPackage, propProcToPackage, procedureNode))
cgiEnv.OutCgiRdf("LAYOUT_SPLINE", [propProcToPackage])
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 = 'PROCEDURE' 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)
for row in result:
procedureName = str(row[0])
nodeProcedure = oracle_procedure.MakeUri( cgiEnv.m_oraDatabase , oraSchema, procedureName )
grph.add( ( node_oraschema, pc.property_oracle_procedure, nodeProcedure ) )
lib_oracle.AddLiteralNotNone(grph,nodeProcedure,"Status",row[1])
lib_oracle.AddLiteralNotNone(grph,nodeProcedure,"Creation",row[2])
cgiEnv.OutCgiRdf("LAYOUT_RECT",[pc.property_oracle_procedure])
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))