[sqlalchemy] Turbogears 2.1 breaks with SQLAlchemy 0.7beta

2011-02-14 Thread Jorge Vargas
Hello guys, Just an FYI. Due to the change of API in SA0.7 (http://www.sqlalchemy.org/trac/wiki/07Migration#Thesqlalchemy.exceptionsaliasinsys.modulesisremoved) to be exact. The current release of TG is broken, as several packages it uses for example http://dpaste.com/416049/ use the old import.

[sqlalchemy] [OT] new to macos any db viewer you recommend?

2009-03-13 Thread Jorge Vargas
Hello, Will anyone recommend me a nice tool to view/analyze my databases? I normally use the shell and SA but I'm starting a project with an existing db (and heavy on db procedures and trigger) so I'll like to have some sort of GUI to simplify my learning curve. After some searching I found

[sqlalchemy] Re: SQLAlchemy 0.5 Released

2009-01-07 Thread Jorge Vargas
On Tue, Jan 6, 2009 at 3:42 PM, Michael Bayer mike...@zzzcomputing.com wrote: Hello list - I am pleased to announce the release of SQLAlchemy 0.5.0, the first official release in the 0.5 series. This series has been in the making since the Pycon 2008 sprints, where we first began

[sqlalchemy] Re: ANN: Sprox First Beta Release

2008-12-29 Thread Jorge Vargas
On Mon, Dec 29, 2008 at 4:26 AM, percious perciou...@gmail.com wrote: Sprox is ready for it's first beta release. Now, this release is 0.5b4 because of sprox's heritage, and therefore it's level of maturity. Sprox has a new website up at www.sprox.org. This site is of course generated with

[sqlalchemy] Re: how to build a model package?

2008-12-23 Thread Jorge Vargas
On Sat, Dec 20, 2008 at 9:34 AM, Etienne Robillard robillard.etie...@gmail.com wrote: On Wed, 17 Dec 2008 02:48:08 -0600 Jorge Vargas jorge.var...@gmail.com wrote: Hello, I have been trying to figure out an alternative to the following setup. The problem I'm trying to solve is fixing

[sqlalchemy] Re: 0.5 release schedule

2008-12-23 Thread Jorge Vargas
I just launched last week a site running on 0.5rc4, given the quality of SA releases you shouldn't fear it's not final tag. It's really stable the only thing that could stop you from deploying is a hard policy on what goes to prod, by your organization/company/etc. On Thu, Dec 18, 2008 at 7:54

[sqlalchemy] Re: iterate_properties missing in 0.5?

2008-12-12 Thread Jorge Vargas
On Thu, Dec 11, 2008 at 6:21 PM, Michael Bayer mike...@zzzcomputing.com wrote: On Dec 11, 2008, at 7:08 PM, Jorge Vargas wrote: Hi, has the behavior here http://www.sqlalchemy.org/trac/wiki/FAQ#Whatsthebestwaytofigureoutwhichattributesarecolumnsgivenaclass changed in 0.5? I'm trying

[sqlalchemy] iterate_properties missing in 0.5?

2008-12-11 Thread Jorge Vargas
Hi, has the behavior here http://www.sqlalchemy.org/trac/wiki/FAQ#Whatsthebestwaytofigureoutwhichattributesarecolumnsgivenaclass changed in 0.5? I'm trying that and getting AttributeError: iterate_properties this is my code, so far: klass = model.User def add_user(): obj = klass()

[sqlalchemy] How can I reuse the string syntax in my own code?

2008-12-06 Thread Jorge Vargas
Hi, I have been working on a little project to transform excel docs (actually them saved as csv files) into SQLAlchemy objects. Of course this is tailored for my own database which I need to import but I have been splitting it into api more and more and eventually plan to release it as some

[sqlalchemy] Re: how to query across all fields in an object?

2008-10-14 Thread Jorge Vargas
) #not a relation or p.use_list == False )) #or a singular reference ] these above are just for example, do your own filtering ciao svil On Tuesday 14 October 2008 20:26:16 Jorge Vargas wrote: Hi, I'm trying to implement a simple search field in my application and I

[sqlalchemy] Re: Two foreignkey's to the same table, rendering a join error.

2008-10-06 Thread Jorge Vargas
On Sun, Oct 5, 2008 at 8:56 AM, Michael Bayer [EMAIL PROTECTED] wrote: you can use strings with Python in them when you use declarative even with args like primaryjoin, so you could say things like: class Policy(DeclarativeBase): __tablename__ = 'policy' policy_state =

[sqlalchemy] Re: Two foreignkey's to the same table, rendering a join error.

2008-10-04 Thread Jorge Vargas
at 9:13 AM, Michael Bayer [EMAIL PROTECTED] wrote: Information on primaryjoin and secondaryjoin is available at: http://www.sqlalchemy.org/docs/05/mappers.html#advdatamapping_relation_customjoin On Sep 25, 2008, at 8:18 PM, Jorge Vargas wrote: hello I'm having a bit of troubles

[sqlalchemy] Two foreignkey's to the same table, rendering a join error.

2008-09-25 Thread Jorge Vargas
hello I'm having a bit of troubles with the following case. http://paste.turbogears.org/paste/8177 This is the error I'm getting. Now I know it has to do with SA not being able to know to which field to map state.id, but how do I fix it? Specify a 'primaryjoin' expression. If this is a

[sqlalchemy] Re: Elixir 0.6.1 released!

2008-08-19 Thread Jorge Vargas
On Mon, Aug 18, 2008 at 11:37 PM, Jose Galvez [EMAIL PROTECTED] wrote: I'm not trying to be an ass, but what are the advantages to using Elixer well you did sound like one :) the first thing is that declarative is very new to SA (0.4.something, and only mainstream in 0.5), while elixir has

[sqlalchemy] How to load a complex data set into an SA aware object?

2008-02-14 Thread Jorge Vargas
Hi, I'm working on a project where I got several read only tables that are dependent on a third-party, I got several vainlla SQL queries to get the data I need of them and I was wondering which will be the best way to load them up into SA. The queries themselfs are quite complex with several

[sqlalchemy] Re: Microsoft Jet Database Engine

2006-11-05 Thread Jorge Vargas
On 11/4/06, Rick Morrison [EMAIL PROTECTED] wrote: Wow, Jet? There's a blast from the past. I would be amazed if you could get 100% of the unit tests to pass, as some of Jet's SQL syntax can vary quite a bit from ANSI standards. Did you use an ODBC connector, DAO or ADO? A general-purpose

[sqlalchemy] Re: CheckConstraint

2006-10-27 Thread Jorge Vargas
why not just include formencode support? On 10/27/06, Michael Bayer [EMAIL PROTECTED] wrote: you mean a python-level constraint. id definitely build this as just a callable that takes the whole insert/update criterion and just returns true or false. all the django-niceties are