print or set to variable - Hash key and field(value) - from redis database using python

Question

Trying to read a hash key and field from redis Database using python. In the DB i have many numeric keys(0,1,2,etc), and each has a TIMESTAMP field with the time value (2021-08-07 11:28:07.330731)

I can read the hash key and also read the desired field, individually.

How do I get it to read\list and print out to either screen or a variable the hash key associated with the desired field value.

r = myRedis database

field = r.hget('0','TIMESTAMP') # this gives me the field "TIMESTAMP" value, from Hash with key '0' and intkeylist = r.keys() # gives me the key list

just not sure how to tie these two together, so I get all my keys associated with the fields "TIMESTAMP"(value) listed together

Desired OUTPUT: Key Field value

etc...

Fix your formatting first

Petr L.
– Petr L.

2021-08-07 18:15:15 +00:00
Commented Aug 7, 2021 at 18:15 — Petr L.
– Petr L., Commented Aug 7, 2021 at 18:15

Petr L. · Accepted Answer · 2021-08-07 18:55:33Z

1

timestamps_log = ""    
for x in intkeylist:
       timestamps_log += str(x + r.hget(x,'TIMESTAMP'))
print(timestamps_log)

edited Aug 7, 2021 at 18:55

answered Aug 7, 2021 at 18:17

Petr L.

5097 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

dancer Over a year ago

Ty, this works. Thought there would be a redis command for this.

Petr L. Over a year ago

@dancer Right, fixed.

dancer Over a year ago

and to dump to variable i would put? for x in intkeylist: keylist_timestamp = (x,r.get(x,'TIMESTAMP'))

Petr L. Over a year ago

@dancer like that

Collectives™ on Stack Overflow

print or set to variable - Hash key and field(value) - from redis database using python

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related