Class: Sequel::TinyTDS::Dataset

Inherits:
Dataset show all
Includes:
MSSQL::DatasetMethods
Defined in:
lib/sequel/adapters/tinytds.rb

Defined Under Namespace

Modules: ArgumentMapper, PreparedStatementMethods

Constant Summary

Constant Summary

Constants included from MSSQL::DatasetMethods

MSSQL::DatasetMethods::APOS, MSSQL::DatasetMethods::APOS_RE, MSSQL::DatasetMethods::BACKSLASH_CRLF_RE, MSSQL::DatasetMethods::BACKSLASH_CRLF_REPLACE, MSSQL::DatasetMethods::BOOL_FALSE, MSSQL::DatasetMethods::BOOL_TRUE, MSSQL::DatasetMethods::BRACKET_CLOSE, MSSQL::DatasetMethods::BRACKET_OPEN, MSSQL::DatasetMethods::CASE_INSENSITIVE_COLLATION, MSSQL::DatasetMethods::CASE_SENSITIVE_COLLATION, MSSQL::DatasetMethods::COMMA, MSSQL::DatasetMethods::COMMA_SEPARATOR, MSSQL::DatasetMethods::CONSTANT_MAP, MSSQL::DatasetMethods::CROSS_APPLY, MSSQL::DatasetMethods::DATEPART_OPEN, MSSQL::DatasetMethods::DATEPART_SECOND_CLOSE, MSSQL::DatasetMethods::DATEPART_SECOND_MIDDLE, MSSQL::DatasetMethods::DATEPART_SECOND_OPEN, MSSQL::DatasetMethods::DEFAULT_TIMESTAMP_FORMAT, MSSQL::DatasetMethods::DELETE_CLAUSE_METHODS, MSSQL::DatasetMethods::DOUBLE_APOS, MSSQL::DatasetMethods::DOUBLE_BRACKET_CLOSE, MSSQL::DatasetMethods::EXTRACT_MAP, MSSQL::DatasetMethods::FETCH_NEXT, MSSQL::DatasetMethods::FORMAT_DATE, MSSQL::DatasetMethods::FROM, MSSQL::DatasetMethods::HEX_START, MSSQL::DatasetMethods::HSTAR, MSSQL::DatasetMethods::INSERT_CLAUSE_METHODS, MSSQL::DatasetMethods::INTO, MSSQL::DatasetMethods::NOLOCK, MSSQL::DatasetMethods::OFFSET, MSSQL::DatasetMethods::OUTER_APPLY, MSSQL::DatasetMethods::OUTPUT, MSSQL::DatasetMethods::OUTPUT_INSERTED, MSSQL::DatasetMethods::PAREN_CLOSE, MSSQL::DatasetMethods::PAREN_SPACE_OPEN, MSSQL::DatasetMethods::ROWS, MSSQL::DatasetMethods::ROWS_ONLY, MSSQL::DatasetMethods::SELECT_CLAUSE_METHODS, MSSQL::DatasetMethods::SELECT_SPACE, MSSQL::DatasetMethods::SPACE, MSSQL::DatasetMethods::TIMESTAMP_USEC_FORMAT, MSSQL::DatasetMethods::TOP, MSSQL::DatasetMethods::TOP_PAREN, MSSQL::DatasetMethods::UNICODE_STRING_START, MSSQL::DatasetMethods::UNION_ALL, MSSQL::DatasetMethods::UPDATE_CLAUSE_METHODS, MSSQL::DatasetMethods::UPDATE_CLAUSE_METHODS_2000, MSSQL::DatasetMethods::UPDLOCK, MSSQL::DatasetMethods::WILDCARD

Constants inherited from Dataset

