Hi,
At the end of imdbpy2sql.py script, i get this error:
# TIME TOTAL TIME TO INSERT/WRITE DATA : 253min, 55sec (wall) 93min,
7sec (user) 15min, 0sec (system)
building database indexes (this may take a while)
# TIME createIndexes() : 26min, 33sec (wall) 0min, 0sec (user) 0min,
0sec (system)
adding foreign keys (this may take a while)
Traceback (most recent call last):
File "/usr/bin/imdbpy2sql.py", line 5, in <module>
pkg_resources.run_script('IMDbPY==4.8.2', 'imdbpy2sql.py')
File "/usr/lib64/python2.6/site-packages/pkg_resources.py", line 500,
in run_script
self.require(requires)[0].run_script(script_name, ns)
File "/usr/lib64/python2.6/site-packages/pkg_resources.py", line
1236, in run_script
execfile(script_filename, namespace, namespace)
File
"/usr/lib64/python2.6/site-packages/IMDbPY-4.8.2-py2.6-linux-x86_64.egg/EGG-INFO/scripts/imdbpy2sql.py",
line 2958, in <module>
run()
File
"/usr/lib64/python2.6/site-packages/IMDbPY-4.8.2-py2.6-linux-x86_64.egg/EGG-INFO/scripts/imdbpy2sql.py",
line 2910, in run
buildIndexesAndFK()
File
"/usr/lib64/python2.6/site-packages/IMDbPY-4.8.2-py2.6-linux-x86_64.egg/EGG-INFO/scripts/imdbpy2sql.py",
line 2722, in buildIndexesAndFK
createForeignKeys(DB_TABLES)
File
"/usr/lib64/python2.6/site-packages/IMDbPY-4.8.2-py2.6-linux-x86_64.egg/imdb/parser/sql/dbschema.py",
line 460, in createForeignKeys
table.addForeignKeys(mapTables, ifNotExists)
File
"/usr/lib64/python2.6/site-packages/IMDbPY-4.8.2-py2.6-linux-x86_64.egg/imdb/parser/sql/objectadapter.py",
line 133, in addForeignKeys
newcls._connection.query(fkQuery)
File "/usr/lib64/python2.6/site-packages/sqlobject/dbconnection.py",
line 414, in query
return self._runWithConnection(self._query, s)
File "/usr/lib64/python2.6/site-packages/sqlobject/dbconnection.py",
line 327, in _runWithConnection
val = meth(conn, *args)
File "/usr/lib64/python2.6/site-packages/sqlobject/dbconnection.py",
line 411, in _query
self._executeRetry(conn, conn.cursor(), s)
File "/usr/lib64/python2.6/site-packages/sqlobject/dbconnection.py",
line 406, in _executeRetry
return cursor.execute(query)
psycopg2.IntegrityError: insert or update on table "movie_info" violates
foreign key constraint "movie_id_exists"
DETAIL: Key (movie_id)=(2077921) is not present in table "title".
When i look in movie_info table for id 2077921, i have this:
id; movie_id; info_type; info; note
"2077921";1559911;96;"Hallo - Sie haben Ihre Frau vergessen. In:
Illustrierte Film-Bühne, Film-Bühne G.m.b.H., No. 310, 1949, Pgs. 4";""
In table title, i have no line with id=2077921 but i have a line with id
=1559911 (the number from movie_info's movie_id. The line seems to match :)
"1559911";"Hallo - Sie haben Ihre Frau
vergessen";"";1;1949;;"H4215";;;;"";"8500761c703695245a02335ec6e4e139"
The data files were downloaded on december 13th and i use imdbpy 4.8.2.
If you need any more informations, i can provide them
------------------------------------------------------------------------------
Cloud Computing - Latest Buzzword or a Glimpse of the Future?
This paper surveys cloud computing today: What are the benefits?
Why are businesses embracing it? What are its payoffs and pitfalls?
http://www.accelacomm.com/jaw/sdnl/114/51425149/
_______________________________________________
Imdbpy-help mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/imdbpy-help
