okfn / opendataeditor

The Open Data Editor (ODE) is a no-code application to explore, validate and publish data in a simple way. Forever free and open source project powered by the Frictionless Framework.
http://opendataeditor.okfn.org
MIT License
183 stars 22 forks source link

Making field required if there are empty/null cells bring the application to inconsistent state #552

Closed roll closed 1 month ago

roll commented 2 months ago

Overview

Screenshot from 2024-09-19 14-29-57

sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: players.Golden Balls
[SQL: INSERT INTO players ("_rowNumber", "_rowValid", "Name", "Golden Balls") VALUES (?, ?, ?, ?)]
[parameters: [(2, 1, 'Lionel Messi', 6), (3, 1, 'Cristiano Ronaldo', 5), (4, 1, 'Franz Beckenbauer', 2), (5, 1, 'Michel Platini', 1), (6, 1, 'Johan Cruyff', 1), (7, 1, 'Marco van Basten', 1), (8, 1, 'Ronaldo Nazario', 2), (9, 1, 'Zinedine Zidane', 1), (10, 1, 'Ronaldo', 2), (11, 0, 'Ronaldinho', None)]]
(Background on this error at: https://sqlalche.me/e/20/gkpj)

Plan