webdeveloppro / aiohttp_boilerplate Goto Github PK

2018-10-09 15:30:33,387 ERROR Task exception was never retrieved
future: <Task finished coro=<worker_check_payments() done, defined at /Users/arti/Desktop/projects/webdeveloppro/acretrader/northcapital/console/northcapital.py:197> exception=SQLException('Missing parameters {Pending,Submitted}')>
Traceback (most recent call last):
  File "/Users/arti/Desktop/projects/webdeveloppro/acretrader/northcapital/console/northcapital.py", line 203, in worker_check_payments
    for x in await Investment.get_ach_pending():
  File "/Users/arti/Desktop/projects/webdeveloppro/acretrader/northcapital/console/models.py", line 32, in get_ach_pending
    where="payment_data->>'method' = 'ACH' and created_date >  NOW() - INTERVAL '1 month' and status >= 20 and "
  File "/Users/arti/Desktop/projects/webdeveloppro/acretrader/northcapital/aiohttp_boilerplate/models/__init__.py", line 130, in select
    params=params, many=self.is_list)
  File "/Users/arti/Desktop/projects/webdeveloppro/acretrader/northcapital/aiohttp_boilerplate/sql/__init__.py", line 98, in select
    self.query += ' where {}'.format(self.prepare_where(where, params))
  File "/Users/arti/Desktop/projects/webdeveloppro/acretrader/northcapital/aiohttp_boilerplate/sql/__init__.py", line 49, in prepare_where
    raise SQLException('Missing parameters {}'.format(','.join(missing_params)))
aiohttp_boilerplate.sql.SQLException: Missing parameters {Pending,Submitted}

invalid input for query argument $2: {'as': 'asdas123'} (expected str, got dict)