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…
I'm trying to execute the following query using sqlalchemy: query = session.query( func.count(ExampleTable.id) ).filter(ExampleTable.environment == self.environment)) if ids_list: query = query.filter(ExampleTable.id.in_(ids_list)) I noticed it was slow, so i did a simple timing "benchmark": start = perf_counter() query.first() print(format(perf_counter() - start,…
so my problem is i am trying to make an enum with int values but it didn't work. first of all, this is the code. class UserRole(enum.IntEnum): publisher = 4 editor = 3 manager = 2 admin = 1 class…
I am using python to query an external api, transform the data and write it to a postgresql database internally. In that process, I am comparing the result from the api with existing data in the database using pandas and…
Been struggling with this one. Long story short I have a problem where we need to read a file at different times throughout the month provided by the client. The file can be a few hundred lines, or over a…
I have deployed a FastAPI application on DigitalOcean droplets and Azure App Service, with MySQL databases hosted on DigitalOcean and Azure respectively. Despite several attempts to mitigate the issue, I am consistently facing database connection problems, resulting in errors like:…
I have 2 tables: chat and chat_messages. I want to get only those chats which don't have chat_messages from users (they may have messages from other sources like admins). This code returns 0 records, I can't figure out why: message_count_subquery…
(Note - I'm aware of this apparently-duplicate question, but the answer provided there does not work) I'm trying to convert a SqlAlchemy Join Query to JSON, such that the columns from both joined tables are reflected in the output. All…
My problem next: I can't execute query, where need to get list of Accounts with their Records by account_id as sum of Records. My query next: subq = ( select( func.sum(Record.amount).label('amount') ) .filter(Record.account_id == Account.uuid) .subquery() ) accounts = (…