Module: Kaisoku::TestMap::Schema

Defined in:
lib/kaisoku/test_map/schema.rb

Class Method Summary collapse

Class Method Details

.add_column(db, table, column, definition) ⇒ Object 



74
75
76
77
78
 
# File 'lib/kaisoku/test_map/schema.rb', line 74

def add_column(db, table, column, definition)
  db.execute("ALTER TABLE #{table} ADD COLUMN #{column} #{definition}")
rescue SQLite3::SQLException
  nil
end

.gemfile_lock_hash(configuration) ⇒ Object 



67
68
69
70
71
72
 
# File 'lib/kaisoku/test_map/schema.rb', line 67

def gemfile_lock_hash(configuration)
  path = configuration.absolute_path('Gemfile.lock')
  return '' unless File.file?(path)

  Digest::SHA256.file(path).hexdigest
end

.meta(db, key) ⇒ Object 



54
55
56
 
# File 'lib/kaisoku/test_map/schema.rb', line 54

def meta(db, key)
  db.get_first_value('SELECT value FROM map_meta WHERE key = ?', [key])
end

.setup(db) ⇒ Object 



10
11
12
13
14
15
16
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
44
 
# File 'lib/kaisoku/test_map/schema.rb', line 10

def setup(db)
  db.execute_batch(<<~SQL)
    PRAGMA foreign_keys = ON;

    CREATE TABLE IF NOT EXISTS map_meta (
      key TEXT PRIMARY KEY,
      value TEXT NOT NULL
    );

    CREATE TABLE IF NOT EXISTS entities (
      id INTEGER PRIMARY KEY,
      adapter TEXT NOT NULL,
      identifier TEXT NOT NULL,
      file TEXT NOT NULL,
      line INTEGER,
      avg_duration_ms INTEGER,
      last_status TEXT,
      last_failed_at INTEGER,
      failure_count INTEGER NOT NULL DEFAULT 0,
      UNIQUE(adapter, identifier)
    );

    CREATE TABLE IF NOT EXISTS deps (
      entity_id INTEGER NOT NULL,
      dep_file TEXT NOT NULL,
      checksum TEXT NOT NULL,
      granularity TEXT NOT NULL DEFAULT 'file',
      PRIMARY KEY(entity_id, dep_file, granularity),
      FOREIGN KEY(entity_id) REFERENCES entities(id) ON DELETE CASCADE
    );

    CREATE INDEX IF NOT EXISTS idx_deps_file ON deps(dep_file);
  SQL
  add_column(db, 'entities', 'failure_count', 'INTEGER NOT NULL DEFAULT 0')
end

.write_meta(db, key, value) ⇒ Object 



58
59
60
61
62
63
64
65
 
# File 'lib/kaisoku/test_map/schema.rb', line 58

def write_meta(db, key, value)
  sql = <<~SQL
    INSERT INTO map_meta (key, value)
    VALUES (?, ?)
    ON CONFLICT(key) DO UPDATE SET value = excluded.value
  SQL
  db.execute(sql, [key, value.to_s])
end

.write_runtime_metadata(db, adapter:, configuration:) ⇒ Object 



46
47
48
49
50
51
52
 
# File 'lib/kaisoku/test_map/schema.rb', line 46

def write_runtime_metadata(db, adapter:, configuration:)
  write_meta(db, 'schema_version', TestMap::SCHEMA_VERSION)
  write_meta(db, 'ruby_version', RUBY_VERSION)
  write_meta(db, 'adapter', adapter)
  write_meta(db, 'gemfile_lock_hash', gemfile_lock_hash(configuration))
  write_meta(db, 'created_at', Time.now.to_i) unless meta(db, 'created_at')
end