require "delegate"

# The DBI::Row class is a delegate of Array, rather than a subclass, because
# there are times when it should act like an Array, and others when it should
# act like a Hash (and still others where it should act like String, Regexp,
# etc).  It also needs to store metadata about the row, such as
# column data type and index information, that users can then access.
#
module DBI
   class Row < DelegateClass(Array)
      attr_reader :column_names

      # DBI::Row.new(columns, size_or_array=nil)
      #
      # Returns a new DBI::Row object using +columns+.  The +size_or_array+
      # argument may either be an Integer or an Array.  If it is not provided,
      # it defaults to the length of +columns+.
      #
      # DBI::Row is a delegate of the Array class, so all of the Array
      # instance methods are available to your DBI::Row object (keeping in
      # mind that initialize, [], and []= have been explicitly overridden).
      #
      def initialize(columns, size_or_array=nil)
         size_or_array ||= columns.size 

         case size_or_array
            when Integer
               @arr = Array.new(size_or_array)
            when Array
               @arr = size_or_array
            else
               raise TypeError, "parameter must be either Integer or Array"
         end

         # The '@column_map' is used to map column names to integer values so
         # that users can reference row values by name or number.

         @column_map   = {}
         @column_names = columns
         columns.each_with_index { |c,i| @column_map[c] = i }
         super(@arr)
      end

      # Replaces the contents of @arr with +new_values+
      def set_values(new_values)
         @arr.replace(new_values)
      end
      
      # Yields a column value by name (rather than index), along with the
      # column name itself.
      def each_with_name
         @arr.each_with_index do |v, i|
            yield v, @column_names[i]
         end 
      end
      
      # Returns the Row object as a hash
      def to_h
         hash = {}
         each_with_name{ |v, n| hash[n] = v}
         hash
      end
      
      # Create a new row with 'new_values', reusing the field name hash.
      def clone_with(new_values)    
         Row.new(@column_names, new_values)
      end

      alias field_names column_names

      # Retrieve a value by index (rather than name).
      #
      # Deprecated.  Since Row delegates to Array, just use Row#at.
      def by_index(index)
         @arr[index]
      end
    
      # Value of the field named +field_name+ or nil if not found.
      def by_field(field_name)
         begin
            @arr[@column_map[field_name.to_s]]
         rescue TypeError
            nil
         end
      end
 
      # Row#[]
      #
      # row[int]
      # row[array]
      # row[regexp]
      # row[arg, arg]
      # row[arg, arg, ...]
      #
      # Sample: Row.new(["first","last","age"], ["Daniel", "Berger", "36"])
      #
      # Retrieves row elements.  Exactly what it retrieves depends on the
      # kind and number of arguments used.
      #
      # Zero arguments will raise an ArgumentError.
      #
      # One argument will return a single result.  This can be a String,
      # Symbol, Integer, Range or Regexp and the appropriate result will
      # be returned.  Strings, Symbols and Regexps act like hash lookups,
      # while Integers and Ranges act like Array index lookups.
      #
      # Two arguments will act like the second form of Array#[], i.e it takes
      # two integers, with the first number the starting point and the second
      # number the length, and returns an array of values.
      #
      # If three or more arguments are provided, an array of results is
      # returned.  The behavior for each argument is that of a single argument,
      # i.e. Strings, Symbols, and Regexps act like hash lookups, while
      # Integers and Ranges act like Array index lookups.
      # 
      # If no results are found, or an unhandled type is passed, then nil
      # (or a nil element) is returned.
      #
      def [](*args)
         begin
            case args.length
               when 0
                  err = "wrong # of arguments(#{args.size} for at least 1)"
                  raise ArgumentError, err
               when 1
                  case args[0]
                     when Array
                        args[0].collect { |e| self[e] }
                     when Regexp
                        self[@column_names.grep(args[0])] 
                     else
                        @arr[conv_param(args[0])]
                  end
               # We explicitly check for a length of 2 in order to properly
               # simulate the second form of Array#[].
               when 2
                  @arr[conv_param(args[0]), conv_param(args[1])]
               else
                  results = []
                  args.flatten.each{ |arg|
                     case arg
                        when Integer
                           results.push(@arr[arg])
                        when Regexp
                           results.push(self[@column_names.grep(arg)])
                        else
                           results.push(self[conv_param(arg)])
                     end
                  }
                  results.flatten
            end
         rescue TypeError
            nil
         end
      end

      # Assign a value to a Row object by element.  You can assign using
      # a single element reference, or by using a start and length similar
      # to the second form of Array#[]=.
      #
      # row[0]     = "kirk"
      # row[:last] = "haines"
      # row[0, 2]  = "test" 
      #
      def []=(key, value_or_length, obj=nil)
         if obj
            @arr[conv_param(key), conv_param(value_or_length)] = obj
         else
            @arr[conv_param(key)] = value_or_length
         end
      end

      def clone
         clone_with(@arr.dup)
      end

      alias dup clone

      private

      # Simple helper method to grab the proper value from @column_map
      def conv_param(arg)
         case arg
            when String, Symbol
               @column_map[arg.to_s]
            when Range
               if arg.first.kind_of?(Symbol) || arg.first.kind_of?(String)
                  first = @column_map[arg.first.to_s]
                  last  = @column_map[arg.last.to_s]
               else
                  first = arg.first
                  last  = arg.last
               end

               if arg.exclude_end?
                  (first...last) 
               else
                  (first..last)
               end
            else
               arg
         end
      end
   end # class Row
end # module DBI