module Bricolage::SQLUtils

Private Instance Methods

escape_sql_string(s) click to toggle source
# File lib/bricolage/sqlutils.rb, line 13
def escape_sql_string(s)
  s.gsub(/'/, "''")
end
s(s)
Alias for: sql_string_literal
sql_string_literal(s) click to toggle source
# File lib/bricolage/sqlutils.rb, line 7
def sql_string_literal(s)
  %Q('#{escape_sql_string s}')
end
Also aliased as: s
sql_timestamp_format(time) click to toggle source
# File lib/bricolage/sqlutils.rb, line 23
def sql_timestamp_format(time)
  time.strftime('%Y-%m-%d %H:%M:%S')
end
sql_timestamp_literal(time) click to toggle source
# File lib/bricolage/sqlutils.rb, line 17
def sql_timestamp_literal(time)
  %Q(timestamp '#{sql_timestamp_format(time)}')
end
Also aliased as: t
t(time)