Database Info

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