| 01:27.07 | *** join/#storm webmaven (~webmaven@c-68-35-25-63.hsd1.nm.comcast.net) |
| 02:22.24 | *** join/#storm shaunm (~shaunm@c-98-212-133-244.hsd1.il.comcast.net) |
| 03:09.28 | *** join/#storm jdobrien (~john@146.22.103.97.cfl.res.rr.com) |
| 03:10.00 | *** join/#storm nocaloan (~billy@dsl081-087-021.lax1.dsl.speakeasy.net) |
| 03:10.43 | jdobrien | is there a hook that can fire when a storm object is changed? |
| 03:11.39 | jdobrien | something that would fire before commit, but not when no properties were changed |
| 03:12.05 | novemcame | i'm working with a really bizarre table setup that has an "ON UPDATE timestamp = CURRENT_TIME()" even though that shouldn't be the default action |
| 03:12.28 | bob2 | __storm__invalidated__? |
| 03:12.37 | novemcame | how can I tell storm not to update the column on an update. I've tried item.timestamp=item.timestamp and that doesn't seem to work |
| 03:13.02 | jdobrien | novemcame, that's not storm |
| 03:13.10 | bob2 | how could storm not trigger that? |
| 03:13.28 | jdobrien | novemcame, the database triggers it |
| 03:14.04 | novemcame | right, but with a MySQL statement I can tell it I want the timestamp to remain the same by specifying "timestamp=timestamp" in a SQL clause |
| 03:14.21 | novemcame | (and I understand that the best solution is removing that ON UPDATE clause, just curious if there's a work around) |
| 03:14.48 | jdobrien | novemcame, is this MySQL? |
| 03:14.53 | novemcame | Yes |
| 03:15.47 | jdobrien | novemcame, storm just runs SQL, it's not magic. the database will do the rest |
| 03:17.28 | jdobrien | novemcame, update table ??? set timestamp=timestamp; prevents the trigger from firing in SQL, the same will happen if you set the value in storm |
| 03:17.50 | jdobrien | I mean to say if... |
| 05:07.04 | *** join/#storm shaunm_ (~shaunm@c-98-212-133-244.hsd1.il.comcast.net) |
| 06:22.54 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
| 06:29.03 | *** join/#storm stub1 (~stub@ppp-58-8-17-216.revip2.asianet.co.th) |
| 06:29.07 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
| 06:31.57 | *** join/#storm stub1 (~stub@ppp-58-8-240-232.revip2.asianet.co.th) |
| 06:32.00 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
| 07:13.27 | *** join/#storm jukart (lovely@81.189.156.94) |
| 08:01.18 | *** join/#storm zmijunkie (~chatzilla@i59F5C2B8.versanet.de) |
| 08:09.51 | *** join/#storm bigjools (~quassel@canonical/launchpad/bigjools) |
| 08:15.03 | jamesh | jdobrien: I didn't notice you asking this question here. There is no hook that will tell you about all changes. |
| 08:15.34 | jamesh | jdobrien: the __storm_flushed__() method will be called on objects after flushing changes made through the object itself. |
| 08:15.55 | jamesh | jdobrien: but it won't fire if you make changes through a ResultSet (i.e. with ResultSet.set() or ResultSet.remove()) |
| 08:16.59 | jamesh | if you need to catch all changes, then a DB trigger might be appropriate. |
| 11:38.49 | jdobrien | jamesh, thanks |
| 14:06.36 | *** join/#storm shaunm_ (~shaunm@c-98-212-133-244.hsd1.il.comcast.net) |
| 15:23.58 | mup | storm/trunk r358 committed by jkakar@kakar.ca |
| 15:23.58 | mup | Merged reference-set-order-by [r=niemeyer,sidnei] [f=580037] |
| 15:23.59 | mup | The order_by property defined for a ReferenceSet can now be |
| 15:23.59 | mup | specified as string, in order to avoid circular dependency issues. |
| 15:23.59 | mup | The property column is resolved after import time. |
| 16:28.30 | *** join/#storm jkakar (~jkakar@145.Red-79-150-162.dynamicIP.rima-tde.net) |
| 16:31.27 | *** join/#storm m4v (~znc@unaffiliated/m4v) |
| 17:15.18 | *** join/#storm jdobrien (~john@97.103.22.146) |
| 17:41.18 | jdobrien | how would I do a find condition so that the SQL was something like select * from t where i = 1 and (x!='A' and b.alive=True) |
| 17:42.31 | therve | jdobrien: the parenthesis don't change anything right? |
| 17:44.23 | therve | is b another table? is it missing a joing? |
| 17:44.33 | jdobrien | therve, it's a typo |
| 17:45.30 | jdobrien | therve, I my be overthinking this one |
| 17:46.00 | therve | maybe :) |
| 17:46.03 | therve | what's the real query? |
| 17:47.13 | jdobrien | therve, something like select * from object where gen > 1 and (status!='Dead' and first_gen > 1) |
| 17:48.37 | jdobrien | therve, so I want all status = 'Live' and only status='Dead' where first_gen <= 1 |
| 17:49.48 | jdobrien | or select * from object where gen > 1 and (status = Live or (status='Dead' and first_gen <= 1)) |
| 17:50.34 | jdobrien | therve, basically I want do do a condition based on two values |
| 17:50.53 | jdobrien | i mean two conditions |
| 17:57.33 | *** join/#storm jukart (~jukart@d86-32-163-62.cust.tele2.at) |
| 17:57.47 | jdobrien | therve, how do I group conditions in storm find? |
| 17:57.58 | jdobrien | hmm parenthesis? hehe |
| 17:58.07 | jdobrien | And() |
| 18:01.18 | jdobrien | oh here's what I want Not() |
| 18:03.03 | jkakar | jdobrien: You want And and Or (and maybe Not). |
| 18:03.20 | jdobrien | jkakar, yeah i wanted Not |
| 18:03.50 | jkakar | jdobrien: store.find(Object, Object.gen > 1, Or(Object.status == "Live", And(Object.status == "Dead", Object.first_gen <= 1))) |
| 18:04.18 | jdobrien | jkakar, it's simpler with a Not since status can only be Live or Dead |
| 18:04.48 | jdobrien | jkakar, thanks! |
| 18:05.22 | jkakar | jdobrien: Ah, right, I see. |
| 18:12.21 | jdobrien | jkakar, Not doesn't do what I thought it did |
| 18:12.37 | jdobrien | AND Object.generation > 0 AND NOT false, (Ob |
| 18:13.55 | jkakar | jdobrien: Can you paste the Storm code you're using please? |
| 18:14.27 | jdobrien | jkakar, i think im on the right track...i ask again if this doesn't work |
| 18:14.30 | jkakar | jdobrien: Okay. |
| 19:34.29 | *** join/#storm m4v (~znc@unaffiliated/m4v) |
| 23:41.07 | *** join/#storm jkakar (~jkakar@145.Red-79-150-162.dynamicIP.rima-tde.net) |