SQL Alchemy supports multiple ways of specifying datatypes for SQL database columns. If regular Python datatypes are used, SQL Alchemy will try to sensibly map these to datatypes supported by the connected to database. There is also the possibility of…
I am using SQLAlchemy and PostgreSQL, and I am trying to create a case-insensitive unique constraint that works like this UniqueConstraint( 'country', 'organisation_id', func.lower(func.trim('name')), name='uq_country_orgid_lower_trim_name' ) Ensuring a unique combination of name, country and organisation id, regardless of case and…
I'm trying to add a timestamp column, updated_at, in the updates when doing a upsert using on_conflict_do_update. Below is my current implementation but encounter the below error when running at the last line. Exception has occurred: ProgrammingError (psycopg2.errors.AmbiguousColumn) column reference…
I have a table zipnames with four columns: id, zipcode, name_fi and name_sv. Both of the name_* columns are nullable. For each possible zipcode, I might have up to four rows: both names present, only name_fi present, only name_sv present,…
I have a table with primary uuid key, unique article and some other params. My model: class Product(Base): __tablename__ = "products" idf: Mapped[str] = mapped_column(primary_key=True, unique=True) name: Mapped[str] = mapped_column(nullable=False) article: Mapped[str] = mapped_column(nullable=False, unique=True) category: Mapped[str] = mapped_column(default="") description:…
I want to store a secret key encrypted and I want to ensure there is always either none or exactly one entry in this SQLAlchemy model/table. How can this be enforced?
I have been trying to build a docker-compose container for my back-end service using Fastapi.The issue is docker-compose container logs keep returning that my database engine fails. I am using asyncpg for async connection in postgresql. ╰─λ sudo docker-compose logs…
I'm applying the FastAPI to develop an API collection. In VS Code, I've added a virtual environment and a Python interpreter path. sqlalchemy dependency was installed in the venv, but Python was still unable to locate the package. Help is appreciated.…
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 need to make a python script using a query and params formatted as a list of dicts to use the execute function on the engine object. The script that I have been trying only returns -1: db_type = "mssql+pyodbc"…