Class: Hyphy::SQLStatement

Inherits:
Sequel::Model
  • Object
show all
Defined in:
lib/hyphy/models/sql_statement.rb

Constant Summary collapse

DIGIT_MARKER = 
'<digit>'

Class Method Summary collapse

Instance Method Summary collapse

Class Method Details

.truncate_table ⇒ Object 



45
46
47
 
# File 'lib/hyphy/models/sql_statement.rb', line 45

def self.truncate_table
  Hyphy::DB[:sql_statements].truncate
end

Instance Method Details

#add_metadata(key, value) ⇒ Object 



38
39
40
41
42
43
 
# File 'lib/hyphy/models/sql_statement.rb', line 38

def add_metadata(key, value)
  new_metadata = metadata
  new_metadata[key] = value
  self.metadata_json = JSON(new_metadata)
  save
end

#digitless ⇒ Object 



25
26
27
 
# File 'lib/hyphy/models/sql_statement.rb', line 25

def digitless
  without_digits = stripped_statement.gsub(/\d+/, DIGIT_MARKER)
end

#duration ⇒ Object 



17
18
19
 
# File 'lib/hyphy/models/sql_statement.rb', line 17

def duration
  @duration ||= (end_time - start_time)
end

#metadata ⇒ Object 



33
34
35
36
 
# File 'lib/hyphy/models/sql_statement.rb', line 33

def metadata
  return {} unless metadata_json
  JSON.parse(metadata_json)
end

#stripped_statement ⇒ Object 



21
22
23
 
# File 'lib/hyphy/models/sql_statement.rb', line 21

def stripped_statement
  statement.strip
end

#trace ⇒ Object 



29
30
31
 
# File 'lib/hyphy/models/sql_statement.rb', line 29

def trace
  JSON.parse(trace_json)
end