Hi, I am attempting to import imdb plain text file using imdbpy2sql.py using
the following command on ubuntu precise and am getting aKeyError: 'gender' .
Can anyone assist?
sye@dbuddy:~/imdbpy/bin$ sudo python imdbpy2sql.py -d /home/sye/database/ -u
mysql://rootuser:rootpassword@localhost/imdb
NOTICE: IF you're using InnoDB tables, data insertion can
be very slow; you can switch to MyISAM tables - forcing it
with the --mysql-force-myisam option - OR use the
--mysql-innodb command line option, but DON'T USE these if
you're already working on MyISAM tables, because it will
force MySQL to use InnoDB, and performances will be poor.
Traceback (most recent call last):
File "imdbpy2sql.py", line 2589, in <module>
CACHE_PID = PersonsCache()
File "imdbpy2sql.py", line 1141, in __init__
'namePcodeNf', 'surnamePcode', 'md5sum'])
File "imdbpy2sql.py", line 638, in createSQLstr
colNames.append(colName(table, col))
File "imdbpy2sql.py", line 583, in colName
return table.sqlmeta.columns[column].dbName
KeyError: 'gender'
Thanks Sye.
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Imdbpy-help mailing list
Imdbpy-help@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-help