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
-
#convert_smallint_to_bool ⇒ Object
Whether to convert smallint to boolean arguments for this dataset.
Instance Method Summary collapse
-
#complex_expression_sql_append(sql, op, args) ⇒ Object
SQLAnywhere uses + for string concatenation, and LIKE is case insensitive by default.
-
#constant_sql_append(sql, constant) ⇒ Object
Use Date() and Now() for CURRENT_DATE and CURRENT_TIMESTAMP.
-
#cross_apply(table) ⇒ Object
Uses CROSS APPLY to join the given table into the current dataset.
-
#escape_like(string) ⇒ Object
SqlAnywhere uses \ to escape metacharacters, but a ‘]’ should not be escaped.
-
#into(table) ⇒ Object
Specify a table for a SELECT …
-
#recursive_cte_requires_column_aliases? ⇒ Boolean
SqlAnywhere requires recursive CTEs to have column aliases.
- #supports_cte?(type = :select) ⇒ Boolean
- #supports_is_true? ⇒ Boolean
- #supports_join_using? ⇒ Boolean
- #supports_multiple_column_in? ⇒ Boolean
- #supports_timestamp_usecs? ⇒ Boolean
- #supports_where_true? ⇒ Boolean
Instance Attribute Details
#convert_smallint_to_bool ⇒ Object
Whether to convert smallint to boolean arguments for this dataset. Defaults to the SqlAnywhere module setting.
274 275 276 |
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 274 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.
316 317 318 319 320 321 322 323 324 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 |
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 316 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 = '' 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
373 374 375 376 377 378 379 380 381 382 |
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 373 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.
306 307 308 |
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 306 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
368 369 370 |
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 368 def escape_like(string) string.gsub(/[\\%_\[]/){|m| "\\#{m}"} end |
#into(table) ⇒ Object
Specify a table for a SELECT … INTO query.
385 386 387 |
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 385 def into(table) clone(:into => table) end |
#recursive_cte_requires_column_aliases? ⇒ Boolean
SqlAnywhere requires recursive CTEs to have column aliases.
311 312 313 |
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 311 def recursive_cte_requires_column_aliases? true end |
#supports_cte?(type = :select) ⇒ Boolean
281 282 283 |
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 281 def supports_cte?(type=:select) type == :select || type == :insert end |
#supports_is_true? ⇒ Boolean
293 294 295 |
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 293 def supports_is_true? false end |
#supports_join_using? ⇒ Boolean
297 298 299 |
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 297 def supports_join_using? false end |
#supports_multiple_column_in? ⇒ Boolean
285 286 287 |
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 285 def supports_multiple_column_in? false end |
#supports_timestamp_usecs? ⇒ Boolean
301 302 303 |
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 301 def false end |
#supports_where_true? ⇒ Boolean
289 290 291 |
# File 'lib/sequel/adapters/shared/sqlanywhere.rb', line 289 def supports_where_true? false end |