1 files changed, 25 insertions, 0 deletions
diff --git a/src/guff/site-model.cr b/src/guff/site-model.cr
new file mode 100644
index 0000000..ecde831
--- /dev/null
+++ b/src/guff/site-model.cr
@@ -0,0 +1,25 @@
+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
+      one(:get_default, nil, {} of String => String)
+    end
+
+    def to_site(host : String?)
+      # TODO
+      get_default
+    end
+  end
+end