Re: [sqlalchemy] Locked file when trying to copy

[Jeroen Dierckx]

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.

[sqlalchemy] Locked file when trying to copy

[Jeroen Dierckx]

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.