Use the contents of a WordPress database in your Rails app

jazzido (Manuel Aristarán) — Mon, 30 Jan 2006 04:10:02 GMT

These two models can be used to access the posts and associated comments of a WordPress database.



class WpBlogComment < ActiveRecord::Base



  # if wordpress tables live in a different database (i.e. 'wordpress') change the following

  # line to set_table_name "wordpress.wp_comments"

  # don't forget to give the db user permissions to access the wordpress db

  set_table_name "wp_comments"

  set_primary_key "comment_ID"



  belongs_to :post , :class_name => "WpBlogPost", :foreign_key => "comment_post_ID"



  validates_presence_of :comment_post_ID, :comment_author, :comment_content, :comment_author_email

  

  def validate_on_create

    if WpBlogPost.find(comment_post_ID).comment_status != 'open'

      errors.add_to_base('Sorry, comments are closed for this post')

    end

  end



end



class WpBlogPost < ActiveRecord::Base



  set_table_name "wp_posts"

  set_primary_key "ID"



  has_many :comments, :class_name => "WpBlogComment", :foreign_key => "comment_post_ID"



  def self.find_by_permalink(year, month, day, title)

    find(:first, 

         :conditions => ["YEAR(post_date) = ? AND MONTH(post_date) = ? AND DAYOFMONTH(post_date) = ? AND post_name = ?", year.to_i, month.to_i, day.to_i, title])

  end

end

On-the-fly thumbnailer method for a Rails 'Photo' controller

jazzido (Manuel Aristarán) — Fri, 08 Apr 2005 06:47:20 GMT



require 'RMagick'



class PhotoController < ApplicationController



[...snip...]



    def render_resized_image

                @photo=Photo.find(@params["id"])



                maxw = @params["width"] != nil ? @params["width"].to_i : 90

                maxh = @params["height"] != nil ? @params["height"].to_i : 90

                aspectratio = maxw.to_f / maxh.to_f





                pic = Magick::Image.from_blob(@photo.image)[0]





                picw = pic.columns

                pich = pic.rows

                picratio = picw.to_f / pich.to_f



                if picratio > aspectratio then

                        scaleratio = maxw.to_f / picw

                else

                        scaleratio = maxh.to_f / pich

                end



                #breakpoint



                thumb = pic.resize(scaleratio)



                @response.headers["Content-type"]=@photo.mime

    end

end

Requires RMagick

Based on Thumbnailer in Ruby and RMagick

DZone Snippets: Jazzido's Code Snippets

Use the contents of a WordPress database in your Rails app

On-the-fly thumbnailer method for a Rails 'Photo' controller