Posts: 13
Threads: 2
Joined: Aug 2024
I have a dictionary:
{'Q_MGR_NAME': 'BOBBEE2', 'START_DATE': '2024-08-21', 'START_TIME': '05.08.47', 'END_DATE': '2024-08-21', 'END_TIME': '05.09.47', 'COMMAND_LEVEL': 940, 'OBJECT_COUNT': 2, 'Q_STATISTICS_DATA': {'SYSTEM.ADMIN.COMMAND.QUEUE': {'Q_NAME': 'SYSTEM.ADMIN.COMMAND.QUEUE', 'CREATION_DATE': '2023-04-18', 'CREATION_TIME': '12.32.19', 'Q_TYPE': 'LOCAL', 'DEFINITION_TYPE': 'PREDEFINED', 'Q_MIN_DEPTH': 0, 'Q_MAX_DEPTH': 0, 'AVG_Q_TIME': [0, 0], 'PUTS': [17, 0], 'PUTS_FAILED': 0, 'PUT1S': [0, 0], 'PUT1S_FAILED': 0, 'PUT_BYTES': [1512, 0], 'GETS': [17, 0], 'GET_BYTES': [1512, 0], 'GETS_FAILED': 0, 'BROWSES': [0, 0], 'BROWSE_BYTES': [0, 0], 'BROWSES_FAILED': 0, 'MSGS_NOT_QUEUED': 17, 'MSGS_EXPIRED': 0, 'MSGS_PURGED': 0}, 'PYMQI': {'Q_NAME': 'PYMQI', 'CREATION_DATE': '2024-08-14', 'CREATION_TIME': '07.39.31', 'Q_TYPE': 'LOCAL', 'DEFINITION_TYPE': 'PREDEFINED', 'Q_MIN_DEPTH': 40, 'Q_MAX_DEPTH': 60, 'AVG_Q_TIME': [0, 0], 'PUTS': [20, 0], 'PUTS_FAILED': 0, 'PUT1S': [0, 0], 'PUT1S_FAILED': 0, 'PUT_BYTES': [20480, 0], 'GETS': [0, 0], 'GET_BYTES': [0, 0], 'GETS_FAILED': 0, 'BROWSES': [0, 0], 'BROWSE_BYTES': [0, 0], 'BROWSES_FAILED': 0, 'MSGS_NOT_QUEUED': 0, 'MSGS_EXPIRED': 0, 'MSGS_PURGED': 0}}}
I have a routine that gives me the PATH to the two nested dictionaries with Q_NAME elements:
Value SYSTEM.ADMIN.COMMAND.QUEUE found at ['Q_STATISTICS_DATA']['SYSTEM.ADMIN.COMMAND.QUEUE']['Q_NAME']
Value PYMQI found at ['Q_STATISTICS_DATA']['PYMQI']['Q_NAME']
I use this to try to get the list of keys, but get the following error:
print('Keys of = ", new_test_dict.Q_STATISTICS_DATA.SYSTEM.ADMIN.COMMAND.QUEUE.keys())
AttributeError: 'dict' object has no attribute 'Q_STATISTICS_DATA'
Posts: 13
Threads: 2
Joined: Aug 2024
(Aug-22-2024, 06:30 PM)Bobbee Wrote: I have a dictionary:
{'Q_MGR_NAME': 'BOBBEE2', 'START_DATE': '2024-08-21', 'START_TIME': '05.08.47', 'END_DATE': '2024-08-21', 'END_TIME': '05.09.47', 'COMMAND_LEVEL': 940, 'OBJECT_COUNT': 2, 'Q_STATISTICS_DATA': {'SYSTEM.ADMIN.COMMAND.QUEUE': {'Q_NAME': 'SYSTEM.ADMIN.COMMAND.QUEUE', 'CREATION_DATE': '2023-04-18', 'CREATION_TIME': '12.32.19', 'Q_TYPE': 'LOCAL', 'DEFINITION_TYPE': 'PREDEFINED', 'Q_MIN_DEPTH': 0, 'Q_MAX_DEPTH': 0, 'AVG_Q_TIME': [0, 0], 'PUTS': [17, 0], 'PUTS_FAILED': 0, 'PUT1S': [0, 0], 'PUT1S_FAILED': 0, 'PUT_BYTES': [1512, 0], 'GETS': [17, 0], 'GET_BYTES': [1512, 0], 'GETS_FAILED': 0, 'BROWSES': [0, 0], 'BROWSE_BYTES': [0, 0], 'BROWSES_FAILED': 0, 'MSGS_NOT_QUEUED': 17, 'MSGS_EXPIRED': 0, 'MSGS_PURGED': 0}, 'PYMQI': {'Q_NAME': 'PYMQI', 'CREATION_DATE': '2024-08-14', 'CREATION_TIME': '07.39.31', 'Q_TYPE': 'LOCAL', 'DEFINITION_TYPE': 'PREDEFINED', 'Q_MIN_DEPTH': 40, 'Q_MAX_DEPTH': 60, 'AVG_Q_TIME': [0, 0], 'PUTS': [20, 0], 'PUTS_FAILED': 0, 'PUT1S': [0, 0], 'PUT1S_FAILED': 0, 'PUT_BYTES': [20480, 0], 'GETS': [0, 0], 'GET_BYTES': [0, 0], 'GETS_FAILED': 0, 'BROWSES': [0, 0], 'BROWSE_BYTES': [0, 0], 'BROWSES_FAILED': 0, 'MSGS_NOT_QUEUED': 0, 'MSGS_EXPIRED': 0, 'MSGS_PURGED': 0}}}
I have a routine that gives me the PATH to the two nested dictionaries with Q_NAME elements:
Value SYSTEM.ADMIN.COMMAND.QUEUE found at ['Q_STATISTICS_DATA']['SYSTEM.ADMIN.COMMAND.QUEUE']['Q_NAME']
Value PYMQI found at ['Q_STATISTICS_DATA']['PYMQI']['Q_NAME']
I use this to try to get the list of keys, but get the following error:
print('Keys of = ", new_test_dict.Q_STATISTICS_DATA.SYSTEM.ADMIN.COMMAND.QUEUE.keys())
AttributeError: 'dict' object has no attribute 'Q_STATISTICS_DATA'
Posts: 13
Threads: 2
Joined: Aug 2024
If I print the keys for the entire DICT I get
Keys of patho = dict_keys(['Q_MGR_NAME', 'START_DATE', 'START_TIME', 'END_DATE', 'END_TIME', 'COMMAND_LEVEL', 'OBJECT_COUNT', 'Q_STATISTICS_DATA'])
Q_STATISTICS_DATA is a nested dictionary. I was expecting if I pointed to this I could get the keys of the nested dictionary. NO?
Posts: 7,320
Threads: 123
Joined: Sep 2016
This should help on how to use the nested dictionary.
test_dict = {
'Q_MGR_NAME': 'BOBBEE2',
'START_DATE': '2024-08-21',
'START_TIME': '05.08.47',
'END_DATE': '2024-08-21',
'END_TIME': '05.09.47',
'COMMAND_LEVEL': 940,
'OBJECT_COUNT': 2,
'Q_STATISTICS_DATA': {
'SYSTEM.ADMIN.COMMAND.QUEUE': {
'Q_NAME': 'SYSTEM.ADMIN.COMMAND.QUEUE',
'CREATION_DATE': '2023-04-18',
'CREATION_TIME': '12.32.19',
'Q_TYPE': 'LOCAL',
'DEFINITION_TYPE': 'PREDEFINED',
'Q_MIN_DEPTH': 0,
'Q_MAX_DEPTH': 0,
'AVG_Q_TIME': [0, 0],
'PUTS': [17, 0],
'PUTS_FAILED': 0,
'PUT1S': [0, 0],
'PUT1S_FAILED': 0,
'PUT_BYTES': [1512, 0],
'GETS': [17, 0],
'GET_BYTES': [1512, 0],
'GETS_FAILED': 0,
'BROWSES': [0, 0],
'BROWSE_BYTES': [0, 0],
'BROWSES_FAILED': 0,
'MSGS_NOT_QUEUED': 17,
'MSGS_EXPIRED': 0,
'MSGS_PURGED': 0
},
'PYMQI': {
'Q_NAME': 'PYMQI',
'CREATION_DATE': '2024-08-14',
'CREATION_TIME': '07.39.31',
'Q_TYPE': 'LOCAL',
'DEFINITION_TYPE': 'PREDEFINED',
'Q_MIN_DEPTH': 40,
'Q_MAX_DEPTH': 60,
'AVG_Q_TIME': [0, 0],
'PUTS': [20, 0],
'PUTS_FAILED': 0,
'PUT1S': [0, 0],
'PUT1S_FAILED': 0,
'PUT_BYTES': [20480, 0],
'GETS': [0, 0],
'GET_BYTES': [0, 0],
'GETS_FAILED': 0,
'BROWSES': [0, 0],
'BROWSE_BYTES': [0, 0],
'BROWSES_FAILED': 0,
'MSGS_NOT_QUEUED': 0,
'MSGS_EXPIRED': 0,
'MSGS_PURGED': 0
}
}
}
# Accessing the nested dictionary
q_statistics = test_dict['Q_STATISTICS_DATA'].keys()
print(f"Keys of Q_STATISTICS_DATA = {q_statistics}")
# Accessing PUT_BYTES for SYSTEM.ADMIN.COMMAND.QUEUE
put_bytes = test_dict['Q_STATISTICS_DATA']['SYSTEM.ADMIN.COMMAND.QUEUE']['PUT_BYTES']
print(f"PUT_BYTES for SYSTEM.ADMIN.COMMAND.QUEUE <{put_bytes}>")
# Using nested-lookup at PyPi
# pip install nested-lookup
from nested_lookup import nested_lookup
print(nested_lookup('Q_MAX_DEPTH', test_dict))Output: Keys of Q_STATISTICS_DATA = dict_keys(['SYSTEM.ADMIN.COMMAND.QUEUE', 'PYMQI'])
PUT_BYTES for SYSTEM.ADMIN.COMMAND.QUEUE <[1512, 0]>
[0, 60]
Posts: 6,806
Threads: 20
Joined: Feb 2020
Aug-22-2024, 08:30 PM
(This post was last modified: Aug-22-2024, 08:30 PM by deanhystad.)
Classes use "." to get an attribute. Dictionaries use [].
Why would you think that new_test_dict.Q_STATISTICS_DATA should give you new_test_dict["Q_STATISTICS_DATA"]? Is new_test_dict a dictionary like you have in your post, or is it some other thing? There is a python package named attrdict that lets you use "." index a dictionary instead of []. A roll your own version.
data = {
"Q_MGR_NAME": "BOBBEE2",
"START_DATE": "2024-08-21",
"START_TIME": "05.08.47",
"END_DATE": "2024-08-21",
"END_TIME": "05.09.47",
"COMMAND_LEVEL": 940,
"OBJECT_COUNT": 2,
"Q_STATISTICS_DATA": {
"SYSTEM.ADMIN.COMMAND.QUEUE": {
"Q_NAME": "SYSTEM.ADMIN.COMMAND.QUEUE",
"CREATION_DATE": "2023-04-18",
"CREATION_TIME": "12.32.19",
"Q_TYPE": "LOCAL",
"DEFINITION_TYPE": "PREDEFINED",
"Q_MIN_DEPTH": 0,
"Q_MAX_DEPTH": 0,
"AVG_Q_TIME": [0, 0],
"PUTS": [17, 0],
"PUTS_FAILED": 0,
"PUT1S": [0, 0],
"PUT1S_FAILED": 0,
"PUT_BYTES": [1512, 0],
"GETS": [17, 0],
"GET_BYTES": [1512, 0],
"GETS_FAILED": 0,
"BROWSES": [0, 0],
"BROWSE_BYTES": [0, 0],
"BROWSES_FAILED": 0,
"MSGS_NOT_QUEUED": 17,
"MSGS_EXPIRED": 0,
"MSGS_PURGED": 0,
},
"PYMQI": {
"Q_NAME": "PYMQI",
"CREATION_DATE": "2024-08-14",
"CREATION_TIME": "07.39.31",
"Q_TYPE": "LOCAL",
"DEFINITION_TYPE": "PREDEFINED",
"Q_MIN_DEPTH": 40,
"Q_MAX_DEPTH": 60,
"AVG_Q_TIME": [0, 0],
"PUTS": [20, 0],
"PUTS_FAILED": 0,
"PUT1S": [0, 0],
"PUT1S_FAILED": 0,
"PUT_BYTES": [20480, 0],
"GETS": [0, 0],
"GET_BYTES": [0, 0],
"GETS_FAILED": 0,
"BROWSES": [0, 0],
"BROWSE_BYTES": [0, 0],
"BROWSES_FAILED": 0,
"MSGS_NOT_QUEUED": 0,
"MSGS_EXPIRED": 0,
"MSGS_PURGED": 0,
},
},
}
class AttributeDictionary:
def __init__(self, dictionary):
self.dictionary = dictionary
def __getattr__(self, attribute):
part = self.dictionary[attribute]
if isinstance(part, dict):
return AttributeDictionary(part)
return part
def __str__(self):
return str(self.dictionary)
def __repr__(self):
return repr(self.dictionary)
attr_dict = AttributeDictionary(data)
print(attr_dict.Q_STATISTICS_DATA.PYMQI.PUT_BYTES[0])
print(data["Q_STATISTICS_DATA"]["PYMQI"]["PUT_BYTES"][0])Or if you just want a dictionary where you can provide a path, that is easier.
data = {
"Q_MGR_NAME": "BOBBEE2",
"START_DATE": "2024-08-21",
"START_TIME": "05.08.47",
"END_DATE": "2024-08-21",
"END_TIME": "05.09.47",
"COMMAND_LEVEL": 940,
"OBJECT_COUNT": 2,
"Q_STATISTICS_DATA": {
"SYSTEM.ADMIN.COMMAND.QUEUE": {
"Q_NAME": "SYSTEM.ADMIN.COMMAND.QUEUE",
"CREATION_DATE": "2023-04-18",
"CREATION_TIME": "12.32.19",
"Q_TYPE": "LOCAL",
"DEFINITION_TYPE": "PREDEFINED",
"Q_MIN_DEPTH": 0,
"Q_MAX_DEPTH": 0,
"AVG_Q_TIME": [0, 0],
"PUTS": [17, 0],
"PUTS_FAILED": 0,
"PUT1S": [0, 0],
"PUT1S_FAILED": 0,
"PUT_BYTES": [1512, 0],
"GETS": [17, 0],
"GET_BYTES": [1512, 0],
"GETS_FAILED": 0,
"BROWSES": [0, 0],
"BROWSE_BYTES": [0, 0],
"BROWSES_FAILED": 0,
"MSGS_NOT_QUEUED": 17,
"MSGS_EXPIRED": 0,
"MSGS_PURGED": 0,
},
"PYMQI": {
"Q_NAME": "PYMQI",
"CREATION_DATE": "2024-08-14",
"CREATION_TIME": "07.39.31",
"Q_TYPE": "LOCAL",
"DEFINITION_TYPE": "PREDEFINED",
"Q_MIN_DEPTH": 40,
"Q_MAX_DEPTH": 60,
"AVG_Q_TIME": [0, 0],
"PUTS": [20, 0],
"PUTS_FAILED": 0,
"PUT1S": [0, 0],
"PUT1S_FAILED": 0,
"PUT_BYTES": [20480, 0],
"GETS": [0, 0],
"GET_BYTES": [0, 0],
"GETS_FAILED": 0,
"BROWSES": [0, 0],
"BROWSE_BYTES": [0, 0],
"BROWSES_FAILED": 0,
"MSGS_NOT_QUEUED": 0,
"MSGS_EXPIRED": 0,
"MSGS_PURGED": 0,
},
},
}
class PathDictionary:
def __init__(self, dictionary):
self.dictionary = dictionary
def __getitem__(self, path):
value = self.dictionary
for part in path.split("."):
value = value[part]
return value
path_dict = PathDictionary(data)
print(path_dict["Q_STATISTICS_DATA.PYMQI.PUT_BYTES"][0])
print(data["Q_STATISTICS_DATA"]["PYMQI"]["PUT_BYTES"][0])
Posts: 13
Threads: 2
Joined: Aug 2024
Thanks, I played with what you presented and it is working. I changed a few things to see if my understanding was correct and that worked. Let me play a little. I eventually want to capture the key/values under each queue and add to them the DEQ and ENQ stats from a Q REST and push them out as CSV to be loaded into an EXCEL sheet whit charts to track. What you gave me helped alot.
|
