def ListDbaUsers(cgiEnv, node_oradb, grph): # SQL> desc dba_users # Name Null? Type # ----------------------------------------- -------- ---------------------------- # USERNAME NOT NULL VARCHAR2(30) # USER_ID NOT NULL NUMBER # PASSWORD VARCHAR2(30) # ACCOUNT_STATUS NOT NULL VARCHAR2(32) # LOCK_DATE DATE # EXPIRY_DATE DATE # DEFAULT_TABLESPACE NOT NULL VARCHAR2(30) # TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30) # CREATED NOT NULL DATE # PROFILE NOT NULL VARCHAR2(30) # INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30) # EXTERNAL_NAME VARCHAR2(4000) # PASSWORD_VERSIONS VARCHAR2(8) # EDITIONS_ENABLED VARCHAR2(1) # AUTHENTICATION_TYPE VARCHAR2(8) qryDbaUsers = "select username, user_id, account_status, lock_date, expiry_date from dba_users" result = lib_oracle.ExecuteQueryThrow(cgiEnv.ConnectStr(), qryDbaUsers) for row in result: # row=('ORACLE_OCM', 21, 'EXPIRED & LOCKED') DEBUG("row=" + str(row)) nodeSchema = oracle_schema.MakeUri(cgiEnv.m_oraDatabase, str(row[0])) grph.add((node_oradb, pc.property_oracle_schema, nodeSchema)) lib_oracle.AddLiteralNotNone(grph, nodeSchema, "Schema-id", row[1]) lib_oracle.AddLiteralNotNone(grph, nodeSchema, "Status", row[2]) lib_oracle.AddLiteralNotNone(grph, nodeSchema, "Lock date", row[3]) lib_oracle.AddLiteralNotNone(grph, nodeSchema, "Expiry date", row[4])
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() 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 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 = 'VIEW' 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: viewName = str(row[0]) nodeView = oracle_view.MakeUri(cgiEnv.m_oraDatabase, oraSchema, viewName) grph.add((node_oraschema, pc.property_oracle_view, nodeView)) lib_oracle.AddLiteralNotNone(grph, nodeView, "Status", row[1]) lib_oracle.AddLiteralNotNone(grph, nodeView, "Creation", row[2]) # It cannot work if there are too many views. # cgiEnv.OutCgiRdf("LAYOUT_RECT") cgiEnv.OutCgiRdf("LAYOUT_RECT", [pc.property_oracle_view])
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 = 'TABLE' AND OWNER = '" + oraSchema + "'" sys.stderr.write("sql_query=%s\n" % sql_query) node_oraschema = oracle_schema.MakeUri(cgiEnv.m_oraDatabase, oraSchema) result = lib_oracle.ExecuteQuery(cgiEnv.ConnectStr(), sql_query) for row in result: tableName = str(row[0]) # sys.stderr.write("tableName=%s\n" % tableName ) nodeTable = oracle_table.MakeUri(cgiEnv.m_oraDatabase, oraSchema, tableName) grph.add((node_oraschema, pc.property_oracle_table, nodeTable)) lib_oracle.AddLiteralNotNone(grph, nodeTable, "Status", row[1]) lib_oracle.AddLiteralNotNone(grph, nodeTable, "Creation", row[2]) # It cannot work if there are too many tables. # cgiEnv.OutCgiRdf("LAYOUT_RECT") cgiEnv.OutCgiRdf("LAYOUT_RECT", [pc.property_oracle_table])
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 = 'TYPE' 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) for row in result: type_name = str(row[0]) node_type = oracle_type.MakeUri(cgiEnv.m_oraDatabase, ora_schema, type_name) grph.add((node_oraschema, pc.property_oracle_type, node_type)) lib_oracle.AddLiteralNotNone(grph, node_type, "Status", row[1]) lib_oracle.AddLiteralNotNone(grph, node_type, "Creation", row[2]) # Display in lines. cgiEnv.OutCgiRdf("LAYOUT_RECT", [pc.property_oracle_type])
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 = 'SEQUENCE' 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) for row in result: sequence_name = str(row[0]) node_sequence = oracle_sequence.MakeUri(cgiEnv.m_oraDatabase, ora_schema, sequence_name) grph.add((node_oraschema, pc.property_oracle_sequence, node_sequence)) lib_oracle.AddLiteralNotNone(grph, node_sequence, "Status", row[1]) lib_oracle.AddLiteralNotNone(grph, node_sequence, "Creation", row[2]) # "Collapsing", clustering nodes is needed if there are many objects. cgiEnv.OutCgiRdf("LAYOUT_RECT", [pc.property_oracle_sequence])
def Main(): cgiEnv = lib_oracle.OracleEnv() # BEWARE: There is an implicit dependency on the structure of Oracle schema URI. 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' 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) for row in result: package_name = str(row[0]) node_package = oracle_package.MakeUri(cgiEnv.m_oraDatabase, ora_schema, package_name) grph.add((node_oraschema, pc.property_oracle_package, node_package)) lib_oracle.AddLiteralNotNone(grph, node_package, "Status", row[1]) lib_oracle.AddLiteralNotNone(grph, node_package, "Creation", row[2]) # It cannot work if there are too many tables. # cgiEnv.OutCgiRdf("LAYOUT_RECT") cgiEnv.OutCgiRdf("LAYOUT_RECT", [pc.property_oracle_package])
def ListAllUsers(cgiEnv, node_oradb, grph): # SQL> desc all_users # Name Null? Type # ----------------------------------------- -------- ---------------------------- # USERNAME NOT NULL VARCHAR2(30) # USER_ID NOT NULL NUMBER # CREATED NOT NULL DATE qryDbaUsers = "select username, user_id, created from all_users" result = lib_oracle.ExecuteQueryThrow(cgiEnv.ConnectStr(), qryDbaUsers) for row in result: DEBUG("row=" + str(row)) nodeSchema = oracle_schema.MakeUri(cgiEnv.m_oraDatabase, str(row[0])) grph.add((node_oradb, pc.property_oracle_schema, nodeSchema)) lib_oracle.AddLiteralNotNone(grph, nodeSchema, "Schema-id", row[1]) lib_oracle.AddLiteralNotNone(grph, nodeSchema, "Created", row[2])
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 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 = 'FUNCTION' AND OWNER = '" + oraSchema + "'" sys.stderr.write("sql_query=%s\n" % sql_query) node_oraschema = oracle_schema.MakeUri(cgiEnv.m_oraDatabase, oraSchema) result = lib_oracle.ExecuteQuery(cgiEnv.ConnectStr(), sql_query) for row in result: functionName = str(row[0]) nodeFunction = oracle_function.MakeUri(cgiEnv.m_oraDatabase, oraSchema, functionName) grph.add((node_oraschema, pc.property_oracle_function, nodeFunction)) lib_oracle.AddLiteralNotNone(grph, nodeFunction, "Status", row[1]) lib_oracle.AddLiteralNotNone(grph, nodeFunction, "Creation", row[2]) cgiEnv.OutCgiRdf("LAYOUT_RECT", [pc.property_oracle_function])