Class: Pesan

Inherits:
Eksa::Model show all
Defined in:
app/models/pesan.rb

Class Method Summary collapse

Methods inherited from Eksa::Model

db, ensure_schema

Class Method Details

.buat(konten, pengirim) ⇒ Object 



16
17
18
 
# File 'app/models/pesan.rb', line 16

def self.buat(konten, pengirim)
  db.execute("INSERT INTO pesan (konten, pengirim) VALUES (?, ?)", [konten.strip, pengirim.strip])
end

.cari(id) ⇒ Object 



20
21
22
 
# File 'app/models/pesan.rb', line 20

def self.cari(id)
  db.execute("SELECT * FROM pesan WHERE id = ?", [id]).first
end

.cari_kata(keyword) ⇒ Object 



32
33
34
 
# File 'app/models/pesan.rb', line 32

def self.cari_kata(keyword)
  db.execute("SELECT * FROM pesan WHERE konten LIKE ? OR pengirim LIKE ? ORDER BY id DESC", ["%#{keyword}%", "%#{keyword}%"])
end

.hapus(id) ⇒ Object 



28
29
30
 
# File 'app/models/pesan.rb', line 28

def self.hapus(id)
  db.execute("DELETE FROM pesan WHERE id = ?", [id])
end

.semua ⇒ Object 



12
13
14
 
# File 'app/models/pesan.rb', line 12

def self.semua
  db.execute("SELECT * FROM pesan ORDER BY id DESC")
end

.setup_schema ⇒ Object 



2
3
4
5
6
7
8
9
10
 
# File 'app/models/pesan.rb', line 2

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

.update(id, konten, pengirim) ⇒ Object 



24
25
26
 
# File 'app/models/pesan.rb', line 24

def self.update(id, konten, pengirim)
  db.execute("UPDATE pesan SET konten = ?, pengirim = ? WHERE id = ?", [konten.strip, pengirim.strip, id])
end