Class: Eksa::Model

Inherits:
Object
  • Object
show all
Defined in:
lib/eksa/model.rb

Direct Known Subclasses

Pesan

Class Method Summary collapse

Class Method Details

.db ⇒ Object 



6
7
8
9
10
11
12
13
 
# File 'lib/eksa/model.rb', line 6

def self.db
  db_dir = File.expand_path("../../db", __dir__)
  db_path = File.join(db_dir, "eksa_app.db")
  FileUtils.mkdir_p(db_dir) unless Dir.exist?(db_dir)
  @db ||= SQLite3::Database.new(db_path)
  setup_initial_schema
  @db
end

.setup_initial_schema ⇒ Object 



15
16
17
18
19
20
21
22
23
 
# File 'lib/eksa/model.rb', line 15

def self.setup_initial_schema
  @db.execute <<-SQL
    CREATE TABLE IF NOT EXISTS pesan (
      id INTEGER PRIMARY KEY AUTOINCREMENT,
      konten TEXT,
      pengirim TEXT
    );
  SQL
end