Nice news I guess :) I'm no Python expert (neither imdbpy) so I will leave the changes for you. But I can let you know that for me it was a matter of adding a column in the sql schemas files and the respective field in the code loading the titles data (using a md5 function of course). 2 simple lines and it did the trick for me, plus I didn't notice a high increase in the import time on my virtual machine either. Since I'm not very interested in the imdb ids for other tables (e.g. actors) I didn't patch those but if you do it I guess it's just better to have it all at once.
I'm currently focusing on another part of my project but I'll get back to this. If you happen to have these changes in the meantime it will be sweet to know everything is in place for a central repository and I'll take that in mind. I'm hoping to create a script that manages everything and host the data & api for upload/download in google's appengine. Bye, On Jul 30, 8:02 pm, Davide Alberani <davide.alber...@gmail.com> wrote: > On Jul 30, Alexmipego <alexmip...@gmail.com> wrote: > > > Once the MD5 column was present on the > > distribution everyone would be compatible with my solution. You ask > > about when and where this "matching" would be done, and the beauty of > > this (for you) is that it can be done completely outside imdbpy2sql. > > I admit you've more or less persuaded me. ;-) > If I'll have time, this week or the next one, I'll look at what > can be done. > > > Btw, I initially thought that I could simply assume the ID you assign > > to each title is sequential, so I could simply assume the first line > > in the CSV was ID 1 and the last would simply match. However, I found > > out that the final sql table has more rows than the raw file and that > > means something is either wrong or some extra processing is done. > > That's due to the fact that not every file in the set of the > plain text data files is updated at the same time, and so there > can be incongruences and even errors here and there. > So, every time imdbpy2sql is asked to handle a movie title (or a > person or company name, for instance), it checks if it's already > known or create it otherwise. > This means that imdbpy2sql will run nicely even if the movies.list.gz > file is removed. > > Bye, > -- > Davide Alberani <davide.alber...@gmail.com> [GPG KeyID: > 0x465BFD47]http://www.mimante.net/ > > ------------------------------------------------------------------------------ > The Palm PDK Hot Apps Program offers developers who use the > Plug-In Development Kit to bring their C/C++ apps to Palm for a share > of $1 Million in cash or HP Products. Visit us here for more > details:http://p.sf.net/sfu/dev2dev-palm > _______________________________________________ > Imdbpy-help mailing list > imdbpy-h...@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/imdbpy-help ------------------------------------------------------------------------------ The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm _______________________________________________ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help
