Class: Hiiro::TaskRecord

Inherits:
Object
  • Object
show all
Defined in:
lib/hiiro/task_record.rb

Class Method Summary collapse

Class Method Details

.all_as_list ⇒ Object 



33
34
35
 
# File 'lib/hiiro/task_record.rb', line 33

def self.all_as_list
  order(:name).all
end

.create_table!(db) ⇒ Object 



7
8
9
10
11
12
13
14
15
16
17
18
 
# File 'lib/hiiro/task_record.rb', line 7

def self.create_table!(db)
  db.create_table?(:tasks) do
    primary_key :id
    String :name, null: false
    String :tree
    String :session
    String :app
    Integer :color_index
    String :created_at
    unique :name
  end
end

.find_by_name(n) ⇒ Object 



29
30
31
 
# File 'lib/hiiro/task_record.rb', line 29

def self.find_by_name(n)
  where(name: n).first
end

.subtasks_of(parent_name) ⇒ Object 



24
25
26
27
 
# File 'lib/hiiro/task_record.rb', line 24

def self.subtasks_of(parent_name)
  where(Sequel.like(:name, "#{parent_name}/%"))
    .exclude(Sequel.like(:name, "#{parent_name}/%/%"))
end

.top_level ⇒ Object 



20
21
22
 
# File 'lib/hiiro/task_record.rb', line 20

def self.top_level
  where(Sequel.~(Sequel.like(:name, '%/%')))
end