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:…
I have a Postgres database running in a Docker container and a Python application running in another Docker container. When I try to connect to the Postgres database from the Python app using SQLAlchemy, I get the following error: sqlalchemy.exc.OperationalError:…
I am trying to add a new row to my table enjordplatform_keywords but everytime I do that it instead tries to add the row in the middle of the table. Usually that id that it is trying to insert it…