flask app convert sql query to python plotly.

[Albert-Jan Roskam]

   On Apr 2, 2022 20:50, Abdellah ALAOUI ISMAILI <my.alaoui.ia at gmail.com>
   wrote:

     i would like to convert in my flask app an SQL query to an plotly pie
     chart using pandas. this is my code :

     def query_tickets_status() :
         query_result = pd.read_sql ("""
                 SELECT COUNT(*)count_status, status
                 FROM tickets
                 GROUP BY status""", con = mydc_db)
         return query_result

     labels_statut = query_tickets_status['status']
     values_statut = query_tickets_status['count_status']

   ======
   I think you mean:
   labels_statut = query_tickets_status()['status']
   values_statut = query_tickets_status()['count_status']