Roger Demetrescu ha scritto:
> On 9/27/07, Glauco <[EMAIL PROTECTED]> wrote:
>
>> Glauco, can you send a small test script reproducing the error ?
>>
>> I'll gladly take a look at that...
>>
>> Cheers,
>>
>> Roger
>>
>>
>>
>> Yes...
>>
>> this is the example
>>
>>
>>
>> session.query( UnitaAziendale ).order_by(Anagrafica.c.nome)
>>
>
> <SNIP>
>
>
> Thanks Glauco...
>
> But you forgot your Tables and mappers definition... ;)
>
isn't forgotten...
i dont' have table definition in SA but use reverse engeenering over an
existing DB,
and this mapper are huge...
anyway i try to give an idea with only some example of base table
implied in this example.
Table(u'unita_aziendale',
DynamicMetaData(),
Column(u'id',PGInteger(),primary_key=True,nullable=False,default=PassiveDefault(<sqlalchemy.sql._TextClause
object at 0xb6fdf06c>)),
Column(u'id_azienda',PGInteger(),ForeignKey(u'azienda.id'),nullable=False),
Column(u'id_anagrafica',PGInteger(),ForeignKey(u'anagrafica.id')),
Column(u'codice_struttura',PGText(length=None,convert_unicode=False)),
Column(u'bdn_id',PGInteger()),
Column(u'bdn_data_ultima_modifica',PG2Date()),
Column(u'bdn_specie',PGChar(length=4,convert_unicode=False)),
Column(u'bdn_flag_carne_latte',PGChar(length=1,convert_unicode=False)),
Column(u'data_inizio',PG2Date()),Column(u'data_fine',PG2Date()),
Column(u'id_precedente',PGInteger(),ForeignKey(u'unita_aziendale.id')),
Column(u'ts_ultima_modifica',PG2DateTime(timezone=False),default=PassiveDefault(<sqlalchemy.sql._TextClause
object at 0xb6fdf98c>)),
Column(u'id_operatore',PGInteger(),ForeignKey(u'operatore.id')),
Column(u'stato_record',PGChar(length=1,convert_unicode=False),default=PassiveDefault(<sqlalchemy.sql._TextClause
object at 0xb6fdfacc>)),schema=None)
Table(u'anagrafica',
DynamicMetaData(),
Column(u'id',PGInteger(),primary_key=True,nullable=False,default=PassiveDefault(<sqlalchemy.sql._TextClause
object at 0xb702390c>)),
Column(u'nome',PGText(length=None,convert_unicode=False)),
Column(u'indirizzo',PGText(length=None,convert_unicode=False)),
Column(u'telefono',PGText(length=None,convert_unicode=False)),
Column(u'email',PGText(length=None,convert_unicode=False)),
Column(u'id_comune',PGInteger(),ForeignKey(u'comune.id')),
Column(u'localita',PGText(length=None,convert_unicode=False)),
Column(u'cap',PGText(length=None,convert_unicode=False)),
Column(u'dato_fiscale',PGText(length=None,convert_unicode=False)),
Column(u'cod_nazionalita',PGChar(length=3,convert_unicode=False),ForeignKey(u'nazione.codice')),
Column(u'data_nascita',PG2Date()),Column(u'id_comune_nascita',PGInteger(),ForeignKey(u'comune.id')),
Column(u'cod_nazione_nascita',PGChar(length=3,convert_unicode=False),ForeignKey(u'nazione.codice')),
Column(u'id_precedente',PGInteger(),ForeignKey(u'anagrafica.id')),
Column(u'ts_ultima_modifica',PG2DateTime(timezone=False),default=PassiveDefault(<sqlalchemy.sql._TextClause
object at 0xb70291cc>)),
Column(u'id_operatore',PGInteger(),ForeignKey(u'operatore.id')),
Column(u'stato_record',PGChar(length=1,convert_unicode=False),default=PassiveDefault(<sqlalchemy.sql._TextClause
object at 0xb702930c>)),
Column(u'tipo',PGChar(length=1,convert_unicode=False),nullable=False,default=PassiveDefault(<sqlalchemy.sql._TextClause
object at 0xb70293cc>)),
Column(u'cod_professione',PGChar(length=3,convert_unicode=False),ForeignKey(u'professione.codice')),
Column(u'cod_titolo_studio',PGChar(length=3,convert_unicode=False),ForeignKey(u'titolo_studio.codice')),schema=None)
assign_mapper(context,
UnitaAziendale,
tbl['unita_aziendale'],
column_prefix="unita_aziendale_",
extension = SelectResultsExt(),
properties = { 'anagrafica' :
relation(Anagrafica, lazy=False),
'figure' :
relation(FiguraAziendale, backref='unita_aziendale'),
'produzioni' :
relation(Produzione, backref='unita_aziendale'),
'azienda_veterinario' :
relation(AziendaVeterinario,
primaryjoin=tbl['azienda_veterinario'].c.id_unita_aziendale ==
tbl['unita_aziendale'].c.id),
'peso' :
relation(SchedaTotali),
})
assign_mapper(context,
Anagrafica,
tbl['anagrafica'],
column_prefix = 'anagrafica_',
extension = SelectResultsExt(),
properties = {
'comune' : relation( Comune,
primaryjoin = tbl['anagrafica'].c.id_comune ==
tbl['comune'].c.id ),
'nazione' : relation( Nazione,
primaryjoin = tbl['anagrafica'].c.cod_nazionalita ==
tbl['nazione'].c.codice ),
'comune_nascita' : relation( Comune,
primaryjoin = tbl['anagrafica'].c.id_comune_nascita
== tbl['comune'].c.id),
'nazione_nascita' : relation(Nazione,
primaryjoin = tbl['anagrafica'].c.cod_nazione_nascita
== tbl['nazione'].c.codice ),
'professione' : relation( Professione ),
'titolo_studio' : relation( TitoloStudio ),
})
i hope this is enough, if not i can send all to you by mail.
> Ah, and which database are you using ?
>
Postgres 8.1
> Are you using SA 0.3 or SA 0.4 ?
>
0.3
Thank's Glauco
--
+------------------------------------------------------------+
Glauco Uri - Programmatore
glauco(at)allevatori.com
Sfera Carta Software(R) [EMAIL PROTECTED]
Via Bazzanese,69 Casalecchio di Reno(BO) - Tel. 051591054
+------------------------------------------------------------+
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
