Using Postgres, and results in failing tests.
/home/sm/PycharmProjects/REST-API/venv/bin/python /home/sm/PycharmProjects/REST-API/manage.py test
test_non_registered_user_login (test_auth.TestAuthBlueprint)
Test for login of non-registered user ... 2019-02-10 09:07:51,551 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1
2019-02-10 09:07:51,551 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,551 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1
2019-02-10 09:07:51,551 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,551 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("blacklist_tokens")
2019-02-10 09:07:51,551 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,552 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("api_users")
2019-02-10 09:07:51,552 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,552 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("discord_channels")
2019-02-10 09:07:51,552 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,552 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("discord_messages")
2019-02-10 09:07:51,552 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,552 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("Users_Profile")
2019-02-10 09:07:51,552 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,553 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("Users")
2019-02-10 09:07:51,553 INFO sqlalchemy.engine.base.Engine ()
ERROR
test_registered_user_login (test_auth.TestAuthBlueprint)
Test for login of registered-user login ... 2019-02-10 09:07:51,556 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("blacklist_tokens")
2019-02-10 09:07:51,556 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,557 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("api_users")
2019-02-10 09:07:51,557 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,557 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("discord_channels")
2019-02-10 09:07:51,557 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,557 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("discord_messages")
2019-02-10 09:07:51,557 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,557 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("Users_Profile")
2019-02-10 09:07:51,557 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,557 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("Users")
2019-02-10 09:07:51,557 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,559 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("blacklist_tokens")
2019-02-10 09:07:51,559 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,559 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("api_users")
2019-02-10 09:07:51,559 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,560 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("discord_channels")
2019-02-10 09:07:51,560 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,560 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("discord_messages")
2019-02-10 09:07:51,560 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,560 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("Users_Profile")
2019-02-10 09:07:51,560 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,560 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("Users")
2019-02-10 09:07:51,560 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,561 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("blacklist_tokens")
2019-02-10 09:07:51,562 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,562 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("api_users")
2019-02-10 09:07:51,562 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,562 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("discord_channels")
2019-02-10 09:07:51,562 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,562 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("discord_messages")
2019-02-10 09:07:51,562 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,562 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("Users_Profile")
2019-02-10 09:07:51,562 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,563 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("Users")
2019-02-10 09:07:51,563 INFO sqlalchemy.engine.base.Engine ()
ERROR
test_registered_with_already_registered_user (test_auth.TestAuthBlueprint)
Test registration with already registered email ... ERROR
test_registration (test_auth.TestAuthBlueprint)
Test for user registration ... ERROR
2019-02-10 09:07:51,564 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("blacklist_tokens")
2019-02-10 09:07:51,564 INFO sqlalchemy.engine.base.Engine ()
test_valid_blacklisted_token_logout (test_auth.TestAuthBlueprint)
Test for logout after a valid token gets blacklisted ... 2019-02-10 09:07:51,564 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("api_users")
2019-02-10 09:07:51,564 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,564 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("discord_channels")
2019-02-10 09:07:51,564 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,564 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("discord_messages")
2019-02-10 09:07:51,564 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,565 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("Users_Profile")
2019-02-10 09:07:51,565 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,565 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("Users")
2019-02-10 09:07:51,565 INFO sqlalchemy.engine.base.Engine ()
ERROR
2019-02-10 09:07:51,566 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("blacklist_tokens")
2019-02-10 09:07:51,566 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,566 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("api_users")
2019-02-10 09:07:51,566 INFO sqlalchemy.engine.base.Engine ()
test_valid_logout (test_auth.TestAuthBlueprint)
Test for logout before token expires ... 2019-02-10 09:07:51,566 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("discord_channels")
2019-02-10 09:07:51,567 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,567 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("discord_messages")
2019-02-10 09:07:51,567 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,567 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("Users_Profile")
2019-02-10 09:07:51,567 INFO sqlalchemy.engine.base.Engine ()
2019-02-10 09:07:51,567 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("Users")
2019-02-10 09:07:51,567 INFO sqlalchemy.engine.base.Engine ()
ERROR
test_app_is_development (test_config.TestDevelopmentConfig) ... ok
test_app_is_production (test_config.TestProductionConfig) ... ok
test_app_is_testing (test_config.TestTestingConfig) ... ok
test_decode_auth_token (test_user_medol.TestUserModel) ... ERROR
test_encode_auth_token (test_user_medol.TestUserModel) ... ERROR
======================================================================
ERROR: test_non_registered_user_login (test_auth.TestAuthBlueprint)
Test for login of non-registered user
----------------------------------------------------------------------
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 86, in _compiler_dispatch
meth = getter(visitor)
AttributeError: 'SQLiteTypeCompiler' object has no attribute 'visit_JSON'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2790, in visit_create_table
create_column, first_pk=column.primary_key and not first_pk
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2822, in visit_create_column
text = self.get_column_specification(column, first_pk=first_pk)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/dialects/sqlite/base.py", line 906, in get_column_specification
column.type, type_expression=column
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 391, in process
return type_._compiler_dispatch(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 88, in _compiler_dispatch
raise exc.UnsupportedCompilationError(visitor, cls)
sqlalchemy.exc.UnsupportedCompilationError: Compiler <sqlalchemy.dialects.sqlite.base.SQLiteTypeCompiler object at 0x7f6261350438> can't render element of type <class 'sqlalchemy.sql.sqltypes.JSON'>
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/app/test/base.py", line 14, in setUp
db.create_all()
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 963, in create_all
self._execute_for_all_tables(app, bind, 'create_all')
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 955, in _execute_for_all_tables
op(bind=self.get_engine(app, bind), **extra)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/schema.py", line 4200, in create_all
ddl.SchemaGenerator, self, checkfirst=checkfirst, tables=tables
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2011, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1599, in _run_visitor
visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
return meth(obj, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 779, in visit_metadata
_is_metadata_operation=True,
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
return meth(obj, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 824, in visit_table
include_foreign_key_constraints,
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 980, in execute
return meth(self, multiparams, params)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1035, in _execute_ddl
else None,
File "<string>", line 1, in <lambda>
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 448, in compile
return self._compiler(dialect, bind=bind, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 29, in _compiler
return dialect.ddl_compiler(dialect, self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 310, in __init__
self.string = self.process(self.statement, **compile_kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2802, in visit_create_table
% (table.description, column.name, ce.args[0])
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 276, in reraise
raise value.with_traceback(tb)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2790, in visit_create_table
create_column, first_pk=column.primary_key and not first_pk
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2822, in visit_create_column
text = self.get_column_specification(column, first_pk=first_pk)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/dialects/sqlite/base.py", line 906, in get_column_specification
column.type, type_expression=column
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 391, in process
return type_._compiler_dispatch(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 88, in _compiler_dispatch
raise exc.UnsupportedCompilationError(visitor, cls)
sqlalchemy.exc.CompileError: (in table 'Users', column 'Roles'): Compiler <sqlalchemy.dialects.sqlite.base.SQLiteTypeCompiler object at 0x7f6261350438> can't render element of type <class 'sqlalchemy.sql.sqltypes.JSON'>
======================================================================
ERROR: test_registered_user_login (test_auth.TestAuthBlueprint)
Test for login of registered-user login
----------------------------------------------------------------------
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 86, in _compiler_dispatch
meth = getter(visitor)
AttributeError: 'SQLiteTypeCompiler' object has no attribute 'visit_JSON'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2790, in visit_create_table
create_column, first_pk=column.primary_key and not first_pk
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2822, in visit_create_column
text = self.get_column_specification(column, first_pk=first_pk)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/dialects/sqlite/base.py", line 906, in get_column_specification
column.type, type_expression=column
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 391, in process
return type_._compiler_dispatch(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 88, in _compiler_dispatch
raise exc.UnsupportedCompilationError(visitor, cls)
sqlalchemy.exc.UnsupportedCompilationError: Compiler <sqlalchemy.dialects.sqlite.base.SQLiteTypeCompiler object at 0x7f6261350438> can't render element of type <class 'sqlalchemy.sql.sqltypes.JSON'>
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/app/test/base.py", line 14, in setUp
db.create_all()
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 963, in create_all
self._execute_for_all_tables(app, bind, 'create_all')
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 955, in _execute_for_all_tables
op(bind=self.get_engine(app, bind), **extra)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/schema.py", line 4200, in create_all
ddl.SchemaGenerator, self, checkfirst=checkfirst, tables=tables
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2011, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1599, in _run_visitor
visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
return meth(obj, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 779, in visit_metadata
_is_metadata_operation=True,
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
return meth(obj, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 824, in visit_table
include_foreign_key_constraints,
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 980, in execute
return meth(self, multiparams, params)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1035, in _execute_ddl
else None,
File "<string>", line 1, in <lambda>
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 448, in compile
return self._compiler(dialect, bind=bind, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 29, in _compiler
return dialect.ddl_compiler(dialect, self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 310, in __init__
self.string = self.process(self.statement, **compile_kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2802, in visit_create_table
% (table.description, column.name, ce.args[0])
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 276, in reraise
raise value.with_traceback(tb)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2790, in visit_create_table
create_column, first_pk=column.primary_key and not first_pk
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2822, in visit_create_column
text = self.get_column_specification(column, first_pk=first_pk)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/dialects/sqlite/base.py", line 906, in get_column_specification
column.type, type_expression=column
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 391, in process
return type_._compiler_dispatch(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 88, in _compiler_dispatch
raise exc.UnsupportedCompilationError(visitor, cls)
sqlalchemy.exc.CompileError: (in table 'Users', column 'Roles'): Compiler <sqlalchemy.dialects.sqlite.base.SQLiteTypeCompiler object at 0x7f6261350438> can't render element of type <class 'sqlalchemy.sql.sqltypes.JSON'>
======================================================================
ERROR: test_registered_with_already_registered_user (test_auth.TestAuthBlueprint)
Test registration with already registered email
----------------------------------------------------------------------
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 86, in _compiler_dispatch
meth = getter(visitor)
AttributeError: 'SQLiteTypeCompiler' object has no attribute 'visit_JSON'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2790, in visit_create_table
create_column, first_pk=column.primary_key and not first_pk
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2822, in visit_create_column
text = self.get_column_specification(column, first_pk=first_pk)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/dialects/sqlite/base.py", line 906, in get_column_specification
column.type, type_expression=column
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 391, in process
return type_._compiler_dispatch(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 88, in _compiler_dispatch
raise exc.UnsupportedCompilationError(visitor, cls)
sqlalchemy.exc.UnsupportedCompilationError: Compiler <sqlalchemy.dialects.sqlite.base.SQLiteTypeCompiler object at 0x7f6261350438> can't render element of type <class 'sqlalchemy.sql.sqltypes.JSON'>
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/app/test/base.py", line 14, in setUp
db.create_all()
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 963, in create_all
self._execute_for_all_tables(app, bind, 'create_all')
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 955, in _execute_for_all_tables
op(bind=self.get_engine(app, bind), **extra)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/schema.py", line 4200, in create_all
ddl.SchemaGenerator, self, checkfirst=checkfirst, tables=tables
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2011, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1599, in _run_visitor
visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
return meth(obj, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 779, in visit_metadata
_is_metadata_operation=True,
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
return meth(obj, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 824, in visit_table
include_foreign_key_constraints,
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 980, in execute
return meth(self, multiparams, params)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1035, in _execute_ddl
else None,
File "<string>", line 1, in <lambda>
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 448, in compile
return self._compiler(dialect, bind=bind, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 29, in _compiler
return dialect.ddl_compiler(dialect, self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 310, in __init__
self.string = self.process(self.statement, **compile_kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2802, in visit_create_table
% (table.description, column.name, ce.args[0])
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 276, in reraise
raise value.with_traceback(tb)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2790, in visit_create_table
create_column, first_pk=column.primary_key and not first_pk
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2822, in visit_create_column
text = self.get_column_specification(column, first_pk=first_pk)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/dialects/sqlite/base.py", line 906, in get_column_specification
column.type, type_expression=column
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 391, in process
return type_._compiler_dispatch(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 88, in _compiler_dispatch
raise exc.UnsupportedCompilationError(visitor, cls)
sqlalchemy.exc.CompileError: (in table 'Users', column 'Roles'): Compiler <sqlalchemy.dialects.sqlite.base.SQLiteTypeCompiler object at 0x7f6261350438> can't render element of type <class 'sqlalchemy.sql.sqltypes.JSON'>
======================================================================
ERROR: test_registration (test_auth.TestAuthBlueprint)
Test for user registration
----------------------------------------------------------------------
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 86, in _compiler_dispatch
meth = getter(visitor)
AttributeError: 'SQLiteTypeCompiler' object has no attribute 'visit_JSON'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2790, in visit_create_table
create_column, first_pk=column.primary_key and not first_pk
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2822, in visit_create_column
text = self.get_column_specification(column, first_pk=first_pk)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/dialects/sqlite/base.py", line 906, in get_column_specification
column.type, type_expression=column
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 391, in process
return type_._compiler_dispatch(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 88, in _compiler_dispatch
raise exc.UnsupportedCompilationError(visitor, cls)
sqlalchemy.exc.UnsupportedCompilationError: Compiler <sqlalchemy.dialects.sqlite.base.SQLiteTypeCompiler object at 0x7f6261350438> can't render element of type <class 'sqlalchemy.sql.sqltypes.JSON'>
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/app/test/base.py", line 14, in setUp
db.create_all()
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 963, in create_all
self._execute_for_all_tables(app, bind, 'create_all')
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 955, in _execute_for_all_tables
op(bind=self.get_engine(app, bind), **extra)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/schema.py", line 4200, in create_all
ddl.SchemaGenerator, self, checkfirst=checkfirst, tables=tables
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2011, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1599, in _run_visitor
visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
return meth(obj, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 779, in visit_metadata
_is_metadata_operation=True,
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
return meth(obj, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 824, in visit_table
include_foreign_key_constraints,
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 980, in execute
return meth(self, multiparams, params)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1035, in _execute_ddl
else None,
File "<string>", line 1, in <lambda>
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 448, in compile
return self._compiler(dialect, bind=bind, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 29, in _compiler
return dialect.ddl_compiler(dialect, self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 310, in __init__
self.string = self.process(self.statement, **compile_kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2802, in visit_create_table
% (table.description, column.name, ce.args[0])
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 276, in reraise
raise value.with_traceback(tb)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2790, in visit_create_table
create_column, first_pk=column.primary_key and not first_pk
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2822, in visit_create_column
text = self.get_column_specification(column, first_pk=first_pk)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/dialects/sqlite/base.py", line 906, in get_column_specification
column.type, type_expression=column
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 391, in process
return type_._compiler_dispatch(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 88, in _compiler_dispatch
raise exc.UnsupportedCompilationError(visitor, cls)
sqlalchemy.exc.CompileError: (in table 'Users', column 'Roles'): Compiler <sqlalchemy.dialects.sqlite.base.SQLiteTypeCompiler object at 0x7f6261350438> can't render element of type <class 'sqlalchemy.sql.sqltypes.JSON'>
======================================================================
ERROR: test_valid_blacklisted_token_logout (test_auth.TestAuthBlueprint)
Test for logout after a valid token gets blacklisted
----------------------------------------------------------------------
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 86, in _compiler_dispatch
meth = getter(visitor)
AttributeError: 'SQLiteTypeCompiler' object has no attribute 'visit_JSON'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2790, in visit_create_table
create_column, first_pk=column.primary_key and not first_pk
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2822, in visit_create_column
text = self.get_column_specification(column, first_pk=first_pk)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/dialects/sqlite/base.py", line 906, in get_column_specification
column.type, type_expression=column
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 391, in process
return type_._compiler_dispatch(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 88, in _compiler_dispatch
raise exc.UnsupportedCompilationError(visitor, cls)
sqlalchemy.exc.UnsupportedCompilationError: Compiler <sqlalchemy.dialects.sqlite.base.SQLiteTypeCompiler object at 0x7f6261350438> can't render element of type <class 'sqlalchemy.sql.sqltypes.JSON'>
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/app/test/base.py", line 14, in setUp
db.create_all()
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 963, in create_all
self._execute_for_all_tables(app, bind, 'create_all')
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 955, in _execute_for_all_tables
op(bind=self.get_engine(app, bind), **extra)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/schema.py", line 4200, in create_all
ddl.SchemaGenerator, self, checkfirst=checkfirst, tables=tables
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2011, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1599, in _run_visitor
visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
return meth(obj, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 779, in visit_metadata
_is_metadata_operation=True,
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
return meth(obj, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 824, in visit_table
include_foreign_key_constraints,
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 980, in execute
return meth(self, multiparams, params)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1035, in _execute_ddl
else None,
File "<string>", line 1, in <lambda>
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 448, in compile
return self._compiler(dialect, bind=bind, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 29, in _compiler
return dialect.ddl_compiler(dialect, self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 310, in __init__
self.string = self.process(self.statement, **compile_kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2802, in visit_create_table
% (table.description, column.name, ce.args[0])
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 276, in reraise
raise value.with_traceback(tb)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2790, in visit_create_table
create_column, first_pk=column.primary_key and not first_pk
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2822, in visit_create_column
text = self.get_column_specification(column, first_pk=first_pk)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/dialects/sqlite/base.py", line 906, in get_column_specification
column.type, type_expression=column
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 391, in process
return type_._compiler_dispatch(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 88, in _compiler_dispatch
raise exc.UnsupportedCompilationError(visitor, cls)
sqlalchemy.exc.CompileError: (in table 'Users', column 'Roles'): Compiler <sqlalchemy.dialects.sqlite.base.SQLiteTypeCompiler object at 0x7f6261350438> can't render element of type <class 'sqlalchemy.sql.sqltypes.JSON'>
======================================================================
ERROR: test_valid_logout (test_auth.TestAuthBlueprint)
Test for logout before token expires
----------------------------------------------------------------------
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 86, in _compiler_dispatch
meth = getter(visitor)
AttributeError: 'SQLiteTypeCompiler' object has no attribute 'visit_JSON'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2790, in visit_create_table
create_column, first_pk=column.primary_key and not first_pk
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2822, in visit_create_column
text = self.get_column_specification(column, first_pk=first_pk)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/dialects/sqlite/base.py", line 906, in get_column_specification
column.type, type_expression=column
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 391, in process
return type_._compiler_dispatch(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 88, in _compiler_dispatch
raise exc.UnsupportedCompilationError(visitor, cls)
sqlalchemy.exc.UnsupportedCompilationError: Compiler <sqlalchemy.dialects.sqlite.base.SQLiteTypeCompiler object at 0x7f6261350438> can't render element of type <class 'sqlalchemy.sql.sqltypes.JSON'>
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/app/test/base.py", line 14, in setUp
db.create_all()
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 963, in create_all
self._execute_for_all_tables(app, bind, 'create_all')
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 955, in _execute_for_all_tables
op(bind=self.get_engine(app, bind), **extra)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/schema.py", line 4200, in create_all
ddl.SchemaGenerator, self, checkfirst=checkfirst, tables=tables
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2011, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1599, in _run_visitor
visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
return meth(obj, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 779, in visit_metadata
_is_metadata_operation=True,
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
return meth(obj, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 824, in visit_table
include_foreign_key_constraints,
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 980, in execute
return meth(self, multiparams, params)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1035, in _execute_ddl
else None,
File "<string>", line 1, in <lambda>
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 448, in compile
return self._compiler(dialect, bind=bind, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 29, in _compiler
return dialect.ddl_compiler(dialect, self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 310, in __init__
self.string = self.process(self.statement, **compile_kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2802, in visit_create_table
% (table.description, column.name, ce.args[0])
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 276, in reraise
raise value.with_traceback(tb)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2790, in visit_create_table
create_column, first_pk=column.primary_key and not first_pk
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2822, in visit_create_column
text = self.get_column_specification(column, first_pk=first_pk)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/dialects/sqlite/base.py", line 906, in get_column_specification
column.type, type_expression=column
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 391, in process
return type_._compiler_dispatch(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 88, in _compiler_dispatch
raise exc.UnsupportedCompilationError(visitor, cls)
sqlalchemy.exc.CompileError: (in table 'Users', column 'Roles'): Compiler <sqlalchemy.dialects.sqlite.base.SQLiteTypeCompiler object at 0x7f6261350438> can't render element of type <class 'sqlalchemy.sql.sqltypes.JSON'>
======================================================================
ERROR: test_decode_auth_token (test_user_medol.TestUserModel)
----------------------------------------------------------------------
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 86, in _compiler_dispatch
meth = getter(visitor)
AttributeError: 'SQLiteTypeCompiler' object has no attribute 'visit_JSON'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2790, in visit_create_table
create_column, first_pk=column.primary_key and not first_pk
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2822, in visit_create_column
text = self.get_column_specification(column, first_pk=first_pk)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/dialects/sqlite/base.py", line 906, in get_column_specification
column.type, type_expression=column
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 391, in process
return type_._compiler_dispatch(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 88, in _compiler_dispatch
raise exc.UnsupportedCompilationError(visitor, cls)
sqlalchemy.exc.UnsupportedCompilationError: Compiler <sqlalchemy.dialects.sqlite.base.SQLiteTypeCompiler object at 0x7f6261340a90> can't render element of type <class 'sqlalchemy.sql.sqltypes.JSON'>
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/app/test/base.py", line 14, in setUp
db.create_all()
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 963, in create_all
self._execute_for_all_tables(app, bind, 'create_all')
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 955, in _execute_for_all_tables
op(bind=self.get_engine(app, bind), **extra)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/schema.py", line 4200, in create_all
ddl.SchemaGenerator, self, checkfirst=checkfirst, tables=tables
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2011, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1599, in _run_visitor
visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
return meth(obj, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 779, in visit_metadata
_is_metadata_operation=True,
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
return meth(obj, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 824, in visit_table
include_foreign_key_constraints,
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 980, in execute
return meth(self, multiparams, params)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1035, in _execute_ddl
else None,
File "<string>", line 1, in <lambda>
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 448, in compile
return self._compiler(dialect, bind=bind, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 29, in _compiler
return dialect.ddl_compiler(dialect, self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 310, in __init__
self.string = self.process(self.statement, **compile_kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2802, in visit_create_table
% (table.description, column.name, ce.args[0])
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 276, in reraise
raise value.with_traceback(tb)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2790, in visit_create_table
create_column, first_pk=column.primary_key and not first_pk
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2822, in visit_create_column
text = self.get_column_specification(column, first_pk=first_pk)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/dialects/sqlite/base.py", line 906, in get_column_specification
column.type, type_expression=column
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 391, in process
return type_._compiler_dispatch(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 88, in _compiler_dispatch
raise exc.UnsupportedCompilationError(visitor, cls)
sqlalchemy.exc.CompileError: (in table 'Users', column 'Roles'): Compiler <sqlalchemy.dialects.sqlite.base.SQLiteTypeCompiler object at 0x7f6261340a90> can't render element of type <class 'sqlalchemy.sql.sqltypes.JSON'>
======================================================================
ERROR: test_encode_auth_token (test_user_medol.TestUserModel)
----------------------------------------------------------------------
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 86, in _compiler_dispatch
meth = getter(visitor)
AttributeError: 'SQLiteTypeCompiler' object has no attribute 'visit_JSON'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2790, in visit_create_table
create_column, first_pk=column.primary_key and not first_pk
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2822, in visit_create_column
text = self.get_column_specification(column, first_pk=first_pk)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/dialects/sqlite/base.py", line 906, in get_column_specification
column.type, type_expression=column
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 391, in process
return type_._compiler_dispatch(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 88, in _compiler_dispatch
raise exc.UnsupportedCompilationError(visitor, cls)
sqlalchemy.exc.UnsupportedCompilationError: Compiler <sqlalchemy.dialects.sqlite.base.SQLiteTypeCompiler object at 0x7f6261340a90> can't render element of type <class 'sqlalchemy.sql.sqltypes.JSON'>
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/sm/PycharmProjects/REST-API/app/test/base.py", line 14, in setUp
db.create_all()
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 963, in create_all
self._execute_for_all_tables(app, bind, 'create_all')
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 955, in _execute_for_all_tables
op(bind=self.get_engine(app, bind), **extra)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/schema.py", line 4200, in create_all
ddl.SchemaGenerator, self, checkfirst=checkfirst, tables=tables
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2011, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1599, in _run_visitor
visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
return meth(obj, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 779, in visit_metadata
_is_metadata_operation=True,
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 130, in traverse_single
return meth(obj, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 824, in visit_table
include_foreign_key_constraints,
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 980, in execute
return meth(self, multiparams, params)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1035, in _execute_ddl
else None,
File "<string>", line 1, in <lambda>
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 448, in compile
return self._compiler(dialect, bind=bind, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 29, in _compiler
return dialect.ddl_compiler(dialect, self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 310, in __init__
self.string = self.process(self.statement, **compile_kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2802, in visit_create_table
% (table.description, column.name, ce.args[0])
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 276, in reraise
raise value.with_traceback(tb)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2790, in visit_create_table
create_column, first_pk=column.primary_key and not first_pk
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 341, in process
return obj._compiler_dispatch(self, **kwargs)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch
return meth(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 2822, in visit_create_column
text = self.get_column_specification(column, first_pk=first_pk)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/dialects/sqlite/base.py", line 906, in get_column_specification
column.type, type_expression=column
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/compiler.py", line 391, in process
return type_._compiler_dispatch(self, **kw)
File "/home/sm/PycharmProjects/REST-API/venv/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 88, in _compiler_dispatch
raise exc.UnsupportedCompilationError(visitor, cls)
sqlalchemy.exc.CompileError: (in table 'Users', column 'Roles'): Compiler <sqlalchemy.dialects.sqlite.base.SQLiteTypeCompiler object at 0x7f6261340a90> can't render element of type <class 'sqlalchemy.sql.sqltypes.JSON'>
----------------------------------------------------------------------
Ran 11 tests in 0.029s
FAILED (errors=8)
Process finished with exit code 1