The code I am running exists in conf/__init__.py and I am simply calling it like so:
<!-- ~/Documents/DataProc/Development/pharmat_email tbrannon --> python
Python 2.4.2 (#1, Sep 14 2006, 05:23:55)
[GCC 4.0.1 (Apple Computer, Inc. build 5363)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> import conf
>>> sa = conf.sqlalchemy()
DEBUG:root:Engine <sqlalchemy.engine.base.ComposedSQLEngine object at 0x147d870>
2006-09-26 02:10:01,124 INFO sqlalchemy.pool.QueuePool.0x147d610 Created new connection <pymssql.pymssqlCnx instance at 0x1494a58>
INFO:sqlalchemy.pool.QueuePool.0x147d610:Created new connection <pymssql.pymssqlCnx instance at 0x1494a58>
2006-09-26 02:10:01,124 INFO sqlalchemy.pool.QueuePool.0x147d610 Connection <pymssql.pymssqlCnx instance at 0x1494a58> checked out from pool
INFO:sqlalchemy.pool.QueuePool.0x147d610:Connection <pymssql.pymssqlCnx instance at 0x1494a58> checked out from pool
2006-09-26 02:10:01,137 INFO sqlalchemy.engine.base.ComposedSQLEngine.0x147d870 SELECT [COLUMNS_cb46].[TABLE_SCHEMA], [COLUMNS_cb46].[TABLE_NAME], [COLUMNS_cb46].[COLUMN_NAME], [COLUMNS_cb46].[IS_NULLABLE], [COLUMNS_cb46].[DATA_TYPE], [COLUMNS_cb46].[ORDINAL_POSITION], [COLUMNS_cb46].[CHARACTER_MAXIMUM_LENGTH], [COLUMNS_cb46].[NUMERIC_PRECISION], [COLUMNS_cb46].[NUMERIC_SCALE], [COLUMNS_cb46].[COLUMN_DEFAULT]
FROM [INFORMATION_SCHEMA].[COLUMNS] AS [COLUMNS_cb46]
WHERE [COLUMNS_cb46].[TABLE_NAME] = %(COLUMNS_TABLE_NAME)s AND [COLUMNS_cb46].[TABLE_SCHEMA] = %(COLUMNS_TABLE_SCHEMA)s ORDER BY [COLUMNS_cb46].[ORDINAL_POSITION]
INFO:sqlalchemy.engine.base.ComposedSQLEngine.0x147d870:SELECT [COLUMNS_cb46].[TABLE_SCHEMA], [COLUMNS_cb46].[TABLE_NAME], [COLUMNS_cb46].[COLUMN_NAME], [COLUMNS_cb46].[IS_NULLABLE], [COLUMNS_cb46].[DATA_TYPE], [COLUMNS_cb46].[ORDINAL_POSITION], [COLUMNS_cb46].[CHARACTER_MAXIMUM_LENGTH], [COLUMNS_cb46].[NUMERIC_PRECISION], [COLUMNS_cb46].[NUMERIC_SCALE], [COLUMNS_cb46].[COLUMN_DEFAULT]
FROM [INFORMATION_SCHEMA].[COLUMNS] AS [COLUMNS_cb46]
WHERE [COLUMNS_cb46].[TABLE_NAME] = %(COLUMNS_TABLE_NAME)s AND [COLUMNS_cb46].[TABLE_SCHEMA] = %(COLUMNS_TABLE_SCHEMA)s ORDER BY [COLUMNS_cb46].[ORDINAL_POSITION]
2006-09-26 02:10:01,151 INFO sqlalchemy.engine.base.ComposedSQLEngine.0x147d870 {'COLUMNS_TABLE_NAME': 'Users', 'COLUMNS_TABLE_SCHEMA': 'dbo'}
INFO:sqlalchemy.engine.base.ComposedSQLEngine.0x147d870:{'COLUMNS_TABLE_NAME ': 'Users', 'COLUMNS_TABLE_SCHEMA': 'dbo'}
Traceback (most recent call last):
File "<stdin>", line 1, in ?
File "conf/__init__.py", line 34, in __init__
self.table = tables(self.metadata )
File "conf/__init__.py", line 38, in __init__
self.users = Table('Users', metadata, autoload=True)
File "build/bdist.darwin-8.7.1-i386/egg/sqlalchemy/schema.py", line 138, in __call__
File "build/bdist.darwin-8.7.1-i386/egg/sqlalchemy/engine/base.py", line 498, in reflecttable
File "build/bdist.darwin-8.7.1-i386/egg/sqlalchemy/engine/base.py", line 232, in close
File "build/bdist.darwin- 8.7.1-i386/egg/sqlalchemy/pool.py", line 205, in close
File "build/bdist.darwin-8.7.1-i386/egg/sqlalchemy/pool.py", line 210, in _close
sqlalchemy.exceptions.InvalidRequestError: This connection still has 1 open cursors
>>>
=================== here's the source code ==============================
import pymssql
from sqlalchemy import *
from logging import *
basicConfig(level=DEBUG)
class sqlalchemy:
def __init__(self):
self.engine = create_engine("mssql://pl:[EMAIL PROTECTED]:433/Phmr", echo=True)
self.metadata = BoundMetaData(self.engine)
debug("Engine %s" % self.engine)
self.table = tables(self.metadata)
class tables:
def __init__(self, metadata):
self.users = Table('Users', metadata, autoload=True) #### SA dies on this line
self.user_searches = Table('UserSearches', metadata, autoload=True)
self.customers = Table('Customers', metadata, autoload=True)
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
