[10:29] danilos: I have no idea what to do with this question re: translations. Do you? https://answers.launchpad.net/launchpad/+question/165196 [10:30] gmb, please assign that to me, there's a very similar question from dpm already and I'll have to discuss that with henninge later today [10:30] danilos: Will do, thanks. [11:10] gmb (& benji) I'm taking a look at the accessor_for/mutator_for stuff. I'll toss it to benji if I can't figure it out. :-P [11:23] gmb, the easiest thing to do that would almost certainly work would be to define a PropertyWithAccessorAndMutator and move on. I'm digging into Passthrough now though. [11:28] gmb, yeah, Passthrough will try to adapt the context object, thereby bypassing the wrapped property. [11:29] I recommend what I said before. [12:01] * gmb returns [12:01] gary_poster: Thanks for the email. I'm going to chose the purple face, since the PropertyWithAccessorAndMutator option is so obvious I should have spotted it a mile off. [12:01] gmb, cool :-) [12:02] Also, I like that you referred to "lazy.delegates" [12:02] heh [12:02] actually I saw that typo and thought I had fixed it :-P [12:02] :) [12:03] * gmb ploughs through some more Questions. [12:09] gary_poster: To whom should a person speak if they want a Private PPA? I'm guessing it's lumped in with commercial subscriptions, but that's just a guess. [12:09] gmb: yes, send them off to young matthew [12:10] thanks both of you [12:10] bac: Young Matthew it is. Ta. [12:10] [12:21] gmb: is lp2devnull running as cron? [12:22] bac: Yes. Grr. Let me see if it's doing owt. [12:23] i have a bug that is simple (only one bugtask and is for lp) that hasn't updated. my understanding is that only cards for bugs with multiple bugtasks were troublesome. [12:23] s/is/was [12:23] Well, it's certainly been running, according to syslog anyway. [12:23] I'll run it manually. Hang on [12:24] gary_poster: in your world, do you use safari to hit launchpad.dev? with lion it is broken for me. firefox continues to work. [12:24] bac, in my world I use chrome, which is fine. [12:25] bac: Just ran it and it seems to have done lots of stuff... Can you check? [12:25] gary_poster: for some odd reason, safari is not using /etc/hosts for name resolution as it properly did pre-lion. so it tries to do a dns lookup for launchpad.dev [12:25] bac, yucko [12:26] gmb: it worked, thanks [12:26] bac, sounds like a bug report to me [12:26] Hmm. [12:26] yeah, those are fruitful [12:27] a guy at dinner the other night mentioned apple contacted him to test a fix for a problem he filed four years and three OS versions ago. it was their first acknowledgment of the bug. [12:27] bac :-P [12:27] :-( would have been more apt... [12:29] gmb: my card for bug 788685 got moved to done-done even though it is qa-needstesting [12:29] <_mup_> Bug #788685: Enable translating selected Ubuntu universe packages in Launchpad

