find 2 elements

kentaro0919

Hi,

I am trying to implement with tinydb a user usage database.

{"1": {"user": "user_one"}, "2017-01": "usage"}
{"2": {"user": "user_two"}, "2017-01": "usage"}

My code try to find if exist before writing.
I thouth it was working but I find out that when I was running through 2016

I was expecting
{"1": {"user": "user_one"}, "2017-01": "usage"}
{"2": {"user": "user_two"}, "2017-01": "usage"}
{"3": {"user": "user_one"}, "2016-12": "usage"}
{"4": {"user": "user_two"}, "2016-12": "usage"}

but as {"user": "user_one"} exist in "1" nothing was writin "3". How can I find {"user": "user_one"} and "2017-01"

kentaro0919

Or is it better to store like
{"1": {"user": "user_one"}, "usage": ["2017-01", "2016-12" ]}
{"2": {"user": "user_two"}, "usage": ["2017-01", "2016-12" ]}

and update to
{"1": {"user": "user_one"}, "usage": ["2017-01", "2016-12", "2016-11" ]}
{"2": {"user": "user_two"}, "usage": ["2017-01", "2016-12" , "2016-11" ]}

Or use table?
{"2016-12": {"1": {"user": "user_one"}, "2016-12": "usage"}
{"2017-1": {"1": {"user": "user_one"}, "2017-1": "usage"}

kentaro0919

I find how to query 2 elements
db.search( (first query ) & (second query ))

Unfortunate as I had as attribute I can not use. I need to up date the json format.

I will try with
{
"1": {
"user": "user_one"
},
"usage": [{
"2017-01": "data"
}, {
"2016-12": "data"
}, {
"2016-11": "data"
}]
}

msiemens

Hey, just for my understanding: You want to associate the user info with a list of usage dates? And then query for a specific user + usage date? Is that correct?

Cheers!