Dataset::ACTION_METHODS, Dataset::ALL, Dataset::AND_SEPARATOR, Dataset::APOS, Dataset::APOS_RE, Dataset::ARG_BLOCK_ERROR_MSG, Dataset::ARRAY_ACCESS_ERROR_MSG, Dataset::ARRAY_EMPTY, Dataset::AS, Dataset::ASC, Dataset::BACKSLASH, Dataset::BOOL_FALSE, Dataset::BOOL_TRUE, Dataset::BRACKET_CLOSE, Dataset::BRACKET_OPEN, Dataset::CASE_ELSE, Dataset::CASE_END, Dataset::CASE_OPEN, Dataset::CASE_THEN, Dataset::CASE_WHEN, Dataset::CAST_OPEN, Dataset::COLON, Dataset::COLUMN_CHANGE_OPTS, Dataset::COLUMN_REF_RE1, Dataset::COLUMN_REF_RE2, Dataset::COLUMN_REF_RE3, Dataset::COMMA, Dataset::COMMA_SEPARATOR, Dataset::CONDITIONED_JOIN_TYPES, Dataset::CONDITION_FALSE, Dataset::CONDITION_TRUE, Dataset::COUNT_FROM_SELF_OPTS, Dataset::COUNT_OF_ALL_AS_COUNT, Dataset::DATASET_ALIAS_BASE_NAME, Dataset::DEFAULT, Dataset::DEFAULT_VALUES, Dataset::DELETE, Dataset::DELETE_CLAUSE_METHODS, Dataset::DESC, Dataset::DISTINCT, Dataset::DOT, Dataset::DOUBLE_APOS, Dataset::DOUBLE_QUOTE, Dataset::EMULATED_FUNCTION_MAP, Dataset::EQUAL, Dataset::ESCAPE, Dataset::EXISTS, Dataset::EXTENSIONS, Dataset::EXTRACT, Dataset::FORMAT_DATE, Dataset::FORMAT_DATE_STANDARD, Dataset::FORMAT_OFFSET, Dataset::FORMAT_TIMESTAMP_RE, Dataset::FORMAT_TIMESTAMP_USEC, Dataset::FORMAT_USEC, Dataset::FOR_UPDATE, Dataset::FRAME_ALL, Dataset::FRAME_ROWS, Dataset::FROM, Dataset::FUNCTION_EMPTY, Dataset::GROUP_BY, Dataset::HAVING, Dataset::IMPORT_ERROR_MSG, Dataset::INSERT, Dataset::INSERT_CLAUSE_METHODS, Dataset::INTO, Dataset::IS_LITERALS, Dataset::IS_OPERATORS, Dataset::JOIN_METHODS, Dataset::LATERAL, Dataset::LIKE_OPERATORS, Dataset::LIMIT, Dataset::MUTATION_METHODS, Dataset::NON_SQL_OPTIONS, Dataset::NOTIMPL_MSG, Dataset::NOT_SPACE, Dataset::NULL, Dataset::NULLS_FIRST, Dataset::NULLS_LAST, Dataset::N_ARITY_OPERATORS, Dataset::OFFSET, Dataset::ON, Dataset::ON_PAREN, Dataset::OPTS, Dataset::ORDER_BY, Dataset::ORDER_BY_NS, Dataset::OVER, Dataset::PAREN_CLOSE, Dataset::PAREN_OPEN, Dataset::PAREN_SPACE_OPEN, Dataset::PARTITION_BY, Dataset::PREPARED_ARG_PLACEHOLDER, Dataset::QUALIFY_KEYS, Dataset::QUERY_METHODS, Dataset::QUESTION_MARK, Dataset::QUESTION_MARK_RE, Dataset::QUOTE, Dataset::QUOTE_RE, Dataset::REGEXP_OPERATORS, Dataset::RETURNING, Dataset::SELECT, Dataset::SELECT_CLAUSE_METHODS, Dataset::SET, Dataset::SPACE, Dataset::SPACE_WITH, Dataset::SQL_WITH, Dataset::STANDARD_TIMESTAMP_FORMAT, Dataset::TILDE, Dataset::TIMESTAMP_FORMAT, Dataset::TWO_ARITY_OPERATORS, Dataset::UNCONDITIONED_JOIN_TYPES, Dataset::UNDERSCORE, Dataset::UPDATE, Dataset::UPDATE_CLAUSE_METHODS, Dataset::USING, Dataset::V190, Dataset::VALUES, Dataset::WHERE, Dataset::WILDCARD

Instance Attribute Summary

Attributes included from MSSQL::DatasetMethods

#mssql_unicode_strings

Attributes inherited from Dataset

#db, #opts, #row_proc

Instance Method Summary (collapse)

Methods included from MSSQL::DatasetMethods

#complex_expression_sql_append, #constant_sql_append, #cross_apply, #disable_insert_output, #emulated_function_sql_append, #escape_like, #full_text_search, #insert_select, #into, #multi_insert_sql, #nolock, #outer_apply, #output, #quoted_identifier_append, #select_sql, #server_version, #supports_group_cube?, #supports_group_rollup?, #supports_insert_select?, #supports_intersect_except?, #supports_is_true?, #supports_join_using?, #supports_modifying_joins?, #supports_multiple_column_in?, #supports_output_clause?, #supports_where_true?, #supports_window_functions?

Methods included from EmulateOffsetWithRowNumber

#select_sql

Methods inherited from Dataset

