Davide Alberani wrote:
> Seen; I've removed the checkfirst parameter on the dropTable call,
> if ibm_db is used.
> It's just a horrible work-around and I hope it doesn't break
> anything else. :-)
>
> By the way, is it safe to call dropTable() if the table doesn't
> exist, with ibm_db?
> If not, I assume we've to catch the raised exception, too. :-/
I think this is neccessary. I get an error (latest CVS version):
RUNNING imdbpy2sql.py
SAVING imdbID values for movies... SKIPPING: no data.
SAVING imdbID values for people... SKIPPING: no data.
SAVING imdbID values for characters... SKIPPING: no data.
SAVING imdbID values for companies... SKIPPING: no data.
DROPPING current database...
Traceback (most recent call last):
File "/home/selke/Desktop/imdb/IMDbPY/usr/bin/imdbpy2sql.py", line
2145, in <module>
run()
File "/home/selke/Desktop/imdb/IMDbPY/usr/bin/imdbpy2sql.py", line
2000, in run
dropTables(DB_TABLES)
File "/usr/lib64/python2.5/site-packages/imdb/parser/sql/dbschema.py",
line 309, in dropTables
File
"/usr/lib64/python2.5/site-packages/imdb/parser/sql/alchemyadapter.py",
line 281, in dropTable
File "/usr/lib/python2.5/site-packages/sqlalchemy/schema.py", line
375, in drop
self.metadata.drop_all(bind=bind, checkfirst=checkfirst, tables=[self])
File "/usr/lib/python2.5/site-packages/sqlalchemy/schema.py", line
1610, in drop_all
bind.drop(self, checkfirst=checkfirst, tables=tables)
File "/usr/lib/python2.5/site-packages/sqlalchemy/engine/base.py",
line 1144, in drop
self._run_visitor(self.dialect.schemadropper, entity,
connection=connection, **kwargs)
File "/usr/lib/python2.5/site-packages/sqlalchemy/engine/base.py",
line 1168, in _run_visitor
visitorcallable(self.dialect, conn, **kwargs).traverse(element)
File "/usr/lib/python2.5/site-packages/sqlalchemy/sql/visitors.py",
line 75, in traverse
return self._non_cloned_traversal(obj)
File "/usr/lib/python2.5/site-packages/sqlalchemy/sql/visitors.py",
line 134, in _non_cloned_traversal
self.traverse_single(target)
File "/usr/lib/python2.5/site-packages/sqlalchemy/sql/visitors.py",
line 35, in traverse_single
return meth(obj, **kwargs)
File "/usr/lib/python2.5/site-packages/sqlalchemy/sql/compiler.py",
line 936, in visit_metadata
self.traverse_single(table)
File "/usr/lib/python2.5/site-packages/sqlalchemy/sql/visitors.py",
line 35, in traverse_single
return meth(obj, **kwargs)
File "/usr/lib/python2.5/site-packages/sqlalchemy/sql/compiler.py",
line 963, in visit_table
self.execute()
File "/usr/lib/python2.5/site-packages/sqlalchemy/engine/base.py",
line 1794, in execute
return self.connection.execute(self.buffer.getvalue())
File "/usr/lib/python2.5/site-packages/sqlalchemy/engine/base.py",
line 844, in execute
return Connection.executors[c](self, object, multiparams, params)
File "/usr/lib/python2.5/site-packages/sqlalchemy/engine/base.py",
line 854, in _execute_text
self.__execute_raw(context)
File "/usr/lib/python2.5/site-packages/sqlalchemy/engine/base.py",
line 916, in __execute_raw
self._cursor_execute(context.cursor, context.statement,
context.parameters[0], context=context)
File "/usr/lib/python2.5/site-packages/sqlalchemy/engine/base.py",
line 960, in _cursor_execute
self._handle_dbapi_exception(e, statement, parameters, cursor)
File "/usr/lib/python2.5/site-packages/sqlalchemy/engine/base.py",
line 942, in _handle_dbapi_exception
raise exceptions.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
sqlalchemy.exceptions.ProgrammingError: (ProgrammingError)
ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI
Driver][DB2/LINUXX8664] SQL0204N "IMDB.PERSON_INFO" is an undefined
name. SQLSTATE=42704 SQLCODE=-204 '\nDROP TABLE person_info' {}
Joachim
--
M. Sc. Joachim Selke
Technische Universität Braunschweig, Institut für Informationssysteme
Mühlenpfordtstraße 23, 38106 Braunschweig, Germany
<http://www.l3s.uni-hannover.de/~selke>
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Imdbpy-devel mailing list
Imdbpy-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
