class DB_Utils

Public Class Methods

sql_value_format(value) click to toggle source
# File lib/anhpham/methods/db_utils.rb, line 2
def self.sql_value_format(value)
  if value.nil?
    return 'null'
  else
    value = value.gsub("'","''") if value.kind_of? String
    return "'#{value}'"
  end
end
sql_value_format_prefix_wildcard(value) click to toggle source
# File lib/anhpham/methods/db_utils.rb, line 11
def self.sql_value_format_prefix_wildcard(value)
  if value.nil?
    return 'null'
  else
    value = value.gsub("'","''") if value.kind_of? String
    return "'#{value}%'"
  end
end
sql_value_format_suffix_wildcard(value) click to toggle source
# File lib/anhpham/methods/db_utils.rb, line 20
def self.sql_value_format_suffix_wildcard(value)
  if value.nil?
    return 'null'
  else
    value = value.gsub("'","''") if value.kind_of? String
    return "'%#{value}'"
  end
end
sql_value_format_wildcard(value) click to toggle source
# File lib/anhpham/methods/db_utils.rb, line 29
def self.sql_value_format_wildcard(value)
  if value.nil?
    return 'null'
  else
    value = value.gsub("'","''") if value.kind_of? String
    return "'%#{value}%'"
  end
end