[sqlalchemy] Sqlautocode 0.7 released

2011-08-20 Thread percious
I released sqlautocode 0.7 today. This release was based on feedback from a few users, and adds support for sqlalchemy 0.7 and python 2.7. Here's a rundown of the feature changes since the last release: 0.7 (8-20-2011) SA 0.7 Support Python 2.7 Support Declarative

[sqlalchemy] Sprox 0.6.6 Released

2009-09-24 Thread percious
I lied, we found a few more ways to tweak sprox 0.6. (www.sprox.org) Thanks to Alessandro Molina (amol) for providing a speed enhancement when rendering dictionaries. Thanks to Temmu Yli-Elsila for his help in debugging the preventCache problem with DojoGrid in IE. Sprox will now work

[sqlalchemy] Postgres, reflection, and search_path

2008-06-20 Thread percious
Hey guys, I have a postgres database which requires me to set search_path to 'my_db' before I can get a proper table listing. I have written a schema for this database, but what I would like to do is compare my schema against the existing database, and make sure that all my tables and columns

[sqlalchemy] Re: Postgres, reflection, and search_path

2008-06-20 Thread percious
, 2:47 pm, Michael Bayer [EMAIL PROTECTED] wrote: its likely a connection specific thing.  do it on a Connection, then   send that as bind to metadata.reflect(). On Jun 20, 2008, at 4:45 PM, percious wrote: Hey guys, I have a postgres database which requires me to setsearch_pathto

[sqlalchemy] Re: Postgres, reflection, and search_path

2008-06-20 Thread percious
Nevermind, that got it. Thanks mike for your ordinarily punctual responses. BTW, anyone have a need for a db schema comparison tool? I thought there was one out there, but I was dubious about the source. cheers. -chris On Jun 20, 3:06 pm, percious [EMAIL PROTECTED] wrote: like

[sqlalchemy] Re: Postgres, reflection, and search_path

2008-06-20 Thread percious
that also works. Thanks mike. On Jun 20, 3:13 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Jun 20, 2008, at 5:06 PM, percious wrote: like this?    from sqlalchemy import MetaData, create_engine    metadata = MetaData()    engine = create_engine('postgres://[EMAIL PROTECTED]/Target

[sqlalchemy] Summer Python Internship - National Renewable Energy Laboratory

2008-04-24 Thread percious
Student Intern – Scientific Computing Group 5900 5900-7259 A student internship is available in the National Renewable Energy Laboratory's (NREL) Scientific Computing Group. NREL is the nation's primary laboratory for research, development and deployment of renewable energy and energy

[sqlalchemy] sqlalchemy.org looks down

2008-03-24 Thread percious
Any reason for this? -chris --~--~-~--~~~---~--~~ 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 [EMAIL

[sqlalchemy] Re: sqlalchemy.org looks down

2008-03-24 Thread percious
unresponsive. restart fixed it. looking at the logs now On Mar 24, 2008, at 12:48 PM, percious wrote: Any reason for this? -chris --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post

[sqlalchemy] Re: Dynamically adding MapperExtension

2007-03-13 Thread percious
) ... do stuff ... def helloworld(): print hello world extension.func = helloworld ... do stuff ... percious wrote: question. Lets say I have a series of table definitions, and a series of objects linked to the tables with a bunch of mappers. First question: Is there a way

[sqlalchemy] Re: Ping

2007-03-06 Thread percious
Problem is, using turbogears I don't really have access to the pool_recycle without some horrible monkey patch. FYI, my ping seems to work, so I'm going with that for now. cheers. -percious On Mar 5, 1:00 pm, Sébastien LELONG [EMAIL PROTECTED] securities.fr wrote: I need to ping the Mysql

[sqlalchemy] Ping

2007-03-05 Thread percious
I need to ping the Mysql database to keep it alive. Is there a simple way to do this with SA? -chris --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

[sqlalchemy] SQA failing on table creation

2007-03-01 Thread percious
Here is the dump: [EMAIL PROTECTED] percious]$ tg-admin sql create Creating tables at mysql://percious:[EMAIL PROTECTED]:3306/percious Traceback (most recent call last): File /home2/percious/bin/tg-admin, line 7, in ? sys.exit( File /home2/percious/lib/python2.4/TurboGears-1.0-py2.4.egg

[sqlalchemy] drop_all not working for me

2007-02-12 Thread percious
See test case: from turbogears import config from turbogears.database import metadata from turbogears import database from sqlalchemy import Table, Column, Integer, Unicode import sqlalchemy.orm config.update({sqlalchemy.dburi:sqlite:///:memory:}) database.bind_meta_data() Table('t_table',

[sqlalchemy] Re: drop_all not working for me

2007-02-12 Thread percious
, percious [EMAIL PROTECTED] wrote: See test case: from turbogears import config from turbogears.database import metadata from turbogears import database from sqlalchemy import Table, Column, Integer, Unicode import sqlalchemy.orm config.update({sqlalchemy.dburi:sqlite:///:memory

[sqlalchemy] Dynamically adding MapperExtension

2007-02-09 Thread percious
question. Lets say I have a series of table definitions, and a series of objects linked to the tables with a bunch of mappers. First question: Is there a way to get from the table definitions in the metadata to the Mapper? Second question: If I create a MapperExtension, can I then link it to

[sqlalchemy] Multiple joins and cascading delete

2007-01-18 Thread percious
Consider the following model: class Comment(object): def __init__(self, text): self.text = text CommentTable=Table('Comment', metadata, Column('id', Integer, primary_key=True), Column('text', Unicode(512)), )

[sqlalchemy] Re: Multiple mappers for Many to Many Relationships

2007-01-14 Thread percious
Thanks Mike. Works fine. I'll buy you a beer at Pycon if I see you there... Please let me know if we can fix my original post like I emailed you about. -chris --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups