Class: KnjDB_java_mysql_result

Inherits:
Object
  • Object
show all
Defined in:
lib/knj/knjdb/drivers/mysql/knjdb_mysql.rb

Overview

This class controls the result for the Java-MySQL-driver.

Instance Method Summary collapse

Constructor Details

#initialize(knjdb, opts, result) ⇒ KnjDB_java_mysql_result

Constructor. This should not be called manually.



548
549
550
551
552
553
554
555
556
557
558
559
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql.rb', line 548

def initialize(knjdb, opts, result)
  @knjdb = knjdb
  @result = result
  
  if !opts.key?(:result) or opts[:result] == "hash"
    @as_hash = true
  elsif opts[:result] == "array"
    @as_hash = false
  else
    raise "Unknown type of result: '#{opts[:result]}'."
  end
end

Instance Method Details

#each ⇒ Object 



600
601
602
603
604
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql.rb', line 600

def each
  while data = self.fetch
    yield(data)
  end
end

#fetch ⇒ Object 



573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql.rb', line 573

def fetch
  return false if !@result
  self.read_meta if !@keys
  status = @result.next
  
  if !status
    @result = nil
    @keys = nil
    @count = nil
    return false
  end
  
  if @as_hash
    ret = {}
    1.upto(@keys.length) do |count|
      ret[@keys[count - 1]] = @result.string(count)
    end
  else
    ret = []
    1.upto(@count) do |count|
      ret << @result.string(count)
    end
  end
  
  return ret
end

#read_meta ⇒ Object

Reads meta-data about the query like keys and count.



562
563
564
565
566
567
568
569
570
571
 
# File 'lib/knj/knjdb/drivers/mysql/knjdb_mysql.rb', line 562

def read_meta
  @result.before_first
  meta = @result.meta_data
  @count = meta.column_count
  
  @keys = []
  1.upto(@count) do |count|
    @keys << meta.column_label(count).to_sym
  end
end