the quickest route would be to use DEBUG logging or echo=debug which will show the rows coming back.
or I’d just stick a pdb.set_trace() and/or pdb.post_mortem() in the source of your app or SQLalchemy and poke from there when the error occurs. On Oct 28, 2013, at 10:43 AM, Gustavo Gawryszewski <[email protected]> wrote: > Is there a way to force sqlalchemy to print out which is the result > that is breaking the system? > > On Mon, Oct 28, 2013 at 12:40 PM, Michael Bayer > <[email protected]> wrote: >> it seems apparent that data that isn’t in the range (None, 0, 1) is getting >> into that column, that’s the part you’d need to fix. >> >> Or make yourself a custom type that interprets whatever number it is you’re >> putting in there as a boolean. >> >> >> On Oct 28, 2013, at 10:34 AM, Gustavo Gawryszewski <[email protected]> >> wrote: >> >>> Well, it happened again after i've added some data to my database. >>> >>> I'm using sqlalchemy 0.8.3 and pymysql 0.6.1. (I have also tried with >>> mysql-python 1.2.4) >>> >>> On Fri, Oct 25, 2013 at 3:33 PM, Michael Bayer <[email protected]> >>> wrote: >>>> >>>> On Oct 25, 2013, at 12:59 PM, Gustavo Gawryszewski <[email protected]> >>>> wrote: >>>> >>>> >>>> I've got an error while trying to retrieve boolean items from mysql. >>>> >>>> as stated in >>>> http://stackoverflow.com/questions/19591801/sqlalchemy-cant-convert-boolean-to-int-with-mysql >>>> >>>> but when I've installed without the C Extensions everything worked fine. >>>> >>>> Is that a bug? >>>> >>>> >>>> can’t reproduce, please see http://stackoverflow.com/a/19596096/34549 >>>> >>>> >>>> >>>> -- >>>> 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/groups/opt_out. >>>> >>>> >>>> -- >>>> 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/groups/opt_out. >>> >>> >>> >>> -- >>> Gustavo Gawryszewski >>> Founder & Principal Designer >>> www.bekind.com.br >>> >>> Mobile: +55 51 9456-4554 >>> Website: http://gawry.com >>> LinkedIn: http://www.linkedin.com/in/gawry >>> Twitter: http://twitter.com/gawry >>> >>> -- >>> 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/groups/opt_out. >> >> -- >> 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/groups/opt_out. > > > > -- > Gustavo Gawryszewski > Founder & Principal Designer > www.bekind.com.br > > Mobile: +55 51 9456-4554 > Website: http://gawry.com > LinkedIn: http://www.linkedin.com/in/gawry > Twitter: http://twitter.com/gawry > > -- > 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/groups/opt_out. -- 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/groups/opt_out.
