Contents

#
#--
# Ronin SQL - A Ronin library providing support for SQL related security
# tasks.
#
# Copyright (c) 2007-2008 Hal Brodigan (postmodern.mod3 at gmail.com)
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
#++
#

require 'ronin/code/sql/statement'

module Ronin
  module Code
    module SQL
      class Update < Statement

        def initialize(style,table=nil,set_data={},where_expr=nil,&block)
          @table = table
          @set_data = set_data
          @where_expr = where_expr

          super(style,&block)
        end

        def table(value)
          @table = value
          return self
        end

        def set(data)
          @set_data = data
          return self
        end

        def where(expr)
          @where_expr = expr
          return self
        end

        def compile
          set_values = "#{keyword_set} "+@set_data.map { |name,value|
      "#{name} = #{quote_string(value)}"
          }.join(', ')

          return compile_expr(keyword_update,@table,set_values,where?)
        end

        protected

        keyword :update
        keyword :where
        keyword :set

        def where?
          compile_expr(keyword_where,@where_expr) if @where_expr
        end

      end
    end
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
ronin-sql-0.1.0	lib/ronin/code/sql/update.rb
ronin-sql-0.1.1	lib/ronin/code/sql/update.rb