I all,
I got a KeyedTuple error that I don't know what it means or how to solve it.
Could anyone give me some help?
Thanks.
I'm using SQLAlchemy-0.9.3-py2.6.egg
ProgrammingError: (ProgrammingError) can't adapt type 'KeyedTuple' 'SELECT
unita_aziendale.id AS unita_aziendale_id, unita_aziendale.id_azienda AS
unita_aziendale_id_azienda, unita_aziendale.id_anagrafica AS
unita_aziendale_id_anagrafica, unita_aziendale.codice_struttura AS
unita_aziendale_codice_struttura, unita_aziendale.bdn_id AS
unita_aziendale_bdn_id, unita_aziendale.bdn_data_ultima_modifica AS
unita_aziendale_bdn_data_ultima_modifica, unita_aziendale.ts_ultima_modifica AS
unita_aziendale_ts_ultima_modifica, unita_aziendale.id_operatore AS
unita_aziendale_id_operatore, unita_aziendale.bdn_specie AS
unita_aziendale_bdn_specie, unita_aziendale.bdn_flag_carne_latte AS
unita_aziendale_bdn_flag_carne_latte, unita_aziendale.data_inizio AS
unita_aziendale_data_inizio, unita_aziendale.data_aggiornamento_izs AS
unita_aziendale_data_aggiornamento_izs, unita_aziendale.codice_regionale AS
unita_aziendale_codice_regionale, unita_aziendale.data_fine AS
unita_aziendale_data_fine, unita
_aziendale.cod_tipologia_struttura AS unita_aziendale_cod_tipologia_struttura,
unita_aziendale.cod_specie AS unita_aziendale_cod_specie,
unita_aziendale.id_veterinario_associato AS
unita_aziendale_id_veterinario_associato, unita_aziendale.num_iscrizione_cciaa
AS unita_aziendale_num_iscrizione_cciaa, unita_aziendale.num_registro_imprese
AS unita_aziendale_num_registro_imprese, unita_aziendale.data_iscrizione AS
unita_aziendale_data_iscrizione, unita_aziendale.ua_dipartimento AS
unita_aziendale_ua_dipartimento, anagrafica_1.id AS anagrafica_1_id,
anagrafica_1.nome AS anagrafica_1_nome, anagrafica_1.indirizzo AS
anagrafica_1_indirizzo, anagrafica_1.telefono AS anagrafica_1_telefono,
anagrafica_1.fax AS anagrafica_1_fax, anagrafica_1.email AS anagrafica_1_email,
anagrafica_1.id_comune AS anagrafica_1_id_comune, anagrafica_1.localita AS
anagrafica_1_localita, anagrafica_1.cap AS anagrafica_1_cap,
anagrafica_1.dato_fiscale AS anagrafica_1_dato_fiscale,
anagrafica_1.cod_professione
AS anagrafica_1_cod_professione, anagrafica_1.cod_cittadinanza AS
anagrafica_1_cod_cittadinanza, anagrafica_1.cod_titolo_studio AS
anagrafica_1_cod_titolo_studio, anagrafica_1.data_nascita AS
anagrafica_1_data_nascita, anagrafica_1.id_comune_nascita AS
anagrafica_1_id_comune_nascita, anagrafica_1.cod_nazione_nascita AS
anagrafica_1_cod_nazione_nascita, anagrafica_1.ts_ultima_modifica AS
anagrafica_1_ts_ultima_modifica, anagrafica_1.id_operatore AS
anagrafica_1_id_operatore, anagrafica_1.tipo AS anagrafica_1_tipo,
anagrafica_1.tipo_persona AS anagrafica_1_tipo_persona, anagrafica_1.data_fine
AS anagrafica_1_data_fine \nFROM azienda AS azienda_1, unita_aziendale LEFT
OUTER JOIN anagrafica AS anagrafica_1 ON anagrafica_1.id =
unita_aziendale.id_anagrafica \nWHERE unita_aziendale.id_azienda = azienda_1.id
AND unita_aziendale.id IN (%(id_1)s, %(id_2)s, %(id_3)s, %(id_4)s, %(id_5)s,
%(id_6)s, %(id_7)s, %(id_8)s, %(id_9)s, %(id_10)s, %(id_11)s, %(id_12)s,
%(id_13)s, %(id_14)s, %(i
d_15)s, %(id_16)s, %(id_17)s, %(id_18)s, %(id_19)s, %(id_20)s, %(id_21)s,
%(id_22)s, %(id_23)s, %(id_24)s, %(id_25)s, %(id_26)s, %(id_27)s, %(id_28)s,
%(id_29)s, %(id_30)s, %(id_31)s, %(id_32)s, %(id_33)s, %(id_34)s, %(id_35)s,
%(id_36)s, %(id_37)s, %(id_38)s, %(id_39)s, %(id_40)s, %(id_41)s, %(id_42)s,
%(id_43)s, %(id_44)s, %(id_45)s, %(id_46)s, %(id_47)s, %(id_48)s, %(id_49)s,
%(id_50)s, %(id_51)s, %(id_52)s, %(id_53)s, %(id_54)s, %(id_55)s, %(id_56)s,
%(id_57)s, %(id_58)s, %(id_59)s, %(id_60)s, %(id_61)s, %(id_62)s, %(id_63)s,
%(id_64)s, %(id_65)s, %(id_66)s, %(id_67)s, %(id_68)s, %(id_69)s, %(id_70)s,
%(id_71)s, %(id_72)s, %(id_73)s, %(id_74)s, %(id_75)s, %(id_76)s, %(id_77)s,
%(id_78)s, %(id_79)s, %(id_80)s, %(id_81)s, %(id_82)s, %(id_83)s, %(id_84)s,
%(id_85)s, %(id_86)s, %(id_87)s, %(id_88)s, %(id_89)s, %(id_90)s, %(id_91)s,
%(id_92)s, %(id_93)s, %(id_94)s, %(id_95)s, %(id_96)s, %(id_97)s, %(id_98)s,
%(id_99)s, %(id_100)s, %(id_101)s, %(id_102)s, %(id_103)s, %(id_104)
s, %(id_105)s, %(id_106)s, %(id_107)s, %(id_108)s, %(id_109)s, %(id_110)s,
%(id_111)s, %(id_112)s, %(id_113)s, %(id_114)s, %(id_115)s, %(id_116)s,
%(id_117)s, %(id_118)s, %(id_119)s, %(id_120)s, %(id_121)s, %(id_122)s,
%(id_123)s, %(id_124)s, %(id_125)s, %(id_126)s, %(id_127)s, %(id_128)s,
%(id_129)s, %(id_130)s, %(id_131)s, %(id_132)s, %(id_133)s, %(id_134)s,
%(id_135)s, %(id_136)s, %(id_137)s, %(id_138)s, %(id_139)s, %(id_140)s,
%(id_141)s, %(id_142)s, %(id_143)s, %(id_144)s, %(id_145)s, %(id_146)s,
%(id_147)s, %(id_148)s, %(id_149)s, %(id_150)s, %(id_151)s, %(id_152)s,
%(id_153)s, %(id_154)s, %(id_155)s, %(id_156)s, %(id_157)s, %(id_158)s,
%(id_159)s, %(id_160)s, %(id_161)s, %(id_162)s, %(id_163)s, %(id_164)s,
%(id_165)s, %(id_166)s, %(id_167)s, %(id_168)s, %(id_169)s, %(id_170)s,
%(id_171)s, %(id_172)s, %(id_173)s, %(id_174)s, %(id_175)s, %(id_176)s,
%(id_177)s, %(id_178)s, %(id_179)s, %(id_180)s, %(id_181)s, %(id_182)s,
%(id_183)s, %(id_184)s, %(id_185)s, %(id_186)s, %(
id_187)s, %(id_188)s, %(id_189)s, %(id_190)s, %(id_191)s, %(id_192)s,
%(id_193)s, %(id_194)s, %(id_195)s, %(id_196)s, %(id_197)s, %(id_198)s,
%(id_199)s, %(id_200)s, %(id_201)s, %(id_202)s, %(id_203)s, %(id_204)s,
%(id_205)s, %(id_206)s, %(id_207)s, %(id_208)s, %(id_209)s, %(id_210)s,
%(id_211)s, %(id_212)s, %(id_213)s, %(id_214)s, %(id_215)s, %(id_216)s,
%(id_217)s, %(id_218)s, %(id_219)s, %(id_220)s) ORDER BY nome' {'id_170':
(315165,), 'id_171': (339665,), 'id_172': (339670,), 'id_173': (339666,),
'id_174': (322695,), 'id_175': (314365,), 'id_176': (310093,), 'id_177':
(2488,), 'id_178': (344447,), 'id_179': (317871,), 'id_60': (327130,), 'id_38':
(340843,), 'id_39': (332113,), 'id_122': (334636,), 'id_32': (334643,),
'id_33': (334642,), 'id_30': (334639,), 'id_31': (334641,), 'id_36': (340883,),
'id_37': (340882,), 'id_34': (76,), 'id_35': (334640,), 'id_63': (334189,),
'id_9': (318026,), 'id_90': (322144,), 'id_89': (336423,), 'id_88': (336420,),
'id_167': (2486,), 'id_
166': (2634,), 'id_165': (2528,), 'id_164': (2529,), 'id_83': (336427,),
'id_162': (312428,), 'id_161': (336918,), 'id_80': (319871,), 'id_98':
(336422,), 'id_99': (336424,), 'id_118': (334567,), 'id_119': (334631,),
'id_112': (334620,), 'id_91': (333871,), 'id_92': (337320,), 'id_93':
(337321,), 'id_116': (334565,), 'id_95': (334635,), 'id_114': (334575,),
'id_115': (334576,), 'id_10': (317311,), 'id_11': (317314,), 'id_12':
(317310,), 'id_13': (317317,), 'id_14': (317316,), 'id_15': (2532,), 'id_16':
(2531,), 'id_17': (2533,), 'id_18': (1,), 'id_19': (334543,), 'id_1':
(355881,), 'id_109': (334563,), 'id_108': (334562,), 'id_23': (325337,),
'id_86': (333868,), 'id_77': (319872,), 'id_101': (335375,), 'id_100':
(336421,), 'id_103': (333873,), 'id_102': (334637,), 'id_105': (334566,),
'id_104': (334561,), 'id_107': (334560,), 'id_106': (334578,), 'id_182':
(344783,), 'id_72': (2628,), 'id_184': (339059,), 'id_192': (314723,),
'id_193': (313512,), 'id_67': (318955,), 'id_66':
(341094,), 'id_196': (2501,), 'id_187': (350984,), 'id_194': (339487,),
'id_195': (310647,), 'id_220': (322333,), 'id_198': (310704,), 'id_199':
(310687,), 'id_69': (341102,), 'id_68': (318954,), 'id_202': (310669,),
'id_203': (310709,), 'id_200': (310723,), 'id_201': (310666,), 'id_206':
(310716,), 'id_7': (318024,), 'id_4': (340431,), 'id_5': (338877,), 'id_208':
(310717,), 'id_209': (2537,), 'id_76': (319868,), 'id_181': (2535,), 'id_180':
(2492,), 'id_183': (344784,), 'id_75': (319873,), 'id_185': (339057,), 'id_73':
(340353,), 'id_70': (341103,), 'id_186': (339056,), 'id_189': (338748,),
'id_188': (96,), 'id_78': (319869,), 'id_79': (319874,), 'id_211': (310693,),
'id_210': (310722,), 'id_213': (310706,), 'id_212': (310665,), 'id_215':
(312420,), 'id_214': (310668,), 'id_217': (336001,), 'id_216': (311707,),
'id_219': (312973,), 'id_218': (336000,), 'id_110': (334574,), 'id_65':
(345218,), 'id_111': (334619,), 'id_64': (334194,), 'id_94': (337303,),
'id_74': (331573,),
'id_190': (315284,), 'id_117': (333872,), 'id_191': (311175,), 'id_96':
(336379,), 'id_61': (332592,), 'id_97': (335384,), 'id_197': (2500,), 'id_43':
(332308,), 'id_42': (332108,), 'id_41': (332109,), 'id_40': (332112,), 'id_47':
(326239,), 'id_46': (332404,), 'id_45': (332403,), 'id_44': (332309,), 'id_49':
(315515,), 'id_48': (326240,), 'id_134': (335385,), 'id_135': (336370,),
'id_136': (336360,), 'id_137': (336368,), 'id_130': (335382,), 'id_131':
(335383,), 'id_132': (335387,), 'id_133': (337319,), 'id_138': (337310,),
'id_139': (337309,), 'id_156': (766,), 'id_157': (765,), 'id_154': (352448,),
'id_155': (346695,), 'id_152': (337322,), 'id_153': (336428,), 'id_150':
(337315,), 'id_151': (337312,), 'id_158': (336626,), 'id_159': (341659,),
'id_113': (334638,), 'id_2': (355880,), 'id_58': (338978,), 'id_169':
(339668,), 'id_3': (315285,), 'id_54': (317271,), 'id_55': (338977,), 'id_56':
(338975,), 'id_57': (338976,), 'id_50': (315802,), 'id_51': (2915,), 'id_52':
(3127
83,), 'id_53': (312782,), 'id_123': (335379,), 'id_87': (335378,), 'id_121':
(334634,), 'id_120': (334630,), 'id_127': (336419,), 'id_126': (336418,),
'id_125': (335380,), 'id_124': (335377,), 'id_6': (117,), 'id_129': (335381,),
'id_128': (336369,), 'id_85': (334632,), 'id_207': (310721,), 'id_145':
(337316,), 'id_144': (337304,), 'id_147': (337307,), 'id_84': (336426,),
'id_141': (337318,), 'id_140': (337313,), 'id_143': (334633,), 'id_142':
(334582,), 'id_163': (2557,), 'id_168': (339669,), 'id_205': (310646,),
'id_149': (337300,), 'id_148': (337317,), 'id_82': (332849,), 'id_62':
(334191,), 'id_81': (332598,), 'id_160': (335736,), 'id_8': (318132,), 'id_59':
(319220,), 'id_29': (336320,), 'id_71': (2786,), 'id_28': (314831,), 'id_21':
(2554,), 'id_20': (334544,), 'id_146': (337306,), 'id_22': (334298,), 'id_25':
(315784,), 'id_24': (325336,), 'id_27': (314447,), 'id_26': (2553,), 'id_204':
(310724,)}
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
