Database Info (Python)

Database Info (Python)
 1def OutputConnectionInfo(db):
 2    ot = impact.gui.output_toolbox
 3
 4    # On Error Resume Next
 5    ot.add(" ")
 6    ot.add("Connection: " + db.connection_name)
 7    if db.connected:
 8        ot.add("ACTIVE connection")
 9    ot.add("Connected: " + str(db.connected))
10    ot.add("Low Speed: " + str(db.low_speed))
11    ot.add("Files Blobbed: " + str(db.files_blobbed))
12    ot.add("Settings Blobbed: " + str(db.settings_blobbed))
13    ot.add("Users Blobbed: " + str(db.users_blobbed))
14    ot.add("Primary: " + str(db.primary))
15    ot.add("Secondary: " + str(db.secondary))
16
17    if db.database_driver.isNone():
18        ot.add("No driver information")
19    else:
20        ot.add("Driver Connection String: " + db.database_driver.connection_string)
21        ot.add("Driver Desc: " + db.database_driver.description)
22        ot.add("Driver Type: " + db.database_driver.driver_type)
23        ot.add("Driver Name: " + db.database_driver.full_name)
24        ot.add("Driver version: " + db.database_driver.version)
25    if db.database_server.isNone():
26        ot.add("No server information")
27    else:
28        ot.add("Server Name: " + db.database_server.server_name)
29        ot.add("Server Type: " + db.database_server.server_type)
30        ot.add("Database Name: " + db.database_server.database_name)
31        ot.add("Server version: " + db.database_server.version)
32    if 0 != 0:
33        ot.add("Some properties could not be retrieved")
34
35for db in impact.databases:
36    OutputConnectionInfo(db)