On Fri, Nov 4, 2016 at 8:13 AM, James Burke <james.burke1...@gmail.com> wrote:
> Hi All,
>
> I've run into a odd problem, where calling the count function hangs my code
> indefinitely. The odd thing is it was working until recently, so I'm a
> little confused.
>
> customer =
> session.query(Customer).filter(Customer.phone_number.contains([message['metadata']['MIN']]))
> logger.debug(len(customer.all()))
> logger.debug('Works perfectly fine')
> logger.debug(customer.count())
> logger.debug('I will never see this')
>
> Has anybody run into this problem before?
>What database are you using? Have you tried logging into it to see if it is actually executing the query? If you run the exact query by hand, does it execute quickly? Adding echo='debug' to your create_engine() call will log the query and parameters, which may help. If you Ctrl-C the process, what does the backtrace look like? Simon -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- 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 https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
