Class: Mysql::Result

Inherits:
ResultBase show all
Defined in:
lib/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

Constructor Details

#initialize(fields, protocol = nil) ⇒ Result

Returns a new instance of Result.

Parameters:



721
722
723
724
725
726
 
# File 'lib/mysql.rb', line 721

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



730
731
732
733
734
735
736
737
738
739
740
741
 
# File 'lib/mysql.rb', line 730

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:



744
745
746
747
748
749
 
# File 'lib/mysql.rb', line 744

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:



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

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:



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

def fetch_fields
  @fields
end

#fetch_lengths ⇒ Array<Integer>

Returns length of each fields.

Returns:

  • (Array<Integer>) —

    length of each fields



779
780
781
782
 
# File 'lib/mysql.rb', line 779

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



759
760
761
762
763
 
# File 'lib/mysql.rb', line 759

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

#field_tell ⇒ Integer

Returns current field position.

Returns:

  • (Integer) —

    current field position



752
753
754
 
# File 'lib/mysql.rb', line 752

def field_tell
  @field_index
end

#num_fields ⇒ Integer

Returns number of fields.

Returns:

  • (Integer) —

    number of fields



785
786
787
 
# File 'lib/mysql.rb', line 785

def num_fields
  @fields.size
end