fastapi
when i adding the background table this happened.
Privileged issue
- [X] I'm @tiangolo or he asked me directly to create an issue here.
Issue Content
sqlalchemy.exc.IntegrityError: (psycopg.errors.NotNullViolation) null value in column "id" violates not-null constraint backend-1 | DETAIL: Failing row contains ([email protected], t, t, null, $2b$12$O1FGCpDKGwyy6wH6CEA0lOpBAxETlYbAg.ib9av622HcJ/YB1AY1C, null). backend-1 | [SQL: INSERT INTO "user" (email, is_active, is_superuser, full_name, hashed_password) VALUES (%(email)s::VARCHAR, %(is_active)s, %(is_superuser)s, %(full_name)s::VARCHAR, %(hashed_password)s::VARCHAR) RETURNING "user".id] backend-1 | [parameters: {'email': '[email protected]', 'is_active': True, 'is_superuser': True, 'full_name': None, 'hashed_password': '$2b$12$O1FGCpDKGwyy6wH6CEA0lOpBAxETlYbAg.ib9av622HcJ/YB1AY1C'}] backend-1 | (Background on this error at: https://sqlalche.me/e/20/gkpj)
Base on your provided information it seems like you are facing a migration issue. If you added a new table did you make sure to run a migration on your database ?
Also could you please add some steps to reproduce. A generic SQL log trace seems a bit light to work with.
Thanks!
The problem appears to be that the user table's id column isn't receiving a value during the INSERT, according to the information you provided. This occurs as a result of the column not being configured to automatically generate values (for example, by using autoincrement=True or a UUID). Make sure the ID is set up to generate itself by double-checking your model and database schema. Make sure this configuration is reflected in your migrations as well. I hope this will work.
@FARMAN9, to ask for help, please open discussion, not issue.
If you still interested in getting help on this topic, please open a discussion and provide more details (what exactly did you change?)
