Class: Pesan

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

Class Method Summary collapse

Methods inherited from Eksa::Model

db, setup_initial_schema

Class Method Details

.buat(konten, pengirim) ⇒ Object 



6
7
8
 
# File 'app/models/pesan.rb', line 6

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

.cari(id) ⇒ Object 



10
11
12
 
# File 'app/models/pesan.rb', line 10

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

.cari_kata(keyword) ⇒ Object 



22
23
24
 
# File 'app/models/pesan.rb', line 22

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 



18
19
20
 
# File 'app/models/pesan.rb', line 18

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

.semua ⇒ Object 



2
3
4
 
# File 'app/models/pesan.rb', line 2

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

.update(id, konten, pengirim) ⇒ Object 



14
15
16
 
# File 'app/models/pesan.rb', line 14

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