I am trying to run databes on Docker container and connect it with my code. This is my connection string: engine = create_engine('postgres+psycopg2://name:password@hostname:port/database_name') As host_name I use IP address of my Linux where I installed docker container. I also checked…
I am trying to insert Pydantic list to Postgres DB using SQlAlchemy but can't figure out how to make it in a correct way. Here is my code: Model class Material(Base): __tablename__ = 'materials' sap_code = Column(String, primary_key=True, nullable=False) sap_name…
My laptop is MacBook Pro (16-inch, 2021) Apple M1 Max. I want to run Azure function with Python. Currently, Azure function Core tools does not support Python function development on ARM64 devices. To develop Python functions on a Mac with…
I'm trying to delete some rows that a 'null' in a Postgresql db by this: async def delete_empty_batches(): query = Batches.delete().where(Batches.c.acquired_by_warehouse_date is None) database.execute(query).fetchall() s = Batches.select() return await database.execute(s).fetchall() But nothing happens. I have tried to make a query…
I have a postgres DB in RDS. When I connect it from my local and insert into it via sqlalchemy, I can see the updated results but when I run the same code from Lambda, the execution is shown as…
I have a table that includes an int column named row_number. This worked fine until I upgraded Debian from 11 to 12 which upgraded MariaDB from 10.5 to 10.11. I now get errors when using SQLAlchemy. I've tracked down where…
I have searched many tutors on how to create table with sqlalchemy: from sqlalchemy import create_engine, MetaData, Table, Column, Integer, String engine = create_engine('sqlite:///college.db', echo = True) meta = MetaData() students = Table( 'students', meta, Column('id', Integer, primary_key = True),…
I want to merge json data distributed over multiple rows in a mysql column via python sqlalchemy library. I was planning to use json_merge_preserve but unable to use over an entire column. I used following code: select(func.json_merge_preserve(db.mytable.c.myjsoncolumn)) But it says…
I'm trying to connect with my Google Cloud Sql db using google.cloud.sql.connector, and this is the code to connect: def getconn(): with Connector() as connector: conn = connector.connect( instance_connection_name, "pg8000", user = db_user, password = db_pass, db = db_name, ip_type…
I am learning how to use fastapi and sql alchemy to build an api, but when trying to get my script to create the tables in postgreSQL it just doesn't work, nothing happens. This is what my code looks like:…