Error parsing GraphQL query: query parse error: Unexpected -1[IntValue] Expected : while writing json to database

[simondpalmer]

I am trying to write json to my prisma database on supabase but I get the following error:

File "C:\Users\Simon Palmer\Documents\Programming\ideally_app\api\main.py", line 862, in discover
    isComplete = save_results(user_id, lot_id, loaded_edges_collection ,results)
  File "C:\Users\Simon Palmer\Documents\Programming\ideally_app\api\main.py", line 337, in save_results
    upload = db.lotinterest.update(
  File "C:\Users\Simon Palmer\AppData\Local\Programs\Python\Python310\lib\site-packages\prisma\actions.py", line 5226, in update
    resp = self._client._execute(
  File "C:\Users\Simon Palmer\AppData\Local\Programs\Python\Python310\lib\site-packages\prisma\client.py", line 378, in _execute
    return self._engine.query(builder.build())
  File "C:\Users\Simon Palmer\AppData\Local\Programs\Python\Python310\lib\site-packages\prisma\engine\query.py", line 219, in query
    return self.request('POST', '/', content=content)
  File "C:\Users\Simon Palmer\AppData\Local\Programs\Python\Python310\lib\site-packages\prisma\engine\http.py", line 112, in request
    return utils.handle_response_errors(resp, errors_data)
  File "C:\Users\Simon Palmer\AppData\Local\Programs\Python\Python310\lib\site-packages\prisma\engine\utils.py", line 174, in handle_response_errors
    raise prisma_errors.DataError(data[0])

prisma.errors.DataError: Error parsing GraphQL query: query parse error: Parse error at 23:25
Unexpected `-1[IntValue]`
Expected `:`

[simondpalmer]

I worked it out. I was forgetting to

 json.dumps(my_object)

[RobertCraigie]

You can also wrap your data using Json, e.g.

from prisma import Json

data = Json({'foo': 'bar'})
# ... pass to query

This has the advantage of supporting serialisation of objects that aren't supported by the standard library json, e.g. datetime.