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 = (…
I have a table with column name "collation" whose schema I cannot change. I generated some data I want to insert into this table using the following code snippet: from sqlalchemy.dialects import postgresql data = [{"collation": "foo"}, {"collation":"bar"}] stmt =…
I've got a database table in a Postgres 15 database, it's got two columns (amongst others), one is of type daterange, the other is tstzrange. We've got some code that inserts to this table with raw SQL (via sqlalchemy core)…