| 02:06.47 | thumper | what's the shorthand way for deleting all rows in a storm table? |
| 02:08.00 | jkakar | thumper: store.find(MyClass).remove() |
| 02:08.06 | thumper | ta |
| 02:08.08 | jkakar | np |
| 03:29.59 | *** join/#storm shaunm (n=shaunm@c-98-212-133-244.hsd1.il.comcast.net) |
| 05:07.19 | *** join/#storm bigdog (n=scmikes@72-197-8-8-arpa.cust.cinci.current.net) |
| 05:19.38 | *** join/#storm sidnei (n=sidnei@plone/dreamcatcher) |
| 05:24.28 | *** join/#storm bigdog1 (n=scmikes@72-197-8-8-arpa.cust.cinci.current.net) |
| 05:39.19 | *** join/#storm jukart (i=lovely@81.189.156.94) |
| 07:42.39 | *** join/#storm gord_ (n=gord@5ac7ea10.bb.sky.com) |
| 12:34.26 | *** join/#storm niemeyer (n=niemeyer@200-138-37-42.ctame705.dsl.brasiltelecom.net.br) |
| 12:45.58 | *** part/#storm sidnei (n=sidnei@plone/dreamcatcher) |
| 14:31.25 | *** join/#storm goschtl (n=goschtl@p5B0BBA23.dip.t-dialin.net) |
| 14:54.33 | *** join/#storm shaunm (n=shaunm@proxyserver.wolfram.com) |
| 16:03.13 | *** join/#storm jukart (n=jukart@d91-128-122-97.cust.tele2.at) |
| 16:39.12 | *** join/#storm jukart (n=jukart@d91-128-122-97.cust.tele2.at) |
| 16:50.00 | *** join/#storm bigdog1 (n=scmikes@72-197-8-8-arpa.cust.cinci.current.net) |
| 17:13.05 | *** join/#storm jukart (n=jukart@d91-128-122-97.cust.tele2.at) |
| 17:22.25 | *** join/#storm ivan` (n=ivan`@unaffiliated/ivan/x-000001) |
| 18:06.41 | *** join/#storm bigdog1 (n=scmikes@72-197-8-8-arpa.cust.cinci.current.net) |
| 20:31.05 | *** join/#storm oubiwann (n=oubiwann@97-119-80-165.omah.qwest.net) |
| 21:09.04 | *** join/#storm baijum (n=baiju@69.15.70.194) |
| 21:10.02 | baijum | Hi all, I was looking at Oracle backend |
| 21:10.32 | baijum | I want to use Sequence object, so I can use like: id = Int(primary=True, default=Sequence("person_seq")) |
| 21:11.34 | baijum | To support this I added: |
| 21:11.34 | baijum | @compile.when(Sequence) |
| 21:11.34 | baijum | def compile_sequence_oracle(compile, sequence, state): |
| 21:11.34 | baijum | <PROTECTED> |
| 21:11.34 | baijum | to backend |
| 21:11.48 | baijum | and it wroks fine with Oracle |
| 21:12.08 | baijum | now I want to use this same Schema with MS SQL |
| 21:12.40 | baijum | How can I change the backed of MS SQL to ignore this Sequence support |
| 21:13.32 | baijum | any pointer ? |
| 21:16.05 | jkakar | baijum: Is there a reason not to use the AUTO_INCREMENT flag on the column in the database? Then you can define id = Int(primary=True) and the right thing should happen, no? |
| 21:16.20 | jkakar | baijum: OH, MS SQL, Sorry, I read MySQL there. |
| 21:16.38 | jkakar | baijum: I haven't used MS SQL in years, so I really don't know the answer. |
| 21:16.42 | baijum | jkakar: I am using IDENTITY with MS SQL |
| 21:16.51 | baijum | and Sequence with Oracle |
| 21:16.55 | jkakar | I see. |
| 21:17.23 | baijum | jkakar: ok, thanks |
| 21:18.26 | baijum | going to ask this question in list |
| 21:24.31 | bac | hi jkakar |
| 21:25.40 | jkakar | Heya bac. How goes it? |
| 21:26.01 | bac | jkakar: pretty good. i'm a bit stuck though |
| 21:26.25 | bac | i've got some methods on a db class, stuff like findPerson, findTeam, etc |
| 21:26.46 | bac | most are still written in sqlobject syntax. i've converted one to be all stormy. so far so good. |
| 21:27.21 | bac | the methods all take an optional 'orderBy' parameter. i'm stuck trying to find a unified syntax that make storm and sqlobject happy. any ideas? |
| 21:28.08 | jkakar | bac: So, for now, you want to avoid changing call sites, and just provide the same interface? |
| 21:28.30 | *** join/#storm oubiwann (n=oubiwann@97-119-81-226.omah.qwest.net) |
| 21:28.38 | jkakar | bac: The typical Storm thing to do is to return a ResultSet and let the caller call .order_by(...), based on their needs. |
| 21:28.55 | jkakar | bac: We have methods in Landscape where we call result.order_by(...) before returning it from such methods. |
| 21:28.56 | bac | jkakar: yeah, i'd like to be able to pass the same syntax for orderBy to the methods, regardless of the orm they happen to use |
| 21:29.15 | jkakar | bac: You can also specify a default order with __storm_order__ on your class. |
| 21:29.54 | jkakar | bac: The orderBy argument, is it something like findPerson(orderBy=Person.name), or is something else? |
| 21:31.35 | bac | jkakar: exactly. the problem is storm wants a tuple of column names and sqlobject wants something more like "person_sort_key(Person.displayname, Person.name)") |
| 21:32.16 | jkakar | bac: Let me just try something here, one sec please. |
| 21:34.09 | jkakar | bac: Okay, sweet. You can pass a string to ResultSet.order_by. |
| 21:34.23 | jkakar | bac: Something like result.order_by("Person.displayname"). |
| 21:34.53 | bac | jkakar: ok, cool, that's helpful |
| 21:35.24 | jkakar | bac: Or, result.order_by("Person.displayname, Person.name") |
| 21:35.46 | bac | great, i was just going to try that |
| 21:35.56 | jkakar | bac: Maybe you can create a regular expression to extract this from the string SQLObject expects...? |
| 21:36.22 | jkakar | bac: I'm not really sure what SQLObject expects, so hard to give more concrete advice than that. |
| 21:36.40 | bac | jkakar: i think i can just accept the string and either convert it to what sqlobject wants or pass straight to storm, whichever is appropriate |
| 21:37.56 | jkakar | bac: Cool. |
| 22:58.00 | *** join/#storm baijum (n=baiju@69.15.70.194) |