A couple more items from last week:
Help: acts_as_soft_deletable doesn’t seem to work with STI. The plugin has been out for a while and it’s surprising that nobody has had a problem with this before now.
Q: What’s a good way to bulk insert a bunch of joined-up models? A: insert into a view. MySQL has updatable views now. This is also a great trick to use in Oracle.
I’d love to see a blog post on using MySQL updatable views to bulk insert into a rails app.
June 7, 2009 at 6:54 pm
If I read correctly, that MySQL documentation says that only one table can be updated in an updateable view. It seems to be more for restricting columns that can be viewed/updated in one table, rather than inserting “joined-up models” into multiple tables.
June 7, 2009 at 7:53 pm