[Imdbpy-help] differences between http and sql results

2009-01-07 Thread Mike Castle
I built a local sqlite db with data from 2009-01-02, using my then installed 3.6 version on Debian/testing (currently using 3.8). I've noticed that there are a few things that are different between the http and sql versions. Some I think (ratings missing from http, year as string vs int) will be

[Imdbpy-help] another http vs sql difference: kind

2009-01-08 Thread Mike Castle
Another difference I noticed. I'm not too worried about the different set of results being returned, I understand that IMDB's web servers and imdbpy will have different implementations for fuzzy matching. No, what I'm confused by is how ['kind'] changes after the update(). #!/usr/bin/python imp

Re: [Imdbpy-help] another http vs sql difference: kind

2009-01-08 Thread Mike Castle
G. Never mind. Forgot to check against head. Works as expected now. Out of curiosity, would that be a result of the new parses or perhaps a side effect of ``fixed bugs about tv mini-series?'' mrc On Thu, Jan 8, 2009 at 10:54 AM, Mike Castle wrote: > Another difference I not

Re: [Imdbpy-help] differences between http and sql results

2009-01-08 Thread Mike Castle
On Thu, Jan 8, 2009 at 10:34 AM, Davide Alberani wrote: > As a side-note, are there SQLite experts around? > Are such poor performances to be expected? A "you can't create a > 3GB single-file database and expect it to be fast, you insensitive clod" > would be clear enough. :-) http://www.mail-ar

Re: [Imdbpy-help] differences between http and sql results

2009-01-08 Thread Mike Castle
On Thu, Jan 8, 2009 at 12:13 PM, Mike Castle wrote: > On Linux, I might try mounting a scratch partition with async, but I > don't yet know if that means ``I know what I'm doing, ignore what the > application tells you to do.'' Oh, and a few lines down it says def

Re: [Imdbpy-help] differences between http and sql results

2009-01-08 Thread Mike Castle
On Thu, Jan 8, 2009 at 12:13 PM, Mike Castle wrote: > > If one has enough ram, a ramdisk/tmpfs of some sort might be helpful > (I don't have enough swap configured to test at the moment). For the curious: On a somehwat wimpy Linux machine with 1G of ram, that's been busy als

[Imdbpy-help] http vs sql: articles in akas

2009-01-09 Thread Mike Castle
Here's an annoying one I just came across: (I finally turned my test loop into a function :-) #!/usr/bin/python2.5 import imdb i1 = imdb.IMDb('http') i2 = imdb.IMDb('sql', 'sqlite:/share/media/imdb/sql.db') test_title = 'The Motorcycle Diaries' test_year = '2004' def do_search(i, title, year

Re: [Imdbpy-help] http vs sql: articles in akas

2009-01-09 Thread Mike Castle
On Fri, Jan 9, 2009 at 3:14 PM, Mike Castle wrote: > > Diarios de motocicleta 2004 [u'Carnets de voyage::(France)', u'Die > Reise des jungen Che::(Germany)', u'The Motorcycle Diaries::(USA)', > u'Voyage \xe0 motocyclette::(France) (festival title)

Re: [Imdbpy-help] http vs sql: articles in akas

2009-01-10 Thread Mike Castle
On Sat, Jan 10, 2009 at 12:50 AM, Davide Alberani wrote: > There's nothing we can do, if the data is missing from the > plain text data files. > I assume that - for legal reasons - some info coming from certain > sources (maybe the studios themselves) can't be distributed that way. Ah. This is w

Re: [Imdbpy-help] http vs sql: articles in akas

2009-01-10 Thread Mike Castle
On Sat, Jan 10, 2009 at 12:45 AM, Davide Alberani wrote: > On Jan 10, Mike Castle wrote: >> But now I have to move that damned article around too?!? > > You can use the mighty functions provided by IMDbPY! ;-) > They are in the 'utils' module. Sweet. I will che

Re: [Imdbpy-help] differences between http and sql results

2009-01-10 Thread Mike Castle
On Sat, Jan 10, 2009 at 12:47 AM, Davide Alberani wrote: > On Jan 09, Mike Castle wrote: > >> For the curious: > [...] >> # TIME createIndexes() : 134 min, 24 sec. >> DONE! (in 424 minutes, 25 seconds) > > Very interesting; so I assume it's safe to wri

[Imdbpy-help] sqlite3.IntegrityError: aka_title.movie_id may not be NULL

2009-01-12 Thread Mike Castle
EXECUTING "COMMIT;"... DONE! EXECUTING "BEFORE_AKAMOVIES_TODB:BEGIN TRANSACTION;"... EXECUTING "BEGIN TRANSACTION;"... DONE! Traceback (most recent call last): File "./imdbpy2sql.py", line 2136, in run() File "./imdbpy2sql.py", line 2040, in run doAkaTitles() File "./imdbpy2sql.py",

[Imdbpy-help] Timing SQLITE creation

2009-01-13 Thread Mike Castle
On Thu, Jan 8, 2009 at 10:45 PM, Mike Castle wrote: > On Thu, Jan 8, 2009 at 12:13 PM, Mike Castle wrote: >> >> If one has enough ram, a ramdisk/tmpfs of some sort might be helpful >> (I don't have enough swap configured to test at the moment). > > For the curiou

Re: [Imdbpy-help] Timing SQLITE creation

2009-01-13 Thread Mike Castle
I also just tested with PRAGMA journal_mode = OFF; and, while it did prevent sqlite from making and removing journal files all the time, it turns out that it didn't make any significant difference. The measurement was actually 5 minutes slow, considering the variability of the machine, probably me

[Imdbpy-help] TV series with unknown episode numbers

2010-06-24 Thread Mike Castle
First, look at this page, specifically the ``unknown'' season: http://www.imdb.com/title/tt0169455/episodes#season-unknown Now, run the following code (sys.path adjusted as necessary): #!/usr/bin/python import sys sys.path.insert(0, '/home/nexus/workspace/imdbpy') import imdb print imdb.VERSION

Re: [Imdbpy-help] TV series with unknown episode numbers

2010-06-26 Thread Mike Castle
On Sat, Jun 26, 2010 at 1:01 AM, Davide Alberani wrote: > In fact it's not a great improvement: to tell the truth, the numer > of the episode should not be computed in the _build_episode function (but > right now I don't have time for a better solution, and anyway... this > one works :-) I concur

[Imdbpy-help] problems with _some_ akas

2012-06-11 Thread Mike Castle
I don't think this is related to the recent changes in IMDB, and happens with both 4.8.2-2 code on my Debian box and recent head. I think it's just dealing with flaky data in a funny manner. >>> i = imdb.IMDb() >>> m = i.get_movie('0059346') >>> for aka in m.get('akas', []): ... print aka ...

Re: [Imdbpy-help] TV series with unknown episode numbers

2013-02-08 Thread Mike Castle
So this problem has returned. I hadn't been actually using imdbpy in a while, but I think this is a result of the rewrite that happened 2012-01-29 This seems to fix it. I'm trying to make the code a bit more resilient, but I'm not sure it needs it. so you can probably simplify as needed. The

Re: [Imdbpy-help] Cinemagoer 2023.05.01

2023-05-02 Thread Mike Castle
woo \o/ On Mon, May 1, 2023 at 10:37 AM Davide Alberani wrote: > Hi all, > We have just released version 2023.05.01 of Cinemagoer. > > It mostly consists of many little fixes to the parsers. > The complete changelog: > https://github.com/cinemagoer/cinemagoer/blob/master/CHANGELOG.txt > > As us