Module: Sequel::SqlAnywhere::DatasetMethods

Included in:
JDBC::SqlAnywhere::Dataset, Dataset
Defined in:
lib/sequel/adapters/shared/sqlanywhere.rb

Constant Summary collapse

BOOL_TRUE = 
'1'.freeze
BOOL_FALSE = 
'0'.freeze
WILDCARD = 
LiteralString.new('%').freeze
TOP = 
" TOP ".freeze
START_AT = 
" START AT ".freeze
SQL_WITH_RECURSIVE = 
"WITH RECURSIVE ".freeze
DATE_FUNCTION = 
'today()'.freeze
NOW_FUNCTION = 
'now()'.freeze
DATEPART = 
'datepart'.freeze
REGEXP = 
'REGEXP'.freeze
NOT_REGEXP = 
'NOT REGEXP'.freeze
APOS = 
Dataset::APOS
APOS_RE = 
Dataset::APOS_RE
DOUBLE_APOS = 
Dataset::DOUBLE_APOS
BACKSLASH_RE = 
/\\/.freeze
QUAD_BACKSLASH = 
"\\\\\\\\".freeze
BLOB_START = 
"0x".freeze
HSTAR = 
"H*".freeze
CROSS_APPLY = 
'CROSS APPLY'.freeze
OUTER_APPLY = 
'OUTER APPLY'.freeze
ONLY_OFFSET = 
" TOP 2147483647".freeze

Instance Attribute Summary collapse

Instance Method Summary collapse

Instance Attribute Details

#convert_smallint_to_bool ⇒ Object

Whether to convert smallint to boolean arguments for this dataset. Defaults to the SqlAnywhere module setting.



278
279
280
 
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 278

def convert_smallint_to_bool
  defined?(@convert_smallint_to_bool) ? @convert_smallint_to_bool : (@convert_smallint_to_bool = @db.convert_smallint_to_bool)
end

Instance Method Details

#complex_expression_sql_append(sql, op, args) ⇒ Object

SQLAnywhere uses + for string concatenation, and LIKE is case insensitive by default.



325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
 
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 325

def complex_expression_sql_append(sql, op, args)
  case op
  when :'||'
    super(sql, :+, args)
  when :<<, :>>
    complex_expression_emulate_append(sql, op, args)
  when :LIKE, :"NOT LIKE"
    sql << Sequel::Dataset::PAREN_OPEN
    literal_append(sql, args.at(0))
    sql << Sequel::Dataset::SPACE << (op == :LIKE ? REGEXP : NOT_REGEXP) << Sequel::Dataset::SPACE
    pattern = String.new
    last_c = ''
    args.at(1).each_char do |c|
      if  c == '_' and not pattern.end_with?('\\') and last_c != '\\'
        pattern << '.'
      elsif c == '%' and not pattern.end_with?('\\') and last_c != '\\'
        pattern << '.*'
      elsif c == '[' and not pattern.end_with?('\\') and last_c != '\\'
        pattern << '\['
      elsif c == ']' and not pattern.end_with?('\\') and last_c != '\\'
        pattern << '\]'
      elsif c == '*' and not pattern.end_with?('\\') and last_c != '\\'
        pattern << '\*'
      elsif c == '?' and not pattern.end_with?('\\') and last_c != '\\'
        pattern << '\?'
      else
        pattern << c
      end
      if c == '\\' and last_c == '\\'
        last_c = ''
      else
        last_c = c
      end
    end
    literal_append(sql, pattern)
    sql << Sequel::Dataset::ESCAPE
    literal_append(sql, Sequel::Dataset::BACKSLASH)
    sql << Sequel::Dataset::PAREN_CLOSE
  when :ILIKE, :"NOT ILIKE"
    super(sql, (op == :ILIKE ? :LIKE : :"NOT LIKE"), args)
  when :extract
    sql << DATEPART + Sequel::Dataset::PAREN_OPEN
    literal_append(sql, args.at(0))
    sql << ','
    literal_append(sql, args.at(1))
    sql << Sequel::Dataset::PAREN_CLOSE
  else
    super
  end
end

#constant_sql_append(sql, constant) ⇒ Object

Use Date() and Now() for CURRENT_DATE and CURRENT_TIMESTAMP



382
383
384
385
386
387
388
389
390
391
 
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 382

def constant_sql_append(sql, constant)
  case constant
  when :CURRENT_DATE
    sql << DATE_FUNCTION
  when :CURRENT_TIMESTAMP, :CURRENT_TIME
    sql << NOW_FUNCTION
  else
    super
  end
end

#cross_apply(table) ⇒ Object

Uses CROSS APPLY to join the given table into the current dataset.



315
316
317
 
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 315

def cross_apply(table)
  join_table(:cross_apply, table)
end

#escape_like(string) ⇒ Object

SqlAnywhere uses \ to escape metacharacters, but a ‘]’ should not be escaped



377
378
379
 
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 377

def escape_like(string)
  string.gsub(/[\\%_\[]/){|m| "\\#{m}"}
end

#into(table) ⇒ Object

Specify a table for a SELECT … INTO query.



394
395
396
 
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 394

def into(table)
  clone(:into => table)
end

#recursive_cte_requires_column_aliases? ⇒ Boolean

SqlAnywhere requires recursive CTEs to have column aliases.

Returns:

  • (Boolean) 


320
321
322
 
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 320

def recursive_cte_requires_column_aliases?
  true
end

#supports_cte?(type = :select) ⇒ Boolean

Returns:

  • (Boolean) 


285
286
287
 
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 285

def supports_cte?(type=:select)
  type == :select || type == :insert
end

#supports_grouping_sets? ⇒ Boolean

SQLAnywhere supports GROUPING SETS

Returns:

  • (Boolean) 


290
291
292
 
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 290

def supports_grouping_sets?
  true
end

#supports_is_true? ⇒ Boolean

Returns:

  • (Boolean) 


302
303
304
 
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 302

def supports_is_true?
  false
end

#supports_join_using? ⇒ Boolean

Returns:

  • (Boolean) 


306
307
308
 
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 306

def supports_join_using?
  false
end

#supports_multiple_column_in? ⇒ Boolean

Returns:

  • (Boolean) 


294
295
296
 
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 294

def supports_multiple_column_in?
  false
end

#supports_timestamp_usecs? ⇒ Boolean

Returns:

  • (Boolean) 


310
311
312
 
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 310

def supports_timestamp_usecs?
  false
end

#supports_where_true? ⇒ Boolean

Returns:

  • (Boolean) 


298
299
300
 
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 298

def supports_where_true?
  false
end