search

Living-with-machines / lwmdb

A django-based library for managing the Living with Machines newspapers metadata database schema
https://living-with-machines.github.io/lwmdb/
MIT License
2 stars 0 forks source link

Newspaper `DataProvider` Integrity error #155

Closed griff-rees closed 1 year ago

griff-rees commented 1 year ago

A regression likely caused in solving ticket #92:

lwmdb_local_django    |   File "/usr/local/lib/python3.11/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
lwmdb_local_django    |
lwmdb_local_django    |     return executor(sql, params, many, context)
lwmdb_local_django    |            ^^^^^^^^^^^^^^^^^
lwmdb_local_django    | ^^^^^^^^^^^^^^^^^^
lwmdb_local_django    | ^
lwmdb_local_django    |
lwmdb_local_django    |   File "/usr/local/lib/python3.11/site-packages/django/db/backends/utils.py", line 84, in _execute
lwmdb_local_django    |     with self.db.wrap_database_errors:
lwmdb_local_django    |   File "/usr/local/lib/python3.11/site-packages/django/db/utils.py", line 91, in __exit__
lwmdb_local_django    |     raise dj_exc_value.with_traceback(traceback) from exc_value
lwmdb_local_django    |   File "/usr/local/lib/python3.11/site-packages/django/db/backends/utils.py", line 87, in _execute
lwmdb_local_django    |     return self.cursor.execute(sql)
lwmdb_local_django    |
lwmdb_local_django    |            ^^^^^^^^^^^^^^^^^^^^^^^^
lwmdb_local_django    |   File "/usr/local/lib/python3.11/site-packages/psycopg/cursor.py", line 723, in execute
lwmdb_local_django    |     raise ex.with_traceback(None)
lwmdb_local_django    | django.db.utils.IntegrityError: column "code" of relation "newspapers_dataprovider" contains null values
lwmdb_local_django exited with code 1
griff-rees commented 1 year ago

FYI: was a case of including null=True and blank=True for both code and legacy_code fields.