Module: Mkxms::Mssql::Utils::StringHelpers

Included in:
String
Defined in:
lib/mkxms/mssql/utils.rb

Instance Method Summary collapse

Instance Method Details

#expand_tabs(tabstops_every = 8) ⇒ Object



55
56
57
58
59
60
61
62
63
64
65
66
67
68
# File 'lib/mkxms/mssql/utils.rb', line 55

def expand_tabs(tabstops_every = 8)
  self.lines.map do |l|
    if l.include?("\t")
      segs = l.split("\t")
      segs[0...-1].map do |seg|
        # seg length must _increase_ to a multiple of 8
        spaces_needed = tabstops_every - (seg.length + 1) % tabstops_every + 1
        seg + ' ' * spaces_needed
      end.join('') + segs[-1]
    else
      l
    end
  end.join('')
end

#sql_quotedObject



70
71
72
# File 'lib/mkxms/mssql/utils.rb', line 70

def sql_quoted
  %Q{N'#{gsub("'", "''")}'}
end