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