[10:29] <gmb> danilos: I have no idea what to do with this question re: translations. Do you? https://answers.launchpad.net/launchpad/+question/165196
[10:30] <danilos> 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] <gmb> danilos: Will do, thanks.
[11:10] <gary_poster> 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] <gary_poster> 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] <gary_poster> gmb, yeah, Passthrough will try to adapt the context object, thereby bypassing the wrapped property.
[11:29] <gary_poster> I recommend what I said before.
[12:01]  * gmb returns
[12:01] <gmb> 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] <gary_poster> gmb, cool :-)
[12:02] <gmb> Also, I like that you referred to "lazy.delegates"
[12:02] <gary_poster> heh
[12:02] <gary_poster> actually I saw that typo and thought I had fixed it :-P
[12:02] <gmb> :)
[12:03]  * gmb ploughs through some more Questions.
[12:09] <gmb> 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] <bac> gmb: yes, send them off to young matthew
[12:10] <gary_poster> thanks both of you
[12:10] <gmb> bac: Young Matthew it is. Ta.
[12:10] <gmb> 
[12:21] <bac> gmb: is lp2devnull running as cron?
[12:22] <gmb> bac: Yes. Grr. Let me see if it's doing owt.
[12:23] <bac> 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] <bac> s/is/was
[12:23] <gmb> Well, it's certainly been running, according to syslog anyway.
[12:23] <gmb> I'll run it manually. Hang on
[12:24] <bac> 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] <gary_poster> bac, in my world I use chrome, which is fine.
[12:25] <gmb> bac: Just ran it and it seems to have done lots of stuff... Can you check?
[12:25] <bac> 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] <gary_poster> bac, yucko
[12:26] <bac> gmb: it worked, thanks
[12:26] <gary_poster> bac, sounds like a bug report to me
[12:26] <gmb> Hmm.
[12:26] <bac> yeah, those are fruitful
[12:27] <bac> 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] <gary_poster> bac :-P
[12:27] <gary_poster> :-( would have been more apt...
[12:29] <bac> 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 <escalated> <oem-services> <qa-needstesting> <Launchpad itself:Fix Committed by bac> <OEM Priority Project:Invalid> <Ubuntu Translations:Triaged> <pkgbinarymangler (Ubuntu):Fix Released by pitti> < https://launchpad.net/bugs/788685 >
[12:29] <bac> i just moved it back
[12:30] <gmb> bac: That'll be because it has a Fix Release bug task. Also, lp2kanban ignores tags (except for syncing them).
[12:30] <bac> ah, righto
[12:30] <gmb> Two bugs there, huzzah.
[12:30] <gary_poster> bac benji danilos gmb, call in about 2
[12:31] <danilos> k
[12:40] <danilos> https://bugs.launchpad.net/~marcus-haslam
[13:19] <danilos> 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] <gary_poster> :-/
[13:37] <benji> heh, I just read the @accessor_for email; I like the Julia Child option
[13:37] <gary_poster> :-)
[13:37] <gary_poster> that's the one he said he chose
[13:55] <gmb> 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] <gary_poster> gmb, ok.
[14:01] <gary_poster> 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] <gary_poster> 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] <gary_poster> 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] <gary_poster> Would it help for me to run the SELECT version of this on staging?
[14:02] <gary_poster> Done.
[14:03] <gary_poster> there is only one naty on staging...
[14:03] <gary_poster> natty
[14:04] <gary_poster> gmb, oh duh
[14:04] <gary_poster> scratch question about "current owner"
[14:04] <gary_poster> I see in sql
[14:04] <gary_poster> oh no
[14:04] <gmb> gary_poster: Wait a sec, seems the SQL's wrong.
[14:04] <gary_poster> my question was right to begin with
[14:04] <gmb> wiki stomping has happened.
[14:05] <gary_poster> just getting confused
[14:06] <gmb> gary_poster: Please refresh the page; the SQL is correct now.
[14:06] <gmb> Julian and I had edits that collided.
[14:06] <gary_poster> ah
[14:06] <gary_poster> ok
[14:07] <gary_poster> yeah was noticing that all of those four seemed to already be what you wanted, at least on staging
[14:08] <gary_poster> gmb,
[14:08] <gary_poster> lpmain_staging=> SELECT id FROM distroseries WHERE name='oneiric';
[14:08] <gary_poster>  id
[14:08] <gary_poster> -----
[14:08] <gary_poster>  112
[14:08] <gary_poster>  107
[14:09] <gmb> Uh?
[14:09] <gmb> That's... Hmm.
[14:09] <gary_poster> gmb,
[14:09] <gary_poster> lpmain_staging=> SELECT id, summary FROM distroseries WHERE name='oneiric';
[14:09] <gary_poster>  id  |                     summary
[14:09] <gary_poster> -----+--------------------------------------------------
[14:09] <gary_poster>  112 | Series for formula supporting Natty and Oneiric.
[14:09] <gary_poster>  107 | See http://wiki.ubuntu.com/OneiricOcelot
[14:09] <gmb> 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] <gmb> But best to be sure.
[14:10] <gary_poster> gmb, I am sure that is what we want
[14:10] <gmb> Ah, fair enough.
[14:10] <gmb> I'll amend the query.
[14:10] <gary_poster> gmb, but we should probably make the sql clearer
[14:10] <gary_poster> I'd specify the distribution
[14:11] <gary_poster> gmb, while you are editing, humo(u)r me and change IN ('bzr') to = 'bzr' :-)
[14:13] <gmb> gary_poster: Done.
[14:17] <gary_poster> gmb, I just approved it
[14:17] <gmb> gary_poster: Thanks.
[14:17] <gary_poster> yw
[14:18] <gary_poster> gmb, if anyone asks, we can't run it on staging
[14:18] <gary_poster> the bzr record is not there
[14:18] <gmb> gary_poster: Understood.
[14:34]  * gmb -> post office; back in 30
[14:40] <bac> hi danilos
[15:00] <gary_poster> dun-dum-daah!  it's CHR time!
[15:00] <gary_poster> (that was supposed to evoke old TV superhero cartoon noises, FTR)
[15:01] <benji> I heard it.
[15:01] <gary_poster> :-) thanks
[15:37] <gary_poster> 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] <gary_poster> (I assign these things to Matthew so they are reasonably clearly "in progress and supposed to be handled" in that case)
[15:37] <gmb> gary_poster: I pinged Matthew about it but didn't assign the ticket to him.
[15:38] <gary_poster> gmb, cool thx I will assign
[16:16] <bac> danilos: you still around?
[16:21] <gmb> 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] <gary_poster> gmb, rock!
[16:24] <gmb> :)
[16:24] <gary_poster> than you
[16:24] <gmb> np
[16:24] <gary_poster> thank, even
[16:29] <gary_poster> lunch is calling, in a not-too-subtle voice.  biab.
[17:44] <gary_poster> thank you for helping awolfson benji
[17:44] <benji> yep, np
[17:58] <benji> I wonder if this new toy is the thing replying to bug mail: https://outofoffice.canonical.com/
[17:59] <benji> I wonder if it sends out-of-office replies to "Precedence: bulk" messages; it shouldn't.
[18:00] <gary_poster> gmb was talking with is about that I think; the answer was "no" in his conversations, AIUI
[18:00] <gary_poster> benji, worth asking him tomorrow though
[18:00] <benji> k
[18:01] <gary_poster> ("talking with IS," I should say)
[18:03] <benji> I wonder if capital letters will fall out of usage over the next few hundred years.
[18:03] <gary_poster> the revenge of e.e. cumming, they will call it
[18:04] <gary_poster> or cummings, even
[18:05] <benji> heh; I like him.  I wonder if he was a time travelor from some future IRC/SMS wasteland.
[18:05] <gary_poster> heh
[18:27] <benji> I'm down to one last query (per row) to remove.  This one may be tricky.
[18:33] <benji> 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] <gary_poster> 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] <benji> 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] <gary_poster> right
[18:36] <benji> 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] <gary_poster> benji, I was just going to look at the storm code, because I can't remember
[18:36] <gary_poster> storm code is pretty clean
[18:36] <gary_poster> give yourself 15 minutes to dig into it for what you want
[18:37] <benji> yeah, I don't see any way to spell it with just Storm
[18:37] <gary_poster> I was going to start with whatever the join code is
[18:37] <gary_poster> oh ok
[18:37] <gary_poster> lemme try one other source then...
[18:37] <benji> I've already spent 15 on it, so I'll call it and switch to SQL
[18:38] <gary_poster> benji, look up Storm's "Alias"
[18:40] <benji> 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] <gary_poster> benji, here's the example I have (in print :-/ )
[18:40] <gary_poster> columns = (PillarName, Project, Product, SQL('rank'))
[18:41] <gary_poster> fake_table = Alias(SQL(query), 'subselect') # I can give you value of query later
[18:42] <benji> 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] <benji> (and why did you give me the value for columns?)
[18:43] <gary_poster> origin = [PillarName, Join(fake_table, PillarName.name == SQL('subselect.name')), LeftJoin(Project, PillarName.project==Project.id), LeftJoin(Product, PillarName.product==Product.id),]
[18:43] <gary_poster> result = store.using(*origin).find(columns)
[18:44] <gary_poster> "query" is a bug raw sql string that I doubt you care about
[18:44] <benji> 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] <benji> grrr
[18:45] <gary_poster> benji, is it useful to return full objects?  Is it useful to be able to use other Storm query bits
[18:45] <gary_poster> ok, benji, that's all I've got :-)
[18:45] <benji> right now they are full objects; I don't understand the second quesiton
[18:45] <gary_poster> the "useful" questions were intended to let you decide whether storm would be a value add
[18:45] <benji> k
[18:46] <gary_poster> "other storm query bits" : like, let people pass in storm constraints and have them fit in
[18:46] <benji> I'm going to have to ponder this for a bit.
[18:46] <benji> ah
[18:46] <gary_poster> I do that with some internal code
[18:46] <gary_poster> probably not good as a public API, but within a module it was handy
[18:46] <benji> 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] <gary_poster> right
[18:47] <gary_poster> 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] <gary_poster> and all I know how to look up :-)
[18:48] <benji> :)
[19:06] <bac> 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 <escalated> <oem-services> <qa-needstesting> <Launchpad itself:Fix Committed by bac> <OEM Priority Project:Invalid> <Ubuntu Translations:Triaged> <pkgbinarymangler (Ubuntu):Fix Released by pitti> < https://launchpad.net/bugs/788685 >
[19:06] <gary_poster> on call with flacoste
[19:06] <bac> gary_poster: np, i'm done.  just giving you an update
[19:16] <bac> gary_poster: you could come present your ec2 work: http://www.cloudcamp.org/rtp/2011-08-06
[19:46] <benji> bac: you're not CHRing at the moment are you?
[19:46] <bac> benji: no, but i will be in 14 mihtues
[19:46] <bac> which is like a minute on 59.8 seconds
[19:47] <bac> er, only
[19:47] <benji> 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] <bac> we introduce the new concept of Speed CHR
[19:47] <bac> like normal CHR but more dangerous
[20:04] <benji> Faster and CHRier
[20:05] <bac> benji: ok, i'm taking the helm
[20:05] <benji> k
[20:13] <bac> benji: so it looks like we're mostly caught up on CHR.  i was expecting to see a big mess.
[20:14] <benji> bac: the only backlog is open questions, as far as I can tell
[20:37] <gary_poster> just sent email update from Francis call
[20:38] <gary_poster> bac, thanks for update
[20:38] <gary_poster> 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] <gary_poster> bye