Re: [sqlalchemy] automated mapping - sqlalchemy or sqlsoup or something else

2013-07-26 Thread Kevin Horn
FYI: There's also sqlacodegen: https://pypi.python.org/pypi/sqlacodegen/


On Thu, Jul 25, 2013 at 11:29 AM, Michael Bayer mike...@zzzcomputing.comwrote:

 check out sqlautocode: https://code.google.com/p/sqlautocode/


 On Jul 25, 2013, at 12:19 PM, Henning Sprang henning.spr...@gmail.com
 wrote:

 Hi,

 To automatically be able to access a large legacy database whithout having
 to write manual mapping code, I'd like to have a tool with automated
 mapping support.

 There seem to be two tools that offer something like this - sqlsoup and
 sqlasagna, but both seem not very actively supported - no commits since
 more than a year, sqlasagna has partly wrong documentation (saying its
 available in pypi, while it isn't, one example), so I'm not sure if I
 really should use one of them and if I'm not missing something.

 I am aware of the automated mapping functionality I can get with
 declarative_base and DeferredReflection, but then I still have to write
 classes for all tables plus define relationships. I might be able to script
 that myself (to make it work automated at runtime, or as a class generator
 as it is avialable in DjangoORM), but still, I'm asking if there is another
 tool I didn't find yet.

 Thanks,
 Henning

 --
 You received this message because you are subscribed to the Google Groups
 sqlalchemy group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to sqlalchemy+unsubscr...@googlegroups.com.
 To post to this group, send email to sqlalchemy@googlegroups.com.
 Visit this group at http://groups.google.com/group/sqlalchemy.
 For more options, visit https://groups.google.com/groups/opt_out.




  --
 You received this message because you are subscribed to the Google Groups
 sqlalchemy group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to sqlalchemy+unsubscr...@googlegroups.com.
 To post to this group, send email to sqlalchemy@googlegroups.com.
 Visit this group at http://groups.google.com/group/sqlalchemy.
 For more options, visit https://groups.google.com/groups/opt_out.






-- 
--
Kevin Horn

-- 
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.




[sqlalchemy] automated mapping - sqlalchemy or sqlsoup or something else

2013-07-25 Thread Henning Sprang
Hi,

To automatically be able to access a large legacy database whithout having 
to write manual mapping code, I'd like to have a tool with automated 
mapping support.

There seem to be two tools that offer something like this - sqlsoup and 
sqlasagna, but both seem not very actively supported - no commits since 
more than a year, sqlasagna has partly wrong documentation (saying its 
available in pypi, while it isn't, one example), so I'm not sure if I 
really should use one of them and if I'm not missing something.

I am aware of the automated mapping functionality I can get with 
declarative_base and DeferredReflection, but then I still have to write 
classes for all tables plus define relationships. I might be able to script 
that myself (to make it work automated at runtime, or as a class generator 
as it is avialable in DjangoORM), but still, I'm asking if there is another 
tool I didn't find yet.

Thanks,
Henning

-- 
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.




Re: [sqlalchemy] automated mapping - sqlalchemy or sqlsoup or something else

2013-07-25 Thread Michael Bayer
check out sqlautocode: https://code.google.com/p/sqlautocode/


On Jul 25, 2013, at 12:19 PM, Henning Sprang henning.spr...@gmail.com wrote:

 Hi,
 
 To automatically be able to access a large legacy database whithout having to 
 write manual mapping code, I'd like to have a tool with automated mapping 
 support.
 
 There seem to be two tools that offer something like this - sqlsoup and 
 sqlasagna, but both seem not very actively supported - no commits since more 
 than a year, sqlasagna has partly wrong documentation (saying its available 
 in pypi, while it isn't, one example), so I'm not sure if I really should use 
 one of them and if I'm not missing something.
 
 I am aware of the automated mapping functionality I can get with 
 declarative_base and DeferredReflection, but then I still have to write 
 classes for all tables plus define relationships. I might be able to script 
 that myself (to make it work automated at runtime, or as a class generator as 
 it is avialable in DjangoORM), but still, I'm asking if there is another tool 
 I didn't find yet.
 
 Thanks,
 Henning
 
 -- 
 You received this message because you are subscribed to the Google Groups 
 sqlalchemy group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to sqlalchemy+unsubscr...@googlegroups.com.
 To post to this group, send email to sqlalchemy@googlegroups.com.
 Visit this group at http://groups.google.com/group/sqlalchemy.
 For more options, visit https://groups.google.com/groups/opt_out.
  
  

-- 
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.