Dynamic Models and WordPress MU

Hi,

WordPress is a PHP-based blogging engine. The MU version supports
multiple blogs in the same database (as opposed to just one in the
basic WordPress app) I’m looking at writing some Rails-based admin
modules to interact with WordPress MU.

WordPress MU creates a separate set of tables for each blog. It does
this by using a master wp_blogs table and for each blog it creates a
set of tables named like:

wp_nn_posts
wp_nn_comments

The “nn” is the record id from the wp_blogs tables. So blog id of 1
generates:

wp_1_posts
wp_1_comments

What would be the best way to reference these models through
ActiveRecord?

Would it be as simple as creating 1 base set of models and then using
Model.table_name = “wp_1_posts” to point to the right tables when the
admin module is accessed? Is the table_name attribute safe to play
with in a multi-user environment? Is another way better suited to
this kind of access?

There are more tables than indicated above, I’m trying to keep this
post short :slight_smile: We’re looking at potentially hosting 100’s of blogs so
I don’t think we want to create a distinct set of models for each.

Thanks for any advice,

Shawn

You received this message because you are subscribed to the Google
Groups “Ruby on Rails: Talk” group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.