| 00:00.32 | *** join/#storm wallflower (n=wallflow@ip-205-246-113-216.pool.grokthis.net) |
| 00:06.10 | *** join/#storm mcella (n=mcella@ip-178-10.sn2.eutelia.it) |
| 00:34.14 | *** join/#storm mcella_ (n=mcella@ip-178-10.sn2.eutelia.it) |
| 01:34.03 | *** join/#storm jukart (n=jukart@85-124-221-45.static.xdsl-line.inode.at) |
| 02:03.40 | *** join/#storm jbot (i=ibot@pdpc/supporter/active/TimRiker/bot/apt) |
| 02:03.40 | *** topic/#storm is The Storm Python ORM - http://storm.canonical.com/ - 0.12 released! || Review branches: https://code.launchpad.net/~storm/storm/trunk/+landing-candidates |
| 04:29.55 | *** join/#storm rreis (n=rreis@189.79.166.191) |
| 04:30.27 | rreis | hi, anyone alive? |
| 04:32.07 | thumper | several people I guess |
| 04:32.17 | thumper | we try to kick off the undead |
| 04:32.22 | thumper | :) |
| 04:32.38 | rreis | lol :) |
| 04:33.20 | rreis | so... Im starting to work with DateTime on Storm. |
| 04:33.57 | rreis | can i do something like this? store.find(Example, Example.timestamp.strftime("%m") == '07') |
| 04:34.43 | rreis | i know that it doesnt work, but how can i achieve the same result? |
| 04:36.05 | rreis | im trying to produce a "where month(date_field) = 7" |
| 04:37.49 | thumper | hmm |
| 04:38.12 | thumper | you can always drop to actual sql |
| 04:38.27 | thumper | I'm not sure of anything to do this, but then again, there is much storm I don't know |
| 04:40.30 | rreis | yep...maybe itÅ time to use Expression values. |
| 04:42.22 | rreis | but the problem is that i dont want to use some datetime functions from mysql... I would like to use postgres later. |
| 04:45.37 | thumper | are there not standard date functions between them |
| 04:45.38 | thumper | ? |
| 04:45.54 | thumper | also, I'd ask radix or jkakar |
| 04:46.03 | thumper | perhaps therve_ or jamesh also |
| 04:47.10 | rreis | mmm... yes, i can use the same stuff on both. :) |
| 04:47.54 | rreis | Im trying to be as much database proof as possible. hehe |
| 04:48.18 | jkakar | rreis: Do you need month 7 for any year, or just month 7 for a given year? |
| 04:49.51 | rreis | jkakar, this is just a simple example to start. Im trying to get the last 3 months. |
| 04:51.33 | rreis | jkakar, but if I see an example to get 7 for any year... I can figure out the 3 months problem. |
| 04:52.19 | jkakar | rreis: Okay. You can do something like this: http://paste.ubuntu.com/32472/ |
| 04:52.29 | jamesh | so you want month() on mysql and extract(month from ...) on postgresql and whatever on other systems? |
| 04:53.13 | rreis | yes... i dont want to get stuck in one database. |
| 04:53.38 | jamesh | jkakar's solution looks best |
| 04:54.04 | jamesh | database indexes can be quite good at checking intervals |
| 04:55.11 | jkakar | jamesh: It's your code from the mailing list. :) |
| 04:55.33 | rreis | jkakar, ahh.... :) |
| 05:01.05 | rreis | thanks guys...but just one more question...hehe |
| 05:02.03 | rreis | how can i group by month? |
| 05:03.06 | rreis | can i use python datetime functions inside the store.find statement? |
| 05:14.43 | jamesh | rreis: what exactly do you want to do? |
| 05:15.21 | jamesh | rreis: there is support for GROUP BY in the development version of Storm, but it might not be what you are after |
| 05:15.52 | jamesh | (itertools.group_by might be more appropriate, depending on what you're doing) |
| 05:22.00 | rreis | jkakar, this is what Im trying now... http://paste.ubuntu.com/32477/ |
| 05:27.21 | jamesh | rreis: http://paste.ubuntu.com/32478/ <- that is approximately what you could do with Storm's development version |
| 05:27.32 | jamesh | note that you aren't getting much benefit from the ORM for that particular query though |
| 05:27.52 | jamesh | the group_by() call is most useful when you are selecting a whole table plus some aggregates |
| 05:36.09 | rreis | jamesh, yes, i see, i still need to use the "month", but I will use it only on special cases.... Im already using the Count without problems when i dont need to change the data. |
| 06:22.38 | *** join/#storm jukart (n=jukart@lsfw01.lovelysystems.com) |
| 06:37.35 | *** join/#storm dobee (n=dobee@lsfw01.lovelysystems.com) |
| 07:01.45 | *** join/#storm thumper (n=tim@125-236-193-95.adsl.xtra.co.nz) |
| 07:28.51 | *** join/#storm tlynn (n=tlynn@host81-149-244-57.in-addr.btopenworld.com) [NETSPLIT VICTIM] |
| 08:39.30 | *** join/#storm lightyear (n=ben@nat/fluendo/x-30b2a5c552ff2e24) |
| 09:45.10 | *** join/#storm mcella (n=mcella@ip-178-10.sn2.eutelia.it) |
| 12:20.37 | *** join/#storm niemeyer (n=niemeyer@200-103-133-65.ctame705.dsl.brasiltelecom.net.br) |
| 12:25.54 | *** join/#storm andrea-bs (n=andrea@ubuntu/member/beeseek.developer.andrea-bs) |
| 12:55.41 | jamesh | hi niemeyer |
| 13:05.23 | niemeyer | jamesh: Heyo! |
| 16:24.25 | lightyear | hey guys. is there any way to dump a full database into a file using storm? |
| 16:25.28 | therve | yes? no? maybe? :) |
| 16:25.40 | therve | it's probably not the best tool for the job |
| 16:26.05 | therve | what do you want? insert statements? csv? |
| 16:53.52 | lightyear | therve: we now do it by dumping ourselfs with a simple script ;) |
| 16:54.20 | lightyear | we want to have a functional test for our media scanner, so let it scan over a bunch of files and check that the resulting database is the expected one |
| 16:56.07 | therve | interesting |
| 16:56.45 | therve | lightyear: I can't think of something in storm to really help you |
| 16:56.56 | therve | lightyear: it would also probably perform pretty badly |
| 16:57.21 | therve | lightyear: I think I'd use something to dump to a csv file, and then compare the file content |
| 16:58.17 | lightyear | yes. we thought about it but we don't want the test to be pitty about the row the data is in |
| 16:59.59 | therve | what do you mean? |
| 17:00.51 | therve | sort order? |
| 17:06.19 | lightyear | yes |
| 17:06.37 | *** join/#storm jukart (n=jukart@85-124-221-45.static.xdsl-line.inode.at) |
| 17:06.38 | lightyear | so we currently read two databases and parse the informations into sets of tuples |
| 17:06.44 | lightyear | and then we compare them |
| 19:30.59 | *** join/#storm jamesh (n=james@canonical/launchpad/jamesh) |
| 19:37.28 | *** join/#storm jukart (n=jukart@85-124-221-45.static.xdsl-line.inode.at) |
| 20:26.56 | *** join/#storm kov (n=kov@debian/developer/kov) |
| 21:12.15 | *** join/#storm NCommander (n=mcasadev@cpe-69-207-147-100.rochester.res.rr.com) |
| 22:30.40 | *** join/#storm thumper (n=tim@125-236-196-71.adsl.xtra.co.nz) |
| 23:05.43 | *** join/#storm ubot3 (n=ubot3@unaffiliated/nalioth/bot/ubot3) |