I found that you need to call eng.dispose() to disconnect from the database before deleting the file.
Not sure about what is happening under the covers at that point, but it seems to work. -- Mike Conley On Fri, May 15, 2009 at 1:35 PM, RusPython <[email protected]>wrote: > > Hi guys, > > I have next code: > > import os > from sqlalchemy import * > from sqlalchemy.orm import * > > metadata = MetaData() > engine = create_engine('sqlite:///temp.db', convert_unicode=True) > metadata.bind = engine > > branches = Table('branches', metadata, > Column('id', Integer, primary_key=True), > Column('name', String(100)), > Column('email', String(100)), > Column('pos', Integer), > ) > > class Branch(object): pass > > mapBranch = mapper(Branch, branches) > > metadata.create_all() > session = create_session() > > # Here I fill database > > session.close() > > # Here I want arch dbfile and then delete it > os.remove('.\temp.db') > > # And I get error :( > > Traceback (most recent call last): > File "G:\project\python\tgk\trunk\src\mail\viewer.py", line 37, in > onClick > converter.convert(branch) > File "G:\project\python\tgk\trunk\src\db\converter.py", line 44, in > convert > os.remove(paths.temp) > WindowsError: [Error 32] The process cannot access the file: 'G:\ > \project > \\python\\tgk\\trunk\\src\\temp.db' > > How I can close connection with db file? > > Thanks, > Viktor > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" 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/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
