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…
Below that there is an endpoint that uploads a photo to aws-s3 and return the url of the photo. This works well. session1 = boto3.Session( aws_access_key_id='XXXXXXXXXX', aws_secret_access_key='XXXXXXXXX' ) S3_BUCKET_NAME = "XXXXX" s3 = session1.resource("s3") bucket = s3.Bucket(S3_BUCKET_NAME) KB= 1024 MB…
` @user.post("/add-user") async def write_user_date(user: User): conn.execute(users.insert().values( name=user.name, email=user.email, password=user.password, )) return conn.execute(users.select()).fetchall() ` That is my code, but every time when I post a data it's show ERROR: Exception in ASGI application Traceback (most recent call last): File "c:usershpdesktopfastapi…
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 am attempting to run a simple FastAPI application on CentOS 7 but getting some errors. I will include some more details for context: Python Version - 3.6.8 pip version - 9.0.3 I am running the application with this command:…
I want to retrieve files based on specific tag from AWS s3 bucket using python. Although I have made a solution using boto3 and loops but it is taking a lot and lot of time depending on number of files…
Though I have pip and pip3 installed fastapi library in my Ubuntu based workstation, I get a weird error saying No module named 'fastapi'. I have been scratching my head since two days ago as the same code works in…
I am using mysql database and it's doesn't support list if I stored sting like "apple","banana" in my mysql database then when using get method fastapi how to convert theme from string to list like ["apple","banana"]. I tried this but…
I am learning to use celery and I want to be able to do an operation on a database from a Celery task. I am using docker; a container for my app, another for the database (postgresql), and another for…
I have this code for delete operation on a Postgresql DB: @app.delete("/posts/{id}", status_code=status.HTTP_204_NO_CONTENT) def delete_post(id: int): print("ID IS ",id) cursor.execute("""DELETE FROM public."Posts" WHERE id = %s""", (str(id),)) deleted_post = cursor.fetchone() <--- Showing error for this line conn.commit() if deleted_post is…