Hi,
I'm new to Elixir and tried to follow the Diving-in Tutorial (http://
elixir.ematia.de/trac/wiki/TutorialDivingIn).
All went fine, until I tried to execute the command "create_all()". I
got the following bunch of output:
++++++++++++++++++++++++++
>>> create_all()
2009-03-10 20:26:19,312 INFO sqlalchemy.engine.base.Engine.0x...9570
PRAGMA table_info("model_movie")
2009-03-10 20:26:19,328 INFO sqlalchemy.engine.base.Engine.0x...9570
()
2009-03-10 20:26:19,328 INFO sqlalchemy.engine.base.Engine.0x...9570
ROLLBACK
Traceback (most recent call last):
File "<pyshell#4>", line 1, in <module>
create_all()
File "build\bdist.win32\egg\elixir\__init__.py", line 127, in
create_all
File "D:\WinApps\Programming\Python26\Lib\site-packages\sqlalchemy
\schema.py", line 1765, in create_all
bind.create(self, checkfirst=checkfirst, tables=tables)
File "D:\WinApps\Programming\Python26\Lib\site-packages\sqlalchemy
\engine\base.py", line 1129, in create
self._run_visitor(self.dialect.schemagenerator, entity,
connection=connection, **kwargs)
File "D:\WinApps\Programming\Python26\Lib\site-packages\sqlalchemy
\engine\base.py", line 1158, in _run_visitor
visitorcallable(self.dialect, conn, **kwargs).traverse(element)
File "D:\WinApps\Programming\Python26\Lib\site-packages\sqlalchemy
\sql\visitors.py", line 89, in traverse
return traverse(obj, self.__traverse_options__,
self._visitor_dict)
File "D:\WinApps\Programming\Python26\Lib\site-packages\sqlalchemy
\sql\visitors.py", line 200, in traverse
return traverse_using(iterate(obj, opts), obj, visitors)
File "D:\WinApps\Programming\Python26\Lib\site-packages\sqlalchemy
\sql\visitors.py", line 194, in traverse_using
meth(target)
File "D:\WinApps\Programming\Python26\Lib\site-packages\sqlalchemy
\sql\compiler.py", line 795, in visit_metadata
collection = [t for t in sql_util.sort_tables(tables) if
self._can_create(t)]
File "D:\WinApps\Programming\Python26\Lib\site-packages\sqlalchemy
\sql\compiler.py", line 788, in _can_create
return not self.checkfirst or not self.dialect.has_table
(self.connection, table.name, schema=table.schema)
File "D:\WinApps\Programming\Python26\Lib\site-packages\sqlalchemy
\databases\sqlite.py", line 443, in has_table
row = cursor.fetchone()
File "D:\WinApps\Programming\Python26\Lib\site-packages\sqlalchemy
\engine\base.py", line 1668, in fetchone
self.connection._handle_dbapi_exception(e, None, None,
self.cursor, self.context)
File "D:\WinApps\Programming\Python26\Lib\site-packages\sqlalchemy
\engine\base.py", line 931, in _handle_dbapi_exception
raise exc.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
ProgrammingError: (ProgrammingError) Cannot operate on a closed
cursor. None None
++++++++++++++++++
pysqllite is installed, as prescribed in the article. I've used the
Windows binary for python 2.6.
Any idea what I'm missing here? Would really like to start using this
database system for my applications, but I have to be able to "get
from the ground"...
Best rgds,
--Geert
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"SQLElixir" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlelixir?hl=en
-~----------~----~----~----~------~----~------~--~---