< https://launchpad.net/bugs/788685 > [12:29] i just moved it back [12:30] bac: That'll be because it has a Fix Release bug task. Also, lp2kanban ignores tags (except for syncing them). [12:30] ah, righto [12:30] Two bugs there, huzzah. [12:30] bac benji danilos gmb, call in about 2 [12:31] k [12:40] https://bugs.launchpad.net/~marcus-haslam [13:19] apparently, IS and plenty other people have noticed auto-responder emails too, I've seen some grudging comments in bugs as well, hopefully it doesn't end up being too bad for us :/ [13:19] :-/ [13:37] heh, I just read the @accessor_for email; I like the Julia Child option [13:37] :-) [13:37] that's the one he said he chose [13:55] gary_poster: Can you take a look at - and approve, if possible - my SQL request on https://wiki.canonical.com/InformationInfrastructure/OSA/RequestLogging/LP/SQL? It's to resolve a problem with the owner of the bzr packageset for Oneiric. [13:55] gmb, ok. [14:01] gmb, I would feel better if you first asked them to run "SELECT * FROM packageset WHERE name = ..." and verified that you got what you expected before asking for the update. Failing that, we can maybe go with these following questions. [14:01] what/who is the current owner of those four packages, or more generally, can I assume that you have doublechecked those four names are definitely what you want? [14:02] Have you verified that there are no distroseries with a name of 'natty' other than the one you want? (SELECT id FROM distroseries WHERE name='natty') [14:02] Would it help for me to run the SELECT version of this on staging? [14:02] Done. [14:03] there is only one naty on staging... [14:03] natty [14:04] gmb, oh duh [14:04] scratch question about "current owner" [14:04] I see in sql [14:04] oh no [14:04] gary_poster: Wait a sec, seems the SQL's wrong. [14:04] my question was right to begin with [14:04] wiki stomping has happened. [14:05] just getting confused [14:06] gary_poster: Please refresh the page; the SQL is correct now. [14:06] Julian and I had edits that collided. [14:06] ah [14:06] ok [14:07] yeah was noticing that all of those four seemed to already be what you wanted, at least on staging [14:08] gmb, [14:08] lpmain_staging=> SELECT id FROM distroseries WHERE name='oneiric'; [14:08] id [14:08] ----- [14:08] 112 [14:08] 107 [14:09] Uh? [14:09] That's... Hmm. [14:09] gmb, [14:09] lpmain_staging=> SELECT id, summary FROM distroseries WHERE name='oneiric'; [14:09] id | summary [14:09] -----+-------------------------------------------------- [14:09] 112 | Series for formula supporting Natty and Oneiric. [14:09] 107 | See http://wiki.ubuntu.com/OneiricOcelot [14:09] gary_poster: Oaky. We should continue this in #launchpad so that cjwatson can clear up the confusion for us. I suspect 107 is the one we want. [14:10] But best to be sure. [14:10] gmb, I am sure that is what we want [14:10] Ah, fair enough. [14:10] I'll amend the query. [14:10] gmb, but we should probably make the sql clearer [14:10] I'd specify the distribution [14:11] gmb, while you are editing, humo(u)r me and change IN ('bzr') to = 'bzr' :-) [14:13] gary_poster: Done. [14:17] gmb, I just approved it [14:17] gary_poster: Thanks. [14:17] yw [14:18] gmb, if anyone asks, we can't run it on staging [14:18] the bzr record is not there [14:18] gary_poster: Understood. [14:34] * gmb -> post office; back in 30 [14:40] hi danilos [15:00] dun-dum-daah! it's CHR time! [15:00] (that was supposed to evoke old TV superhero cartoon noises, FTR) [15:01] I heard it. [15:01] :-) thanks [15:37] gmb, is https://support.one.ubuntu.com/Ticket/Display.html?id=3622 the one you asked mrevell about, or was that another one (and so I can ask him)? [15:37] (I assign these things to Matthew so they are reasonably clearly "in progress and supposed to be handled" in that case) [15:37] gary_poster: I pinged Matthew about it but didn't assign the ticket to him. [15:38] gmb, cool thx I will assign [16:16] danilos: you still around? [16:21] gary_poster: FYI, WRT the out of office notification problem discussed earlier; sladen had collated a list of bug and comment IDs. I've written a short script and have hidden all the offending comments. We can re-run this as necessary with different data sets. [16:24] gmb, rock! [16:24] :) [16:24] than you [16:24] np [16:24] thank, even [16:29] lunch is calling, in a not-too-subtle voice. biab. [17:44] thank you for helping awolfson benji [17:44] yep, np [17:58] I wonder if this new toy is the thing replying to bug mail: https://outofoffice.canonical.com/ [17:59] I wonder if it sends out-of-office replies to "Precedence: bulk" messages; it shouldn't. [18:00] gmb was talking with is about that I think; the answer was "no" in his conversations, AIUI [18:00] benji, worth asking him tomorrow though [18:00] k [18:01] ("talking with IS," I should say) [18:03] I wonder if capital letters will fall out of usage over the next few hundred years. [18:03] the revenge of e.e. cumming, they will call it [18:04] or cummings, even [18:05] heh; I like him. I wonder if he was a time travelor from some future IRC/SMS wasteland. [18:05] heh [18:27] I'm down to one last query (per row) to remove. This one may be tricky. [18:33] gary_poster: Do you know how to rename a table in a JOIN? I don't know the term for it and I don't see that Storm supports it. (I need to join the same table twice, the second time with a new name so I can distinguish it in the join condition) [18:34] benji, dunno if it helps, but I imagine you've seen the "it can be faster to get a big chunk out of the database in a kind of raw format and then significantly process it in Python" approach. rename a table in a join with storm. not sure; looking [18:35] yeah, I used that approach in my last task, but this one actually makes sense as a SQL query, unfortunately I'm not using SQL so... [18:35] right [18:36] I could always switch to SQL. It might be the sanest thing. Maybe in review someone will show me the Storm-tastic way of doing it. [18:36] benji, I was just going to look at the storm code, because I can't remember [18:36] storm code is pretty clean [18:36] give yourself 15 minutes to dig into it for what you want [18:37] yeah, I don't see any way to spell it with just Storm [18:37] I was going to start with whatever the join code is [18:37] oh ok [18:37] lemme try one other source then... [18:37] I've already spent 15 on it, so I'll call it and switch to SQL [18:38] benji, look up Storm's "Alias" [18:40] gary_poster: I saw that, but it's intended for ORDER BY, and my reading of the code suggests that it won't work for JOINs because the JOINs don't have a place to specify the alias (the actual string that the column should be aliased to) [18:40] benji, here's the example I have (in print :-/ ) [18:40] columns = (PillarName, Project, Product, SQL('rank')) [18:41] fake_table = Alias(SQL(query), 'subselect') # I can give you value of query later [18:42] oh, that's using a subselect; I guess that could work... but I'm hesitant to work so hard to avoid SQL; what do you think? [18:43] (and why did you give me the value for columns?) [18:43] origin = [PillarName, Join(fake_table, PillarName.name == SQL('subselect.name')), LeftJoin(Project, PillarName.project==Project.id), LeftJoin(Product, PillarName.product==Product.id),] [18:43] result = store.using(*origin).find(columns) [18:44] "query" is a bug raw sql string that I doubt you care about [18:44] wait, I just realized that since I'm using this TemplatesCollection thing, I don't think even that would work (or how to transition sanely to SQL) [18:44] grrr [18:45] benji, is it useful to return full objects? Is it useful to be able to use other Storm query bits [18:45] ok, benji, that's all I've got :-) [18:45] right now they are full objects; I don't understand the second quesiton [18:45] the "useful" questions were intended to let you decide whether storm would be a value add [18:45] k [18:46] "other storm query bits" : like, let people pass in storm constraints and have them fit in [18:46] I'm going to have to ponder this for a bit. [18:46] ah [18:46] I do that with some internal code [18:46] probably not good as a public API, but within a module it was handy [18:46] not here, but I could see why that would be a reason to use Storm (keeping you from having to munge strings six ways from Sunday) [18:46] right [18:47] ok cool, I'm happy to try and be a sounding board if you want to talk through whatever problem you've identified, but otherwise, that's all I know benji :-) [18:48] and all I know how to look up :-) [18:48] :) [19:06] hi gary, fyi i worked with julian until he left for EOD trying to do QA for bug 788685 . it is a pretty involved process and once we finally got a new package built, uploaded, and processed the build failed for unrelated reasons. by then julian was gone. [19:06] <_mup_> Bug #788685: Enable translating selected Ubuntu universe packages in Launchpad

< https://launchpad.net/bugs/788685 > [19:06] on call with flacoste [19:06] gary_poster: np, i'm done. just giving you an update [19:16] gary_poster: you could come present your ec2 work: http://www.cloudcamp.org/rtp/2011-08-06 [19:46] bac: you're not CHRing at the moment are you? [19:46] benji: no, but i will be in 14 mihtues [19:46] which is like a minute on 59.8 seconds [19:47] er, only [19:47] k; I silenced my CHR alarm and then promptly forgot to do it; I'll see how much I can do in 15 minutes. [19:47] we introduce the new concept of Speed CHR [19:47] like normal CHR but more dangerous [20:04] Faster and CHRier [20:05] benji: ok, i'm taking the helm [20:05] k [20:13] benji: so it looks like we're mostly caught up on CHR. i was expecting to see a big mess. [20:14] bac: the only backlog is open questions, as far as I can tell [20:37] just sent email update from Francis call [20:38] bac, thanks for update [20:38] i'll consider the cloud thing, but I may be more interested in that sort of thing when Julia is a bit older. That's lazy I know...we'll see :-) [20:39] * gary_poster past EoD [20:39] bye