Re: [Imdbpy-help] AGAIN: sqlite3.ProgrammingError: You must not use 8-bit bytestrings

2011-01-24 Thread Petite Abeille
On Jan 24, 2011, at 12:28 AM, Luis wrote: > Maybe > there is some other connection for sqlobject that needs the > text_factory=str fix. Not sure if it's the right way, but I added the following: connectObject.text_factory = str at line 518 of bin/imdbpy2sql.py So now it looks like this (lin

Re: [Imdbpy-help] IMDb IDs aren't really necessary for names and titles

2011-03-29 Thread Petite Abeille
On Mar 29, 2011, at 7:13 AM, Michael Grier wrote: > curl -i -s "http://www.imdb.com/Name?Abraham%2C%20Peter%20%28III%29"; | > grep --color=never Location: | cut -d " " -f 2 | cut -d / -f 5 Nice :) Also you can use HEAD instead of GET (e.g. -I/--head in curl). Checking for a 302 would not hurt

Re: [Imdbpy-help] IMDb IDs aren't really necessary for names and titles

2011-03-31 Thread Petite Abeille
On Mar 31, 2011, at 6:23 AM, Michael Grier wrote: > Oh, and IMDb doesn't allow HEAD requests... you get a "405 Method not > allowed" or something like that. Right you are... no HEAD at IMDb... In any case, a search will properly redirect to an unique hit...the secret to happiness is to search

Re: [Imdbpy-help] imdbpy2sql 4.7 - invalid byte sequence for encoding "UTF8"

2011-04-17 Thread Petite Abeille
On Apr 13, 2011, at 8:46 AM, darklow wrote: > Ananlyzed error a bit more. Mostly these errors occur in Japanese actors > (actors.list), in filmography there apperars strange characters: Sounds like a character set encoding issue. Originally, something like actors.list is ISO-8859-1 encoded. IMD

Re: [Imdbpy-help] Quick Question

2013-03-10 Thread Petite Abeille
On Mar 10, 2013, at 1:28 PM, Davide Alberani wrote: > Well... it was not thought for this, but can be done. > You can use the imdbpy2sql.py script to put the plain text data files > into a database, and then with a normal query on the 'title' table you > can get the IDs of all the movies produce

Re: [Imdbpy-help] imdbpy2sql.py hangs

2013-09-16 Thread Petite Abeille
On Sep 16, 2013, at 7:55 PM, Sawyer Ward wrote: > It took 1281min Is that a typo? 1,281 minutes is over 21 hours… this is way excessive under any half-reasonable scenario... -- LIMITED TIME SALE - Full Year of Micro

Re: [Imdbpy-help] imdbpy2sql.py hangs

2013-09-17 Thread Petite Abeille
On Sep 16, 2013, at 8:20 PM, Sawyer Ward wrote: > No that is not a typo. I really don't get why it took so long, I run it > using my SSD. FWIW… on a feeble laptop, on an external usb drive, with sqlite and IMDbPY-4.9, for the September 6th dataset: real 212m41.025s user 131m57.357s sys