Class: DB_Utils

Inherits:
Object
  • Object
show all
Defined in:
lib/Ifd_Automation/methods/db_utils.rb

Class Method Summary collapse

Class Method Details

.sql_value_format(value) ⇒ Object 



2
3
4
5
6
7
8
9
 
# File 'lib/Ifd_Automation/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) ⇒ Object 



11
12
13
14
15
16
17
18
 
# File 'lib/Ifd_Automation/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) ⇒ Object 



20
21
22
23
24
25
26
27
 
# File 'lib/Ifd_Automation/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) ⇒ Object 



29
30
31
32
33
34
35
36
 
# File 'lib/Ifd_Automation/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