diff options
Diffstat (limited to 'src')
-rw-r--r-- | src/guff/models/role.cr | 28 |
1 files changed, 28 insertions, 0 deletions
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 |