/srv/irclogs.ubuntu.com/2006/05/08/#launchpad.txt

matsubaraKurtKraut: that's an interesting feature. I suggest you to file a bug. Usually you would go to the list of open request to verify the ones that need help.12:04
matsubarasince it's not possible to close request you end up with lots of open requests that should be in a closed state12:05
KurtKrautmatsubara, yes, that how I've been doing that. But after clicking and reading about 10 request, I can find only one that stills needs help and I still can contribute with12:05
=== zyga [n=zyga@ubuntu/member/zyga] has joined #launchpad
matsubaraKurtKraut: I feel your pain. I'm the one triaging Launchpad support requests. Are you using the Web UI or the the email interface?12:09
KurtKrautmatsubara, I'm using the web UI12:09
KurtKrautmatsubara, I've never tried thru e-mail. I suppose it would be even messier ;D12:10
matsubaraKurtKraut: currently it's a bit messy indeed. But you could try using your email client filters to help with that.12:10
KurtKrautmatsubara, I check my e-mail mostly in public computers at university. They're all Windows so I can't have an e-mail client. I'm forced to use gmail webmail12:12
=== ddaa -> bed
matsubarafound it! bug 3157 KurtKraut 12:15
UbugtuMalone bug 3157 in launchpad "Anyone should be able to edit a support ticket" [Normal,Confirmed]  http://launchpad.net/bugs/315712:15
KurtKrautmatsubara, it would be good. be besides that, non-replied equest should be also trackable.12:16
matsubaraKurtKraut: please file a bug: https://launchpad.net/products/launchpad/+filebug12:16
KurtKrautI'm doing that at the moment ;D12:17
KurtKrautmatsubara, done. Check if https://launchpad.net/products/launchpad/+bug/42665 is understandable12:18
UbugtuMalone bug 42665 in launchpad "LP should allow tracking support requests that has not been replied yet" [Normal,Unconfirmed]  12:18
matsubaraKurtKraut: thanks,12:18
=== mpt_ [n=mpt@203-173-141-46.bliink.ihug.co.nz] has joined #launchpad
matsubaraKurtKraut: i think so.12:20
elmohttps://launchpad.net/distros/ubuntu/dapper/+source/gnupg/+pots/gnupg/pt_BR12:22
elmoif TODO is 0, why is the bar split in two, with 70% being marked NEW ?12:22
elmo(in the lowermost left hand portlet)12:22
matsubaraelmo: I think there's an open bug about that.12:23
elmook12:23
matsubaraelmo: bug 3929112:25
UbugtuMalone bug 39291 in rosetta "status bar on package listing wrong" [Normal,Confirmed]  http://launchpad.net/bugs/3929112:25
elmomatsubara: cool, thanks12:25
=== zyga_ [n=zyga@ubuntu/member/zyga] has joined #launchpad
=== SnkBite [n=SnkBite@212.25.63.35] has joined #launchpad
=== KurtKraut is now known as kurtkraut
=== salgado_ [n=salgado@201-27-4-75.dsl.telesp.net.br] has joined #launchpad
mdkespiv: ping?01:13
=== kurtkraut is now known as KurtKraut
mdkespiv: if you get this, just chasing up on my emails.01:30
mdke-> bed01:31
=== jdong [n=jdong@d192-24-132-154.try.wideopenwest.com] has joined #launchpad
lifelessZnarl: or elmo: there is a new rt request for balleny.03:40
lifelessappreciate if that can be done asap03:40
mpt_Gooooooooooooooooood afternoon Launchpadders!03:59
mpt_salgado, pong03:59
mpoolgood morning04:03
KurtKrautgood night (in UTC-3) :P04:04
=== SnkBite [n=SnkBite@212.25.63.35] has joined #launchpad
=== stub [n=stub@ppp-58.8.1.191.revip2.asianet.co.th] has joined #launchpad
dilysMerge to devel/launchpad/: [trivial]  Fix bug 41138 (+viewstatus crashes when opening a remote bug) (r1846: Brad Bollenbach)04:43
=== KurtKraut [n=ktk@tor/session/external/x-8fea18549379efb8] has left #launchpad []
stubThere is no security contact for firefox in Ubuntu, so security contact will be subscribed to this bug :-(04:54
=== zakame [n=zak@ubuntu/member/zakame] has joined #launchpad
stublifeless: pull problems building a production branch05:06
lifelessstub: meep. 05:07
stublifeless: https://chinstrap.ubuntu.com/~dsilvers/paste/filezCqOgx.html05:07
lifelessfunnily enough, I'm working on that bug right now05:07
lifelessor that class of bug anyhow05:07
stubheh. I can workaround I think.05:07
lifelesslets see05:08
=== stub builds a tree manually
lifelessgive me a second05:08
stubok.05:09
=== stub continues anyway to see who wins
lifelesswhat is foo ?05:09
stubThe branch I just tried to merge into - the one in the paste05:09
lifelesswhat dir are you working in so we dont conflict05:09
stubI'm working in ~pqm/production/launchpad05:10
lifelessok, I'll work in foo05:10
stubGah... forgot to fix the config files05:10
lifelessfoo pulled ok05:11
stubIt did?05:13
lifelessyup05:13
stubHmm.... 05:13
lifeless(for me)05:13
stubI'm using bzr in ~pqm/bin, with no PYTHONPATH set05:13
=== stub tries a pull in foo too, bringing in committed launchpad.conf updates
stubWorked fine. I'm renaming foo back to launchpad and will push that.05:17
stubLaunchpad is going down in 15 mins for a regular code update. Estimated down time is 10 minutes. Wikis will be in read only mode during this period.05:29
=== mpt__ [n=mpt@203-173-141-46.bliink.ihug.co.nz] has joined #launchpad
=== jd_ [n=jd@wikipedia/Meanos] has joined #launchpad
=== ozamosi- [n=nnozamos@h50n5c1o1049.bredband.skanova.com] has joined #launchpad
=== ozamosi- is now known as ozamosi
=== dsas [n=dean@host86-129-15-192.range86-129.btcentralplus.com] has joined #launchpad
=== mpt_ [n=mpt@203-173-141-46.bliink.ihug.co.nz] has joined #launchpad
=== ChanServ [ChanServ@services.] has joined #launchpad
=== mpt_ [n=mpt@203-173-141-46.bliink.ihug.co.nz] has joined #launchpad
=== dsas [n=dean@host86-129-15-192.range86-129.btcentralplus.com] has joined #launchpad
=== ozamosi [n=nnozamos@h50n5c1o1049.bredband.skanova.com] has joined #launchpad
=== mpt [n=mpt@203-173-141-46.bliink.ihug.co.nz] has joined #launchpad
=== mattl [n=mattl@host-87-75-129-11.bulldogdsl.com] has joined #launchpad
=== ifmy [n=ifmy@ip-62-235-216-201.dial.scarlet.be] has joined #launchpad
=== sfllaw [i=sfllaw@debian/developer/coleSLAW] has joined #launchpad
=== Ju [n=Ju@c-24-126-231-240.hsd1.ca.comcast.net] has joined #launchpad
=== auth00 [i=auth@fiji.grd.sgsnet.se] has joined #launchpad
=== Seveas [n=seveas@ubuntu/member/seveas] has joined #launchpad
=== mpool [n=mbp@ozlabs.org] has joined #launchpad
=== sladen [i=paul@starsky.19inch.net] has joined #launchpad
=== sevrin [n=sevrin@202.75.186.154] has joined #launchpad
=== mdke [n=matt@ubuntu/member/mdke] has joined #launchpad
=== elmo [n=james@83.216.156.21] has joined #launchpad
=== sivang [i=sivan@muse.19inch.net] has joined #launchpad
=== fabbione [i=fabbione@gordian.fabbione.net] has joined #launchpad
=== heyko\na [i=heyko@esenscity.de] has joined #launchpad
=== dilys [i=daf@muse.19inch.net] has joined #launchpad
=== ruffneck [n=ruffneck@intelligenzia.org.helsinki.fi] has joined #launchpad
=== snail [i=syeates@oucs-yeates.oucs.ox.ac.uk] has joined #launchpad
=== asw [n=asw@karuna.med.harvard.edu] has joined #launchpad
=== interalia [n=interali@adsl-60-232.swiftdsl.com.au] has joined #launchpad
=== merriam [n=merriam@84.12.152.145] has joined #launchpad
=== jordi [n=jordi@115.Red-213-96-69.staticIP.rima-tde.net] has joined #launchpad
SteveAmorning08:02
SteveAspiv: hi08:02
SteveAstub: hello08:03
SteveAmpt or mpt_: hello08:03
spivSteveA: Hello.08:03
SteveAspiv: voice call tonight?08:04
spivSteveA: Turns out that while my headphone jack now works, my microphone jack doesn't.  I've filed a bug :/08:04
=== raphink [n=raphink@ubuntu/member/raphink] has joined #launchpad
spivSteveA: That'd be good, but it'll have to be POTS I'm afraid.08:04
stubSteveA: Morning08:05
mpt_hi SteveA 08:05
stublifeless: pqm web ui is giving tracebacks btw.08:24
SteveAspiv: pick up a $10 sound card perhaps?08:25
spivSteveA: You can get $10 sound cards that fit in laptops?08:26
SteveAare you sure your mic jack doesn't work?  for mine and many others, you need to turn on the mic amplifier (or some such switch) in the alsa settings08:26
=== SnkBite [n=SnkBite@212.25.63.35] has joined #launchpad
lifelessstub: yes, known08:27
spivSteveA: I spent a long time yesterday, probably much more than is sensible, trying to make it work, and trying every possible combination of alsa settings and the like.  Googling suggests it's a driver issue.08:28
SteveAi see08:28
=== jinty [n=jinty@244.Red-83-54-78.dynamicIP.rima-tde.net] has joined #launchpad
=== mpt__ [n=mpt@203-173-141-46.bliink.ihug.co.nz] has joined #launchpad
SteveAspiv: is it fixed in some kernel out there?08:46
spivSteveA: Not that I know of.08:46
SteveAdo you still have that desktop machine?08:47
dilysMerge to devel/launchpad/: [trivial]  Fix https://launchpad.net/bugs/41108 and remove the warn_about_no_published_uploads config options that I forgot to remove from staging and jubany's config files. (r1847: Guilherme Salgado)08:48
spivNo, its disk is sitting in our headless router, and the rest is sitting in a cupboard.  It wouldn't shock me if it doesn't boot anymore, even if I put the disk back in... the woes I had with that system are a long story (but boring).08:49
SteveAspiv: http://www.gwctech.com/ebproductdetail.asp?id=88  <--- apparently work on linux08:51
SteveA US$2008:52
spivSteveA: Cool, I'll see if I can find one locally (but that will have to wait until tomorrow).08:54
=== SnkBite [n=SnkBite@212.25.63.35] has joined #launchpad
SteveAspiv: that was for a quick google of "usb soundcard linux ubuntu"08:57
SteveAthere are probably others08:57
spivYeah, I'll look tomorrow, when the shops are open.  There ought to be something cheap.08:59
=== ifmy [n=ifmy@xtfsa101.fsa.ucl.ac.be] has joined #launchpad
jameshspiv: I've had good success with my Logitech USB headset, which is one less thing to cart around compared to a headset + USB sound card09:07
spivjamesh: Cool, thanks.09:08
jameshspiv: Ekiga and Skype seem to work quite nicely with multiple sound cards too09:09
jameshEkiga can be set to ring on one card but use the other one for conversations09:10
spivjamesh: That's good, because if I bought a new headset and things *still* didn't work, I might have to kill something ;)09:10
jameshspiv: the one time I did have trouble was when I left the headset plugged in when rebooting, and the sound cards got numbered in the other order09:11
spivIt's frustrating, my stolen laptop had no issues (and even had a builtin mic that worked surprisingly well for voip!)...09:11
jameshdeleting ~/.asound* can sometimes help too :)09:11
spivjamesh: Heh.  Thanks for the tip :)09:12
jameshdespite its faults, OSS was a lot easier to understand and debug09:12
spivYeah, I'm learning that.09:17
spivI preferred it when I was happily ignorant :)09:18
=== carlos [n=carlos@49.Red-88-9-27.dynamicIP.rima-tde.net] has joined #launchpad
carlosmorning09:22
SteveAhi carlos09:23
=== mpt_ [n=mpt@203-173-141-46.bliink.ihug.co.nz] has joined #launchpad
=== SteveA pings spiv
=== raphink-pbook [n=raphink@ubuntu/member/raphink] has joined #launchpad
=== sfllaw [i=sfllaw@206-248-135-100.dsl.teksavvy.com] has joined #launchpad
=== ubuntulog [i=ubuntulo@trider-g7.fabbione.net] has joined #launchpad
=== Topic for #launchpad: https://launchpad.net/ | developer meeting: Thu 4 May, 1200UTC (wiki:MeetingAgenda) | launchpad-users@lists.canonical.com (wiki:MailingLists) | Channel logs: http://tinyurl.com/72w39
=== Topic (#launchpad): set by SteveA at Thu Apr 27 14:02:12 2006
=== #launchpad [freenode-info] if you're at a conference and other people are having trouble connecting, please mention it to staff: http://freenode.net/faq.shtml#gettinghelp
=== sfllaw [i=sfllaw@debian/developer/coleSLAW] has joined #launchpad
=== ddaa [n=ddaa@nor75-18-82-241-238-155.fbx.proxad.net] has joined #launchpad
=== heyko\na is now known as heyko
=== BjornT [n=bjorn@clt-84-32-240-183.dtiltas.lt] has joined #launchpad
=== sfllaw [i=sfllaw@debian/developer/coleSLAW] has joined #launchpad
=== cmvo [n=cmvo@62.225.11.174] has left #launchpad []
SteveAsabdfl: hi01:08
sabdflSteveA: got it already :-)01:08
SteveAokay01:08
SteveAstub: ping01:10
ddaaheya01:10
SteveAhello david01:11
lifelessprint "hello, world!'01:11
ddaalifeless: unclosed quote01:11
lifelessonly if its python01:11
ddaaWhich chrisforsaken language supports unmatched quotes like that?01:12
lifelessdunno01:13
SteveAvisual basic had in interesting tolerence for variable names that differ only in case01:14
ddaalifeless: "Is all the bzr-side stuff in place for repositories and knits? If so, the LP-side can drop in when it's ready."01:14
ddaacan your reply to that?01:15
lifelessI'm not sure what the question means01:16
SteveABjornT: interested in working from my place on friday?01:16
lifelesswhat is the LP side01:16
lifelesswhat support is desired?01:16
ddaalifeless: that's a recent message from sabdfl in the "Hg user survey" thread01:16
ddaaI think the LP support mentioned here is Supermirror support.01:17
SteveAthis is about making it so that our sftp service and launchpad branch data model and UI can support knits and repositories01:17
sabdflif not now, then at least in a few months, using bzr 0.801:17
lifelessrighto01:17
lifelessso the bzr 0.8 code format is stable01:18
ddaasince there are a few questions about bzr-side status of knits, repos, and LP integration, I'd like you or mpool to reply on list.01:18
=== BjornT [n=bjorn@213.226.190.253] has joined #launchpad
lifelessspiv has merges in the queue for rocketfuel to update it to having the bzrlib that will support this01:18
lifelessthen it can be rolled out in the next rollout, and the supermirror will mirror knit repos happily01:19
lifelessreading from repositories is part of that.01:19
lifelesshaving the sftp server host repositories is quite a different problem, and there is a bug open in malone about that. It needs some specification to decide what the beahviour should be01:19
lifelessIOW, this week, or next, tops.01:20
lifelessfor publishing from a knit repo to the supermirror01:20
ddaaSteveA: who will maintain the agenda for bzr meeting. We should talk about fixing bug 41414.01:20
UbugtuMalone bug 41414 in launchpad "supermirror-branch-puller ignores format changes" [Normal,Unconfirmed]  http://launchpad.net/bugs/4141401:20
ddaathat's likely to become a sticky problem once we have knit support rolled out.01:21
ddaaand people start converting existing weave branches to knit01:21
lifelessddaa: if SteveA is amenable, salgado is the right person to do the implementation01:21
SteveAphone, back in a minute01:22
lifelesssabdfl: does that answer your question ? 01:23
ddaalifeless: there was also some mention of support for the lp:// url scheme01:23
lifelessddaa: bjornt and mpool were the ones working on that. AIUI it was blocked on zope 3.2 but now isn't01:24
=== ddaa creates a sticky with agenda items
lifelesscarlos: ping01:29
carloslifeless: pong01:29
lifelessplease update teh status of your branch on pending-reviews01:29
carloslifeless: I'm finishing that atm01:30
carloswill do as soon as I do the push01:30
=== jsgotangco [n=jsg123@ubuntu/member/jsgotangco] has joined #launchpad
=== mpt [n=mpt@203-173-141-46.bliink.ihug.co.nz] has joined #launchpad
=== sabdfl [n=mark@ubuntu/member/pdpc.silver.sabdfl] has left #launchpad []
=== sfllaw [i=sfllaw@206-248-152-226.dsl.teksavvy.com] has joined #launchpad
=== bradb [n=bradb@modemcable092.66-130-66.mc.videotron.ca] has joined #launchpad
=== matsubara [n=matsubar@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
matsubaragood morning!01:54
stubSteveA: pong01:54
SteveAtalking to david for a couple of minutes01:55
salgadompt, still around?01:59
carlosmpt: I need you too :-P02:01
dilysMerge to devel/launchpad/: [trivial]  More cosmetics on analyze-error-reports: make headers nicer (r1848: kiko)02:01
ddaastub: I'd like to have a chat with you about COUNT() optimisation, caching and db denormalisation02:02
stubok02:03
ddaastub: ping me when you are free02:03
stubddaa: ping02:07
ddaastub: so how to optimise pages that need many many COUNT queries? Let me give you some context.02:09
ddaaThe recent oops report showed that the branch listing page for the vcs-import user frequently times out. It's a page with a few hundred branches, so it's quite pathologic, but we should be ready to handle that much for product and prodject branches in the future.02:10
stubCOUNT() is going to be as slow as doing the actual select, and that is not going to change. 02:10
ddaaThe culprit is that displaying each branch in the listing involving two COUNT queries02:10
ddaaone for all revisions in the branch, one for the revisions in the past month02:11
ddaaI can imagine multiple ways of optimising those queries, so I would like your opinion02:11
stubAny page that is not batched is broken as far as I am concerned - even if the batch size is set high and batching generally never happens, if there is no theoretical limit to the number of items being displayed then we can assume that occasionally there will be insane numbers. And attempting to display insane amounts of items is broken.02:12
stubIt might be possible to collapse that into a single query, using a group by clause.02:13
salgadolifeless, I assume you've seen the breakage of pqm.launchpad.net?02:13
stubI would have to see the existing queries and attempt to collapse it into a single one. However, the load on the DB is still just as much - you are only saving some round trip time.02:13
ddaaI think batching would be quite annoying on those page, so I want to look for ways to optimise things out as much as possible at first.02:13
stubsalgado: Yes - lifeless knows02:13
stubddaa: Batching needs to go in. Even if you set it to a high number, it needs to be there.02:14
ddaastub: mh... did not think of group by...02:14
=== carlos_ [n=carlos@39.Red-88-9-28.dynamicIP.rima-tde.net] has joined #launchpad
stub(and that goes to everyone else writing unbatched pages!)02:14
carloslifeless: updated02:15
ddaastub: one way to optimise this page is just to cache the counts in the Branch table. It's a bit more complexity on the branch scanner, gives away a bit of robustness for the "revisions in past month" stat, but it nice and simple.02:15
carlosmpt: are you around? my dsl line went down...02:15
mptcarlos, vaguely02:16
mptsalgado, pong02:16
salgadompt, have you seen my email about the new shipit?02:17
ddaastub: other ways involve things like: 1. compute the total count by getting the first and last RevisionNumber by sequence for a Branch and substract the sequence of the first from the sequence of the last.02:17
mptsalgado, about the style sheets? yes02:17
stubddaa: yes, we do similar caching elsewhere. If it is ok for the cached counts to get out of date, we can rebuild caches daily. If that is not good enough, we might be able to maintain them with database triggers (or Python code if we can guarantee nothing else updates that particular chunk of data without bypassing the API you define)02:17
stubddaa: That would be just as slow. I expect the timings would be identical.02:18
ddaa2. duplicate the Revision date on the RevisionNumber and add an index that makes it fast to select the RevisionNumbers for a Branch later than a given timestamp. 02:18
mptsalgado, my #1 priority is to get the next lot of MaloneSimplifications landed, though I am often pulled away from that to do various things about the menus02:18
ddaa3. do not duplicate the date, but create a view that joins Revision and RevisionNumber02:18
stubThe join would be fast I suspect - no need to denormalize at this stage.02:19
ddaastub: that system is very amenable to caching, since we have only a single code path _and_ a single process to update the RevisionNumber and Revision tables (it's the branch scanner)02:20
ddaastub: I wanted to know if you could think of any system that would bring similar benefits without making the branch scanner more complex.02:21
jordihey02:21
jordigot a call from carlos, his network link is unstable, and went to have lunch02:22
ddaastub: so, what's your recommendation?02:23
ddaa(aside from batching, which is good for search engines and webmail, but not good in that case IMO)02:23
stubddaa: Trying to do a single query instead of two counts is a noble goal. You may get the results you need by joining Branch and BranchRevision, possibly doing some final counts in Python if the SQL gets hideous. But ideally, instead of issuing 100 queries, we want to issue 1 that generates all the stats you need.02:24
mptcarlos, I'm going to sleep RSN02:24
mptoh, thanks jordi 02:25
mptjordi, tell carlos to e-mail me :-)02:25
=== SnkBite [n=SnkBite@212.25.63.35] has joined #launchpad
stubddaa: I'd need to see the existing queries to give a pointer on that, but it would almost certainly involve using GROUP BY02:25
=== carlos -> lunch
carlosmpt: I added a branch to your UI review queue, I need some help with way we should link to the new form I'm adding there02:26
carlosmpt: I will send you an email anyway if you don't read this before I'm back after lunch02:26
ddaastub: mh... okay, so that would be a pretty hideous query with group by and count subqueries (I can only imagine what it might look like), but you mean that the DB would be able to optimise things out pretty well, right?02:26
stubddaa: Even if you need to do 5 or 10 queries because the SQL would be too hideous otherwise, it will still likely be a win to issuing a few hundred simple ones.02:26
=== ddaa looks for the actual code
mptcarlos, there are no UI reviews any more02:26
ddaastub: I like this idea very much. Keep display complexity in display code. I want to try it.02:27
=== beyond [n=beyond@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
=== BjornT [n=bjorn@213.226.190.253] has joined #launchpad
salgadohey stub. do you have a few minutes? I need some help with one of the shipit reports02:30
stubsalgado: sure02:30
=== kjcole [n=kjcole@ubuntu/member/kjcole] has joined #launchpad
ddaastub: https://chinstrap.ubuntu.com/~dsilvers/paste/fileMnqr7T.html02:38
ddaathat might involve some heavy handed refactoring, but I think it's worth it, so do not let that stop you.02:39
=== BjornT_ [n=bjorn@213.226.190.253] has joined #launchpad
lifelessmpt: uhm, there are still ui reviews, but they are no longer a requirement for merging02:40
=== niemeyer [n=niemeyer@200.138.54.202] has joined #launchpad
lifelessmpt: in that people will still want help designing the ui. I don't care whether you manage your time and the list of people wanting your help via the wiki page or not..02:41
lifelessbut I suggest that some coordination is good.02:41
stubddaa: So we need to take that as a basis, and get those two stats for a set of rows rather than a single row. Do you want me to try and assemble that into a suitable SQL query?02:42
ddaastub: that would be nice. That would allow me to file a bug with all the interesting details attached. BTW, would I be allowed to attach your SQLese in the bug?02:43
stubddaa: I don't have a problem with that, but Mark has been known to freak. Private bug will be fine though.02:44
stubddaa: I'll have a look after I've sorted Salgado's query02:44
ddaaokay, will make private and subscribe Launchpad Devels...02:45
ddaastub: thanks for the branch-scanner rollout, I see that the RevisionNumber.destroySelf fix has landed :)02:54
ddaahey kiko03:02
=== SnkBite [n=SnkBite@212.25.63.35] has joined #launchpad
=== sfllaw [i=sfllaw@206-248-153-146.dsl.teksavvy.com] has joined #launchpad
SteveAddaa: is a time and day set for next week's bzr meeting?03:19
ddaastill waiting for jamesh reply03:19
ddaabut it looks like it's going to be Tuesday 0800 UTC03:19
SteveAnot monday?03:20
ddaamonday is a national holiday in france :)03:20
carlosmpt: well, more than UI review what I need is some help from you to know where should I add such link ;-)03:21
kikocarlos, did the esperanto user reply back?03:21
ddaaSteveA: then, we can see if we can make it happen on the next  monday03:21
carloskiko: no03:21
=== heyko is now known as heyko\na
SteveAok.  so, set it for tuesday 0800 UTC.  please send out an email confirming it03:21
carloskiko: btw, PoMsgSetPage is also done, the only remaining issue is the way to link to that new page03:23
kikocarlos, good work. so can I see an example up and running?03:24
stubddaa: https://chinstrap.ubuntu.com/~dsilvers/paste/fileA9QPfa.html03:25
carlosif you download my branch, yes ;-)03:25
kikocarlos, you don't have it publically accessible?03:25
carloskiko: let me see this new router I have, perhaps I could redirect the port to my laptop...03:25
=== ifmy [n=ifmy@xtfsa101.fsa.ucl.ac.be] has joined #launchpad
stubddaa: And https://chinstrap.ubuntu.com/~dsilvers/paste/filevR04LL.html03:28
carloskiko: try this http://39.red-88-9-28.dynamicip.rima-tde.net:8086/03:28
carlosit doesn't work for me, but I'm not sure it's because I'm inside my LAN...03:28
kikolooks good03:28
carlosok03:28
stubddaa: The last one seems to be what you are asking for03:28
carloskiko: http://39.red-88-9-28.dynamicip.rima-tde.net:8086/distros/ubuntu/hoary/+source/evolution/+pots/evolution-2.2/es/1/+translate 03:29
ddaastub: thank you, I'll check that out after lunch03:29
ddaaddaa.belly.append(lunch)03:30
carloshmm I'm getting a deprecation warning...03:32
carloshttps://chinstrap.ubuntu.com/~dsilvers/paste/filesVYWDk.html03:32
carlosSteveA, BjornT_: ^^^03:33
=== Kinnison snerks at how bad launchpad looks if you have javascript disabled in your browser
Kinnisonwhat happened to the top bar?03:35
BjornT_carlos: you can ignore it. it something that we should fix, though, there should be a bug open on this.03:35
carlosBjornT_: ok03:36
carlosKinnison: I don't see any difference ...03:36
kikocarlos, I don't understand that page03:37
Kinnisoncarlos: http://users.pepperfish.net/dsilvers/js-disabled.png03:38
carloskiko: what exactly?03:38
kikocarlos, the page appears to be a rosetta translation page with a single entry03:39
carloskiko: that's the point ;-)03:39
carloskiko: here you see one of the differences:03:40
carloshttp://localhost:8086/distros/ubuntu/hoary/+source/evolution/+pots/evolution-2.2/es/14/+translate03:40
carlosvs03:40
carloshttp://localhost:8086/distros/ubuntu/hoary/+source/evolution/+pots/evolution-2.2/es/+translate?count=1&offset=1303:40
carloskiko: change the URL to my IP address, please03:40
kikocarlos, I'm on the phone, give me 20m03:40
carlosok03:40
ddaaKinnison: looks like a CSS bug.03:53
ddaaThere's a missing list display attribute for that list, I think.03:53
=== alef0 [i=alef0@M924P018.adsl.highway.telekom.at] has joined #launchpad
=== BjornT__ [n=bjorn@clt-84-32-240-183.dtiltas.lt] has joined #launchpad
=== j_ack [n=nico@p508D902A.dip0.t-ipconnect.de] has joined #launchpad
=== BjornT__ [n=bjorn@clt-84-32-240-183.dtiltas.lt] has joined #launchpad
=== j_ack [n=nico@p508D902A.dip0.t-ipconnect.de] has left #launchpad ["Ex-Chat"]
=== morgs [n=morganc@www2a.your-server.co.za] has left #launchpad []
ddaamatsubara: can you close https://launchpad.net/products/launchpad/+ticket/812 as answered, please?04:20
matsubaraddaa: no, I can't. Only launchpad admins or the user who filed the support request can close it04:21
ddaaduh04:22
ddaamatsubara: is that reported as a bug?04:22
matsubaraddaa: yes.04:23
matsubaraddaa: bug 315704:24
UbugtuMalone bug 3157 in launchpad "Anyone should be able to edit a support ticket" [Normal,Confirmed]  http://launchpad.net/bugs/315704:24
ddaakiko-phone: ping04:29
ddaakiko: would it be possible for salgado to work on bug 41414 in the next couple of weeks?04:40
UbugtuMalone bug 41414 in launchpad "supermirror-branch-puller ignores format changes" [Normal,Confirmed]  http://launchpad.net/bugs/4141404:40
kikouhm04:40
kikomaybe.04:40
kikoMAYBE.04:40
kikoit's a big maybe04:40
ddaasalgado knows the branch puller inside out, and this bug can cause very serious performance problems after we have rolled out the upgraded bzrlib (spiv is working on that) and people start upgrading existing weave branches to knits.04:41
ddaait's not on fire yet, but it will be urgent eventually04:42
salgadoddaa, so, all that needs to be done is check if the format in the destination branch is older than the format in the source branch, and in that case throw away the existing destination branch and mirror it again?04:43
=== carthik [n=carthik@pdpc/supporter/student/carthik] has joined #launchpad
carthikHi, the default sort order on LP is "priority, then severity"04:44
ddaasalgado: mhh...04:45
carthikHowever, in the list of bugs, none of the table columns have the title "priority" or for that matter " severity"04:45
kikocarthik, it's in flux; it will soon be simplified to a single "importance".04:45
carthikkiko, thank you.04:45
ddaasalgado: I suggest we have this discussion on the bug, so lifeless can keep track of it.04:45
ddaaI think it should be a bit different from what you say.04:46
salgadookay. I'll comment there and then you answer there04:46
carthikkiko, also, making a change to a bug's meta-info and adding a comment there (At the top, the dropdown "State" menu) does not allow me to subscribe to the bug, unlike adding a normal comment at the bottom of the thread. Is this being sorted out too?04:46
kikocarthik, yes, it's a wart. one which I don't have a good answer to at the moment, though.04:48
carthikkiko, thanks a lot. I appreciate the quick responses :)04:49
kikothe only immediate idea I have is displaying or repeating the table of statuses at the boom of the bug close to the add new comment04:49
kikobut that has a lot of drawbacks04:49
kikoso it's a tricky problem04:50
=== zakame [n=zakame@ubuntu/member/zakame] has joined #launchpad
zakamehi all04:55
kikohello zakame 04:55
zakameI'd like to inquire about the LaunchpadSupportApp spec, has there been any progress on it? =)04:56
zakamehi ki! :D04:56
kikozakame, some progress yes -- have you been looking at /support on launchpad?04:57
=== carthik is now known as carthik_away
zakameno, actually I was meaning to do a proposal for Ubuntu on the SoC, about a better bug reporting tool/suite... I was looking at the UDU BugReportingRoadmap earlier04:59
=== heyko\na is now known as heyko
=== carthik_away is now known as carthik_home
ddaasalgado: bug 4141405:06
UbugtuMalone bug 41414 in launchpad "supermirror-branch-puller ignores format changes" [Normal,Confirmed]  http://launchpad.net/bugs/4141405:06
ddaasalgado: note that the second comment is "it would be nice if"05:07
carlosBjornT, SteveA: I need to create a FileUpload object for a doc test, any suggestion?05:08
BjornTcarlos: it depends on what you intend to test. for bug attachments i simply did:05:10
BjornT>>> file_upload = StringIO(...)05:10
BjornT>>> file_upload.filename = 'file.name'05:10
carlosBjornT: the problem is that our view class checks that we are getting a FileUpload05:12
carlosbecause sometimes, epiphany submissions were giving us a unicode string05:12
carlosBjornT: I'm not checking that concrete part, I just need to emulate a submission with the upload to check later that some attributes were set to the right values05:13
carlosBjornT: I guess I could add that check code inside the pagetest and let zope to handle the upload, right?05:14
carlosa pagetest is just a doc tests with extra 'sugar'05:14
BjornTcarlos: well, you could simply create a FileUpload object. you just need to pass it an object which has 'file', 'headers' and 'filename' attributes.05:26
carlosBjornT: ok, let's try...05:27
=== zakame is now known as zakame_away
carlosBjornT: thanks, it worked, I have the test finished now05:52
=== zakame_away [n=zakame@ubuntu/member/zakame] has left #launchpad []
SteveAcarlos: did you get the getView issue sorted?06:03
carlosSteveA: getView? the FileUpload question?06:04
SteveAyou pasted a link to a deprecation warning06:04
carlosoh, that one06:04
carlosSteveA: BjornT said that I can ignore it06:04
SteveAto do with using getView where now it should be getMultiAdapter06:04
SteveAokay.06:04
carlosthat there is a bug already filed and will be fixed 06:04
SteveAi, or some other zope3 internals person, will fix it later06:05
carlosok, thanks06:09
carloskiko: hi, do you have time for a fast review?06:18
carloskiko: it's a fix for https://launchpad.net/products/rosetta/+bug/4165306:18
UbugtuMalone bug 41653 in rosetta "Importation of po file goes in the wrong template" [Major,In progress]  06:18
kikook06:18
carloskiko: https://chinstrap.ubuntu.com/~dsilvers/paste/filej6jncz.html06:18
kikoit's "Import", though, not "Importation"06:18
kiko-        potemplate = pofile.potemplate06:19
kikounused, pyflakes caught, correct?06:19
carlosright06:19
carlos;-)06:19
kikoI saw that last week when I did a big pyflakes run06:20
kiko+The FileUpload class needs a class with the attributes: filename, file and06:20
kikoactually, it "requires an instance", not a class06:21
kikocarlos, does this test fail if you revert the fix?06:21
=== lbm [n=lbm@0x555298ca.adsl.cybercity.dk] has joined #launchpad
carloskiko: yes06:21
kikocan you explain how the pofile attribute was being set before?06:22
carlosthat's the point of it ;-)06:22
kikoor was it always null?06:22
carloskiko: the problem is that it was not being set06:22
kikoever?06:22
carloskiko: until the guess code is executed06:22
kikohow did we know that an upload was for a... wow06:22
kikoI see06:22
=== bradb & # lunch
=== simira [n=simira@tellus.err.no] has joined #launchpad
carlosIt makes no sense to guess it when you know exactly it06:23
kikothat's a pretty big bug06:23
kikohow did it work before?06:23
carloswell, the guess was working, and hidding it06:23
kikobefore the new translation upload queue?06:23
carloskiko: the schema was really different06:23
=== simira [n=simira@tellus.err.no] has left #launchpad []
kikohow did we store uploads?06:24
carloskiko: inside IPOFile.rawfile06:24
mdkecarlos: https://launchpad.net/bugs/42645 is fixed, thanks very much06:24
UbugtuMalone bug 42645 in rosetta "bad merge" [Major,Confirmed]  06:24
kikocarlos, also, do you not feel that we should be supplying pofile to addOrUpdateEntry() instead of doing it in the browser code?06:24
carlosmdke: hmm, I did nothing...06:24
mdkeor at least, the symtom is fixed06:24
kikoI understand it is optional06:24
mdkecarlos: ah, i know: it was from an upload to the distro yesterday, that must have restored the template. 06:25
carloskiko: well, we could do it that way too... it's just that the method is growing a lot... I'm even thinking on moving the potemplate argument outside it06:26
carlosmdke: I guess06:26
kikocarlos, moving stuff out of the API by doing assignment after calling the function is kind of a bad idea06:29
carloskiko: well, the API is to add entries to the queue, after that, you improve the data you have for that import, sometimes you will know it directly when it's created and other times you will know it later with our guess code06:31
kikowell06:31
kikohere's my rationale06:31
kikothe /action/ of adding or updating entries06:31
kikoshould allow you to specify a pofile if you know it06:31
kikoand if you remove it from the API06:31
kikothen it is not clear to people using it06:32
kikonow06:32
kikoI will tell you something which looks weird in that API06:32
kiko             sourcepackagename=self.context.potemplate.sourcepackagename,06:32
kiko             distrorelease=self.context.potemplate.distrorelease,06:32
kiko             productseries=self.context.potemplate.productseries,06:32
kiko             potemplate=self.context.potemplate)06:32
kikono wonder you have a lot of arguments!06:32
carloskiko: I see this like, for instance, IPersonSet.createPersonAndEmail, you fill the basic information and later you can set other fields06:34
kikocarlos, can you not just supply potemplate to that API?06:38
kikoare there places where you supply SPN, DR, PS that is different to the potemplate (or where the potemplate is absent?)06:38
carloskiko: there are places where I don't know the potemplate06:40
carlosand also, there are other situations where the potemplate information is not the same as the direct arguments, like for KDE .po files06:41
carlosthe .po files are stored in a sourcepackage and the .pot in another one06:41
kikoI see06:42
kikookay06:42
kikor=kiko either way, but I'd consider adding the pofile to the argument (and I think that createPersonAndEmail is a different sort of problem and perhaps broken as well)06:43
carloskiko: Ok, I'm going to add the pofile argument to be consistent with potemplate and if I have some time to cleanup APIs I will revisit this and change it in a better way06:44
carloskiko: thanks for the review06:44
kikocool06:44
kikosure enjoy it06:44
=== ohoel [n=beshy@ti400720a081-14005.bb.online.no] has joined #launchpad
=== dsas [n=dean@host86-129-15-192.range86-129.btcentralplus.com] has joined #launchpad
=== alef-null [i=alef0@M1014P016.adsl.highway.telekom.at] has joined #launchpad
ohoeldoes launchpad handle gnome cvs accounts in any way?06:51
carlosohoel: no06:53
ohoelhmm, ok. is there a way to delete an account?06:53
ohoelI've got ivindHoel which is in use, and ivindHoel2 which must have been made by mistake06:53
salgadoohoel, you can merge them at https://launchpad.net/people/+requestmerge06:55
salgado(you have to be logged in with the account you want to keep)06:55
=== alef-null is now known as alef0
ohoelsalgado: thanks06:59
=== beyond is now known as beyond-rango
=== carlos [n=carlos@207.Red-88-9-33.dynamicIP.rima-tde.net] has joined #launchpad
=== carlos -> out
carlossee you later07:14
=== sabdfl [n=mark@ubuntu/member/pdpc.silver.sabdfl] has joined #launchpad
=== AlinuxSOS [n=AlinuxOS@d83-176-127-37.cust.tele2.it] has joined #launchpad
AlinuxSOShello dear people07:59
=== fabbione [i=fabbione@gordian.fabbione.net] has joined #launchpad
AlinuxSOSquestion: Is Mozilla Firefox 1.5 imported into rosetta?08:00
SteveAAlinuxSOS: hi.  i think the rosetta people are not here at the moment.08:01
AlinuxSOS:)08:01
AlinuxSOSjogging somewhere ?:)08:02
AlinuxSOShehe08:02
SteveAperhaps08:02
SteveAi think the weather is nice for that in spain08:03
=== beyond-rango is now known as beyond
mdkeAlinuxSOS: I don't think firefox uses rosetta for translations, it is done upstream.08:06
mdkethe mozilla localisation is really odd08:06
=== LeeJunFan [n=junfan@s64-186-37-84.skycon.net] has joined #launchpad
AlinuxSOSodd ?08:08
AlinuxSOSthe problem is that translation is ready08:09
mdkeit uses plugins, xpi files08:09
AlinuxSOSbut noone makes mozilla-firefox-locale-ka pack08:09
mdkeAlinuxSOS: if you have a translation, file a bug on mozilla-firefox-locale-all and attach the translated xpi file 08:09
AlinuxSOSmdke, :) I've alredy done it08:09
mdkeAlinuxSOS: fine, no problem then.08:10
AlinuxSOS2 months ago08:10
AlinuxSOSI've send file ka_GE.xpi for 1.5.0.1 Firefox08:10
mdkeAlinuxSOS: bug number?08:10
AlinuxSOSbut nothing is done :(08:10
AlinuxSOSwho is mozilla-firefox-locale-all packager?08:11
AlinuxSOSno numbers08:11
AlinuxSOSthere is no package08:11
AlinuxSOSso no bugs at the moment.08:11
mdkeAlinuxSOS: what is the bug number you filed with the translation?08:16
AlinuxSOSmdke, I'm talking with David Moreno Garza08:17
AlinuxSOSwho promissed me mozilla-firefox-locale-ka (Georgian) package08:17
AlinuxSOSbut seems that nothing is done :(08:18
AlinuxSOSit's really frustrates me.08:18
AlinuxSOShttp://www.gia.ge/dormidon/main.php?root=117 even new translations are ready08:18
AlinuxSOSand no packages :(08:18
mdkeAlinuxSOS: you said that you filed a bug 2 months ago, just give me the number and I'll ensure it gets looked at08:19
AlinuxSOSI've sent .xpi file directly to the Packager08:21
AlinuxSOSmdke, ti parler in privato :)08:21
mdkeAlinuxSOS: that will not help. As I said, file a bug on mozilla-firefox-locale-all, and attach the translated xpi file.08:21
mdkeeither you've done that, or you haven't08:22
mdkewhich is it?08:22
AlinuxSOSI've sent ka_GE.xpi file to a damog (David Moreno Garza) directly who prommised me that he would be glad to do debian/ubuntu .deb package of locale08:23
AlinuxSOSbut nothing is done08:23
mdkeAlinuxSOS: ok. If you follow the procedure I mentioned, that will ensure that it will get done.08:23
AlinuxSOSbefore I was talking with him via ICQ08:23
AlinuxSOSthis 2 month offline08:24
mdkec'mon dude, trust me, and file a bug as I've said.08:24
mdkeit will work, many other languages have done it during this release cycle08:24
=== AlinuxSOS is now known as AlinuxOS
AlinuxOSmdke, where ?08:26
AlinuxOSin rosetta?08:26
AlinuxOScould you please tell me where can I do it08:26
mdkeAlinuxOS: for the third time. mozilla-firefox-locale-all.08:26
AlinuxOSI simply trusted this guy08:26
AlinuxOS:(08:26
AlinuxOSeh08:26
AlinuxOSwhat's this ? a package ? :) site08:26
mdkeclick here:08:27
mdkehttps://launchpad.net/distros/ubuntu/+source/mozilla-firefox-locale-all/+filebug08:27
mdkefill in the boxes, then submit the bug.08:27
mdkethen, attach the xpi file08:27
=== jinty [n=jinty@244.Red-83-54-78.dynamicIP.rima-tde.net] has joined #launchpad
=== LeeJunFan [n=junfan@adsl-69-210-207-5.dsl.klmzmi.ameritech.net] has joined #launchpad
AlinuxOSmdke, thank you!08:39
AlinuxOSmdke, is there a whish list ?08:42
mdkeAlinuxOS: for what?08:47
AlinuxOS:)08:47
=== sabdfl [n=mark@ubuntu/member/pdpc.silver.sabdfl] has left #launchpad []
=== ohoel_ [n=beshy@ti400720a081-16803.bb.online.no] has joined #launchpad
bradbBjornT: Any reason why the email interface shouldn't populate the launchbag? I'd at least like to reliably get the current bug from there for this event handler I'm writing.09:26
BjornTbradb: when can't you get the bug reliably?09:34
bradbBjornT: Maybe it's just the tests, but bugnotifications.txt fails, for example.09:34
bradbI assumed the LB is currently populated only on traverals.09:35
bradband traversals09:35
bradb(the test fails because it hits my event handler, raising an error trying to access .bug on the LB.)09:36
bradbThere's another way I can solve this, which is pretty easy too, which is with IHasBug.09:37
BjornTbradb: right, it's populated only on traversals. i think you should avoid using the LB in the event handler, since it's like using a global variable, but you might want to check with SteveA what he thinks about it.09:41
bradbI'll just make sure everything implements IHasBug, I think. The my handler can assert that the event.object is either an IBug or an IHasBug.09:41
=== simira [n=simira@tellus.err.no] has joined #launchpad
simirais it possible to sort members list for a group after karma?10:05
=== vitalstatistix [n=mykingdo@c-65-96-80-133.hsd1.ma.comcast.net] has joined #launchpad
salgadosimira, that's not possible today, but it's a trivial change, so if you file a bug I'll make sure it gets fixed soon10:12
=== bradb heads off, later all
=== bradb [n=bradb@modemcable092.66-130-66.mc.videotron.ca] has left #launchpad []
=== heyko is now known as heyko\na
=== vitalstatistix [n=mykingdo@c-65-96-80-133.hsd1.ma.comcast.net] has left #launchpad ["Ex-Chat"]
mdzis there any way I can query for bugs which are assigned to someone (not a particular person, but anyone)?10:53
sfllawLike, not-nobody?10:53
sfllawThat would be nice.10:53
=== WaterSevenUb [n=WaterSev@azevedo.astro.up.pt] has joined #launchpad
mdzyes10:59
mdze.g., I'd like to see all unconfirmed bugs which are assigned to somebody10:59
Seveasmdz, https://launchpad.net/distros/ubuntu/+bugs?field.searchtext=&orderby=-priority%2C-severity&field.status%3Alist=Unconfirmed&field.severity%3Alist=Wishlist&field.severity%3Alist=Minor&field.severity%3Alist=Normal&field.severity%3Alist=Major&field.severity%3Alist=Critical&field.priority%3Alist=Wontfix&field.priority%3Alist=Low&field.priority%3Alist=Medium&field.priority%3Alist=High&assignee_option=an11:00
Seveasy&field.assignee=&field.owner=&field.component-empty-marker=1&field.omit_dupes.used=&field.omit_dupes=on&field.has_patch.used=&field.has_no_package.used=&search=Search+bugs+in+Ubuntu11:00
Seveaswoah11:00
Seveasbasically: yes you can, eith the detailed search form11:00
SeveasAssignee: "doesn't matter"11:01
Seveasah crud, that brings in unassigned as well11:01
Seveasnvm11:01
simiraSeveas: ever heard of http://url.err.no/? (shorturl)11:02
Seveassimira, yeah, didn't realize the url was that horrific11:02
simira:D11:02
sfllawtinyurl is also good.11:10
=== mpt [n=mpt@203-109-236-140.bliink.ihug.co.nz] has joined #launchpad
=== sabdfl [n=mark@ubuntu/member/pdpc.silver.sabdfl] has joined #launchpad
sabdflevening all11:14
kikohello sabdfl11:15
=== cprov [n=cprov@201-68-7-160.dsl.telesp.net.br] has joined #launchpad
sabdflkiko: i have a very short patch for your review (28 lines)11:16
simiraevening sabdfl 11:17
sabdflkiko: https://chinstrap.ubuntu.com/~dsilvers/paste/fileQvZ7do.html11:17
sabdflcould you look at that for me please?11:17
kikosabdfl, why are you moving the zcml around?11:17
kikoso from reading this patch what you are doing is making sure all languages appear in the distroreleaselang pages. is that it?11:18
sabdflkiko: cleanliness11:19
sabdflyes - folks have been asking for that forever, i got frustrated waiting11:19
kikookay11:20
sabdflwithout this, you have to enter the language code manually to start the pofile11:20
kikocan you clarify cleanliness -- I don't have enough context11:20
sabdflit's a [trivial]  fix *except* for the slightly unrelated issue of distrorelease.potemplates11:20
sabdflwhich is list()'ifying its results11:20
sabdflalso, the naming is not great, but we have no precedent11:20
sabdflactually, we do, but as a method11:20
kikoit looks okay to me11:20
sabdflgetPoFileOrDummy11:20
sabdfli thought this way was better11:21
kikotrue.11:21
kikobut I don't quite understand what you mean by list()ifying inside DistroRelease.potemplates being a problem11:21
sabdfli don't think Carlos is grokking the dummy thing yet, will be interesting to see if he's done something similar for POMsgSetView11:21
sabdflin order to sort by potemplate.potemplatename.name11:22
kikoyes I saw that11:22
kikobut it was that way already, right?11:22
sabdfldistrorelease.potemplates does a selectBy, listifies, and sorts11:22
sabdflyes, but i would expect you to ask me to fix it since i'm touching that code11:22
kikois it even fixable, however? 11:22
sabdflhttps://launchpad.net/products/rosetta/+spec/potemplate-priorities11:23
kikoI remember we spoke of this and I looked into it and it doesn't seem to be fixable the right way11:23
sabdflwell11:23
sabdflwith prejoins, we should be able to orderBy['-priority', 'potemplatename.name'] 11:23
kikoare you suggesting orderBy=['POTemplateName.name'] ?11:23
kikoyeah, but that's a bit of a hack11:23
sabdfled zachary11:23
sabdflnot at all, it maps perfectly to the SQL11:24
sabdfldoes it work now?11:24
kikowell, it's a bit of a hack because you are now taking advantage of prejoins adding in the table in the select11:24
kikowhich is rather unrelated IYSWIM11:24
sabdflyes... but I see the prejoin as an integral part of the query11:24
sabdfli think you like to prejoin in the view11:25
sabdflto optimise for particular cases11:25
sabdflwhereas in this case I *know* i want the potemplatename11:25
kikoI haven't given this enough thought, but I'd be fine with you changing that to be an orderBy if you think it's better.11:25
sabdflok, if it works, I'll do that11:25
kikoI have some reservations about using prejoin and orderBy that may be pure brazilian prejudice11:26
kikoso don't wait for my psychoanalysis ;)11:26
sabdfli know where you are coming from11:26
sabdflbut then i've always felt that preJoin should be a selectBy optional keyword argument11:26
sabdflalong with orderBy11:26
kikoyeah, andrew said that doing that would mean it would never be upstreamable because they had rejected patches in the past that affected select*By11:27
kiko's API11:27
sabdflupstream has issues, don't they11:28
sabdflhave you chatted with gustavo about sql alchemy?11:28
kikowell, the danger is colliding/sandbagging an existing user who used prejoin as a column name11:29
kikowhich I find somewhat understandable11:29
kikoyeah we did at FISL11:29
kikohe is finding it very agreeable11:29
kiko(I only think it's nicer because it is being maintained!)11:29
sabdflit should be possible to make it preJoin to avoid case issues (python is case sensitive, SQL is not)11:34
sabdfla column called preJoin could just as easily be referred to as prejoin11:34
sabdflinteresting11:43
sabdflkiko: result.orderBy(['potemplatename.name'] )11:44
sabdfldoes not error11:44
sabdflbut does not work, either11:44
sabdfl>>> for p in hoary.currentpotemplates: print p.potemplatename.name11:44
sabdfl...11:44
sabdflevolution-2.211:44
sabdflpmount11:44
sabdflpkgconf-mozilla11:44
sabdflinteresting11:44
=== simira [n=simira@tellus.err.no] has left #launchpad []
kikoand adding the orderBy in the select() call?11:44
sabdflgives a tricky error... missing FROM clause for potemplatename11:46
sabdfli'll need to join them in there11:46
kikoyeah, I assumed that.11:46
kikoI'd leave it as a list()11:46
kikoit will not issue extra queries thankfully11:47
kikobecause of your prejoin()11:47
sabdflcould be several hundred in that list()11:47
kikoit's okay11:47
kikoit's not expensive11:47
kikoit's only expensive if it causes SQL to be issued.11:48
kiko(which you're already fixing with your prejoin)11:48
sabdflok, done11:48
sabdflwill land it with r=kiko11:48
sabdfltomorrow, if tests pass tonight11:49
=== ddaa -> bed
kikosabdfl, I keep trying to figure out a way of making po_files_or_dummies simpler11:53
kikosabdfl, I also wonder whether a property is appropriate given it does cause two largish queries to be issued11:53
kikommmm11:53
sabdflyou only ever call it once, and you do need both queries11:54
kikoyeah, but database API is API to the world11:54
sabdflother option was to put this logic in the view class11:54
sabdflview/pofiles11:54
kikothere is rosetta browser code that does exactly that11:54
sabdflnot for distroreleaselanguage there is not11:55
kikoagreed agreed11:55
mdkehi sabdfl 11:55
mdkesabdfl: you might have seen in your email, spiv answered about the two wiki specs we've discussed: it seems he has a few ideas and not too much work is required, are you ok with him doing a few hours on it?11:56
sabdflmdke: you'll need to clear that with stevea, +1 from me, if he asks you can quote me11:57
mdkesabdfl: right, thanks.11:57
lifelessmorning11:58
mdkeSteveA: still around?11:58
sabdflhey lifeless11:59
mdkemorning lifeless 11:59
sabdfllifeless: how do i test knits?11:59
lifelesssabdfl: for launchpad, there is a test branch on chinstrap.11:59
sabdflmpt: is there any solution in the pipeline to the FOUC?11:59
lifelessone second11:59
=== LeeJunFan [n=junfan@adsl-69-210-207-5.dsl.klmzmi.ameritech.net] has joined #launchpad

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!