we havent gotten around to supporting INSERT from a SELECT, as a
python-constructed SQL clause, as of yet. is there any reason you
cant just use a plain text() query for this ?
On Jul 13, 2006, at 9:46 AM, Ricky Iacovou wrote:
>
> Hi there.
>
> I'm moving some SQLObject code to SQLAlchemy, and I can't work out
> how to do
> something. I'm sure it's trivially simple, I just can't see
> anything like it
> in the documentation, and my trial-and-error approach hasn't worked
> so far.
>
> A bare-bones is described below:
>
> Assume two name<->id mapping tables and a single join table
> "ForeignKey"-ed to
> these:
>
> a = Table ( 'a',
> Column('id', Integer, primary_key=True),
> Column('name', String(256)))
>
> b = Table ( 'b',
> Column('id', Integer, primary_key=True),
> Column('name', String(256)))
>
> ab = Table ( 'ab',
> Column('a_id', Integer, ForeignKey ( "a.id" )),
> Column('b_id', Integer, ForeignKey ( "b.id" )))
>
> Now assume I am given two *name* values, and these are drawn from a
> and b, and
> I want to insert a row into ab containing the two id values. In
> plain SQL, I
> would do this:
>
> insert into ab ( a_id, b_id )
> select a.id, b.id from a, b where a.name = "foo" and b.name = "bar"
>
> In SQLObject I suspect this isn't even possible: retrieving the row
> objects
> using a byName() lookup will simply perform SELECTs. However, I'm
> keen to
> find a more efficient way of doing this since I'd like to insert
> multiple
> rows on one leg of the SELECT, like this:
>
> insert into ab ( a_id, b_id )
> select a.id, b.id from a, b where a.name = "foo" and b.name in
> ( "bar", "baz", ... )
>
> Can a kind Alchemist please prod me in the right direction?
>
> Thanks,
>
> Ricky
>
>
>
> ----------------------------------------------------------------------
> ---
> Using Tomcat but need to do more? Need to support web services,
> security?
> Get stuff done quickly with pre-integrated technology to make your
> job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache
> Geronimo
> http://sel.as-us.falkag.net/sel?
> cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Sqlalchemy-users mailing list
> Sqlalchemy-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
