Skip to content

Instantly share code, notes, and snippets.

@Xevion
Created July 22, 2020 15:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Xevion/b261d5c39ca290c4ff1687693d38de6e to your computer and use it in GitHub Desktop.
Save Xevion/b261d5c39ca290c4ff1687693d38de6e to your computer and use it in GitHub Desktop.
Traceback (most recent call last):
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\engine\base.py", line 1205, in _execute_context
context = constructor(dialect, self, conn, *args)
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\engine\default.py", line 865, in _init_compiled
for key in compiled_params
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\engine\default.py", line 865, in <genexpr>
for key in compiled_params
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\sql\sqltypes.py", line 2425, in process
serialized = json_serializer(value)
File "C:\Python37\lib\json\__init__.py", line 231, in dumps
return _default_encoder.encode(obj)
File "C:\Python37\lib\json\encoder.py", line 199, in encode
chunks = self.iterencode(o, _one_shot=True)
File "C:\Python37\lib\json\encoder.py", line 257, in iterencode
return _iterencode(o, 0)
File "C:\Python37\lib\json\encoder.py", line 179, in default
raise TypeError(f'Object of type {o.__class__.__name__} '
TypeError: Object of type College is not JSON serializable
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\flask\app.py", line 2464, in __call__
return self.wsgi_app(environ, start_response)
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sassutils\wsgi.py", line 170, in __call__
return self.app(environ, start_response)
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\flask\app.py", line 2450, in wsgi_app
response = self.handle_exception(e)
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\flask\app.py", line 1867, in handle_exception
reraise(exc_type, exc_value, tb)
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\flask\_compat.py", line 39, in reraise
raise value
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\flask\app.py", line 2447, in wsgi_app
response = self.full_dispatch_request()
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\flask\app.py", line 1952, in full_dispatch_request
rv = self.handle_user_exception(e)
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\flask\app.py", line 1821, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\flask\_compat.py", line 39, in reraise
raise value
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\flask\app.py", line 1950, in full_dispatch_request
rv = self.dispatch_request()
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\flask\app.py", line 1936, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "F:\Programming\Python\Projects\unimatch\unimatch\routes.py", line 107, in quiz_submit
db.session.commit()
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\orm\scoping.py", line 163, in do
return getattr(self.registry(), name)(*args, **kwargs)
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\orm\session.py", line 1042, in commit
self.transaction.commit()
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\orm\session.py", line 504, in commit
self._prepare_impl()
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\orm\session.py", line 483, in _prepare_impl
self.session.flush()
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\orm\session.py", line 2523, in flush
self._flush(objects)
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\orm\session.py", line 2664, in _flush
transaction.rollback(_capture_exception=True)
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\util\langhelpers.py", line 69, in __exit__
exc_value, with_traceback=exc_tb,
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\util\compat.py", line 178, in raise_
raise exception
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\orm\session.py", line 2624, in _flush
flush_context.execute()
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 422, in execute
rec.execute(self)
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 589, in execute
uow,
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\orm\persistence.py", line 245, in save_obj
insert,
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\orm\persistence.py", line 1136, in _emit_insert_statements
statement, params
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\engine\base.py", line 1014, in execute
return meth(self, multiparams, params)
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\engine\base.py", line 1133, in _execute_clauseelement
distilled_params,
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\engine\base.py", line 1208, in _execute_context
e, util.text_type(statement), parameters, None, None
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\engine\base.py", line 1512, in _handle_dbapi_exception
sqlalchemy_exception, with_traceback=exc_info[2], from_=e
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\util\compat.py", line 178, in raise_
raise exception
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\engine\base.py", line 1205, in _execute_context
context = constructor(dialect, self, conn, *args)
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\engine\default.py", line 865, in _init_compiled
for key in compiled_params
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\engine\default.py", line 865, in <genexpr>
for key in compiled_params
File "C:\Users\Xevion\.virtualenvs\unimatch\lib\site-packages\sqlalchemy\sql\sqltypes.py", line 2425, in process
serialized = json_serializer(value)
File "C:\Python37\lib\json\__init__.py", line 231, in dumps
return _default_encoder.encode(obj)
File "C:\Python37\lib\json\encoder.py", line 199, in encode
chunks = self.iterencode(o, _one_shot=True)
File "C:\Python37\lib\json\encoder.py", line 257, in iterencode
return _iterencode(o, 0)
File "C:\Python37\lib\json\encoder.py", line 179, in default
raise TypeError(f'Object of type {o.__class__.__name__} '
sqlalchemy.exc.StatementError: (builtins.TypeError) Object of type College is not JSON serializable
[SQL: INSERT INTO quiz_result (uuid, response_id, date_created, date_updated, colleges) VALUES (%(uuid)s, %(response_id)s, %(date_created)s, %(date_updated)s, %(colleges)s)]
[parameters: [{'colleges': [[<College vt>, <College usd>, <College cwru>, <College lu>, <College columbia>]], 'response_id': 1}]]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment