On Mar 19, 2010, at 11:23 AM, 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.items())) > > With use_labels == True and fold_equivalents == False the above > solution does not work > because the join columns labels no more correspond to the originals > and then > to the table C columns labels. > > I am new to sqlalchemy. > Is there a better solution ? > Can I avoid fold_equivalents in this case?
can you point me to the SQL syntax for an INSERT into a JOIN ? > > Thanks! > > Marco Vaccari > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
