wpdb_activerecord
If you'd like to do it in Ruby instead, then this library might help with some of the boilerplate.
It's a wrapper for the WordPress database, using ActiveRecord, that gives you access to the WordPress database and all its content via a nice ORM.
Installation
gem "wpdb_activerecord"
gem "mysql2", "~> 0.3.0"
Usage
Post
WPDB::Post.all # Get all posts
@post = WPDB::Post.find(75)
@post.tags
@post.categories
@post.comments
@post.attachments # No matter what type
@post.revisions # versions
@post.postmetas # post meta values
@post.author # get user (WPDB::User)
Term
WPDB::Term.tag # get all tags
WPDB::Term.category # get all categories
@term = WPDB::Term.first
@term.posts # get all the term posts
User
@user = WPDB::User.find(25)
@user.posts
@user.comments
Advanced
Sometime we will custom the table name prefix (default is wp_) or inherit to use and redefine something.
You can define your yaml file to setup prefix and association class_name.
Put the config file named "wpdb_activerecord.yml" in config
Example:
# config/wpdb_config.yml
WPDB_PREFIX: "cgjbugpbs_" # the table of WPDB::Post is cgjbugpbs_posts, not wp_posts
WPDB_USER_CLASS: "WUser"
# models/w_user.rb
class WUser < WPDB::User
def hello
puts "world"
end
end
# usage
@author = WPDB::Post.find(25).author
@author.class_name # will get WUser, not WPDB::User
@author.hello # world
All setting attributes you can use:
- WPDB_PREFIX
- WPDB_COMMENT_CLASS
- WPDB_USER_CLASS
- WPDB_POST_CLASS
- WPDB_POSTMETA_CLASS
- WPDB_TERM_CLASS
- WPDB_TERM_RELATIONSHIP_CLASS
- WPDB_TERM_TAXONOMY_CLASS
Table Fields
wp_posts
WPDB::Post
- ID:integer
- post_author:integer
- post_date:datetime
- post_date_gmt:datetime
- post_content:text
- post_title:string
- post_excerpt:string
- post_status:varchar(20)
- post_password:varchar(20)
- post_name:varchar(200) (post slug)
- post_modified:datetime
- post_modified_gmt:datetime
- post_parent:integer
- guid:varchar(255)
- menu_order:integer
- post_type:varchar(20)
- post_mime_type:varchar(100)
- comment_count:integer
wp_postmeta
WPDB::Postmeta
- meta_id:integer
- post_id:integer
- meta_key:varchar(255)
- meta_value:text
wp_comments
WPDB::Comment
- comment_ID:integer
- comment_post_id:integer
- comment_author:varchar(255)
- comment_author_email:varchar(100)
- comment_author_url:varchar(200)
- comment_author_IP:varchar(100)
- comment_date:datetime
- comment_date_gmt:datetime
- comment_content:text
- comment_karma:integer
- comment_approved:varchar(20)
- comment_agent:varchar(255)
- comment_type:varchar(20)
- comment_parent:bigint(20)
- user_id:bigint(20)
wp_users
WPDB::User
- ID:integer
- user_login:varchar(60)
- user_pass:varchar(64)
- user_nicename:varchar(50)
- user_email:varchar(100)
- user_url:varchar(100)
- user_registered:datetime
- user_status:integer
- display_name:varchar(250)
wp_usermeta
WPDB::Usermeta
- umeta_id:integer
- user_id:integer
- meta_key:varchar(255)
- meta_value:text
wp_terms
WPDB::Term
- term_id:integer
- name:varchar(200)
- slug:varchar(200)
- term_group:integer
wp_term_taxonomy
WPDB::TermTaxonomy
- term_taxonomy_id:integer
- term_id:integer
- taxonomy:varchar(32)
- description:text
- parent:integer
- count:integer
wp_term_relationships
WPDB::TermRelationship
- object_id:integer
- term_taxonomy_id:integer
- term_order:integer
wp_options
WPDB::Option
- option_id:integer
- option_name:varchar(64)
- option_value:text
- autoload:varchar(20)