Class: AocCli::Database::Attempt

Inherits:
Object
  • Object
show all
Defined in:
lib/aoc_cli/database.rb

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(attempt:) ⇒ Attempt

Returns a new instance of Attempt.



41
42
43
44
45
 
# File 'lib/aoc_cli/database.rb', line 41

def initialize(attempt:)
  @attempt = attempt
  @db = Query.new(path:Paths::Database.cfg(attempt.user))
    .table(t:"attempts", cols:cols)
end

Instance Attribute Details

#attempt ⇒ Object (readonly)

Returns the value of attribute attempt.



40
41
42
 
# File 'lib/aoc_cli/database.rb', line 40

def attempt
  @attempt
end

#db ⇒ Object (readonly)

Returns the value of attribute db.



40
41
42
 
# File 'lib/aoc_cli/database.rb', line 40

def db
  @db
end

Instance Method Details

#cols ⇒ Object 



69
70
71
72
73
74
75
76
77
78
 
# File 'lib/aoc_cli/database.rb', line 69

def cols
  { time: :TEXT, 
    year: :INT, 
    day: :INT, 
    part: :INT, 
    answer: :TEXT, 
    correct: :INT,
    low: :INT,
    high: :INT }
end

#correct ⇒ Object 



46
47
48
49
 
# File 'lib/aoc_cli/database.rb', line 46

def correct
  db.insert(t:"attempts", val:data << 1 << 0 << 0)
  self
end

#count_attempts ⇒ Object 



79
80
81
 
# File 'lib/aoc_cli/database.rb', line 79

def count_attempts
  db.select(t:"attempts", where:where).count
end

#data ⇒ Object 



62
63
64
65
66
67
68
 
# File 'lib/aoc_cli/database.rb', line 62

def data
  [ "'#{Time.now}'",
    "'#{attempt.year}'",
    "'#{attempt.day}'",
    "'#{attempt.part}'",
    "'#{attempt.answer}'" ]
end

#duplicate?(ans:) ⇒ Boolean

Returns:



55
56
57
58
 
# File 'lib/aoc_cli/database.rb', line 55

def duplicate?(ans:)
  db.select(t:"attempts", 
        where:where.merge({answer:ans})).count > 0
end

#incorrect(low:, high:) ⇒ Object 



50
51
52
53
54
 
# File 'lib/aoc_cli/database.rb', line 50

def incorrect(low:, high:)
  db.insert(t:"attempts", 
    val:data << 0 << parse_hint(low:low, high:high))
  self
end

#parse_hint(low:, high:) ⇒ Object 



59
60
61
 
# File 'lib/aoc_cli/database.rb', line 59

def parse_hint(low:, high:)
  [ low ? 1 : 0, high ? 1 : 0 ]
end

#where ⇒ Object 



82
83
84
85
86
 
# File 'lib/aoc_cli/database.rb', line 82

def where
  { year:attempt.year,
    day:attempt.day,
    part:attempt.part }
end