1 files changed, 27 insertions, 0 deletions
diff --git a/src/guff/models/site.cr b/src/guff/models/site.cr
new file mode 100644
index 0000000..9c8899a
--- /dev/null
+++ b/src/guff/models/site.cr
@@ -0,0 +1,27 @@
+module Guff
+  class SiteModel < Model
+    SQL = TemplateCache.new({
+      get_default: "
+        SELECT site_id
+          FROM sites
+         WHERE is_default
+         LIMIT 1
+      ",
+    })
+
+    def initialize(models : Models)
+      super(models, SQL)
+    end
+
+    def get_default : Int
+      r = one(:get_default, nil, {} of String => String)
+      raise "no default site" unless r
+      r.to_i
+    end
+
+    def to_site(host : String?) : Int
+      # TODO
+      get_default
+    end
+  end
+end