Hello All,
I hope the rewrites are going well, if there is any menial work that could
be done let me know.
I don;t know if I have a good concept of the internals to start rewriting
anything for the current tasks at hand.
I keep on experiencing an error when setting up the text files on a MySQL
db.
It seems to want to load 100000 movies in at a time.
Any ideas?
>>>>>>>>>>>>>>>>>>>>>>>>
* FLUSHING MoviesCache...
SCANNING movies: Celebration (1981) (TV) (movieID: 100001)
SCANNING movies: City of Wax (1934) (movieID: 110001)
SCANNING movies: Covjek ispod stola (2009) (movieID: 120001)
SCANNING movies: Dark Spirits (2008) (movieID: 130001)
SCANNING movies: Depth Solitude (1997) (movieID: 140001)
SCANNING movies: Die Huronen (1921) (movieID: 150001)
SCANNING movies: Dorothy Stratten: The Untold Story (1985) (V) (movieID:
160001)
SCANNING movies: Eichmann Trial (1961) (TV) (movieID: 170001)
SCANNING movies: Employee Dang (2003) (movieID: 180001)
SCANNING movies: Ezra's Epitaph (2006) (V) (movieID: 190001)
* FLUSHING MoviesCache...
* TOO MANY DATA (100000 items in MoviesCache), recursion: 1
* SPLITTING (run 1 of 2), recursion: 1
* FLUSHING MoviesCache...
Traceback (most recent call last):
File "C:\python26\scripts\imdbpy2sql.py", line 5, in <module>
pkg_resources.run_script('imdbpy==4.5.1', 'imdbpy2sql.py')
File "C:\Python26\lib\site-packages\pkg_resources.py", line 489, in
run_script
self.require(requires)[0].run_script(script_name, ns)
File "C:\Python26\lib\site-packages\pkg_resources.py", line 1207, in
run_scrip
t
execfile(script_filename, namespace, namespace)
File
"c:\python26\lib\site-packages\imdbpy-4.5.1-py2.6-win32.egg\EGG-INFO\scri
pts\imdbpy2sql.py", line 2911, in <module>
run()
File
"c:\python26\lib\site-packages\imdbpy-4.5.1-py2.6-win32.egg\EGG-INFO\scri
pts\imdbpy2sql.py", line 2747, in run
readMovieList()
File
"c:\python26\lib\site-packages\imdbpy-4.5.1-py2.6-win32.egg\EGG-INFO\scri
pts\imdbpy2sql.py", line 1460, in readMovieList
mid = CACHE_MID.addUnique(title, yearData)
File
"c:\python26\lib\site-packages\imdbpy-4.5.1-py2.6-win32.egg\EGG-INFO\scri
pts\imdbpy2sql.py", line 1068, in addUnique
else: return self.add(key, miscData)
File
"c:\python26\lib\site-packages\imdbpy-4.5.1-py2.6-win32.egg\EGG-INFO\scri
pts\imdbpy2sql.py", line 947, in add
self[key] = c
File
"c:\python26\lib\site-packages\imdbpy-4.5.1-py2.6-win32.egg\EGG-INFO\scri
pts\imdbpy2sql.py", line 857, in __setitem__
self.flush()
File
"c:\python26\lib\site-packages\imdbpy-4.5.1-py2.6-win32.egg\EGG-INFO\scri
pts\imdbpy2sql.py", line 909, in flush
self.flush(quiet=quiet, _recursionLevel=_recursionLevel)
File
"c:\python26\lib\site-packages\imdbpy-4.5.1-py2.6-win32.egg\EGG-INFO\scri
pts\imdbpy2sql.py", line 880, in flush
self._toDB(quiet)
File
"c:\python26\lib\site-packages\imdbpy-4.5.1-py2.6-win32.egg\EGG-INFO\scri
pts\imdbpy2sql.py", line 1052, in _toDB
self._runCommand(l)
File
"c:\python26\lib\site-packages\imdbpy-4.5.1-py2.6-win32.egg\EGG-INFO\scri
pts\imdbpy2sql.py", line 1056, in _runCommand
CURS.executemany(self.sqlstr, self.converter(dataList))
File "C:\Python26\lib\site-packages\MySQLdb\cursors.py", line 205, in
executem
any
r = r + self.execute(query, a)
File "C:\Python26\lib\site-packages\MySQLdb\cursors.py", line 173, in
execute
self.errorhandler(self, exc, value)
File "C:\Python26\lib\site-packages\MySQLdb\connections.py", line 36, in
defau
lterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.IntegrityError: (1062, "Duplicate entry '143880' for key
'PRIM
ARY'")
JRubino
------------------------------------------------------------------------------
Achieve Improved Network Security with IP and DNS Reputation.
Defend against bad network traffic, including botnets, malware,
phishing sites, and compromised hosts - saving your company time,
money, and embarrassment. Learn More!
http://p.sf.net/sfu/hpdev2dev-nov
_______________________________________________
Imdbpy-devel mailing list
Imdbpy-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
