for example see
copyall.py and copydata.py in
http://dbcook.svn.sourceforge.net/viewvc/dbcook/trunk/dbcook/misc/metadata/
On Thursday 02 April 2009 18:24:07 Maxim Khitrov wrote:
> On Tue, Mar 31, 2009 at 4:20 PM, Yassen Damyanov
<yassen....@gmail.com> wrote:
> > On Mar 31, 2009, Maxim Khitrov <mkhit...@gmail.com> wrote:
> >> I should also mention that I'm
> >> using Python 2.6 on Windows. The latest stable MySQL-Python
> >> extension doesn't support 2.6, and there doesn't seem to be a
> >> test version available for Windows.
> >
> > The 1.2.2 Windows version of mysql-python should work flawlessly
> > under Python 2.6. (I haven't tested that however, my Python is
> > 2.5.) Y.
>
> Yes, you're right. I searched through the forums and found an
> installation package for 2.6 that someone else put together.
>
> If using SQLAlchemy to create these dump files directly is not
> possible, what about using reflection to load the schema for a
> given database, recreating that schema in a temporary database,
> loading required data, and then generating the SQL dump?
>
> I can do the first part of that like so:
>
> engine =
> create_engine('mysql://root:<password>@localhost/caffeine_gum2')
> meta = MetaData()
> meta.reflect(bind=engine)
>
> Once I have the metadata, how can I create a temporary database and
> reload the table structure there? I suppose I'll need to use some
> other tool for generating the dump once the data is inserted, but
> that's fine. As long as I'm not modifying the live data I'll be
> happy.
>
> - Max
>
>
--~--~---------~--~----~------------~-------~--~----~
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
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
