[HTTP Error 400: Bad Request] - Setup QUERY into a variable

[lonardonifabio]

Hello,

I've this code:

if selected == "Search": with st.form("Search"): request = st.text_input("Ready to start your news search?","Insert keywords with boolean operators") submitted2 = st.form_submit_button("Search") if submitted2: req = word_tokenize(request) start = '{' core = '"keyword?contains": ' end = '}' query_full = start+core for i in req: if i.lower() == "and": query = ","+core query_full = query_full+query elif i.lower() == "or": query = end+","+start+core query_full = query_full+query elif i.lower() != "or" or i.lower() == "and": query = '"'+i+'"' query_full = query_full+query query_full = "["+query_full+end+"]" x = Articles_Keywords(query_full) st.write(x)

and this is the function:

def Articles_Keywords(query_full): res = db.fetch(query_full) return res.items

This is the error I get it:

2023-01-25 22:06:36.135 Uncaught app exception Traceback (most recent call last): File "/home/appuser/venv/lib/python3.10/site-packages/streamlit/runtime/scriptrunner/script_runner.py", line 565, in _run_script exec(code, module.__dict__) File "/app/aihypernews/news.py", line 186, in <module> x = Articles_Keywords(query_full) File "/app/aihypernews/news.py", line 78, in Articles_Keywords res = db.fetch(query_full) File "/home/appuser/venv/lib/python3.10/site-packages/deta/base.py", line 203, in fetch _, res = self._fetch(query, limit, last) File "/home/appuser/venv/lib/python3.10/site-packages/deta/base.py", line 189, in _fetch code, res = self._request("/query", "POST", payload, content_type=JSON_MIME) File "/home/appuser/venv/lib/python3.10/site-packages/deta/service.py", line 85, in _request raise urllib.error.HTTPError(url, status, res.reason, res.headers, res.fp) urllib.error.HTTPError: HTTP Error 400: Bad Request

How can I fix this issue?

This is a test I did:

1. In the webpage, in the input box I write this string: egypt and book or bike.
2. Query_full = [{"keyword?contains": "egypt","keyword?contains": "book"},{"keyword?contains": "bike"}]
3. This test generates the query in the proper way, it works.

it seems that the issue is likely with the way the query is being passed to the db.fetch() method.

How can I fix this issue?

[lonardonifabio]

If I do like this:

Function:
def Articles_Keywords(query_full): res = db.fetch(query_full) return res.items

Main:
query_full = '[{"keyword?contains": "egypt","keyword?contains": "book"},{"keyword?contains": "bike"}]' st.write = query_full x = Articles_Keywords(query_full)

I get the same error.
Query is correct because If I do like the following it works:

res = db.fetch([{"keyword?contains": "egypt","keyword?contains": "book"},{"keyword?contains": "bike"}])

Please support me, I need to pass the query because everytime the query can change and I need to pass it by a variable.
it seems that the issue is likely with the way the query is being passed to the db.fetch() method.

[lonardonifabio]

Ok it's solved, it is enough call the variable with json.loads