On Fri, 2010-11-26 at 15:41 -0500, Michael Bayer wrote:
> I wouldn't say its a "bug" since its intentional. But I'll grant the
> intention is up for debate. I've always considered usage of execute() to
> mean, you're going below the level of the ORM and would like to control the
> SQL intera
On Tue, 2010-11-30 at 11:52 -0500, Michael Bayer wrote:
> On Nov 30, 2010, at 11:13 AM, James Neethling wrote:
>
> > Hi all,
> >
> > We have a small function that helps us create a simple search query by
> > automatically joining on required relations if needed.
> >
> > For example, consider an
Hello,
I have this table:
class Region(rdb.Model):
"""Represents one region in the layout"""
rdb.metadata(metadata)
rdb.tablename("regions")
id = Column("id", Integer, primary_key=True)
title = Column("title", String(50))
..
channelId
ohhh, I'm out of words other than thank you for spotting it. I can't
believe how stupid I feel right now.
Mariano
Excerpts from Michael Bayer's message of Tue Nov 30 14:27:42 -0300 2010:
> your RegEvent mapper is against the wrong table, here is the correct code:
>
> from sqlalchemy import *
> f
your RegEvent mapper is against the wrong table, here is the correct code:
from sqlalchemy import *
from sqlalchemy.orm import *
metadata = MetaData()
regevent = Table('regevent', metadata,
Column('id', Unicode(200), primary_key=True),
Column('author', Unicode(200)
Excerpts from Michael Bayer's message of Tue Nov 30 13:50:26 -0300 2010:
> Nothing wrong with the mapping, except the "primaryjoin" is not needed. The
> cause is certainly the usage of "useexisting", which implies that these
> tables have already been created, and everything you are specifying
On Nov 30, 2010, at 11:13 AM, James Neethling wrote:
> Hi all,
>
> We have a small function that helps us create a simple search query by
> automatically joining on required relations if needed.
>
> For example, consider an employee ORM that has a 1:M relationship with
> addresses (for postal/p
Nothing wrong with the mapping, except the "primaryjoin" is not needed. The
cause is certainly the usage of "useexisting", which implies that these tables
have already been created, and everything you are specifying in the Table() is
ignored. I wouldn't use that flag.
On Nov 30, 2010, at
Hi all,
We have a small function that helps us create a simple search query by
automatically joining on required relations if needed.
For example, consider an employee ORM that has a 1:M relationship with
addresses (for postal/physical). We can do something like:
query = Employee().search('stree
Hi.
I'm trying to relate two tables with a one to many relationship (the
parent table has a composite primary key) but I'm getting a mapper
error. I found a recent message about this same problem but with
declarative base (which I don't use) and not sure why the suggestion
there didn't apply to my
Simple enough Blob is a binary type, not a character type. You need to
put binary data in there, so in python 2x that's str, ie encode it. Direct
Unicode support in sqla is via the string/Unicode types.
Sent from my iPhone
On Nov 29, 2010, at 8:43 PM, Warwick Prince wrote:
> Hi Michae
Hello,
I'm busy to update an application to the last SQLAlchemy version.
I have to following mapped object, with a relation:
orm.mapper(Image, table.images, properties = {
'owner' : orm.relationship(
Participant,
uselist = False
)
})
In previous version of SQLAlchemy I
12 matches
Mail list logo