| 00:08.12 | *** join/#storm seiflotfy (n=seif@P5118.pallas.wh.tu-darmstadt.de) |
| 00:16.38 | *** join/#storm seiflotfy (n=seif@P5118.pallas.wh.tu-darmstadt.de) |
| 00:24.05 | *** join/#storm seiflotfy3 (n=seif@P5118.pallas.wh.tu-darmstadt.de) |
| 01:07.10 | *** join/#storm seiflotfy (n=seif@P5118.pallas.wh.tu-darmstadt.de) |
| 01:10.34 | *** join/#storm seiflotfy (n=seif@P5118.pallas.wh.tu-darmstadt.de) |
| 01:39.42 | *** join/#storm ivan` (n=ivan`@ludios.net) |
| 05:41.15 | *** join/#storm infobot (i=ibot@rikers.org) |
| 05:41.15 | *** topic/#storm is The Storm Python ORM - http://storm.canonical.com/ - 0.14 released! || Review branches: https://code.launchpad.net/storm/+activereviews || IRC logs: http://ibot.rikers.org/#storm/ |
| 07:38.02 | *** join/#storm ivan` (n=ivan`@ludios.net) |
| 08:08.53 | *** join/#storm _thumper_ (n=quassel@125-236-193-95.adsl.xtra.co.nz) |
| 08:15.22 | *** join/#storm radix (n=r@wordeology.com) [NETSPLIT VICTIM] |
| 10:30.30 | *** join/#storm therve (n=therve@xvm-14-10.ghst.net) |
| 10:56.58 | *** join/#storm andrea-bs (n=andrea@ubuntu/member/beeseek.developer.andrea-bs) |
| 11:15.03 | *** join/#storm zmijunkie (n=chatzill@217.91.111.217) |
| 11:45.37 | *** join/#storm goschtl (n=goschtl@81.187.73.206) |
| 12:13.27 | *** join/#storm goschtl (n=goschtl@81.187.73.206) |
| 12:39.51 | *** join/#storm goschtl (n=goschtl@81.187.73.206) |
| 12:40.51 | *** join/#storm goschtl (n=goschtl@81.187.73.206) |
| 12:42.54 | *** join/#storm niemeyer (n=niemeyer@201.89.9.245) |
| 13:39.54 | *** join/#storm goschtl (n=goschtl@81.187.73.206) |
| 14:06.03 | *** join/#storm mzz (n=mzz@flits102-164.flits.rug.nl) [NETSPLIT VICTIM] |
| 14:09.42 | *** join/#storm keppla (n=keppla@87.123.2.126) |
| 14:10.51 | *** join/#storm goschtl (n=goschtl@81.187.73.206) |
| 14:15.03 | fcorrea | morning gentlemen |
| 14:15.32 | keppla | good morning |
| 14:19.03 | fcorrea | quick question. Supposed you have a resultset foo...will foo.count() actually perform the equivalent count in sql or is it all done in python side? |
| 14:19.30 | keppla | as far as i understand, that will issue a count |
| 14:19.33 | fcorrea | just trying to avoid sql overhead when doing something lie if foo.count() > 0: .... foo.one() |
| 14:19.35 | keppla | query |
| 14:19.42 | fcorrea | keppla: right |
| 14:20.16 | keppla | if you du somehting like "resultset.count() > 0" you may consider "if resultset.any()" as alternative |
| 14:20.25 | fcorrea | keppla: good one |
| 14:20.30 | keppla | thanks |
| 14:21.19 | fcorrea | yeah, maybe a try: except block would be less expensive |
| 14:22.01 | fcorrea | like, try: return foo.one() except: fallback code |
| 14:22.21 | keppla | i was more thinking in terms like for loops |
| 14:22.52 | keppla | if r.any(): |
| 14:22.53 | keppla | <PROTECTED> |
| 14:22.53 | keppla | <PROTECTED> |
| 14:22.53 | keppla | else: |
| 14:22.53 | keppla | <PROTECTED> |
| 14:23.13 | keppla | if have some of those in my template code |
| 14:24.20 | fcorrea | keppla: right. In my case I will always deal with a single object |
| 14:25.31 | keppla | hm, thinking about your example, doesnt one() returns None, if no row is found? |
| 14:25.47 | keppla | instead of raising errors, i mean? |
| 14:26.33 | fcorrea | mmm....never checked if one() would return None. If one does it, then I don't even need to check for any() |
| 14:27.24 | keppla | just tried if (assert store.find(User, User.id == 123123).one() is None) |
| 14:31.28 | fcorrea | did it pass? |
| 14:32.16 | keppla | yeah |
| 14:32.39 | keppla | one seems to raise exceptions only if it finds more than one, not if it finds less |
| 14:32.58 | fcorrea | mmm |
| 14:33.48 | fcorrea | that should not happen in my app :)...but if does, it's my app code and not storm fault :) |
| 14:33.57 | keppla | :) |
| 14:34.02 | fcorrea | keppla: thanks for helpin |
| 14:34.08 | keppla | np |
| 14:34.16 | keppla | glad to help |
| 14:40.41 | *** join/#storm goschtl (n=goschtl@81.187.73.206) |
| 14:44.29 | fcorrea | keppla: see the pattern repeating in here http://bitbucket.org/liberiun/liberiunportaltypes/src/tip/liberiun/portal/types/traversers.py#cl-31 |
| 14:44.41 | fcorrea | ;) |
| 14:47.22 | keppla | :) |
| 15:12.52 | *** join/#storm gord (n=gord@xvm-14-110.ghst.net) |
| 15:28.18 | *** part/#storm keppla (n=keppla@87.123.2.126) |
| 16:02.33 | *** join/#storm andrea-bs (n=andrea@ubuntu/member/beeseek.developer.andrea-bs) |
| 16:18.58 | *** join/#storm goschtl (n=goschtl@94-116-76-139.dynamic.thecloud.net) |
| 16:48.31 | *** join/#storm sidnei (n=sidnei@plone/dreamcatcher) |
| 17:22.15 | *** join/#storm WebMaven (n=webmaven@c-68-35-136-143.hsd1.nm.comcast.net) |
| 17:35.58 | *** join/#storm andrea-bs (n=andrea@ubuntu/member/beeseek.developer.andrea-bs) |
| 21:51.47 | *** join/#storm keppla (n=keppla@i577B027E.versanet.de) |
| 22:56.31 | *** join/#storm artista_frustrad (n=artista_@201-35-53-107.ctame704.dsl.brasiltelecom.net.br) |
| 23:47.08 | *** join/#storm artista_frustrad (n=artista_@201-35-53-107.ctame704.dsl.brasiltelecom.net.br) |