Class: Sequel::SqlAnywhere::Dataset

Inherits:
Dataset
  • Object
show all
Includes:
DatasetMethods
Defined in:
lib/sequel/adapters/sqlanywhere.rb

Constant Summary

Constants included from Dataset::ColumnsLimit1

Dataset::ColumnsLimit1::COLUMNS_CLONE_OPTIONS

Instance Method Summary collapse

Methods included from DatasetMethods

#complex_expression_sql_append, #constant_sql_append, #convert_smallint_to_bool, #cross_apply, #escape_like, #into, #recursive_cte_requires_column_aliases?, #supports_cte?, #supports_grouping_sets?, #supports_is_true?, #supports_join_using?, #supports_multiple_column_in?, #supports_where_true?, #supports_window_clause?, #supports_window_functions?, #with_convert_smallint_to_bool

Methods included from Dataset::ColumnsLimit1

#columns!

Instance Method Details

#fetch_rows(sql) ⇒ Object 



155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
 
# File 'lib/sequel/adapters/sqlanywhere.rb', line 155

def fetch_rows(sql)
  db = @db
  cps = db.conversion_procs
  api = db.api
  execute(sql) do |rs|
    convert = convert_smallint_to_bool
    col_infos = []
    api.sqlany_num_cols(rs).times do |i|
      _, _, name, _, type = api.sqlany_get_column_info(rs, i)
      cp = if type == 500
        cps[500] if convert
      else
        cps[type]
      end
      col_infos << [output_identifier(name), cp]
    end

    self.columns = col_infos.map(&:first)
    max = col_infos.length

    if rs
      while api.sqlany_fetch_next(rs) == 1
        i = -1
        h = {}
        while (i+=1) < max
          name, cp = col_infos[i]
          v = api.sqlany_get_column(rs, i)[1]
          h[name] = cp && v ? cp.call(v) : v
        end
        yield h
      end
    end
  end
  self
end