[sqlalchemy] Re: Modifiable collections on a many-to-many, same table mapping

2009-03-05 Thread Kevin Dangoor
t;three ways to > persist the same thing", leading to errors like that. OK, I can see this case being a bit complex. I just wanted to be sure I wasn't missing some mechanism for handling it. Thanks! Kevin -- Kevin Dangoor work: http://labs.mozilla.com/ email: k...@blazingthi

[sqlalchemy] Re: Database migrations using declarative

2009-03-05 Thread Kevin Dangoor
able__ When you create new columns, don't forget that you need to flip the column declaration around class Bar(Base): foo = Column(String) becomes foo = Column('foo', String) I'm using declarative with sqlalchemy-migrate just fine. Kevin -- Kevin Dango

[sqlalchemy] Modifiable collections on a many-to-many, same table mapping

2009-03-05 Thread Kevin Dangoor
nation column '%s' (or use a viewonly=True relation)." % (source_column, source_mapper, dest_column)) sqlalchemy.orm.exc.UnmappedColumnError: Can't execute sync rule for source column 'users.id'; mapper 'Mapper|Connection|connections' does not map this column.

[sqlalchemy] Re: parent/child relationship: what am I doing wrong?

2009-02-01 Thread Kevin Dangoor
s/05/mappers.html#adjacency-list-relationships > ? > By default, as the doc says, one-to-many is assumed. You want the > backref (parentdir) to be a scalar, so you probably have to specify > "remote_side". > Ruben > > > -- Kevin Dangoor email: k...@b

[sqlalchemy] Re: parent/child relationship: what am I doing wrong?

2009-02-01 Thread Kevin Dangoor
On Sun, Feb 1, 2009 at 10:17 AM, Eric Ongerth wrote: > > Kevin, the default behavior is for relations to be represented by > lists. If what you want is a tree structure where a directory can > only have a single parent, you would use backref=backref("parentdir", > uselist=False). Or at least th

[sqlalchemy] parent/child relationship: what am I doing wrong?

2009-02-01 Thread Kevin Dangoor
on a newly created Directory instance, both subdirs and parentdir are lists when I would expect parentdir to just be null or a Directory. This is using SQLAlchemy 0.5.2. I do hope there's something obvious that I missed... Thanks, Kevin --

[sqlalchemy] Re: MySQL String with no length broken as of r4705

2008-09-17 Thread Kevin Dangoor
On Sep 17, 4:21 pm, Michael Bayer <[EMAIL PROTECTED]> wrote: > some databases do accept VARCHAR without a length. But the code I was looking at is in mysql.py, so I was assuming this is where database-specific behavior goes. >  Also, its a valid   > use case to use String/VARCHAR by itself witho

[sqlalchemy] Re: MySQL String with no length broken as of r4705

2008-09-17 Thread Kevin Dangoor
Hi Mike, On Sep 17, 1:53 pm, Michael Bayer <[EMAIL PROTECTED]> wrote: > We've strictified the difference between String() and Text() in 0.5   > such that String() doesn't implicitly go from VARCHAR to TEXT without   > a length.   So in your case you want to use UnicodeText. OK, I guess that's re

[sqlalchemy] MySQL String with no length broken as of r4705

2008-09-17 Thread Kevin Dangoor
I have some of my columns defined as Column('foo', Unicode). This worked fine with MySQL, but a change made in r4705 appears to have broken this. Prior to 4705, that would generate a TEXT column in the create table. This was switched to just VARCHAR. MySQL 5.0.45 does not accept VARCHAR without a

[sqlalchemy] Re: Object-oriented engine?

2007-03-22 Thread Kevin Dangoor
valid thought? Versant doesn't support SQL, most of its > calls are graph navigation. getchild(), getparent(), getattr() etc... > > Is this worth pursuing, and has anyone tried it? > > Thanks > > > > -- Kevin Dangoor TurboGears email: [EMAIL PROTE

[sqlalchemy] Re: python ORM

2006-12-11 Thread Kevin Dangoor
On 12/11/06, Michael Bayer <[EMAIL PROTECTED]> wrote: > Hibernate is pretty SQL oriented as well, and as I use it every day for > my job I can say it has little to nothing over SA...harder to > configure, more complex and less consistent behavior with regards to > relationships, poorer database su

[sqlalchemy] Re: python ORM

2006-12-11 Thread Kevin Dangoor
On 12/9/06, flyingfrog <[EMAIL PROTECTED]> wrote: > SQLAlchemy lets you define separately DB code and python classes, but > then you hve a real duplication. And to use database functionalities > you always need to access session objects or connections, making > sql-like queries. And i don't want t

[sqlalchemy] Re: SQLAlchemy at pycon 07

2006-12-01 Thread Kevin Dangoor
On Dec 1, 2006, at 7:27 PM, Michael Bayer wrote: > I am going to make it there. I despise airplanes but if i dont go its > like chucking the last two years ! i want to meet all you guys. That's great! I know how rough plane travel can be for some folks. It'll be good to meet you there! Kevin

[sqlalchemy] Re: SQLAlchemy at pycon 07

2006-12-01 Thread Kevin Dangoor
On Nov 29, 2006, at 3:26 PM, Jonathan Ellis wrote: > > My proposal for a talk on SqlSoup was accepted. It looks like someone > else's talk on SA itself was accepted too. Woot! :) Mark Ramm's SA talk was accepted. Very cool to see SA well- represented at PyCon! Hey, Mike! Are you going to mak