open cursors logic failing with autoload tables ?

(original reporter: anonymous) need to test this program out:

import pymssql
from sqlalchemy import *

from   logging import *

basicConfig(level=DEBUG)

class sqlalchemy:

    def __init__(self):
        self.engine = create_engine("mssql://pl:btn@29.9.29.112: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)

since its throwing "too many open cursors". commented out the check in pool.py for now.

Comments (1)