Class: TmsTaskManager::Configs::Database

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

Constant Summary collapse

DB_PATH = 
File.expand_path('../remind.db', __dir__)

Class Method Summary collapse

Class Method Details

.connection ⇒ Object 



11
12
13
14
15
 
# File 'lib/tms_task_manager/configs/database.rb', line 11

def connection
  @connection ||= SQLite3::Database.new(DB_PATH).tap do |db|
    db.results_as_hash = true
  end
end

.setup ⇒ Object 



17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
 
# File 'lib/tms_task_manager/configs/database.rb', line 17

def setup
  connection.execute_batch "  CREATE TABLE IF NOT EXISTS tasks (\n    id INTEGER PRIMARY KEY AUTOINCREMENT,\n    title VARCHAR(255),\n    description TEXT,\n    start_date DATETIME,\n    end_date DATETIME,\n    status VARCHAR(20) CHECK( status IN ('pending', 'in_progress', 'completed') )\n  );\n\n  CREATE TABLE IF NOT EXISTS categories (\n    id INTEGER PRIMARY KEY AUTOINCREMENT,\n    title VARCHAR(255),\n    description TEXT,\n    slug VARCHAR(255) UNIQUE\n  );\n\n  CREATE TABLE IF NOT EXISTS task_category (\n    id INTEGER PRIMARY KEY AUTOINCREMENT,\n    task_id INTEGER,\n    category_id INTEGER,\n    FOREIGN KEY (task_id) REFERENCES tasks(id),\n    FOREIGN KEY (category_id) REFERENCES categories(id)\n  );\n  SQL\nend\n"