AZURE RQ1

import sys, os.path
sys.path.append(os.path.abspath(os.path.join(os.path.dirname( __file__ ), 'myvenv/Lib/site-packages')))
import os
import json
import pymysql

try:
    print("muestra esto")
    conn = pymysql.connect(user = 'Micael@nombreservidormysql',
        password = 'Correplatano!23',
        database = 'stackover',
        host = 'nombreservidormysql.mysql.database.azure.com')
except Exception as inst:
    print("ERROR : ")
    print(inst)
    sys.exit()

print("SUCCESS: Connection to RDS mysql instance succeeded")

item_count = 0
sql = """
    SELECT
        COUNT(sq.Usuario) CantidadUsuarios, sq.Cantidad as CantidadPreguntas
    FROM (
        SELECT COUNT(Id) as Cantidad, OwnerUserId as Usuario FROM Posts
        WHERE PostTypeId = 1
        GROUP BY OwnerUserId
        ORDER BY COUNT(*) DESC
    ) sq
    WHERE sq.Cantidad > 0
    GROUP BY sq.Cantidad
    HAVING COUNT(sq.Usuario) > 0
    """
item_count = 0
with conn.cursor() as cur:
    cur.execute(sql)
    conn.commit()
    for row in cur:
        item_count += 1
        print(row)
print("Filas generadas: %d" %(item_count))