how to search in tinydb?

[elamandeep]

https://pastebin.com/embed_js/fFksPTm8?theme=dark

This is my pastebin of json and I want to search element inside "patterns" using tinyDB. Also if search item found then it will return me index of object

[msiemens]

Hey @elamandeep,

your pastebin link seems to have expired. Could you post the JSON here? Either in a comment or you can upload it as an attachment

[elamandeep]

Here's the json file. I want to search inside patterns when user enters a desired sentence return back me random response .

Suppose a user enter a sentence Hi! I am Aman Deep.
Then It will search every word from that sentence and try to match each word with patterns of json.
And if it finds then generate random response. Are you getting my points or not?

{
    "_default": {
        "1": {
            "tag": "greeting",
            "patterns": [
                "Hi",
                "How are you",
                "Is anyone there?",
                "Hello",
                "Good day",
                "Whats up",
                "Hey",
                "greetings",
                "hloo"
            ],
            "responses": [
                "Hello!",
                "Good to see you again!",
                "Hi there, how can I help?"
            ]
        },
        "2": {
            "tag": "help",
            "patterns": [
                "help",
                "?",
                "need help",
                "aman",
                "amit"
            ],
            "responses": [
                "I am forwarding your message to core team @Core.",
                "@elamandeep is not online . But I will notify him."
            ]
        },
        "3": {
            "tag": "goodbye",
            "patterns": [
                "cya",
                "See you later",
                "Goodbye",
                "I am Leaving",
                "Have a Good day",
                "bye",
                "cao",
                "see ya"
            ],
            "responses": [
                "Sad to see you go :(",
                "Talk to you later",
                "Goodbye!"
            ]
        }
    }
}

[msiemens]

The any query operator will return the object where patterns contains a specific entry:

>>> print(db.search(Query().patterns.any('Hi')))
[{'tag': 'greeting', 'patterns': ['Hi', 'How are you', 'Is anyone there?', 'Hello', 'Good day', 'Whats up', 'Hey', 'greetings', 'hloo'], 'responses': ['Hello!', 'Good to see you again!', 'Hi there, how can I help?']}]
>>> print(db.search(Query().patterns.any('help')))
[{'tag': 'help', 'patterns': ['help', '?', 'need help', 'aman', 'amit'], 'responses': ['I am forwarding your message to core team @Core.', '@elamandeep is not online . But I will notify him.']}]
>>> print(db.search(Query().patterns.any('cya')))
[{'tag': 'goodbye', 'patterns': ['cya', 'See you later', 'Goodbye', 'I am Leaving', 'Have a Good day', 'bye', 'cao', 'see ya'], 'responses': ['Sad to see you go :(', 'Talk to you later', 'Goodbye!']}]

Also if search item found then it will return me index of object

This is not possible with TinyDB. But you can of course process the search result yourself:

doc = db.get(Query().patterns.any('Hi'))  # use `.get` to get the first result
print(doc['patterns'].index('How are you'))