#<<, #==, #[], #add_graph_aliases, #aliased_expression_sql_append, #all, #and, #array_sql_append, #avg, #bind, #boolean_constant_sql_append, #call, #case_expression_sql_append, #cast_sql_append, clause_methods, #clone, #column_all_sql_append, #columns, #columns!, #complex_expression_sql_append, #constant_sql_append, #count, def_mutation_method, #delayed_evaluation_sql_append, #delete, #delete_sql, #distinct, #dup, #each, #each_server, #empty?, #emulated_function_sql_append, #eql?, #escape_like, #except, #exclude, #exclude_having, #exclude_where, #exists, #extension, #extension!, #filter, #first, #first!, #first_source, #first_source_alias, #first_source_table, #for_update, #freeze, #from, #from_self, #from_self!, #frozen?, #function_sql_append, #get, #graph, #grep, #group, #group_and_count, #group_by, #group_cube, #group_rollup, #hash, #having, #identifier_input_method, #identifier_input_method=, #identifier_output_method, #identifier_output_method=, #import, #initialize, #insert, #insert_sql, #inspect, #intersect, #interval, #invert, #join, #join_clause_sql_append, #join_on_clause_sql_append, #join_table, #join_using_clause_sql_append, #last, #lateral, #limit, #literal_append, #lock_style, #map, #max, #min, #multi_insert, #multi_insert_sql, #naked, #naked!, #negative_boolean_constant_sql_append, #offset, #or, #order, #order_append, #order_by, #order_more, #order_prepend, #ordered_expression_sql_append, #paged_each, #placeholder_literal_string_sql_append, #provides_accurate_rows_matched?, #qualified_identifier_sql_append, #qualify, #quote_identifier_append, #quote_identifiers=, #quote_identifiers?, #quote_schema_table_append, #quoted_identifier_append, #range, #recursive_cte_requires_column_aliases?, register_extension, #requires_placeholder_type_specifiers?, #requires_sql_standard_datetimes?, #returning, #reverse, #reverse_order, #row_number_column, #schema_and_table, #select, #select_all, #select_append, #select_group, #select_hash, #select_hash_groups, #select_map, #select_more, #select_order_map, #select_sql, #server, #set_graph_aliases, #single_record, #single_value, #split_alias, #split_qualifiers, #sql, #subscript_sql_append, #sum, #supports_cte?, #supports_cte_in_subqueries?, #supports_distinct_on?, #supports_group_cube?, #supports_group_rollup?, #supports_insert_select?, #supports_intersect_except?, #supports_intersect_except_all?, #supports_is_true?, #supports_join_using?, #supports_lateral_subqueries?, #supports_modifying_joins?, #supports_multiple_column_in?, #supports_ordered_distinct_on?, #supports_regexp?, #supports_replace?, #supports_returning?, #supports_select_all_and_column?, #supports_timestamp_timezones?, #supports_timestamp_usecs?, #supports_where_true?, #supports_window_functions?, #to_hash, #to_hash_groups, #truncate, #truncate_sql, #unbind, #unfiltered, #ungraphed, #ungrouped, #union, #unlimited, #unordered, #unused_table_alias, #update, #update_sql, #where, #window_function_sql_append, #window_sql_append, #with, #with_recursive, #with_sql, #with_sql_delete

Methods included from SQL::StringMethods

#ilike, #like

Methods included from SQL::OrderMethods

#asc, #desc

Methods included from SQL::NumericMethods

#+

Methods included from SQL::ComplexExpressionMethods

#extract, #sql_boolean, #sql_number, #sql_string

Methods included from SQL::CastMethods

#cast, #cast_numeric, #cast_string

Methods included from SQL::BooleanMethods

#~

Methods included from SQL::AliasMethods

#as

Constructor Details

This class inherits a constructor from Sequel::Dataset

Instance Method Details

- (Object) fetch_rows(sql)

Yield hashes with symbol keys, attempting to optimize for various cases.



231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
# File 'lib/sequel/adapters/tinytds.rb', line 231

def fetch_rows(sql)
  execute(sql) do |result|
    columns = result.fields.map!{|c| output_identifier(c)}
    if columns.empty?
      args = []
      args << {:timezone=>:utc} if db.timezone == :utc
      cols = nil
      result.each(*args) do |r|
        unless cols
          cols = result.fields.map{|c| [c, output_identifier(c)]}
          @columns = columns = cols.map{|c| c.last}
        end
        h = {}
        cols.each do |s, sym|
          h[sym] = r[s]
        end
        yield h
      end
    else
      @columns = columns
      if db.timezone == :utc
        result.each(:timezone=>:utc){|r| yield r}
      else
        result.each{|r| yield r}
      end
    end
  end
  self
end

- (Object) prepare(type, name = nil, *values)

Create a named prepared statement that is stored in the database (and connection) for reuse.



263
264
265
266
267
268
269
270
271
# File 'lib/sequel/adapters/tinytds.rb', line 263

def prepare(type, name=nil, *values)
  ps = to_prepared_statement(type, values)
  ps.extend(PreparedStatementMethods)
  if name
    ps.prepared_statement_name = name
    db.set_prepared_statement(name, ps)
  end
  ps
end