seki/sqlite3-util.rb

## sqlite3-util.rb
class SQLite3::Database
  def statement(s)
    if @cache.nil?
      @cache = Hash.new { |h, k| h[k] = self.prepare(k) }
    end
    @cache[s]
  end
end

class SQLite3::Statement
  def get_first_row(*bind_vars)
    execute(*bind_vars).first
  end

  def get_first_value(*bind_vars)
    execute(*bind_vars).each { |row| return row[0] }
    nil
  end
end
	class SQLite3::Database
	def statement(s)
	if @cache.nil?
	@cache = Hash.new { \|h, k\| h[k] = self.prepare(k) }
	end
	@cache[s]
	end
	end

	class SQLite3::Statement
	def get_first_row(*bind_vars)
	execute(*bind_vars).first
	end

	def get_first_value(*bind_vars)
	execute(*bind_vars).each { \|row\| return row[0] }
	nil
	end
	end