Currently running a self-managed postgresDB. I'm accessing via PGAdmin. I'm using the DB credentials for my FastAPI backend that runs alembic migrations. I'm seeing that the root user of the DB can create, delete, update tables and columns. But when…
I am trying to alter a column's type from ENUM to INTEGER (which is also a foreign key) in PostgreSQL using Alembic. However, when I attempt to upgrade the migration, I encounter the following error: sqlalchemy.exc.ProgrammingError: (psycopg2.errors.CannotCoerce) cannot cast type…
I'm trying to run a FastAPI application with a MySQL database in a Docker environment, but I'm encountering a connection error. The application is unable to connect to the database. Here's the error I'm getting: Copysqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2003, "Can't connect…
I have a users table, with the primary key being an id field, which is an autoincrementing integer. I don't have a username field right now, but I would like to add one. Now, the username should be UNIQUE and…
I have a table needs to be partitioned, but since the postgresql_partition_by wasn't added while the creation of the table so am trying to: create a new partitioned table that is similar the origin one. moving the data from the…
I am writing a Flask app with SqlAlchemy and PostgreSQL. When I try to enter a value into an enum field that has more than six characters, I get the following error: sqlalchemy.exc.DataError: (psycopg2.errors.StringDataRightTruncation) value too long for type character…
Currently I am trying to learn about Api development with FastAPI and I am trying to dockerize my project. However, when I try to run the database migrations with alembic in Docker by using docker run sm-api_api alembic upgrade head…
I am getting this error when trying to run migrations in my container. I cannot seem to figure out why. Error response from daemon: OCI runtime create failed: container_linux.go:349: starting container process caused "exec: "alembic": executable file not found in…
I've created a few migrations already using Alembic, it's a really interesting tool. Using it on a new DB would be straightforward enough, however our usecase is to apply these migrations to existing DB's, not only to bring them "up…