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"…
I am trying to select a segment if: settings dict is not null Has key user_parameters in it And user_parameters (dict) has key user_id in it Code below: user_id = '100952' select([self.db.segments]).where( and_( self.db.segments.c.settings.isnot(None), cast(self.db.segments.c.settings, JSON)["user_parameters"].as_string().contains(f"'{user_id}'"), ) ) Converting JSON…
I am genuinely baffled by the behavior I'm seeing so I'm hoping someone can shed some light onto what's going on here. Basically, I have a web app using FastAPI and SQLAlchemy in the back end that involves users posting…