Thanks a lot Lance, that did the trick. best regards, jeroen
On Mon, Aug 16, 2010 at 10:18 PM, Lance Edgar <lance.ed...@gmail.com> wrote: > See > http://groups.google.com/group/sqlalchemy/browse_thread/thread/aa9c753384532e6c/8d070ff7208494b1 > > The solution though I believe is just: > > from sqlalchemy import create_engine > from sqlalchemy.pool import NullPool > > to_engine = create_engine('sqlite:///%s' % temp_file_name, > poolclass=NullPool) > > Lance > > > On Mon, 2010-08-16 at 21:08 +0200, Jeroen Dierckx wrote: > > Hello all, > > I am trying to export data from a MySQL database to a sqlite database > using SqlAlchemy. > I am using 2 engines for each database ( from and to ). > This is the part that creates the sqlite engine: > > to_engine = create_engine(u'sqlite:///%s'%temp_file_name) > to_meta_data = MetaData() > to_meta_data.bind = to_engine > > Then i move the tables from one engine to the other. > I close the connections; > to_connection.close() > > > Finally i want to copy the sqlite file to its permanent location using > shutil.move. But here it goes wrong; the file seems to be locked > still: > shutil.move(temp_file_name, self._filename) > > I get this error (might not be verbatim): > WindowsError: [Error 32] The process does not have access to the file > because the file is being used by another process. > > Can anyone give direction as to why the file might still be locked and > how to avoid it? > > Thanks in advance, > Best regards, > > Jeroen > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.