From 974d7c1d8ae71d50566dc8c2857520dde139a191 Mon Sep 17 00:00:00 2001
From: Paul Duncan <pabs@pablotron.org>
Date: Fri, 1 Apr 2016 15:57:49 -0400
Subject: update TODO

---
 src/guff/models/role.cr | 28 ++++++++++++++++++++++++++++
 1 file changed, 28 insertions(+)
 create mode 100644 src/guff/models/role.cr

(limited to 'src/guff')

diff --git a/src/guff/models/role.cr b/src/guff/models/role.cr
new file mode 100644
index 0000000..9faf6b2
--- /dev/null
+++ b/src/guff/models/role.cr
@@ -0,0 +1,28 @@
+class Guff::RoleModel < Guff::Model
+  SQL = TemplateCache.new({
+    get_roles: "
+      SELECT role_id,
+             role_name,
+             role_desc
+
+        FROM roles
+
+       -- FIXME
+       ORDER BY role_id
+    ",
+  })
+
+  def initialize(models : Models)
+    super(models, SQL)
+  end
+
+  def get_roles
+    r = [] of Hash(String, SQLite3::Value)
+
+    all(:get_roles, nil, nil) do |row|
+      r << row
+    end
+
+    r
+  end
+end
-- 
cgit v1.2.3