Due to suspected platform differences between developers, json.dump is formatting scientific notations in different ways (one person's machine, it formats to 1e-6, and on others it formats to 1e-06). The files are committed to our git history, so having to…
I use an object that needs a startup and a teardown process (load from/save to cache, for example) in a FastAPI endpoints. I used a asynccontextmanager to manage the context of an object, but I also want to process the…
I have problem with this method in my telegram mini app: https://core.telegram.org/bots/webapps#validating-data-received-via-the-mini-app When client trying to log in into my mini app frontend sends check string like in article, i'm generating hash string on backend to check client log in…
Beginner here. I have an HTMl table with buttons and I want a button to toggle open a form with the values from that row. Problem is, if I have multiple rows in my table, it opens multiple forms for…
I have a json that is three levels deep. I want to flatten it into a dataframe that has five columns. id name code level parent_id So: The part I struggle with is that I can extract each nested item,…
I'm in ubuntu 20.04, been trying to install a more recent version of numpy after realising I had 1.24.4 but whenever I try to update it with pip3 install --upgrade numpy It keeps giving me this message Requirement already satisfied:…
I need to process multiple messages in JSON format. Each message has its own nested structure. I would like to create a Python SDK to process these messages. My idea is to map each JSON structure into a set of…
I am trying to connect to a MySQL database hosted on my website's domain using Python, but I keep encountering the following error: mysql.connector.errors.DatabaseError: 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061) my code: import mysql.connector try: db…
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 have a very simple pipeline that fetches the AQI data and stores them in a csv file. Here is the script: import requests import time from datetime import datetime, timedelta import csv import sys from tqdm import tqdm from…