| 03:37.48 | *** join/#storm lifeless (~robertc@122.58.129.196) |
| 05:53.11 | *** join/#storm shadows090 (~shadows09@rrcs-97-76-224-197.se.biz.rr.com) |
| 05:55.52 | shadows090 | has anybody had a problem with a primary key being identified? when I try something like print store.get(person, 6).name, it gives a "has no primary key" exception. However I do have a primary key specified in the class as id = Int(primary=True). Any ideas of what I could check? The field in my db is id, it's auto incrementing, unsigned, and 6 maps to a real entry. this is using mysql |
| 05:57.17 | shadows090 | any help would be appreciated. I'm pretty stumped on this. i've tried changing "id" to "pkey" in both the db and the class, but i can't get rid of the exception. I'm including it from another file as "from PersonClass import *", and it seems to be importing the class correctly |
| 11:22.21 | milosn | marienz: its been a week, i didnt observe the stale data issue with postgres again |
| 11:22.52 | milosn | it must have been bug in my code someplace, bad thing is i dont know where the bug was :) |
| 11:23.39 | milosn | playing with his storm/twisted project again |
| 11:23.53 | milosn | man you gotta love weekends |
| 11:23.55 | milosn | :D |
| 15:43.41 | *** join/#storm Horrorcat (~unknown@static.88-198-247-171.clients.your-server.de) |
| 15:43.45 | Horrorcat | hi all |
| 15:44.03 | Horrorcat | is there a way to express the following in storm: |
| 15:44.40 | Horrorcat | SELECT YEAR(FROM_UNIXTIME(Timestamp)) as year, MONTH(FROM_UNIXTIME(Timestamp)) as month, COUNT(*) FROM transmissions LEFT JOIN broadcasts ON (transmissions.BroadcastID = broadcasts.ID) WHERE broadcasts.StationID = '%d' GROUP BY year, month ORDER BY year ASC, month ASC |
| 15:44.44 | Horrorcat | ? |
| 15:45.22 | Horrorcat | the problem is the GROUP BY on aliased columns |
| 15:48.12 | Horrorcat | ah |
| 15:48.23 | Horrorcat | .group_by(Column("year"), Column("month")) did the trick! |
| 16:16.05 | *** join/#storm artista_frustrad (~artista_f@189.73.40.178) |
| 16:56.39 | *** join/#storm artista_frustrad (~artista_f@189.73.40.178) |
| 17:21.09 | *** join/#storm magmatt (~Matt@63-235-131-194.dia.static.qwest.net) |