On 4/15/15 6:52 AM, Juan Antonio Ibáñez wrote:
Hello,
I have dozens of queries filtering DateTime columns but I have got
one I don't know why it doesn't work. I have:
---------------------------
q = DBSession.query(func.sum(RecargaCredito.importe), Local.nombre)\
.join((Local, RecargaCredito.locales_id == Local.id))
fl_desde = (datetime.now() - timedelta(days=7)).replace(hour=0,
minute=0, second=0)
fl_hasta = datetime.now().replace(hour=23, minute=59, second=59)
q = q.filter(RecargaCredito.fechayhora >= fl_desde).\
filter(RecargaCredito.fechayhora <= fl_hasta)
q = q.group_by(RecargaCredito.locales_id)
f = q.all()
---------------------------
RecargaCredito looks:
---------------------------
class RecargaCredito(DeclarativeBase):
__tablename__ = 'recargas_credito'
__table_args__ = {'mysql_engine':'InnoDB'}
id=Column(Integer, primary_key=True)
fechayhora = DateTime
importe = Column(DECIMAL(9,2))
locales_id=Column(Integer, ForeignKey('locales.id'))
local = relation('Local', remote_side = 'Local.id')
---------------------------
and I get error 'TypeError: can't compare datetime.datetime to
VisitableType'
you seem to be missing "Column()" for fechayhora:
fechayhora = Column(DateTime)
I've checked fl_desde and fl_hasta are python datetime objects
Do you know what that error says?
Regards
--
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 [email protected]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
