how to filter with BinaryJSONField?

[Bin Lyu]

class Modex(baseModal):

    sdgdList = BinaryJSONField(verbose_name="sdgdList",null=True,)

sdgdList Data:

[{"x": "1", "cgs": "11.00", "gbxz": "A", "gdmc": "aaa", "zjqk": "0.48", "zzgs": "0.18", "zjqkCss": "red", "gdblockid": "10",}, {"x": "2", "cgs": "10.06", "gbxz": "A", "gdmc": "bbb", "zjqk": "0.32", "zzgs": "0.17", "zjqkCss": "red", "gdblockid": "10", },{"x": "2", "cgs": "10.06", "gbxz": "A", "gdmc": "aaa", "zjqk": "0.32", "zzgs": "0.17", "zjqkCss": "red", "gdblockid": "10", }]

how to filter 'gdmc' == 'aaa' then result:

[{"x": "1", "cgs": "11.00", "gbxz": "A", "gdmc": "aaa", "zjqk": "0.48", "zzgs": "0.18", "zjqkCss": "red", "gdblockid": "10",},{"x": "2", "cgs": "10.06", "gbxz": "A", "gdmc": "aaa", "zjqk": "0.32", "zzgs": "0.17", "zjqkCss": "red", "gdblockid": "10", }]

[Charles Leifer]

I attempted to answer your question here: https://github.com/coleifer/peewee/issues/2300#issuecomment-729706157

Basically:

SomeModel.select().where(SomeModel.sdgdList['gdmc'] == 'aaa')

--
You received this message because you are subscribed to the Google Groups "peewee-orm" group.
To unsubscribe from this group and stop receiving emails from it, send an email to peewee-orm+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/peewee-orm/22431cdd-4a10-4085-b4de-3f8273d2c25cn%40googlegroups.com.

[Bin Lyu]

SomeModel.select().where(SomeModel.sdgdList['gdmc'] == 'aaa')

filter result is None!

Have you tested it?

SomeModel.select().where(SomeModel.sdgdList['gdmc'] == 'aaa') 

Apply to Data 

dict --> { 'gdmc': {'bar': ['i2']} }

List did't work-------------------

list --> [{"x": "1", "cgs": "11.00", "gbxz": "A", "gdmc": "aaa", "zjqk": "0.48", "zzgs": "0.18", "zjqkCss": "red", "gdblockid": "10",}, {"x": "2", "cgs": "10.06", "gbxz": "A", "gdmc": "bbb", "zjqk": "0.32", "zzgs": "0.17", "zjqkCss": "red", "gdblockid": "10", },]

[Charles Leifer]

I didn't understand that the data was stored in lists. In that case I'm not too sure what the best way would be.

To view this discussion on the web visit https://groups.google.com/d/msgid/peewee-orm/31f5ff47-d003-4d21-9730-5b4182e341fan%40googlegroups.com.

[Bin Lyu]

Thank you for your reply.

in mongo i using args : {'sdgdList.gdmc':name} 

  Is there a similar operation method for peewee?

[Charles Leifer]

Did you also try:

SomeModel.select().where(SomeModel.sdgdList.contains({'gdmc': 'aaa'}))

To view this discussion on the web visit https://groups.google.com/d/msgid/peewee-orm/c0bc649b-1352-48d8-9ecd-188e994a24e5n%40googlegroups.com.

[Bin Lyu]

Yes, I have queried and the return is empty.

[Charles Leifer]

Ah, I just tested locally. Since your data is in a list, you just need to put the data inside a list that you're trying to match.

So this should work:

search = [{'gdmc': 'aaa'}]

SomeModel.select().where(SomeModel.sdgdList.contains(search))

To view this discussion on the web visit https://groups.google.com/d/msgid/peewee-orm/ccc1c37a-f76b-4690-881e-d4af53da9e5bn%40googlegroups.com.

[Bin Lyu]

yes, So useful, i appreciate it very much.