Hi Michael,
Assuming I understood you correctly, I tried the code below. The result was the
same (the query took 486 seconds). Since I autoload everything, I first adjust
the column types to the class you defined. Did I misunderstand something?
Thanks again for your help.
Cheers,
Demitri
---
from sqlalchemy.dialects import postgresql
from sqlalchemy.schema import Column
from sqlalchemy.types import Numeric
...
class ARRAY(postgresql.ARRAY):
def bind_processor(self, dialect):
return None
def result_processor(self, dialect, coltype):
return None
for c in Spectrum.__table__.get_children():
if type(c) is Column:
if c.name in ["values", "inv_var", "and_mask", "or_mask"]: #
numeric[] columns
c.type = ARRAY(Numeric)
print c.name
spPlateFilename = "spPlate-3586-55181.fits"
spectra = session.query(Spectrum).join(SpectrumHeader).\
filter(SpectrumHeader.filename == spPlateFilename).all()
--
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.
