Breaking News: Grepper is joining You.com. Read the official announcement!

primary key qlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed

Jittery Jay answered on June 29, 2021 Popularity 8/10 Helpfulness 3/10

answer primary key qlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed

primary key qlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed

Comment

# SQLAlchemy does not map BigInt to Int by default on the sqlite dialect.
# It should, but it doesnt.
from sqlalchemy import BigInteger
from sqlalchemy.dialects import postgresql, mysql, sqlite

BigIntegerType = BigInteger()
BigIntegerType = BigIntegerType.with_variant(postgresql.BIGINT(), 'postgresql')
BigIntegerType = BigIntegerType.with_variant(mysql.BIGINT(), 'mysql')
BigIntegerType = BigIntegerType.with_variant(sqlite.INTEGER(), 'sqlite')

# Then replace db.BigInteger with BigIntegerType

Popularity 8/10 Helpfulness 3/10 Language python

Source: stackoverflow.com

Tags: null primary-key python

Link to this answer
Share Copy Link