#/usb/bin/python2.4
#
#

import cairo
import CairoPlot
import psycopg2
import sys

try:
	conn = psycopg2.connect("host='127.0.0.1' dbname='minrexdb' user='postgres' password='12345'")
except:
	print "No se pudo conectar a la base de datos, saliendo"
	sys.exit()

cur = conn.cursor()
try:
	cur.execute("""SELECT COUNT(idvisa) AS cantidad, estado FROM visas_inmunidades GROUP BY estado ORDER BY COUNT(idvisa) ASC""")
except:
	print "No se pudieron obtener los datos"
	sys.exit()

rows = cur.fetchall()

data = {}

for row in rows:
	data [row[1]] = row[0]

print data

# Generamos la grafica de pastel
#
background = cairo.LinearGradient(300, 0, 300, 400)
background.add_color_stop_rgb(0,0.4,0.4,0.4)
background.add_color_stop_rgb(1.0,0.1,0.1,0.1)
CairoPlot.pie_plot("visas_estado.png", data, 600, 400, background = None, gradient = True, shadow = True)