Class: Mysql::Result

Inherits:
ResultBase show all
Defined in:
lib/vendor/mysql.rb

Overview

Result set for simple query

Instance Attribute Summary

Attributes inherited from ResultBase

#fields

Instance Method Summary collapse

Methods inherited from ResultBase

#data_seek, #each, #each_hash, #fetch, #fetch_hash, #free, #row_seek, #row_tell, #size

Methods included from Enumerable

#sum

Constructor Details

#initialize(fields, protocol = nil) ⇒ Result

Returns a new instance of Result.

Parameters:



710
711
712
713
714
715
 
# File 'lib/vendor/mysql.rb', line 710

def initialize(fields, protocol=nil)
  super fields
  return unless protocol
  @records = protocol.retr_all_records fields
  fields.each{|f| f.result = self}  # for calculating max_field
end

Instance Method Details

#calculate_field_max_length ⇒ Object

calculate max_length of all fields



719
720
721
722
723
724
725
726
727
728
729
730
 
# File 'lib/vendor/mysql.rb', line 719

def calculate_field_max_length
  max_length = Array.new(@fields.size, 0)
  @records.each_with_index do |rec, i|
    rec = @records[i] = rec.to_a if rec.is_a? RawRecord
    max_length.each_index do |i|
      max_length[i] = rec[i].length if rec[i] && rec[i].length > max_length[i]
    end
  end
  max_length.each_with_index do |len, i|
    @fields[i].max_length = len
  end
end

#fetch_field ⇒ Mysql::Field

Returns current field.

Returns:



733
734
735
736
737
738
 
# File 'lib/vendor/mysql.rb', line 733

def fetch_field
  return nil if @field_index >= @fields.length
  ret = @fields[@field_index]
  @field_index += 1
  ret
end

#fetch_field_direct(n) ⇒ Mysql::Field

Return specified field

Parameters:

  • n (Integer) —

    field index

Returns:

Raises:



757
758
759
760
 
# File 'lib/vendor/mysql.rb', line 757

def fetch_field_direct(n)
  raise ClientError, "invalid argument: #{n}" if n < 0 or n >= @fields.length
  @fields[n]
end

#fetch_fields ⇒ Array<Mysql::Field>

Returns all fields.

Returns:



763
764
765
 
# File 'lib/vendor/mysql.rb', line 763

def fetch_fields
  @fields
end

#fetch_lengths ⇒ Array<Integer>

Returns length of each fields.

Returns:

  • (Array<Integer>) —

    length of each fields



768
769
770
771
 
# File 'lib/vendor/mysql.rb', line 768

def fetch_lengths
  return nil unless @fetched_record
  @fetched_record.map{|c|c.nil? ? 0 : c.length}
end

#field_seek(n) ⇒ Integer

Set field position

Parameters:

  • n (Integer) —

    field index

Returns:

  • (Integer) —

    previous position



748
749
750
751
752
 
# File 'lib/vendor/mysql.rb', line 748

def field_seek(n)
  ret = @field_index
  @field_index = n
  ret
end

#field_tell ⇒ Integer

Returns current field position.

Returns:

  • (Integer) —

    current field position



741
742
743
 
# File 'lib/vendor/mysql.rb', line 741

def field_tell
  @field_index
end

#num_fields ⇒ Integer

Returns number of fields.

Returns:

  • (Integer) —

    number of fields



774
775
776
 
# File 'lib/vendor/mysql.rb', line 774

def num_fields
  @fields.size
end