Skip to content

Instantly share code, notes, and snippets.

@alisonamerico

alisonamerico/tests_snowman.py

Created August 7, 2020 14:09
Show Gist options
  • Save alisonamerico/d69c05d342733a3f978f1cca3ff530b1 to your computer and use it in GitHub Desktop.
Save alisonamerico/d69c05d342733a3f978f1cca3ff530b1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
tests_snowman.py
snowman on  126 is 📦 v0.1.0 via 🐍 v3.8.3
❯ docker-compose exec web pytest
========================================================================= test session starts =========================================================================
platform linux -- Python 3.8.5, pytest-6.0.0, py-1.9.0, pluggy-0.13.1
django: settings: touristspots.settings (from ini)
rootdir: /code, configfile: pytest.ini
plugins: cov-2.10.0, django-3.9.0
collected 18 items
touristspots/api/tests/test_api.py ......EE.. [ 55%]
touristspots/base/tests/test_home.py ..... [ 83%]
touristspots/base/tests/test_urls.py . [ 88%]
touristspots/base/tests/test_wsgi.py .. [100%]
=============================================================================== ERRORS ================================================================================
______________________________________________________________ ERROR at setup of test_update_touristpot _______________________________________________________________
self = <django.db.backends.utils.CursorWrapper object at 0x7f787dc20100>
sql = 'INSERT INTO "api_touristspot" ("name", "geographical_location", "category", "owner_id", "created", "modified") VALUES (%s, %s, %s, %s, %s, %s) RETURNING "api_touristspot"."id"'
params = ('', <django.contrib.gis.db.backends.postgis.adapter.PostGISAdapter object at 0x7f787dc13df0>, '', None, datetime.datetime(2020, 8, 7, 14, 8, 21, 554551, tzinfo=<UTC>), datetime.datetime(2020, 8, 7, 14, 8, 21, 554590, tzinfo=<UTC>))
ignored_wrapper_args = (False, {'connection': <django.contrib.gis.db.backends.postgis.base.DatabaseWrapper object at 0x7f78898c0310>, 'cursor': <django.db.backends.utils.CursorWrapper object at 0x7f787dc20100>})
def _execute(self, sql, params, *ignored_wrapper_args):
self.db.validate_no_broken_transaction()
with self.db.wrap_database_errors:
if params is None:
# params default might be backend specific.
return self.cursor.execute(sql)
else:
> return self.cursor.execute(sql, params)
E psycopg2.errors.NotNullViolation: null value in column "owner_id" violates not-null constraint
E DETAIL: Failing row contains (2, , 0101000020E610000000000000000000000000000000000000, , 2020-08-07 14:08:21.554551+00, 2020-08-07 14:08:21.55459+00, null).
/usr/local/lib/python3.8/site-packages/django/db/backends/utils.py:86: NotNullViolation
The above exception was the direct cause of the following exception:
> ???
/home/alison/Workspace/snowman/touristspots/api/tests/test_api.py:89:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
/usr/local/lib/python3.8/site-packages/django/db/models/manager.py:82: in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
/usr/local/lib/python3.8/site-packages/django/db/models/query.py:433: in create
obj.save(force_insert=True, using=self.db)
/usr/local/lib/python3.8/site-packages/django/db/models/base.py:745: in save
self.save_base(using=using, force_insert=force_insert,
/usr/local/lib/python3.8/site-packages/django/db/models/base.py:782: in save_base
updated = self._save_table(
/usr/local/lib/python3.8/site-packages/django/db/models/base.py:887: in _save_table
results = self._do_insert(cls._base_manager, using, fields, returning_fields, raw)
/usr/local/lib/python3.8/site-packages/django/db/models/base.py:924: in _do_insert
return manager._insert(
/usr/local/lib/python3.8/site-packages/django/db/models/manager.py:82: in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
/usr/local/lib/python3.8/site-packages/django/db/models/query.py:1204: in _insert
return query.get_compiler(using=using).execute_sql(returning_fields)
/usr/local/lib/python3.8/site-packages/django/db/models/sql/compiler.py:1392: in execute_sql
cursor.execute(sql, params)
/usr/local/lib/python3.8/site-packages/django/db/backends/utils.py:68: in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
/usr/local/lib/python3.8/site-packages/django/db/backends/utils.py:77: in _execute_with_wrappers
return executor(sql, params, many, context)
/usr/local/lib/python3.8/site-packages/django/db/backends/utils.py:86: in _execute
return self.cursor.execute(sql, params)
/usr/local/lib/python3.8/site-packages/django/db/utils.py:90: in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
self = <django.db.backends.utils.CursorWrapper object at 0x7f787dc20100>
sql = 'INSERT INTO "api_touristspot" ("name", "geographical_location", "category", "owner_id", "created", "modified") VALUES (%s, %s, %s, %s, %s, %s) RETURNING "api_touristspot"."id"'
params = ('', <django.contrib.gis.db.backends.postgis.adapter.PostGISAdapter object at 0x7f787dc13df0>, '', None, datetime.datetime(2020, 8, 7, 14, 8, 21, 554551, tzinfo=<UTC>), datetime.datetime(2020, 8, 7, 14, 8, 21, 554590, tzinfo=<UTC>))
ignored_wrapper_args = (False, {'connection': <django.contrib.gis.db.backends.postgis.base.DatabaseWrapper object at 0x7f78898c0310>, 'cursor': <django.db.backends.utils.CursorWrapper object at 0x7f787dc20100>})
def _execute(self, sql, params, *ignored_wrapper_args):
self.db.validate_no_broken_transaction()
with self.db.wrap_database_errors:
if params is None:
# params default might be backend specific.
return self.cursor.execute(sql)
else:
> return self.cursor.execute(sql, params)
E django.db.utils.IntegrityError: null value in column "owner_id" violates not-null constraint
E DETAIL: Failing row contains (2, , 0101000020E610000000000000000000000000000000000000, , 2020-08-07 14:08:21.554551+00, 2020-08-07 14:08:21.55459+00, null).
/usr/local/lib/python3.8/site-packages/django/db/backends/utils.py:86: IntegrityError
______________________________________________________________ ERROR at setup of test_delete_touristpot _______________________________________________________________
self = <django.db.backends.utils.CursorWrapper object at 0x7f787d39d1c0>
sql = 'INSERT INTO "api_touristspot" ("name", "geographical_location", "category", "owner_id", "created", "modified") VALUES (%s, %s, %s, %s, %s, %s) RETURNING "api_touristspot"."id"'
params = ('', <django.contrib.gis.db.backends.postgis.adapter.PostGISAdapter object at 0x7f787d39d430>, '', None, datetime.datetime(2020, 8, 7, 14, 8, 22, 939906, tzinfo=<UTC>), datetime.datetime(2020, 8, 7, 14, 8, 22, 939948, tzinfo=<UTC>))
ignored_wrapper_args = (False, {'connection': <django.contrib.gis.db.backends.postgis.base.DatabaseWrapper object at 0x7f78898c0310>, 'cursor': <django.db.backends.utils.CursorWrapper object at 0x7f787d39d1c0>})
def _execute(self, sql, params, *ignored_wrapper_args):
self.db.validate_no_broken_transaction()
with self.db.wrap_database_errors:
if params is None:
# params default might be backend specific.
return self.cursor.execute(sql)
else:
> return self.cursor.execute(sql, params)
E psycopg2.errors.NotNullViolation: null value in column "owner_id" violates not-null constraint
E DETAIL: Failing row contains (3, , 0101000020E610000000000000000000000000000000000000, , 2020-08-07 14:08:22.939906+00, 2020-08-07 14:08:22.939948+00, null).
/usr/local/lib/python3.8/site-packages/django/db/backends/utils.py:86: NotNullViolation
The above exception was the direct cause of the following exception:
> ???
/home/alison/Workspace/snowman/touristspots/api/tests/test_api.py:89:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
/usr/local/lib/python3.8/site-packages/django/db/models/manager.py:82: in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
/usr/local/lib/python3.8/site-packages/django/db/models/query.py:433: in create
obj.save(force_insert=True, using=self.db)
/usr/local/lib/python3.8/site-packages/django/db/models/base.py:745: in save
self.save_base(using=using, force_insert=force_insert,
/usr/local/lib/python3.8/site-packages/django/db/models/base.py:782: in save_base
updated = self._save_table(
/usr/local/lib/python3.8/site-packages/django/db/models/base.py:887: in _save_table
results = self._do_insert(cls._base_manager, using, fields, returning_fields, raw)
/usr/local/lib/python3.8/site-packages/django/db/models/base.py:924: in _do_insert
return manager._insert(
/usr/local/lib/python3.8/site-packages/django/db/models/manager.py:82: in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
/usr/local/lib/python3.8/site-packages/django/db/models/query.py:1204: in _insert
return query.get_compiler(using=using).execute_sql(returning_fields)
/usr/local/lib/python3.8/site-packages/django/db/models/sql/compiler.py:1392: in execute_sql
cursor.execute(sql, params)
/usr/local/lib/python3.8/site-packages/django/db/backends/utils.py:68: in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
/usr/local/lib/python3.8/site-packages/django/db/backends/utils.py:77: in _execute_with_wrappers
return executor(sql, params, many, context)
/usr/local/lib/python3.8/site-packages/django/db/backends/utils.py:86: in _execute
return self.cursor.execute(sql, params)
/usr/local/lib/python3.8/site-packages/django/db/utils.py:90: in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
self = <django.db.backends.utils.CursorWrapper object at 0x7f787d39d1c0>
sql = 'INSERT INTO "api_touristspot" ("name", "geographical_location", "category", "owner_id", "created", "modified") VALUES (%s, %s, %s, %s, %s, %s) RETURNING "api_touristspot"."id"'
params = ('', <django.contrib.gis.db.backends.postgis.adapter.PostGISAdapter object at 0x7f787d39d430>, '', None, datetime.datetime(2020, 8, 7, 14, 8, 22, 939906, tzinfo=<UTC>), datetime.datetime(2020, 8, 7, 14, 8, 22, 939948, tzinfo=<UTC>))
ignored_wrapper_args = (False, {'connection': <django.contrib.gis.db.backends.postgis.base.DatabaseWrapper object at 0x7f78898c0310>, 'cursor': <django.db.backends.utils.CursorWrapper object at 0x7f787d39d1c0>})
def _execute(self, sql, params, *ignored_wrapper_args):
self.db.validate_no_broken_transaction()
with self.db.wrap_database_errors:
if params is None:
# params default might be backend specific.
return self.cursor.execute(sql)
else:
> return self.cursor.execute(sql, params)
E django.db.utils.IntegrityError: null value in column "owner_id" violates not-null constraint
E DETAIL: Failing row contains (3, , 0101000020E610000000000000000000000000000000000000, , 2020-08-07 14:08:22.939906+00, 2020-08-07 14:08:22.939948+00, null).
/usr/local/lib/python3.8/site-packages/django/db/backends/utils.py:86: IntegrityError
======================================================================= short test summary info =======================================================================
ERROR touristspots/api/tests/test_api.py::test_update_touristpot - django.db.utils.IntegrityError: null value in column "owner_id" violates not-null constraint
ERROR touristspots/api/tests/test_api.py::test_delete_touristpot - django.db.utils.IntegrityError: null value in column "owner_id" violates not-null constraint
==================================================================== 16 passed, 2 errors in 17.24s ====================================================================
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment