How to execute multiple queries SQL Python?

Question

I'm trying to execute multiple queries. But it's executing the last one only knowing that I did buffered=True in the cursor. I need to get the result for the 4 queries.

updated_query = cursor.execute(
    'select count(*) from event where update_count > 0 and date > now() - interval 24 hour')
deleted_query = cursor.execute(
    'select count(*) from event where deleted > 0 and date > now() - interval 24 hour')
total_last_24_hours = cursor.execute(
    'select count(*) from event where date > now() - interval 24 hour')
total_events = cursor.execute('select count(*) from event')

result = cursor.fetchall()
for x in result:
    print(x[0])

Output: 3550 which is total_events

this is as expected. cursor.fetchall() is what fetches the results from the last query. — tomgalpin
– tomgalpin, Commented Sep 6, 2022 at 13:17
Curious, why did you not use solution from your previous question? — Parfait
– Parfait, Commented Sep 6, 2022 at 13:29

Parfait · Accepted Answer · 2022-09-06 13:25:03Z

Since all four aggregate queries share same source table, consider combining all calculations in a single SELECT query. For long format, use the proposed solution to your previous question.

updated_query = (
    '''select sum(case
                     when update_count > 0 and date > now() - interval 24 hour
                     then 1
                     else 0
                  end) as update_count,
              sum(case
                     when deleted > 0 and date > now() - interval 24 hour
                     then 1
                     else 0
                  end) as delete_count,
              sum(case
                     when date > now() - interval 24 hour
                     then 1
                     else 0
                  end) as day_count,
              count(*) as total_count
        from event
    '''
)     

result = cursor.fetchall()
for row in result:
    print(row)

Collectives™ on Stack Overflow

How to execute multiple queries SQL Python?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related