[12:02] kiko: sure [12:02] !lilo:*! Hi all. If you're interested in tracking, discussing, political coordination, regarding the U.S. INDUCE act, designed to outlaw technology which can be used to circumvent entertainment industry licensing, please feel free to stop by ##induce .... thanks! [12:03] daf, we're in need of some quality rosetta time with someone in the know, and I'm thinking it could be you. [12:03] do you have a couple of hours to commit this week to us? [12:04] I might be able to do that on Thursday or Friday [12:04] what can I help you with? [12:05] getting rosetta data displayed in soyuz, basically. [12:05] translations for certain packages. [12:05] is that feasible? [12:06] can you give me more details? :) [12:06] you're thinking of integration between soyuz and Rosetta? [12:07] right. getting something like open translations for release X, and for package Y? [12:07] sure, spending some time thinking about that would be good [12:08] I'm not 100% sure I'll have some time this week for that, but I'm certainly happy to do it [12:08] we're partially blocked on that [12:10] in that case, how about we allocate an hour to talk about it on Thursday, with a follow-up meeting on Friday if needed? [12:10] daf: please, could you recreate the database at rosetta server? [12:10] carlos: sure [12:10] two hours, I think, would be required just for talking :) [12:10] daf: thanks [12:10] carlos: done [12:11] kiko: ok, let's do that then :) [12:11] daf: :-? [12:12] daf: https://rosetta.warthogs.hbd.com/++skin++Debug/rosetta/prefs [12:12] cprov, debonzi: daf's on for thursday for our rosetta-mini-sprint. [12:12] cprov, debonzi, daf: what's the good time. [12:12] daf: it works here... [12:12] carlos: interesting [12:12] carlos: looks like some sample data is missing [12:12] your name :-) [12:13] :) [12:13] kiko: I'm online every time , better ask daf [12:13] daf, what's the good time? [12:13] kiko,cprov: what time is it there? [12:13] kiko: sometime during the afternoon, I think [12:14] kiko: i.e. after the rosetta daily meeting and lunch [12:14] carlos: 19 PM [12:14] cprov: thanks [12:15] carlos: TZ=America/Sao_Paulo date [12:15] daf: thanks [12:15] daf: when will be in UTC ? === cprov is lost on TZs [12:17] I suggest 3pm UTC [12:17] i.e. 11am for you guys [12:17] er, no [12:17] 12pm for you guys [12:17] 12pm? [12:17] daf: you can kill us :) [12:17] daf: I don't think so [12:17] :-) [12:18] hmm === carlos sucks [12:18] :-P [12:19] cprov: is that too early for you? :) === npmccallum [~npmccallu@69-162-252-7.ironoh.adelphia.net] has joined #launchpad [12:19] daf: nop, exaclty the opposite, 1/2 hour earlier maybe ? [12:20] :D [12:20] by 12pm, I mean 12:00, by the way [12:20] not 00:00 [12:20] daf: of course :) [12:20] just checking :) [12:21] ok, what time would you like? [12:22] I'm usually around in the evenings [12:22] daf: let's do in that way: 12pm UTC thursday as you said or earlier if possible, ok ? [12:22] we could make it 11am UTC if that suits you better [12:24] daf: not much ... is 12 UTC nice for you too ? [12:24] daf: I think 40 minutes will be more than enough [12:24] actually, the Rosetta team meeting is at 12:00 UTC [12:25] oops [12:25] cprov, I don't think 40 minutes is enough, really. [12:25] kiko: how much do you think ? [12:26] and the meeting will last somewhere around 30m-1h, and I generally have lunch after that so... [12:26] daf: if it's needed, we could move it [12:26] kiko: we just need a set of stocked queries AFAIK [12:27] I think 2h, cprov. there's a lot up in the air [12:27] we *could* make it 10:00 UTC, which is 7am for you guys :) [12:27] carlos: that is true [12:28] daf: uhm, kiko cannot wake so early :) [12:28] :D [12:29] it breaks my legs [12:29] that's funny -- my knees hurt when I've been awake too long [12:29] daf: make it easier, just say when you have 2h free [12:30] ok [12:30] any time from about 14:00 UTC would be fine [12:31] X-) [12:32] carlos: ok, Rosetta seems to be working now === debonzi is lost in the time [12:32] daf: where was the problem? [12:32] carlos: dunno, I just restarted the server ;) [12:33] :-P [12:33] kiko: debonzi : 14 UTC is ok for you ? just have lunch and talk :) ok ? [12:33] it's 11am here, okay by me. [12:34] daf: then ok, thursday 14 UTC [12:35] cprov: ok! [12:35] cprov, for me is ok.. [12:36] daf: thanks [12:36] cprov: de nada :) [12:36] daf: just to warn, if you can think in stocked queries to show relevant information from rosetta in soyuz, let me know . [12:37] cprov: you might be able to use existing Rosetta interfaces for some things [12:37] daf: I will send an email to launchpad explaning better wishes. [12:38] I'm worried about this "idea" of releases -- Rosetta doesn't really pay attention to those [12:38] ok, that sounds good [12:38] daf: yep [12:38] daf, as long as translations are tied to certain source packages (and source package versions?) [12:38] daf, we're okay. [12:39] um... [12:39] daf: carlos see you later [12:39] cprov: later! [12:39] cprov: later [12:39] daf, um what? :) [12:40] well [12:40] translations are tied to templates are tied to products are tied to projects [12:40] Rosetta knows nothing about source packages [12:40] (yet) [12:42] products are tied to source packages, I believe, no? === debonzi goes dinner [12:44] carlos: the form looks really good [12:45] daf: stolen from bugzilla [12:45] but It seems like it's not working [12:45] :-( [12:45] doing some local tests now === lulu [~lu@host217-37-231-28.in-addr.btopenworld.com] has left #launchpad [] [12:47] daf: are you sure you have latest db schema? [12:47] daf: it works in my laptop [12:47] but If I try to change your name with the password 'test' it does not change anything [12:48] hmm [12:48] let me try reloading it again [12:49] ok, done [12:50] perfect [12:50] daf: your name now it's Dafydd2 [12:50] :-) [12:52] heh :) [01:08] daf: do you want wishlist bugs into our bugzilla? [01:15] carlos: yes [01:15] ok [01:15] I filed one against Malone today === stub [~zen@dialup-33.53.194.203.acc03-dryb-mel.comindico.com.au] has joined #launchpad [02:04] hey stub, have some minutes free? [02:04] Sure [02:05] stub, us soyuz lowlives are looking into getting some malone data presented in soyuz. [02:05] stub, do you think you could put some time down this week for sorting the issues out with us? [02:06] I can spare a little time - I'm still at my old work this week. [02:07] we'd need a solid 1h something, and the timezone scheduling means it's not trivial to fit in. [02:07] can you say what time is best? perhaps friday? [02:08] whenever - pick a time. sooner is fine by me. [02:09] (as long as I am awake ;) ) [02:17] daf: 4 bugs left (without counting steve's ones) [02:18] stub, what is a good time UTC for you? [02:18] daf: hey, lalo is alive!! [02:18] Now until Now + 12 hours is good for me [02:58] spiv: ping? [02:58] daf: I'm getting this error: [02:58] TypeError: DBProject() did not get expected keyword argument datecreated [02:59] daf: datecreated has a default value, and I want to use it [02:59] I mean.... the Project table has a default value for the field datecreated [02:59] and I want to use it, but the SQLObject does not let me to do it [03:02] carlos: Do you mean you want to use the default datecreated defined in the database, or the default datecreated defined in the SQLObject subclass? [03:02] stub: the one defined in the database [03:03] I didn't know that sqlobject could define a default value [03:03] what's the best option? [03:03] Then you have to set 'required=False' in the SQLObject subclass, so it lets it be uninitialized. [03:03] ok [03:04] SQLObject defaults don't work for datetimes, since it sets the default when the module is loaded (ie. it is not calculated). [03:04] This needs to be fixed - there is some discussion on the SQLObject mailing list about this [03:05] TypeError: __init__() got an unexpected keyword argument 'required' [03:05] DateTimeCol('datecreated', notNull=True, required=False), [03:05] Sorry - notNull=False === carlos reading sqlobject documentation.. [03:05] stub: that does not works [03:06] DateTimeCol('datecreated', notNull=False, default=None) [03:06] I tried the notNull=False option. [03:06] btw, it should be notNull=True [03:06] hmm [03:06] If I do an insert [03:06] with datetime=NULL [03:07] will be used the default value? [03:07] Yes [03:07] ok [03:07] (default = None, as python None == SQL NULL [03:08] stub: I know, It's just that I thougt that the default value is only used if you don't specify a value for that field [03:08] ok, no more errors about it. Thanks [03:09] Err... you are right. Might be SQLObject magic that makes it work then... possibly by accident. [03:10] I'm not able to do the insert, so perhaps it fails when it commits it into the database (I have other errors) [03:10] I mean, that I didn't tested it 100% [03:11] Can you please add a bug to bugzilla? We have an SQLObject developer starting soon who should be able to fix this properly and feed it back upstream. [03:12] If it doesn't work, you need to pass 'datecreated=datetime.utcnow()' as an argument when creating the object (which is what Malone is doing to avoid this problem). [03:12] stub: what should I specify in the bug report? [03:12] (so hopefully the clocks on the app servers are in sync 'good enough') === carlos don't knows exactly where is the problem [03:13] 'SQLObject needs to use the DEFAULT value for a column as defined in the database' [03:14] ok [03:14] I think the correct syntax should be something like DateTimeCol('datecreated', notNull=True, default=SQLObject.DEFAULT) [03:15] But the SQLObject developers should probably agree on the syntax before I hack it up myself ;) [03:16] hmm, I get this error after fixing all bugs I found: [03:16] ValueError: Unknown SQL builtin type: for [03:18] That would be the value for the 'person' foreign key [03:18] Is RosettaPerson an SQLObject subclass? Or do you need to adapt it to a database.foaf.Person ? [03:19] RosettaPerson represents the Person table [03:19] I fixed it, don't worry [03:19] but as you said, the sqlobjects fails [03:19] psycopg.IntegrityError: ERROR: null value in column "datecreated" violates not-null constraint [03:19] :-P [03:20] Have to do it the malone way for the time being - flag it with a TODO [03:20] I will fix it the way you told me for now [03:20] sure [03:32] stub: should we have a sqlobject component inside launchpad? [03:32] carlos: I don't follow you [03:32] stub: or should the bug report be filed against launchpad? [03:32] stub: to file the bug we talked about some minutes ago [03:33] at bugzilla [03:33] (sorry, it's too late here to think in a verbose mode :-P) [03:33] oh - we should have a component for it - not sure what the best is. [03:34] I don't see anyone now [03:34] Maybe a database product, with components sqlobject, sqlos, schema, psycopg? I don't know if it is launchpad specific. [03:34] justdave: could we have it added ? [03:34] Just stick it anywhere and assign it to me so it doesn't get lost :-) [03:34] stub: at this time it's only used by launchpad [03:35] stub: ok, I will file it against launchpad, is it right for you? [03:35] sure [03:35] ok [03:39] which, the new product with those 4 components in it? [03:40] justdave: not sure, stub? [03:40] I think a 'database' component for launchpad might be best, with me as the owner. [03:41] (stuart@stuartbishop.net is still my bugzilla id) [03:43] ok, done. [03:43] justdave: thanks [03:46] carlos: I don't know if you want Bug1965 to depend on 1968 if you have a working workaround. If the work around is good enough, Bug1968 won't be looked at until the soyuz sprint at the earliest. [03:47] well, we could move it for later [03:47] when we look at beta remaining bugs [03:47] np [03:47] the alpha is for tomorrow [03:47] I suppose the beta will be for the end of the month or something like that [03:48] is a way to have it present when fixing bugs in rosetta [04:14] stub, I'm going to propose 11am UTC on friday, which is like 8am here. how does that sound? [04:19] Fine here [04:23] wonderful. emails will go out to launchpad confirming ;) [04:29] lifeless, yo? [04:30] ? [04:30] how goes it? [04:31] frenetic, as usual :}. You ? [04:34] lifeless, at least as mad as you. [04:34] whats this alpha/beta thing I'm hearing about? [04:34] did you get cprov's request (and made heads or tails out of it)? [04:35] lifeless, alpha release of rosetta tomorrow, which means launchpad alpha in a way, right? [04:35] launchpad is in production already on macquarie [04:35] :) [04:36] lifeless: two bugs left from the rosetta team and I'm starting importing data into the DB [04:36] https://macquarie.warthogs.hbd.com/launchpad/ [04:36] hah. [04:36] and on rosetta, right :) [04:36] carlos: into emperor ? [04:37] lifeless: in my laptop [04:37] arh. right. [04:37] I need to automate the import task [04:37] kiko: I got cprov's request yes, and both stuart and I have answered. [04:37] when that's done, we will move it into a real server [04:37] lifeless, stub: thanx [04:38] kiko: Patch was just accepted a few seconds ago [04:38] carlos: cool, be sure to test with an extract of the live data, you don't want to overwrite anything or stuff [04:39] lifeless: we will not work with the production database for the alpha release [04:39] oh, so its a proof-of-concept period.. K. [04:39] yes [04:39] stub: what do you think about doing a new production drop on tuesday ? [04:40] Fine by me [04:40] ok. who do we need involved? I have access to the launchpad on macquarie, you ahve the db. [04:41] stub: are you the "db nazi" again? [04:41] carlos: not till monday [04:42] (not that nazi's ever really let go) [04:42] ok, I have some pending changes to send [04:42] I will send them later [04:51] kiko: rosetta's products will be mapped to source packages, I'm not sure if we have a full relation with the source table, but It makes no sense to use binary packages with it [04:51] because several binary packages will use the same translation source [04:53] I need a break. See you in about 30 minutes [04:57] carlos, hey, answer my email with more gems like that and I'll send you some vintage brazilian coffee on the next sprint [04:58] :-D [04:58] must.. sleep... soon.. [04:58] my new house doesn't even have a friggin shower yet and I'm at midnight at the office. [04:58] kiko: it's too early to go to sleep :-D [04:58] this has got to change. [04:58] here it's 5:00AM [05:11] here it's *sleeptime* :) === stub [~zen@dialup-33.53.194.203.acc03-dryb-mel.comindico.com.au] has joined #launchpad === stub [~zen@dialup-33.53.194.203.acc03-dryb-mel.comindico.com.au] has joined #launchpad === stub [~zen@c211-28-34-252.sunsh1.vic.optusnet.com.au] has joined #launchpad === limi [~limi@159.80-202-72.nextgentel.com] has joined #launchpad [08:57] morning all [08:58] limi: hi [08:58] carlos :) [09:00] limi: ready for the count down? [09:02] yup [09:04] well, as I said, time to take a shower [09:04] later === lulu [~lu@host217-37-231-28.in-addr.btopenworld.com] has joined #launchpad === lulu [~lu@host217-37-231-28.in-addr.btopenworld.com] has left #launchpad [] === sabdfl [~mark@host217-37-231-28.in-addr.btopenworld.com] has joined #launchpad === sabdfl [~mark@host217-37-231-28.in-addr.btopenworld.com] has joined #launchpad === lulu [~lu@host217-37-231-28.in-addr.btopenworld.com] has joined #launchpad === stub [~zen@dialup-33.53.194.203.acc03-dryb-mel.comindico.com.au] has joined #launchpad [11:18] lulu: I just checked out http://ubuntulinux.org/ Is someone going to produce a favicon.ico file to replace the plone logo? [11:18] that's a good point! I'll ask Limi [11:19] SteveA: we lack an Ubuntu icon [11:20] better not to have one than to have the wrong one === ddaa [~david@nemesis.xlii.org] has joined #launchpad [11:23] elmo's asking for someone to do it [11:26] rosetta.ubuntulinux.org is listening on the https port [11:26] but it is not listening on the http port [11:28] SteveA: ask elmo_mf [11:28] I guess we can run rosetta over https. It isn't a big deal, and means we don't need to worry about redirecting people to use HTTPS when they need to be authenticated with a password. [11:29] SteveA: we need something at http post alpha or people will have troubles to find rosetta (by default all people opens http instead of https) === elmo_mf [~james@host217-37-231-28.in-addr.btopenworld.com] has joined #launchpad [11:30] SteveA: ? [11:30] hello elmo [11:30] what's up? [11:30] I did that rosetta thing you asked for last night? [11:31] now I have to remember exactly what I asked for ;-) [11:31] the rosetta.ubuntulinux.org, going to :9010 on rosetta [11:31] X-) [11:31] so you can run a second launchpad invocation for alpha? [11:31] yes [11:31] ok.. lu said you wanted me tho - was there anything else? [11:32] rosetta.ubuntulinux.org is listening on https [11:32] but not https [11:32] but not http [11:32] (Rather) [11:32] oh, yes, I asked daf and he told me to do that [11:32] oh, ok [11:32] do you want me to a) switch them, or b) make http available but redirect to https ? [11:32] (or c, make both available - seems least good alternative tho) [11:32] making http available but redirecting to https would be neat [11:32] ok [11:32] and probably save us a bunch of email saying "use https" [11:33] right, I'll do that in a bit [11:33] thanks! [11:34] now I just have to wait for daf to get in (after his late night closing rosetta bugs last night), to get everything working [11:34] daf was up pretty late... [11:35] SteveA: I don't think he will wake up early, I think he went to bed about at 5:00AM [11:35] no, at 6:30 [11:35] I hope he's up for the launchpad meeting later today [11:36] the meeting is "late" so I don't think it will be a problem [11:39] do you think we'll be able to turn on rosetta today? === SteveA goes to find some food [11:40] SteveA: I'm working on a script to import the .po/.pot from an XML defining the projects, trying to figure a way to automatize it [11:40] cool [11:40] SteveA: rosetta is ready (should be) [11:41] if it's needed we could import the files by hand [11:41] is there anything you need help with on the script? [11:41] perhaps some ideas about the way to solve the problem will be welcomed [11:42] because I'm not completely sure I'm handling the best way I should [11:42] ok, let's talk about it when I've come back from the cafe [11:42] ok, thanks [11:46] steve: http's there now, redirecting [11:46] only for r.ul.o / r.u.c tho, r.w.h.c just gives you an empty page - I guess that's a feature as we don't want joe random seeing the dev dev version [12:21] SteveA: hi [12:21] daf: hey, you are alive!!! [12:21] :-D [12:21] :) [12:22] daf: I think we will need to import the projects/products by hand [12:22] I'm having hard problems with the script [12:24] carlos: yes, projects and products will need to be done by hand, lifeless has started already because of arch syncing [12:24] please discuss a wiki page with him where we can finetune them [12:24] and include some review [12:24] sabdfl: we are working with tar.gz for the alpha [12:24] once i've signed off on the project / product names, they can be put into the database [12:25] because we don't have the needed modules in arch yet [12:25] yes, i'm just talking about getting the project / product names into the db [12:25] then you attache the POT to the product, right? [12:25] sabdfl: I thought that we should import all ubuntu packages now [12:25] right [12:25] one at a time, by hand [12:26] based on arch for the alpha? === stub [~zen@dialup-33.53.194.203.acc03-dryb-mel.comindico.com.au] has joined #launchpad [12:31] hmm, I think if we can't import all packages in an automated fashion, doing it by hand will take a very long time [12:32] daf: I was working tonight in a kind of xml so we only "import" it by hand one time and future updates will be automatic, but it could still fail [12:33] where import is write some info we need to get by hand and then let a script execute it over an onver again [12:33] but I'm not sure it's a good approach [12:34] waiting for SteveA to talk about it [12:34] hmm, that's an idea [12:54] daf: could we talk about it now [12:54] if we should do it by hand I think we should start as soon as possible... [12:58] let's wait for Steve [12:58] ok === elmo_mf [~james@host217-37-231-28.in-addr.btopenworld.com] has joined #launchpad [12:59] I wonder whether we should decide on a canonical address for rosetta.ubuntusomething, and have everything else redirect to there. [01:00] daf, carlos: let's talk about importing stuff [01:00] ok [01:00] right [01:01] so, let's set the scene === carlos uploading the xml .. [01:01] what raw materials do we have? [01:02] SteveA: at this moment we have the list of packages from wiki or from apt source [01:03] http://gollum.pemas.net/~carlos/import-ubuntu.xml.txt [01:04] the apt source let's us to fill some fields automatically [01:04] did you come up with the xml pattern? [01:04] sorry, I don't understand what do you mean. xml pattern? [01:05] the DTD [01:05] that particular xml format [01:05] SteveA: no, I don't have the DTD wrote [01:05] I recommend you don't write a DTD [01:05] but, what I mean is, did you come up with this XML schema? [01:06] with this xml file format [01:06] i.e. did you invent the structure of the XML? [01:06] thanks daf :-) [01:06] yes [01:06] :-) [01:06] based on the database fields [01:06] cool [01:06] ./debian/rules common-configure-indep && cd po && intltool-update -P && cd .. [01:06] why is there a 'cd ..' at the end/ [01:06] ? [01:06] also, note that && isn't valid xml [01:06] to come back to the default dir [01:06] hmm, right [01:06] it needs to be && [01:07] the processor for this should ensure that each command starts in the appropriate directory [01:07] it shouldn't expect the to clean up [01:07] btw, what the heck is that common-configure-indep thing? is that a cdbs/gnome thing? [01:07] I execute a cd po and I undo it later, that's all [01:07] elmo_mf: cdbs [01:08] I don't need to build the package, only to configure it [01:08] if every command is always '&&' after the last one, we could also represent the commands each on a new line [01:08] this might make it easier to maintain / diff from [01:08] with serveral tags or inside the same tag? [01:08] no, just new lines [01:08] /s/serveral/several/ [01:08] so: [01:08] [01:09] ./debian/rules common-configure-indep [01:09] cd po [01:09] intltool-update -P [01:09] cd .. [01:09] [01:09] ok [01:09] maybe call it instead, or something like that [01:10] ok [01:10] if you run the command inside its own shell, you don't have to worry about the "cd .." [01:11] so, we have a list of packages, and we want a filled-in XML file that looks like carlos's file, right? [01:11] or perhaps with pushd popd... [01:11] the projects fields should be handled by hand [01:11] these are important implementation details, but let's discuss what we actually need to do overall [01:12] ok [01:12] carlos: did you fill in this xml file by hand? [01:12] yes [01:12] do you think it is straightforward to write a tool that reads in the XML, and imports the packages? [01:12] (I'm trying to find out what part you want help with) [01:13] yes, it should be easy when the xml is filled completely [01:13] SteveA: the difficult part is writing the XML file, I think [01:13] ok [01:13] yes, that's the problem [01:13] after all, that should be the only non-automated part [01:13] every package should be handled by hand [01:13] well... we can get a lot of information from the .deb can't we? [01:14] SteveA: yes [01:14] what information can we easily get from a .deb? [01:14] the "hard" part is the commandscript commands [01:14] right, so we need another script to generate a version of the XML which is then fixed up by hand? [01:14] all the ones in your file are the same. [01:14] name, short description and description have a direct mapping [01:14] daf: yes [01:14] So, we can start by trying that script, and seeing if it works. [01:15] Will it be apparrent if it doesn't work properly? [01:15] apparrent? [01:15] It will be obvious if no .pot file is there [01:15] apparent [01:15] um, obvious [01:15] but what about if there are several .pot files? [01:15] we could easily do some basic checks [01:15] so, what about having a step where you run find to locate .pot files? [01:16] potemplate [01:16] SteveA: I have some code to do it in C [01:16] to do what? [01:16] from a the GNOME status pages [01:16] to detect po directories [01:16] ok [01:16] so it's easy to port it to python [01:16] does it work for other projects than gnome? [01:16] yes [01:17] great [01:17] the detection does not depends on any GNOME specific [01:17] feature [01:17] what we should aim for is going through the names of packages. Get the .debs. See if it fits something we can automate. If so, import it. If not, log that somewhere to be done manually. [01:17] does that sound reasonable? [01:18] yes, an "if not len(pot_files) == 1" should work [01:18] yes, that's a start [01:18] sabdfl: I'm a bit confused -- will the Rosetta alpha have all the Ubuntu packages in it or not? [01:18] I don't understand what you just asked, daf [01:18] but we should review later all packages because we need to apply the debian/ubuntu patches to get all strings [01:19] we would like the rosetta alpha to have lots of packages in it [01:19] we should aim for the low-hanging fruit first [01:19] that is, those we can easily automate [01:19] ok [01:19] we would like that, but I would like the team to concentrate on development if importing all the packages is going to be a significant task [01:21] SteveA: eventually, we want Rosetta to have all the information needed to translate all of Ubuntu [01:22] SteveA: I'm asking Mark how soon we want to have all that information [01:22] the important thing right now is to get rosetta used by some of our target audience, while at the same time doing something useful for ubuntu [01:23] so, if we can get 70% of the ubuntu packages in there, the 70% that go all the same, then that's great [01:23] ok, the question is the extent to which we shuold spend time on the "doing something useful for Ubuntu" part [01:23] let's try to come up with a reasonable estimate of what it would take [01:24] then we can make an informed decision as to what to do [01:24] ok [01:24] and, we can keep it as simple as possible [01:24] so, let's agree on our goals [01:24] I'll propose some [01:25] * get enough data into rosetta alpha so that it can be well tested by early adopters [01:25] * get some ubuntu packages translated [01:25] anything else? [01:26] I don't think wee need more goals for the alpha [01:26] makes sense for me [01:26] well, the point of these goals is so that we know what things we have to balance against each other [01:26] yes, those are good goals [01:26] another goal would be to get it done pretty soon [01:26] there are other goals: [01:27] * fix bugs in the alpha [01:27] * start closing beta-critical bugs [01:27] but those goals are to release the beta [01:27] carlos: yes, but if we spend lots of time on goals 1 and 2, we can't work on goals 3 and 4 [01:28] I don't think we shouls expend more than some days for the 1 and 2 [01:28] /s/shouls/should/ [01:28] ok, let's think about what's involved in importing packages [01:28] our plan should be to import packages that come easily [01:28] and to leave those that are more difficult [01:28] until later [01:28] right? === SteveA waits for a response [01:29] yes [01:29] yes [01:30] carlos: do you already have code that uses your xml file to import stuff into rosetta? [01:30] not yet, but I have a script that I think could be adapted easily === cprov [~cprov@200-206-134-238.async.com.br] has joined #launchpad [01:31] how much time would it take to complete the task "have software that takes an xml file of package data, and imports each one into rosetta" ? [01:31] SteveA: one thing... I'm forgeting about the branch field in our database. We don't expose it in the UI and I don't think we should care about it until beta [01:31] SteveA: about 1 hour [01:31] daf: do you agree with carlos' estimate? [01:32] SteveA: I would estimate 2 hours at least [01:32] so, let's allow 3 hours [01:33] :-) [01:33] 1+2 = 3 ;-) [01:33] Is the XML schema complete? does it need any more work? [01:33] Well, the command part needs a little work, but we already discussed that. [01:34] Actually, I want to ask about that. [01:34] SteveA: if we can forget about the branches (not needed until we start with arch) [01:34] yes, I think it's completed [01:34] each of the commands in the example file is exactly the same [01:34] so, do we need to list the commands there? [01:34] SteveA: because all packages use cdbs [01:34] can we just say [01:35] but that will not work always, if we have a way to use a custom command, it's ok for me [01:35] or, we could identify commands by name [01:35] will it work in a lot of cases? [01:35] yes [01:35] then, let's do that for now [01:35] almost all GNOME packages should work [01:35] each package would have a or [01:35] it makes your task easier [01:35] daf: makes sense [01:35] SteveA: ok [01:35] don't over-design it now [01:35] we want to get many packages imported [01:36] I think the redundancy is very much due to the packages carlos has chosen [01:36] daf: the most importants ones are gnome packages [01:36] so, what %age or how many packages, can we get using this? [01:36] carlos: right === carlos follows the list Mark sent [01:36] ok [01:36] I think that's good enough for now [01:36] also, it seems like Mozilla and OO might be feasible to do [01:36] we can improve and generalize the system once we have those important gnome packages imported [01:36] yes, and that's cool :-) [01:36] but do not work on the general case now [01:37] no, you're right [01:37] so, we can just have a element [01:37] and this means "do the standard cdbs import" [01:38] and later on, we'll have other imports, one of which may involve ad-hoc commands [01:38] this is starting to sound like jhbuild [01:38] are you familiar with that, Steve? [01:38] ok, so will we forget also the multiple .pot packages, right? === justdave [~dave@24.247.63.44.gha.mi.chartermi.net] has joined #launchpad [01:38] what is that? [01:38] for now, yes [01:39] although we may still want to check for that [01:39] it's a tool James Henstridge wrote, originally to build GNOME from CVS [01:39] it became more general after that [01:39] it has a list of all the packages as XML [01:39] will a simple find name="*.pot" be good enough to check that we have just one pot file? [01:39] and it knows how to fetch and build each one [01:40] SteveA: no === ddaa [~david@nemesis.xlii.org] has joined #launchpad [01:40] touch foo.pot [01:40] touch bar.pot [01:40] name="*.pot" [01:40] so? [01:40] echo name # ==> "foo.pot bar.pot" [01:40] find will find that, and will reject that package [01:40] works for me [01:41] we want the simplest thing that will work for some of the important packages [01:41] if we reject too many to start with, that's ok [01:41] it's ok for me [01:41] sorry, I think I misunderstood you [01:41] if we make a list of all the files which match *.pot, then that will work for most cases [01:41] want me to try to explain better? [01:42] we can just check that exactly 1 file has been foudn [01:42] found [01:42] for a couple of GNOME packages, there will be multiple .pot files [01:42] I'm proposing that we look for all files inside a .deb that end in .pot. If there is more than one of these, we reject this .deb for now [01:42] and if there is less than one? [01:42] we also reject it [01:43] but, the cdbs-import will fail anyway then [01:43] no, we can't use .debs [01:43] or, source packages [01:43] right, source packages [01:43] ok [01:43] read "source packages" for when I said "debs" [01:43] so, the algorithm should be: [01:43] run the update commands defined for this package [01:43] look for pot files [01:44] if the number of pot files != 1, then add this package to the list of failed ones and go to the next one [01:44] otherwise, import it [01:44] -- [01:44] then, we can look at the list of ones which failed and deal with them individually later [01:45] gtk+ and gnome-applets will fail, because they will have 2 POT files [01:45] yes. [01:45] ok [01:45] will cdbs import always work if there is just one pot file, like this? [01:45] SteveA: yes, if it's not broken (like gnome-applets) [01:46] well, bad example, gnome-applets has two pot files but it's also broken [01:46] but that's a corner case [01:46] how is it broken? [01:46] carlos: actually, in the case of gtk+/gnome-applets, it will only generate one POT file, right? [01:46] will we get an error condition from cdbs-import ? [01:46] daf: yes, it's easy to do that, but it's an specific "hack" [01:46] carlos: since it only updates the po/ directory, and not po-locations or po-properties [01:47] SteveA: yes, it should raise an execption [01:47] SteveA: it misses some files needed to rebuild the .pot file [01:47] daf: but if we reject any package with more than a .pot file, we will not know that [01:48] carlos: will not know what? [01:48] daf: that the package will work with the standard cdbs-import [01:48] Ok, so here's what we need to do. It will miss a lot of packages, but it won't fail silently: [01:48] * for each package name: [01:48] - get the source package [01:48] - run the update commands defined for this package [01:48] - look for pot files [01:48] - if the number of pot files == 1, import it [01:48] - else add this package to the list of failed ones [01:49] [01:49] agreed? [01:49] it might have false positives in some cases [01:49] yes [01:49] but we know about the most important ones, I think [01:49] daf: do you mean that this plan might have "false positives" ? [01:49] SteveA: yes [01:49] what exactly do you mean? [01:50] i.e. it will fail to detect that a package intended to have two POT files because only one of them will be generated [01:51] daf: the .pot files are always there [01:51] come from the .tar.gz [01:51] they are? [01:51] yes [01:51] oh, but not in CVS? [01:51] the problem you are talking about will come when we move to arch [01:51] daf: yes, that's it [01:51] right [01:52] SteveA: this plan is definitely good enough for now [01:52] but the code I have does not checks for .pot files [01:52] but for POTFILES.in [01:52] that exists always [01:52] so it's easy to "fix" later [01:52] great [01:53] could we talk then about tasks? [01:54] yes [01:54] what tasks are needed to make the plan in software? [01:55] * for each package name: [01:55] - get the source package [01:55] - run the update commands defined for this package [01:55] - look for pot files [01:55] - if the number of pot files == 1, import it [01:55] - else add this package to the list of failed ones [01:55] 1.- Parse the list of packages and download them [01:55] wait [01:56] it depens on the way we will handle this... [01:56] specific scripts that does only one thing [01:56] what is the *simplest* way of handling this? [01:56] or a global script that does all [01:56] what about packages for which we have no update commands defined? === SteveA goes to answer door [01:56] daf: will be rejected [01:57] daf: as we talk, only cdbs packages will work in this phase [01:57] ok [01:57] I think we should do several scripts/methods that do every point of the algorithm [01:58] that way, when we move to arch is easier to change that part [01:58] without break anything else === SteveA decides to give up learning lithuanian. The only people I get to talk to aren't interested in even *trying* to understand [01:58] :-D [01:58] SteveA: that's a shame :( [01:59] it is sad, but I get further acting as an ignorant foreigner than in trying to speak the language [01:59] anyhow, back to imports [02:01] right [02:01] I think a script that takes an argument [02:01] the argument is a file containing a list of package names [02:01] the script gets the packages names into a python list [02:02] and instantiates a class PackageImporter for each item in the list [02:02] the class can live in the same module as the script [02:03] and the class executes all steps? [02:03] the class can have a "runimport()" method [02:03] that method contains the workflow we described above [02:03] def runimport(self): [02:04] self.getSourcePackage(tmp_directory) [02:04] self.runCdbsImport() [02:04] self.lookForPotFiles() [02:04] num_pots = self.findPotFiles() [02:05] (rather) [02:05] if num_pots == 1: [02:05] perhaps "class CDBSPackageImporter(PackageImporter):"? [02:05] self.importIntoDB() [02:05] SteveA: what happens when we move to arch? or when we import other packages that are not using cdbs? [02:05] daf: we have only CDBS now. Don't Generalize Now. [02:05] we should use different classes that implements the same interface [02:05] but, by all means call it CDBSPAckageImporter [02:05] SteveA: ok [02:05] SteveA: what values of "now" is this? [02:06] we don't need to generalize now, in order to meet our goals [02:06] what about Mozilla? === limi [~limi@sparkit.easynet.no] has joined #launchpad [02:06] we will generalize when we need to do meet our goals [02:06] we can get all the packages that work with this algorithm, and get them working, and then work on any that need more special treatment [02:07] if mozilla is one of these, then we'll refactor the script / class when we come to do mozilla [02:07] but not before [02:07] we need to keep it as simple as possible right now [02:07] write the script however you want to. the class I sketched is only a suggestion. [02:08] ok [02:08] but, do only what is needed to meet our goal of making this one import command and one flow of control working [02:08] I think the timescale in which we will want to import non-CDBS projects is very short [02:08] i.e. today [02:08] that's ok [02:08] it is still important to get this simple thing working, before making it mre complex [02:08] ok [02:09] it is much easier and more reliable, and more fun, to modify something simple that exists into something more complex, rather than coming up with something complex to start with. [02:09] we want to make progress today. [02:09] if things take longer than planned, and we only get the simplest cases done, well, that's still good progress [02:09] concur [02:10] but, if we plan something complex, and get 90% of the way there, that's no tangible progress. [02:10] ok, we need to think about the individual tasks involved, and estimate this. [02:10] carlos: can you make it a task to write an importer + XML file that does maybe 6-12 packages? [02:10] that's more like a "story" [02:10] I suppose that's two tasks [02:11] right [02:11] daf: sure [02:11] that's a specific goal [02:11] let's go through the workflow in detail. [02:11] 1. get the source package [02:11] so, one part is to write an importer that can import POT+PO files from CDBS source packages [02:11] we have the package name. [02:11] how to get the source pacakge? [02:11] right [02:11] apt-get source [02:11] so you need to have APT and the appropriate sources.list [02:11] we'll need to put it somewhere, right? [02:11] we will use the name of the source package [02:11] yes [02:12] ok, est. time to write code that gets a source package, and unpacks it into a working directory, under the name of the source package ? [02:13] if there is any way to do "apt-get source *" no more tha 15 minutes :-P [02:13] but I don't think we have something like that [02:13] carlos and daf: if you both independently estimate this, we'll have a good idea of whether the estimate is accurate, and whether the task is well-defined [02:13] os.system [02:13] * comes from a file that should be parsed [02:13] this is a trivial task, yes [02:13] estimate 5 minutes [02:14] ok, I'll mark it as 20 minutes [02:14] wow [02:14] grep SOMETHING Sources | apt-get source ? [02:14] 0. write script + class that reads in given file, and goes through each name in turn instantiating class and calling "run" method [02:14] yes, it's trivial :-D [02:15] carlos: don't forget to deal with error conditions [02:15] estimate for 0 [02:15] ? [02:16] I don't think I will be able to do it in less than 20 minutes [02:16] for 0 ? [02:16] yes [02:16] let's say 30 mins then [02:16] 2. run the update commands defined for thsi package [02:16] SteveA: but perhaps daf is faster than me on it === daf shrugs [02:17] carlos: 30 mins is fine. The important thing is that we've thought through the problem, and committed to a reasonable estimate we can achieve [02:17] ok [02:17] if you improve on the estimate, even better [02:17] carlos: you didn't have any sleep last night, right? [02:18] daf: true [02:18] daf: why, am I missing anything? [02:19] 2. run the update commands defined for this package. Estimate for this, please [02:19] hmm, perhaps it's better.. forgetting... [02:19] If we already know how to do it [02:20] no more than 10 minutes [02:20] I'm not sure what "run the update commands" means [02:20] carlos: no, just checking [02:20] I think it's possible to do it in not more than 5 minutes [02:20] SteveA: execute the commandscripts list [02:20] oh, okay [02:20] this involves checking for errors etc. [02:21] hmm, right [02:21] I always forget it :-( 30 minutes [02:21] if the commands return an sppropriate exit value, that's ok [02:21] otherwise, you need to parse the output, perhaps [02:21] let's give it in hour === debonzi [~debonzi@200-206-134-238.async.com.br] has joined #launchpad [02:22] carlos: yes, it's not very strict error checking [02:22] it's more or less "did this command script succeed or fail?" [02:22] it might be worth running command scripts in shells which have -e on [02:22] want to say 45 minutes? [02:22] daf: I know, I did it already for the pwgen and the msgfmt to get .mo files [02:23] carlos: right === SteveA waits for an answer on the 45 minutes suggestion [02:24] for this concrete example using cdbs, no more than 30 minutes [02:24] we already know what should be executed [02:24] 45 sounds good then. [02:24] X-) [02:24] remembering that it is okay to be well ahead [02:24] ok, next [02:24] 3. look for pot files [02:25] sounds very easy to me [02:25] just a few lines of obvious python [02:25] SteveA: using find as an external tool? [02:25] I'd do it in python, personally [02:26] using find I could do it in about 15 minutes (I have all code in C already), with python I don't know how to "emulate" find [02:26] os.walk? [02:27] ok, spend 20 mins trying it in python. If that gets nowhere, use find. [02:27] total time, 40 mins [02:27] and, you'll have learned how to do this in python :) [02:27] :-) [02:27] 4. if the number of pot files == 1, import it [02:28] 30 secs for the first part [02:28] daf: yes, seems like it's with os.walk (carlos saw the documentation) [02:28] SteveA: right [02:28] for "import it" ? [02:29] I think this will more or less be a copy + paste of code from the import script [02:29] for the == 1 :-) [02:30] can you make the import script into a library, and make the import script and this script use the same thing? [02:30] right, it's only a matter of execute all scripts we have already to import it [02:30] or, call the import script? [02:30] hmm, could do [02:31] is the easies thing to call the import script? [02:31] the import script is fairly reusable [02:31] ok, then we'll call the import script [02:31] does it report error conditions well? [02:32] I mean, you can do "from poimport import PODBBBridge" [02:33] an estimate? [02:33] it mostly just raises exceptions when it fails [02:33] so the exit code should be correct === ddaa [~david@nemesis.xlii.org] has left #launchpad ["Client] [02:34] so... [02:34] an estimate? [02:35] I think it should not be more than 30 minutes... [02:35] but better, an hour [02:35] because I'm thinking [02:35] that we should check if the project exists [02:35] or the product [02:35] and create them if they don't exists... [02:36] we have the scripts to create them and we should integrate all to work together [02:38] daf, what do you think? [02:40] while daf is thinking, let's talk about the last task [02:40] if we have all the information needed to create projects and produts, an hour should be enough [02:40] and if you don't, reject it? [02:41] SteveA: good question [02:41] 5. else, add this package to the list of failed ones [02:41] we don't have it without manual changes [02:41] the list of packages don't tell use the project [02:42] /s/use/us/ [02:42] This needs us to write out a list of failed packages to some file, with reasons why they failed, perhaps === daf -> phone [02:42] SteveA: the problem is that we missed the point that we need to process the initial list of packages to discriminate them in different projects [02:43] what would a file look like that represents that? [02:43] mozilla-firebird firebird [02:44] oops [02:44] into projects... [02:44] mozilla-firebird mozilla [02:44] gnome-applets gnome [02:44] etc. ? [02:44] yes, that's a good example [02:45] so, we can have a task that is to go through the list of packages, and assign them to products, like this [02:45] yes === daf back [02:45] then, the import script can take this too, and make it into a mapping [02:45] also, we need another task to collect the data for every project [02:45] so we can create them [02:46] I meant "assign them to projects" above [02:46] ok. We can do this in parallel with writing the import script. [02:46] yes [02:47] maybe an xml or rfc822 file of projects, and a list mapping products to projects [02:47] how many products do we have? [02:47] how many projects? [02:47] I suppose we need to do this only for those products that can be imported easily [02:47] so, that might be only one project: gnome [02:48] SteveA: then we need to execute first the download code [02:48] so, first job is to get the script written except for the "import" step [02:48] try to detect the po files [02:48] and then look at what packages we can import [02:48] and then make a list to associate then the projects for those products... [02:49] [02:49] plan: [02:49] 1. write import script except for "import" step [02:49] 2. look at what packages we can import easily [02:49] 3. make list mapping package to project [02:49] 4. import data about each project [02:49] 5. finish import step (can be done in parallel with 3 and 4) [02:49] 6. import for real [02:50] [02:50] how about that? [02:51] makes sense for me [02:51] where does the data for 4 come from? [02:51] in the script, we can write out a file saying the status of each package: package-name: IMPORTED or package-name: FAILED [02:51] then, we can look through the packages that imported okay, and map those to projects [02:52] daf: we enter the data about projects manually, once we know what projects we need [02:52] daf: by hand [02:52] if there are just 3 or 4 projects, we can write SQL to do it, for example [02:52] if there are more, we should come up with an XML or RFC822 file that gets parsed to do it [02:53] SteveA: we have it already in the xml I proposed [02:53] carlos: Okay. We need to have the "projects" information as an input to the script that produces the XML file [02:54] so in that case, it must be in an XML or RFC822 file itself [02:54] hmm [02:54] SteveA: I prefer what daf said [02:54] daf said "where does the data for 4 come from" [02:54] what else did he say? [02:54] write a script that modifies the same xml to append the products or potemplates [02:54] some hours ago [02:54] oh, okay [02:55] yeah, we can do that [02:55] so, what data files do we have now? [02:55] one XML file containing package information, and one file which maps products to projects? [02:56] [02:56] plan: [02:56] 1. write import script except for "import" step [02:56] 2. look at what packages we can import easily [02:56] 3. make list mapping package to project [02:56] 4. import data about each project [02:56] 5. finish import step (can be done in parallel with 3 and 4) [02:56] daf: yes [02:56] 6. write script that puts project data into the xml [02:56] 7. write real xml [02:56] 8. modify with project data [02:56] 9. pass this to the thing that imports the xml into the database [02:56] it's fine for me [02:57] [02:57] * for each package name: (read in from file of package names) 30 mins [02:57] - get the source package. 20 mins [02:57] - run the update commands defined for this package [02:57] (beware of error conditions) 45 mins [02:57] - look for pot files 40 mins [02:57] - if the number of pot files == 1, import it. 90 mins??? [02:57] - else add this package to the list of failed ones [02:57] write out package: IMPORTED or package: FAIL. 20 mins [02:57] [02:57] that's 245 minutes I think [02:57] 4 hours [02:57] 5 minutes [02:57] + [02:58] the script to write the xml into the database is 3 hours [02:58] and we still have to deal with project data, and write a script that reads in our xml file and modifies it, and writes it out [02:59] altogether, at least a person day-and-a-half [02:59] I think we should import by hand some pot/po files so the alpha testing could begin today [02:59] yes [03:00] how many? [03:00] with two or three projects could be enough so the alpha testers will be able to play with rosetta [03:00] yes [03:00] sorry, products [03:01] someone should file bugs for the story "import products that have a simple pot file" (steps 1..9 above) [03:02] SteveA: also, we need extra help from elmo [03:02] and "write script to automatically create rosetta xml from source packages" (* and - points above) [03:03] and "refine and document carlos' XML format" [03:03] SteveA: we need a chroot with all possible packages installed from warty to be able to run the cbdb script [03:03] and "script to take carlos' xml file, and import the information into the database" === carlos nevers remembers the correct name for cddb [03:03] carlos: can't we run this on a laptop? [03:03] SteveA: I'm doing it [03:03] we just need to run it on some non-server machine [03:04] and get the xml file onto the rosetta machine [03:04] but at the end [03:04] non need to get elmo involved [03:04] we need it on the server [03:04] why? [03:04] to get the updated .pot files [03:04] when we get arch involved, then we will [03:04] I don't think we need this during the alpha [03:04] with arch, we will not need it (or we should not) [03:05] ok, then we can do it on individuals' machines, and get the xml files onto the server [03:05] second thoughts: [03:05] SteveA: and the .pot files will be uploaded also? [03:05] the .pot files sometimes will be updated [03:05] rather than modifying the XML, I suggest that the packages and project information be kept separate [03:05] daf: yes? [03:06] so we have three files: a projects file, a packages file, and a file which maps packages to projects [03:06] carlos: why do you need chroot to install source packages in some working directory? [03:06] does this make sense? [03:06] daf: yes [03:07] makes sense to me [03:07] SteveA: because the dependencies, we start building the .deb packages [03:07] to apply the debian/ubuntu patches [03:07] and we need to satisfy the dependencies [03:07] we never compile it [03:07] but I don't think the checks are avoidable [03:07] but, why do you need chroot? [03:07] easily [03:08] as a security mesure, that's not the important point [03:08] hmm [03:08] I see your point [03:08] we could install them as a normal user [03:08] you can do all this as a user, can't you? [03:08] SteveA: yes [03:08] so, no need to hassle elmo [03:09] true [03:09] great [03:09] SteveA: in how many places is the name of the database stored? [03:09] for launchpad, just one. [03:10] great [03:10] where is that? [03:10] in stand-alone scripts, in each script [03:10] I think [03:10] launchpad-sql-configure.zcml [03:11] if I create the new database and change that value, the alpha server should be ready to import data [03:11] you need to just put a different file in override-includes [03:11] launchpad-sql-configure.zcml is symlinked into there [03:11] I need to take a break [03:11] right [03:11] I need to eat [03:12] SteveA: so I will fill a bug report to fill the database by hand with some products, that bug will block the alpha release, the other ones we were talking about will block the beta, is that ok for you? [03:12] SteveA: me too, I'm hungry :-) [03:12] sounds reasonable [03:12] ok [03:12] but, it would be good to import more stuff using this script before the end of the alpha [03:12] that is, we want to get this stuff imported while the alpha is still going on [03:13] SteveA: the idea is work on it now so we finish them this week (if possible) [03:13] so, maybe we want a bug called "before alpha can end we want the following things to have been tried out" ;-) [03:13] but it does not block the alpha because we will release it today, right? === SteveA is half-kidding [03:13] :-) === SteveA goes for break === carlos too [03:14] I will file all bugs after luch [03:14] later === kiko [~kiko@200-206-134-238.async.com.br] has joined #launchpad === cprov [~cprov@200.158.100.251] has joined #launchpad === debonzi [~debonzi@200.158.100.251] has joined #launchpad [03:44] hahaha! [03:44] createdb -E UNICODE launchpad_test || echo ${DBNAME} already exists [03:44] *oops*! [03:45] brown paper bag for stub, I think :) [03:48] ? [03:48] oh [03:54] SteveA: i will have to keep an eye on the launch process, so please lead the launchpad meeting whether or not i'm here, i'll read the logs [03:55] ok [03:56] daf: what's the latest from lalo? [03:57] SteveA: I don't think I've heard anything you haven't [03:58] ok, so we won't expect him at this meeting, unless he manages to get to an internet cafe [03:58] indeed [03:58] can you send him a summary of the relevant parts? [03:59] I'll mail the log to stub [03:59] a summary, or the log? === stub [~zen@dialup-33.53.194.203.acc03-dryb-mel.comindico.com.au] has joined #launchpad [04:00] hi stub [04:00] hi stub. shouldn't you be asleep? ;-) [04:00] ok, let's start [04:00] Morning [04:00] Yes mom [04:00] we're on === spiv is here [04:01] stub: I noticed this line in the schema Makefile just now: "createdb -E UNICODE launchpad_test || echo ${DBNAME} already exists" [04:01] daf, carlos from rosetta; spiv, kiko, cprov, debonzi from soyuz; stub from malone and DBA land; lulu from rosetta website experience; limi from "everyone's bitch" land; sabdfl half here, half at the warty launch, stevea [04:02] lalo, sends apologies, with a broken computer [04:02] let's start with malone === limi is lulu's bitch at the moment ;) [04:02] SteveA - May Limi and I be excused - the website goes live in an hour [04:02] sure [04:02] thanks [04:03] maybe keep 1/2 an eye, and we'll holler your names if we need something [04:03] stub: I posted the plan for malone to the list, and proposed it in the last meeting [04:03] what do you think about it? [04:04] Sounds sane [04:04] will you lead this, when you get back to working for us? [04:04] Also sounds like we aren't rolling out Malone in the next two weeks, and are initially sticking with Bugzilla [04:05] yes === SteveA realizes he forgot justdave from the list earlier. Hi dave! [04:05] I'm happy to keep leading the Malone work [04:05] ok, great. [04:06] justdave: are you around? [04:06] justdave is working on a list of the top 100 bugzillas, to start importing from [04:06] we'll catch up with dave later. === carlos backs from lunch [04:07] yep [04:07] stub: we'll need to work out what the changes needed to use malone with ubuntu and with launchpad are [04:07] I think daf has been finding bugzilla's dependency charts very useful [04:07] but, we've also been using bugzilla as an issue / project tracking tool as well as strictly a bug tracking tool [04:08] I'm not sure what to do about that, wrt the malone plan [04:08] justdave: how's the list of sites going? [04:09] has not been started yet because I've been dealing with bug-buddy and then release issues with bugzilla.ubuntu.com [04:09] should have it by next week though [04:09] launchpad team in general: we'll need to think about what features malone *needs* to have in order to start using malone for launchpad. At present, we have "assign a person as responsible for fixing a bug". [04:10] and I hope that's all we need. [04:10] justdave: maybe start doing just a few each day to ease into it? [04:10] dependency tracking is useful [04:10] And there is a feature request in Bugzilla for dependency charts [04:10] Being able to close a bug would help ;) [04:10] dependency graphs arenot as essential [04:10] spiv: what do you mean? [04:11] I shuold have filed a bug about dependency tracking first [04:11] (and then made the carts bug depend on it :)) [04:11] SteveA: Just taking your statement a bit too literally. [04:11] * charts [04:11] planning on 20 or so a day right now. [04:12] we need two categories: stuff we *need* in order to start using malone for launchpad development. stuff we'd *like*. [04:12] but I may adjust that number as I get going and see how long it takes for each [04:12] let's put a wiki page up for that [04:12] SteveA: I was about to ask wehere these lists are being kept :) [04:12] And the wiki page shall be called --- MaloneUseCases! [04:13] justdave: as part of the malone plan, we also need scripts to import open bugs from bugzilla. [04:14] SteveA: alternatively, we could file the things we need as bugs [04:14] let's stick them on a wiki page for now [04:14] SteveA: and track it all using a metabug [04:14] ok [04:14] justdave: any thoughts? [04:14] certainly doable. how soon do we need it? [04:15] within the next month, probably [04:15] depends on when stub can get malone ready for use for the launchpad bugs [04:16] justdave: can you file a bug on yourself for malone to write a description of exactly what the "import open bugs" thing needs to do? [04:16] ok, a month is plenty far enough off to do that after I get the list done. [04:16] import script shouldn't take more than a week [04:17] sure [04:17] the important thing is to get the detailed description of what it should do fairly soon, so stub can use that for planning malone [04:17] thanks [04:17] ok, I think that's it for malone [04:17] soyuz next [04:18] yep [04:18] kiko: you've arranged some meetings to get soyuz presenting relevant information from malone and rosetta [04:18] sorry to chip in, just reading scroll back [04:18] and i'd like to say that dependency tracking is really for enhancements to software [04:18] I disagree [04:18] which will be better handled by the project management tool i'd like to work on once malone is nicely bedded down [04:19] daf: go ahead === SteveA pops upstairs to close a window, as it is started raining a lot [04:19] SteveA: yes, we are trying to arrange this soon w/ daf, stub, lamont/elmo [04:19] we 've had bugs in Rosetta which can't be fixed because there is another bug that needs to be fixed first [04:20] are those bugs, or features that are not yet implemented? [04:20] We have had cases where bugs in rosetta required bugs in sqlos to be fixed. [04:21] e.g. you can't commit translations which include % signs [04:21] sabdfl: sometimes features, sometimes bugs [04:21] so that's one bug, in sqlos, that victimises rosetta [04:21] this can't be fixed until a bug in Zope is fixed [04:22] ok, keep going, i just wanted to point out that the project management tool is coming once we get these first launchpad apps bedded down [04:22] and that will be a whole new thing we need to figure out how to use [04:22] it is often feature enhancements, but not always [04:22] and the interaction between that, and malone, will i think be very powerful indeed [04:22] SteveA, right. [04:22] and there are cases where feature enhancements are blocked on bugs [04:23] i.e. I can't implement this feature until this bug is fixed [04:23] we'll get to the point where we can handle each of those scenarios very powerfully in launchpad [04:23] keep going... kiko? [04:23] but I am certain that there are cases where it is a straight bug-to-bug dependency [04:23] I think issues will block bugs, and vice versa (we already know issues and bugs are intimatly mated) [04:24] sabdfl, we've been looking into integration with rosetta and malone, because those are high on our todo list. [04:24] most of the other basic tasks are well underway and accounted for [04:24] have any problems come up so far in integrating the apps? [04:24] but integration is a murky area, particularly because a good part of the concepts don't match up automatically. [04:25] we haven't even started them yet; the meetings we've set up are to start discussing their concepts and our concepts and seeing what matches. from there fill up the templates with real data. [04:25] I wonder if what we want is to coax daf and stub into writing portlets for us, or if we want to go into the database and pull data out. [04:26] there should be clean interfaces to the data you need === carlos goes to open the door [04:26] I think it would work best if the rosetta team is responsible for writing the thing that gives you what objects you need. [04:26] okay. so we shouldn't expect some ready-made "rosetta components" that come with UI and all? [04:26] I think it would work best if the rosetta team is responsible for writing the thing that gives you what objects you need from rosetta [04:27] well, that might work even better [04:27] but on the data level -- we organize that into the interface as we like? [04:27] but I think you need to discuss in these meetings which approach fits best [04:28] what I want to avoid is for the soyuz team to be dealing with the low-level rosetta stuf [04:28] we have allocated a meeting specifically to talk about this tomorrow [04:28] yeah. [04:28] I don't want to overburden rosetta/malone people, and I suspect that data sans UI is easier to obtain at this point, so I'd shoot for that. [04:28] SteveA: agreed: Soyuz should not need to grok Rosetta internals [04:28] is there any stuff you need to discuss going the other way? presenting soyuz information within malone or rosetta? [04:29] just to make things clear -- we want to be able to list open translations for a certain source package. I want to know if that makes sense or if I'm on crack. [04:30] SteveA: does make sense presenting Soyuz data on Rosetta/Malone world ? [04:30] Are these mini-reports or summaries that link into rosetta and malone? Or a duplication? [04:31] stub, I don't know what a duplication would mean, so the first option smells better. [04:31] stub: yes, mini-report, we are thinking in something like that. [04:31] kiko: as I said yesterday (sorry, I forgot to send it to the list) Rosetta will work with source packages (or should do it) [04:31] so the mapping should be one to one [04:32] I think there is a place for summaries ('There are X bugs in this package, click here to see'), or even portlets that don't take up much screen real estate. [04:32] carlos, that's really good news. I wonder if you guys know about source package releases as well (cutoff points, I guess) [04:32] stub, that's what I want, a summary. [04:33] cprov: that's what I was asking :-) [04:33] kiko: I suppose we know, we use same tables [04:33] stub: we also handle with persons ans should be able to get a report about them bugs (Mark has X assigned bug, Y resolved bugs, and so on) [04:33] ok, the rest you can talk about in the meeting tomorrow [04:33] okay. [04:34] what is the tangible outcome of the meetings tomorrow? [04:34] ok [04:34] SteveA, things are under control on our side. Debonzi and Celso have nice little laundry lists and will be picking things off. No major roadblocks except for: [04:34] - Integration issues [04:34] - Package browsing (which you've pushed off) [04:35] - Component browsing (which we haven't dreamed of and doesn't seem important -- we are just going to display where a sourcepackage is on-screen in the sourcepackage view) [04:35] that's it. [04:35] ok [04:35] did all the issues raised at the soyuz meeting on monday get addressed? [04:36] ZODB's still not up, so that blocks part of the work afaict. === SteveA makes a note to get ZODB up [04:36] SteveA: You have a bug about it. [04:36] my note says "look at the bug" [04:36] and getting larger amounts of data is not in our backyard if possible. [04:36] :) [04:37] we'd like to be able to get something automated to push stuff in beyond what's being manually inserted. [04:37] which work does the zodb block? [04:37] just notices, which aren't even critical (but which I find cool). [04:37] Nothing urgent that I can think of -- just the "latest notices" thing. [04:37] ok, the notices. [04:37] cool [04:38] but, it would be good to allow you to experiment with interesting ideas like that [04:38] did all the issues raised at the soyuz meeting on monday get addressed? [04:39] yes, I think [04:39] SteveA, that was one of them. the other is DB fillage. the other is limi's assistance on page-browsing. [04:39] the rest is dealt with. [04:39] spiv: you didn't mail to the list [04:39] (I was being verbose) [04:39] SteveA, sure he did. [04:39] did he? [04:39] Subject: Bugs filed as a result of Soyuz meeting on Monday === SteveA wonders if his spam filter has been working overtime [04:39] SteveA: Sorry, I mailed it just before this meeting, which was a bit later than ideal :( [04:40] oh, okay [04:40] thanks for posting it :-) [04:40] There's two points that didn't have bugs about them yet: [04:41] "leave links to bugs until stub gets back to help you with it" [04:41] I think that one is being taken care of, though. [04:41] you have the meeting [04:41] right. [04:41] And "make Distro --> DistributionRole really work" -- cprov, I want to chat with you about this first, so I can file a bug that makes sense :) [04:42] (Just to confirm that I understand what the issue there is) [04:42] spiv, yeah, this may tie into my teams email I wrote this morning. [04:42] ok [04:42] I asked earlier: what is the tangible thing you'll get out of your meetings tomorrow? [04:42] will someone mail a summary to the list? [04:43] spiv: sure we can chat [04:43] cprov: After this meeting suit you? [04:43] spiv: yes, it's nice for me [04:43] Ok. [04:43] SteveA, we don't know yet, tbh. We're investigating possibilities. We'll probably get information and a strategy. [04:44] kiko: ok, please make sure someone mails a summary of the meetings to the launchpad list after the meetings [04:44] I'll do that. [04:44] Let's move on to rosetta [04:44] thanks. [04:44] daf: how is rosetta going? [04:47] I think we're on track to release the Alpha today [04:47] we've closed a lot of bugs over the past week [04:47] (and filed even more in preparation for the Beta :)) [04:47] http://rosetta.ubuntulinux.org has been set up [04:48] it requires a username and password [04:48] i don't think it should do [04:48] elmo_mf: can you turn this off? [04:49] SteveA: does the launchpad login screen works? [04:49] err, yeah, in a bit [04:49] carlos: nothing will work while apache requires auth [04:49] what about importing packages to be translated? [04:49] SteveA: as soon as it disapear, it will start working automatically? [04:50] carlos: yes, but we need to look at what permissions you have set. [04:50] ok [04:50] daf, carlos: after this meeting, let's look at permissions [04:50] ok [04:51] yes, let's [04:51] what about importing packages? [04:51] what have you decided to do about that? [04:52] we discussed package imports this morning [04:52] we worked out that it is 1.5 days work for someone to write the import script [04:53] so you were going to import a few by hand today [04:53] since it seems developing an import script is going to be a non-trivial effort, we're going to import a few packages by hand for the Alpha [04:53] did you decide which ones? [04:53] no [04:53] not yet, but I think we could follow mark's list of packages, we have them sorted by importance [04:53] I'll take them from Mark's list [04:53] :-) [04:54] :) [04:55] ok [04:55] so, we're aiming to have the rosetta alpha working by the end of today? [04:55] that's right [04:55] so, you'll plan to announce it to the list of "rosetta sounders" tomorrow [04:55] I was planning to announce it as soon as it's up [04:56] if it goes up late, don't announce it when you're very tired [04:56] sleep on it, and check it out in the morning [04:56] I'll bear that advice in mind [04:56] daf: then you should send the announcement :-P [04:57] I should not [04:57] and, let's make time to give the alpha, once it is up, a thorough look at together [04:57] that would be good [04:57] ok. [04:57] SteveA: I have a doubt about rosetta and ubuntu website [04:57] we have a link to rosetta [04:58] (or we will have it) [04:58] if we have it closed only for alphatesters... [04:58] I don't think it will be closed for them [04:58] but we don' have a way to register new users [04:58] only that we'll need to have people registered in the database to do certain things [04:58] we register them by hand [04:58] daf is registering people by hand using your script, isn't he? [04:58] yes [04:59] SteveA: that's the plan [04:59] I'll do a mass registration before I send out the announcement [04:59] what about people who see the site in the link from ubuntulinux.org? [04:59] SteveA: that's my question :-) [05:00] that's undefined behaviour :) === stub 's battery is running low [05:00] let's define it [05:00] ok, let's define that in a rosetta meeting [05:00] I'd like to declare the whole launchpad team meeting over. [05:00] I think we'll want sabdfl's input on that [05:01] thanks for coming, launchpad team [05:01] thanks for chairing, Steve === npmccallum_ [~npmccallu@69-162-252-7.ironoh.adelphia.net] has joined #launchpad [05:02] thanks SteveA [05:02] time to hack! === stub waves g'night [05:02] night stub [05:02] night stub [05:02] stub: bye [05:02] stub: before you go... [05:02] stub: shall I fix that Makefile bug? [05:02] Bug? Looked fine to me... [05:03] stub: look again [05:03] stub: or shall I explain? :) [05:04] daf, carlos: let's meet again in 30 minutes to talk about permissions and anything else pertaining to rosetta alpha [05:04] hardcoded launchpad_test? [05:04] stub: exactly [05:04] SteveA: ok [05:04] sure - fix it if you want. [05:04] stub: ok, thanks [05:05] spiv: you've finished the xml-rpc auth server? I know we had a recent change in an encoding. [05:05] Oh - was there a decision on the unique constraint for schemas and labels? [05:05] stub: I will send you a patch [05:05] well, to lifeless === stub buggers off [05:06] spiv: can you talk with the admins about getting it running on maquarie? Upfront are aiming to deliver their part at the end of the week, so it would be good to get the xml-rpc server running by then. [05:06] cheerio stub === stub [~zen@dialup-33.53.194.203.acc03-dryb-mel.comindico.com.au] has left #launchpad [] === carlos takes a break until next meeting [05:07] SteveA: In theory, yes, but I haven't written as many tests as I'd like to be 100% confident that there's no stupid bugs. [05:07] SteveA: I'll talk to the admins. [05:08] can you mail them today? [05:08] Yes :) [05:09] (Assuming they don't all collapse for 24hrs after the Ubuntu release :) [05:34] password removed from r.ul.o [05:34] elmo_mf: thanks! [05:50] SteveA, daf: meeting? [05:52] hi [05:52] hi [05:53] hi [05:53] so, let's talk about what different people should be able to do with rosetta [05:54] we have the following situations [05:54] - pages / actions that anyone can see / do. [05:54] - pages / actions that only People in the database may see / do [05:55] - pages / actions that noone may see / do [05:55] what things fall into the last category? [05:55] accessing attributes or methods for which no security declaration is made [05:55] you've been doing this all along :) [05:55] indeed :) [05:56] this may sound trivial, but it used to be a real pain with zope 2 development [05:56] before the zope2 security system was partially fixed by making it deny before allowing [05:56] we also have the following situations with people being logged in [05:57] - no-one is logged in (it is the unauthenticated principal) [05:57] - a Person is logged in [05:57] right [05:57] ok [05:57] we have the following combinations of what people can see / do, and who is logged in [05:57] - no-one is logged in; pages/actions that anyone can see/do [05:58] - a person is logged in; pages/actions that anyone can see/do [05:58] - a person is logged in; pages/actions that only people in the database may see/do [05:58] We need to make a list of those pages/actions that only people in the database may see/do [05:59] I think the only pages that should be accesible only for people logged are the forms (except the searcher) [05:59] doing it based on pages is a good first step [05:59] https://rosetta.warthogs.hbd.com/rosetta/projects/$Project.name/$Product.name/$POTemplate.name/translate [06:00] translator dashboard, maintainer dashboard, preferences, translation template [06:00] those are the ones that come to mind [06:00] let's open a bug called "set restrictive permissions on forms in rosetta" [06:00] https://rosetta.warthogs.hbd.com/rosetta/projects/$Project.name/$Product.name/$POTemplate.name/$Language.code/+edit === carlos has pending to open the previous meeting bugs. but I have the log saved === carlos writing this bug report [06:03] ok. [06:04] How about if daf and I pair-program on getting the first few permissions sorted out in the code? [06:04] carlos: when do you need to sleep ? [06:04] SteveA: I can work still some extra hours [06:04] hmm, I don't have access to the server to do the initial import data [06:04] carlos: your stamina is impressive :) [06:05] daf: as soon as I leave the laptop It will go down :-) [06:05] stay where you are! [06:05] I only need to be busy [06:05] :-D [06:06] what other important tasks do we have for today? [06:06] hmmm [06:06] ok, I could prepare a .sql file with the initial server data [06:06] in my laptop [06:06] why can't I run the import script on the server? [06:06] so daf you will only need to load it into rosetta's serve [06:06] daf: I don't have an account :-) [06:07] but I could run the script [06:07] or I could load SQL [06:07] but you will be busy with steve [06:07] that would probably be easier, actually [06:07] that's my point I work now on a sql [06:07] with the initial data for the alpha [06:07] upload it to chinstrap === daf nods [06:07] and you import it into the database === npmccallum__ [~npmccallu@69-162-252-7.ironoh.adelphia.net] has joined #launchpad [06:10] SteveA, daf? [06:11] yes? [06:11] do you agree? [06:11] :-D [06:11] yep [06:11] ok === carlos backs to work === kiko is now known as kiko-fud [06:24] elmo_mf: ping? [06:26] yeah? [06:26] any chance of andrew getting an account on rosetta until Monday, and being able to run some twisted listening on an unpriv port to the outside world, and being able to create a postgres DB? [06:27] I'd like him to be able to run his xml-rpc auth service, with a dummy db, so that upfront can test against the software their stuff will be used with. [06:29] this in turn will make it more likely that the "turning on auth on the ubuntu site" will work properly on friday === doko [doko@dsl-082-083-248-088.arcor-ip.net] has joined #launchpad [06:33] SteveA: yeah, still busy with random release stuff, I'll try and do it in a bit [06:33] ok, shall I mail to admins@... ? === SteveA mails anyway [06:34] never hurts to mail :) [06:35] thanks elmo === debonzi [~debonzi@200.158.100.251] has joined #launchpad === elmo_mf [~james@host217-37-231-28.in-addr.btopenworld.com] has joined #launchpad === elmo_mf is now known as elmo_ === kiko-fud is now known as kiko [09:28] daf: how is going the bug fixing ? [09:31] I have a fix for the recently translated feature locally [09:31] Steve and I are working on permissions [09:33] I'm importing .po files but it's sloooooow [09:33] yeah :( [09:34] even on the Rosetta server, it's slow [09:34] hmm, that's bad [09:38] daf: hmm, we have a problem... [09:38] psycopg.IntegrityError: ERROR: duplicate key violates unique constraint "pomsgidsighting_pomsgset_key" [09:38] INSERT INTO POMsgIDSighting (id, pluralform, pomsgid, inlastrevision, datelastseen, datefirstseen, pomsgset) VALUES (1836, 1, 924, 't', 'NOW', 'NOW', 918) [09:38] msgfmt -c -v does not detect anything and it's a .pot file... [09:39] must be a bug [09:41] I know, I'm debugging it now [09:43] do you know what exactly the "pomsgidsighting_pomsgset_key constraint is? [09:43] yes, I think it's a problem with a plural form [09:43] a unique key [09:43] don't worry, I will handle it [09:44] well, I'm not surprised we're finding bugs in the importer when testing it with real files [09:45] I think I have it, need to look at the .pot file [09:45] SHIT [09:45] #: mailcheck/mailcheck.c:1091 [09:45] #, c-format [09:45] msgid "%d unread" [09:45] msgid_plural "%d unread" [09:45] msgstr[0] "" [09:45] msgstr[1] "" [09:46] How could we handle it? [09:46] it's not a bug in the importer [09:46] ooh [09:46] I think it is a bug [09:46] not in the importer [09:46] this is a valid message set, I think [09:46] the database does not handle it [09:47] oh, right, not in the importer [09:47] the constraint is invalid, I think [09:47] seems like it's invalid [09:47] yes [09:47] funny... [09:47] hope lalo did not assume any check based on that restriction... === carlos removes the unique key [09:49] will you submit a patch to the scema? [09:49] yes [09:49] with the labels changes [09:52] seems like lalo is connected [09:52] I got an orkut invitation from him === carlos needs some food === lulu [~lu@host217-37-231-28.in-addr.btopenworld.com] has joined #launchpad === limi [~limi@159.80-202-72.nextgentel.com] has joined #launchpad === limi [~limi@159.80-202-72.nextgentel.com] has left #launchpad [] === lifeless_ [~robertc@dsl-220.2.240.220.rns01-kent-syd.dsl.comindico.com.au] has joined #launchpad [10:27] hi elmo, do you have some time to give me a breaf explanation about sourcepackage builddepends and builddependsindep? [10:30] if some else know about it are wellcome too :) [10:32] debonzi: what do you need to know? [10:33] builddepends are packages another package needs install to build architecture-dependent packages [10:33] builddependsindep are packages needed to build architecture-independent packages [10:34] daf, That's what I need to know indep means arch-indep :) tks [10:35] no problem [10:58] daf: what should I do with the .po files that fails importing them? bug report with it attached is enough? [10:59] no [10:59] just include the message set that causes the error, I think [10:59] daf: I need to debug it [10:59] and I don't want to expend time on it tonight [10:59] sure [11:00] I have the bt [11:00] BT? [11:00] and I have the .po file, I will save them for tomorrow [11:00] trace [11:00] backtrace [11:01] pfff, it an hour I have only three po files imported. I think we should fix it before the beta release.... [11:01] /s/it/in/ [11:01] :( [11:02] well two, and it's working on the third (and the second failed) [11:07] SteveA: do we have a profile for python? [11:07] I don't know what that means [11:07] carlos, profile.py? [11:07] or hotspot? [11:07] carlos: There is a profiler, if that's what you're asking. [11:08] any URL I could look at [11:08] or a name [11:08] hotshot [11:08] hotspot? [11:08] hotshot [11:08] ok [11:08] thanks * [11:08] I think the database is the bottleneck [11:08] carlos: It may also be worth turning on the debug flag in SQLObject, if you suspect DB calls are the problem. [11:08] phone [11:09] (or the equivalent at the postgres end) [11:09] we may want to provide some db calls that do a lot in one query, and see if that helps [11:18] sorry, I'm back [11:20] daf: the bugs I file now should block the Alpha release or the beta one? [11:21] what are the bugs? [11:21] are bugs inside the imported code that fails [11:21] for instance, it does not handle custom headers (like X-Generator) [11:21] file the bugs, we can fix the dependencies later [11:21] ok [11:22] I think the parser should be fairly liberal with regards to ignoring headers it doesn't recognise [11:23] daf: right === lulu [~lu@host217-37-231-28.in-addr.btopenworld.com] has joined #launchpad [11:32] lulu! late night eh? :) [11:36] kiko:hey hon - yup - last nigtht and tonight, but just had a yummy dinner as a celebration! [11:37] how u? === lulu [~lu@host217-37-231-28.in-addr.btopenworld.com] has left #launchpad [] [11:45] The sql sentences does not show anything that seems to be unnecesary but when it's a SELECT COUNT... in that case it execute it twice [11:45] 2004-09-15 23:44:45 [13570] LOG: statement: SELECT COUNT(*) FROM POMsgIDSighting WHERE pluralform = 0 AND pomsgset = 1345 [11:45] 2004-09-15 23:44:45 [13570] LOG: statement: SELECT COUNT(*) FROM POMsgIDSighting WHERE pluralform = 0 AND pomsgset = 1345 [11:46] hmm [11:46] but I doubt that's the problem to go so slow [11:46] we have about 10 selects/updates [11:46] me too [11:46] hmmm [11:46] 10 per message set? [11:47] I didn't count them [11:47] It's difficult to do it [11:47] yeah :( [11:47] it was a feeling :-) [11:47] perhaps you could create a test PO file which only contains one or two message sets [11:48] wow [11:48] 28 select/updates [11:48] every field is updated in different queries: [11:48] 2004-09-15 23:50:01 [13570] LOG: statement: UPDATE POMsgIDSighting SET inlastrevision = 't' WHERE id = 2691 [11:48] 2004-09-15 23:50:01 [13570] LOG: statement: UPDATE POMsgSet SET commenttext = '' WHERE id = 1345 [11:48] 2004-09-15 23:50:01 [13570] LOG: statement: UPDATE POMsgSet SET sourcecomment = '' WHERE id = 1345 [11:48] 2004-09-15 23:50:01 [13570] LOG: statement: UPDATE POMsgSet SET filereferences = 'accessx-status/GNOME_AccessxStatusApplet.server.in.in.h:3' WHERE id = 1345 [11:48] 2004-09-15 23:50:01 [13570] LOG: statement: UPDATE POMsgSet SET fuzzy = 'f' WHERE id = 1345 [11:49] 2004-09-15 23:50:01 [13570] LOG: statement: UPDATE POMsgSet SET flagscomment = '' WHERE id = 1345 [11:49] 2004-09-15 23:50:01 [13570] LOG: statement: UPDATE POMsgSet SET obsolete = 'f' WHERE id = 1345 [11:49] instead of execute only one UPDATE [11:49] ouch [11:49] that could be a big problem [11:49] with long .po files [11:49] we might be able to improve that [11:50] can you identify where these calls are being made in Python code? [11:50] spiv: should SQLObject be clustering these changes? [11:50] spiv: or is it not that clever? [11:52] SQLObject [11:52] pofile_adapters.py [11:53] it's an sqlobject that changes its attributes [11:53] and every time, it seems like it executes an update [11:54] how about this: [11:55] (we don't have to do this now) [11:55] we take a PO file that is known to import [11:55] i.e. it doesn't trigger any bugs [11:55] and we time how long it takes to import it [11:56] then, we add a magic method which does the above six updates using _connection.query() [11:56] make the PO file adapters use that method [11:56] and time it again [11:56] that way, we know how much of a preformance improvement we can expect from reducing the number of queries [11:57] makes sense (I suppose using_connection.query() will let us to execute sql sentences directly, right?) [11:58] yes, I think there are some cases of it in sql.py already [11:58] ok [11:58] I will file a bug about it now [11:58] brilliant, thanks [11:58] I think perhaps you should sleep now :) [11:59] daf: yes, I was thinking about it already, don't worry :-)