Contents

require 'user_query'

class EntriesController < ApplicationController
  def index
    list
    render :action => 'list'
  end

  # GETs should be safe (see http://www.w3.org/2001/tag/doc/whenToUseGet.html)
  verify :method => :post, :only => [ :destroy, :create, :update ],
         :redirect_to => { :action => :list }

  def list
    @query = UserQuery::Parameters.new(params[:query] ||= { })

    @q_sql = UserQuery::Schema.
      new(:table => Entry,
          :field => [
                     [ :amount, :money ] # override AR::B introspection
                    ]
          ).sql(@query)

    # $stderr.puts "q_sql = #{@q_sql.inspect}"
    @entry_pages, @entries = 
      paginate :entries, 
               :per_page => 10,  # Malformed format string
               :conditions => [ @q_sql ? @q_sql.gsub(/%/, '%%') : '1' ],
               :order => 'id'

  end

  def show
    @entry = Entry.find(params[:id])
  end

  def new
    @entry = Entry.new
  end

  def create
    @entry = Entry.new(params[:entry])
    if @entry.save
      flash[:notice] = 'Entry was successfully created.'
      redirect_to :action => 'list'
    else
      render :action => 'new'
    end
  end

  def edit
    @entry = Entry.find(params[:id])
  end

  def update
    @entry = Entry.find(params[:id])
    if @entry.update_attributes(params[:entry])
      flash[:notice] = 'Entry was successfully updated.'
      redirect_to :action => 'show', :id => @entry
    else
      render :action => 'edit'
    end
  end

  def destroy
    Entry.find(params[:id]).destroy
    redirect_to :action => 'list'
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
user_query-0.1.0	examples/userqueryex/app/controllers/entries_controller.rb