class reg(object):
    def __init__(self, cursor, row):
        for (attr, val) in zip((d[0] for d in cursor.description), row) :
            setattr(self, attr, val)


class Appointment(ModelSQL, ModelView):
    'Patient Appointments'
    __name__ = 'gnuhealth.appointment'


    padron = fields.Function(fields.Char('Padronnac'), 'get_padronnac')


    def get_padronnac(self, name):
        res = ''
        cursor = Transaction().cursor
        ndni=self.patient.name.ref
        cursor.execute("""SELECT gnuhealth_padronnac.id,
                        gnuhealth_padronnac.tipodocumento,
                        gnuhealth_padronnac.nrodocumento,
                        gnuhealth_padronnac.apellidoynombre,
                        gnuhealth_padronnac.cuilbeneficiario,
                        gnuhealth_padronnac.cuiltitular,
                        gnuhealth_padronnac.sexo,
                        gnuhealth_padronnac.tipobeneficiario,
                        gnuhealth_padronnac.cuitemlpleador,
                        gnuhealth_padronnac.codigopostal,
                        gnuhealth_padronnac.provincia,
                        gnuhealth_padronnac.codigoparentesco,
                        gnuhealth_padronnac.ultperiodoaporte,
                        gnuhealth_padronnac.codobrasoc,
                        gnuhealth_padronnac.fechanacimiento,
                        party_party.name,
                        party_party.ref FROM public.gnuhealth_padronnac, public.party_party
                        WHERE gnuhealth_padronnac.codobrasoc = party_party.ref AND nrodocumento = %s """, (ndni,))
        for row in cursor.fetchall():
            res = reg(cursor, row)
        return res