Repository navigation
I think sqlite3 supports check constraints #26
Description
Activity
It's not just on
ALTER TABLE, it also exists for forCREATE TABLEtoo. This doesn't necessarily need to be in for 1.0 milestone. But I think I'd like to explore getting this in and tested to ensure that sqlite does support it.So sqlite supports check constraints. But it does not support adding it to a column that exists. It has to be specified when the column is created.
Looked at this one. We can easily support this in a similar manner to how we support
:collatefor text-insensitive columns. The beauty of ecto/ecto_sql is that we are not limited to the list of documented options shown inEcto.Migration#add/3I'll add this with some tests in the next week.
I should also clean up how we do
collateand move that to thecolumn_optionsfunc instead.And also add documentation that we do not support
create constraintbut do support this way.
https://github.com/warmwaffles/exqlite/blob/cbd1e9c6eef74355c025158c341ccc678fe7446f/lib/ecto/adapters/exqlite/connection.ex#L510-L513
If you drill into the column definition you'll see that
CHECKis allowed https://sqlite.org/lang_altertable.htmlIt doesn't support, exclude although if you can just negate the statement it might suffice.