On Mar 22, 2010, at 4:09 AM, marco vaccari wrote:
> Sorry. I speak english in rare occasions.
>
> No.
> It is not "an insert into a join".
>
> The result of a join between tables A and B is the VALUES partial set
> for an insert into table C.
>
> sql = A.join(B).select(A.c.id == an_id, fold_eq
Sorry. I speak english in rare occasions.
No.
It is not "an insert into a join".
The result of a join between tables A and B is the VALUES partial set
for an insert into table C.
sql = A.join(B).select(A.c.id == an_id, fold_equivalents=True,
use_labels=False)
rec = sql.execute().fetchone()
do_so
Opsss!
dict(zip(record.keys(), record.items())
must be
dict(record.items())
On 19 Mar, 16:23, marco vaccari wrote:
> Consider 3 tables A,B,C
>
> A JOIN B ON A.id = B.id
> produce all the columns required for an insert into C.
>
> I can write:
> C.insert().values(dict(zip(record.keys(), record.
