Using Elixir, how can I get the table object of a self-referential relationship to perform inserts on?

Question

I'm using Elixir with SQLite and I'd like to perform multiple inserts as per the docs:

http://www.sqlalchemy.org/docs/05/sqlexpression.html#executing-multiple-statements

However, my ManyToMany relationship is self-referential and I can't figure out where to get the insert() object from. Can anyone help?

Thanks!

Answer 1

It might be easy if you just stick with SQL Alchemy's built in Declarative style instead of using Elixir as much of what it does is now doable in there. Then you can follow the example here: Many to Many

Then look very closely at the code where a post is added and then keywords related to that post are added. You get multiple inserts done for you into the relator table - the one that maintains the many to many relationship:

>>> post.keywords.append(Keyword('wendy'))
>>> post.keywords.append(Keyword('firstpost'))