module Mkxms::Mssql::SqlStringManipulators

Constants

MSSQL

Public Instance Methods

bit_test(expr, expected) click to toggle source
# File lib/mkxms/mssql/sql_string_manipulators.rb, line 38
def bit_test(expr, expected)
  "#{expr} = #{expected ? 1 : 0}"
end
boolean_desc(_is, s) click to toggle source
# File lib/mkxms/mssql/sql_string_manipulators.rb, line 42
def boolean_desc(_is, s)
  (_is ? '' : 'not ') + s
end
dedent(s) click to toggle source
# File lib/mkxms/mssql/sql_string_manipulators.rb, line 9
def dedent(s)
  margin = nil
  s.lines.map do |l|
    case 
    when margin.nil? && l =~ /^ *$/
      l
    when margin.nil?
      margin = /^ */.match(l)[0].length
      l[margin..-1]
    else
      /^(?: {0,#{margin}})(.*)/m.match(l)[1]
    end
  end.tap do |lines|
    lines.shift if lines.first == "\n"
  end.join('')
end
stresc(s) click to toggle source
# File lib/mkxms/mssql/sql_string_manipulators.rb, line 26
def stresc(s)
  s.gsub("'", "''")
end
strlit(s) click to toggle source
# File lib/mkxms/mssql/sql_string_manipulators.rb, line 30
def strlit(s)
  MSSQL.string_literal(s)
end
unquoted_identifier(s) click to toggle source
# File lib/mkxms/mssql/sql_string_manipulators.rb, line 34
def unquoted_identifier(s)
  MSSQL.strip_identifier_quoting(s)
end