Class: Memo

Inherits:
Object
  • Object
show all
Defined in:
lib/jott/memo.rb

Instance Method Summary collapse

Constructor Details

#initialize ⇒ Memo

Returns a new instance of Memo.



4
5
6
7
 
# File 'lib/jott/memo.rb', line 4

def initialize
  @db = SQLite3::Database.new(File.join(File.dirname(__FILE__), "jott.db"))
  @db.execute("CREATE TABLE IF NOT EXISTS memos(id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT, body TEXT)")
end

Instance Method Details

#all ⇒ Object 



9
10
11
 
# File 'lib/jott/memo.rb', line 9

def all
  @db.execute("SELECT * FROM memos")
end

#clear ⇒ Object 



13
14
15
 
# File 'lib/jott/memo.rb', line 13

def clear
  @db.execute("DROP TABLE memos")
end

#count ⇒ Object 



17
18
19
 
# File 'lib/jott/memo.rb', line 17

def count
  @db.execute("SELECT COUNT(id) FROM memos")
end

#create(title:, body:) ⇒ Object 



21
22
23
 
# File 'lib/jott/memo.rb', line 21

def create(title:, body:)
  @db.execute("INSERT INTO memos(title, body) VALUES (?, ?)", [title, body])
end

#delete(id:) ⇒ Object 



25
26
27
 
# File 'lib/jott/memo.rb', line 25

def delete(id:)
  @db.execute("DELETE FROM memos WHERE id = ?", id)
end

#last ⇒ Object 



29
30
31
 
# File 'lib/jott/memo.rb', line 29

def last
  @db.execute("SELECT max(id), * FROM memos")
end