I would like to change SA to support the embedded version of Firebird SQL.
I am close but the process does not terminate correctly (i.e. I have to kill it), so I am obviously missing something. I made the following change to firebird.py (SA 0.4.0 final): def create_connect_args(self, url): opts = url.translate_connect_args(username='user') if opts.get('port'): opts['host'] = "%s/%s" % (opts['host'], opts['port']) del opts['port'] opts.update(url.query) print opts print opts['host'] if opts['host'] == 'embedded': del opts['host'] print opts type_conv = opts.pop('type_conv', self.type_conv) Then running the following: import sqlalchemy as sa import sqlalchemy.orm as sao import model as db import utils database = u'C:\\Dev\\twcb\\Data\\twcb3.fdb' host = 'embedded' fileurl = str(database.replace('\\', '/')) url = 'firebird://USERNAME:[EMAIL PROTECTED]/%s' % (host, fileurl) dburl = sa.engine.url.make_url(url) engine = sa.create_engine(dburl, encoding='utf8', echo=False) Session = sao.sessionmaker(autoflush=True, transactional=True) Session.configure(bind=engine) session = Session() dbItemConsumption = session.query(db.Consumption).load(63) print dbItemConsumption.consumptionid print dbItemConsumption.consumedvalue print dbItemConsumption.updated session.close() Gives me the correct output, i.e.: {'host': 'embedded', 'password': 'pw', 'user': 'USERNAME', 'database': 'C:/Dev/twcb/Data/twcb3.fdb'} embedded {'password': 'pw', 'user': 'USERNAME', 'database': 'C:/Dev/twcb/Data/twcb3.fdb'} 63 7.5 2007-11-09 However the process hangs and I have to manually kill it. Can anyone help me pinpoint what else needs to be changed? If this works correctly would a patch be accepted? Best regards Werner --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---