From 01f73a7f235c95a10d1be33c540f119fb5549560 Mon Sep 17 00:00:00 2001
From: Luka Hietala <luka.hietala08@gmail.com>
Date: Tue, 25 Nov 2025 14:28:13 +0200
Subject: [PATCH] listaa asunnot index sivulla

---
 app.lua            |  10 ++++++++--
 config.lua         |   5 ++++-
 koivuhaka.sqlite   | Bin 0 -> 12288 bytes
 logs/access.log    |   5 -----
 logs/error.log     |   1 -
 views/index.etlua  |  28 ++++++++++++++++++++++++++++
 views/layout.etlua |  10 ++++++++++
 7 files changed, 50 insertions(+), 9 deletions(-)
 create mode 100644 koivuhaka.sqlite
 delete mode 100644 logs/access.log
 delete mode 100644 logs/error.log
 create mode 100644 views/index.etlua
 create mode 100644 views/layout.etlua

diff --git a/app.lua b/app.lua
index 23814fa..4d1acce 100644
--- a/app.lua
+++ b/app.lua
@@ -1,8 +1,14 @@
 local lapis = require("lapis")
+local db = require("lapis.db")
 local app = lapis.Application()
 
-app:get("/", function()
-  return "Welcome to Lapis " .. require("lapis.version")
+app:enable("etlua")
+app.layout = require "views.layout"
+
+app:get("/", function(self)
+    local res = db.query("SELECT * FROM asunnot")
+    self.asunnot = res
+    return { render = "index" }
 end)
 
 return app
diff --git a/config.lua b/config.lua
index e63bdfd..a38fde4 100644
--- a/config.lua
+++ b/config.lua
@@ -3,5 +3,8 @@ local config = require("lapis.config")
 config("development", {
   server = "nginx",
   code_cache = "off",
-  num_workers = "1"
+  num_workers = "1",
+  sqlite = {
+    database = "koivuhaka.sqlite",
+  }
 })
diff --git a/koivuhaka.sqlite b/koivuhaka.sqlite
new file mode 100644
index 0000000000000000000000000000000000000000..b3d66b8e59aad0f488fe1212e999501998e4d1ab
GIT binary patch
literal 12288
zcmeI%&u-c<7y$4DS}LeIcG-I1VsU~sA)y5{kSdL?X%&@H%2IWx2V{Z?X+lgA2fE#c
zcGz?5dG;K8fxW<-E}FD%Qcp<R^nFVFFOF^fPImI<vSTxXCN!8~h7N?Mf+z~F5E29-
zo!mUT50R%ENjc8q`eTt6D)0Rr-Yb=VF65^?fdByz009sH0T2KI5C8!X009sHfxkwe
zm&)w!?TG`1M=l9{mmiUbA@L*PnGdV!*L|&RXvk<Ebu{##Z^^?mBJnrNAD)R@yM=<d
z67R>vVdQy~C0Xj1F^WlR5tVY;qCGBV^{%0vYJG`UX-N5EidjQ@YoP80zppx-_<<8G
z@bAsNzJA{B573!5D8)me_LXs=clmthTGuG&%JJDev-L%I@_FZY`)lq~_64s%fB*=9
z00@8p2>dewtDDTGaQ%_?A`d%+MV^CMglb5a&>6KC(G)v4E;<f%@szQ7*isa8>{XHt
zM}^uBWj3iyY(<|A!z&**=xxV3zBHPR6S*c^r~12Pc&JPw*OezWlWk9FzEtlT^#f&M
zyNm>3Yl(R_!+}$JWQLQjH8554uFt}%-t1Y?!l&1@BcBD!LnUOG+2)@XmaK93bDqlF
zvm{lLt5UVx8e!A10vdVap-EjDl$KMzT`ISJ{NE_u&WTl4D3b$%U75tQ5P3$%HXdQm
zk>>#&EA^VHR2!-i(kL*AvcF$f8&$PdU)^ki?izJBKzEJ0Y0zDxZVGhQs4If*+H~Xd
rznK3f@CyP2KmY_l00ck)1V8`;KmY_l00cnb{}I?0(*-g4<e&Kt(oZ?g

literal 0
HcmV?d00001

diff --git a/logs/access.log b/logs/access.log
deleted file mode 100644
index a288983..0000000
--- a/logs/access.log
+++ /dev/null
@@ -1,5 +0,0 @@
-127.0.0.1 - - [25/Nov/2025:08:48:00 +0200] "\x16\x03\x01\x07a\x01\x00\x07]\x03\x03\xF0\x04\x9F*\xF0\xA3K\xA1\xF6s\xE3T\xB7f^\x8FSmf\x1ES\xF3\xFA\x9F\xA4`\x89E\x98w\xE1$ JN\xED\x17\x07\xAA\xF5\x96\x8C\xFF\xE26\xEDS\xB1@\x93\x00f\x84\xD7\xCA\xC4c\x07g\xF05\xCDD%I\x00\x22\x13\x01\x13\x03\x13\x02\xC0+\xC0/\xCC\xA9\xCC\xA8\xC0,\xC00\xC0" 400 163 "-" "-"
-127.0.0.1 - - [25/Nov/2025:08:48:00 +0200] "\x16\x03\x01\x02\x90\x01\x00\x02\x8C\x03\x03\x0C\x99\x9C5\xF1\x10~\x19\xBE\xA2*\x9E\x1B3\xAB\x97nS\xDE\xF3D\xBD\xF1?\xB5t\x8A\x8Bz6\x19\xD7 f\xFF\x9B\xD0\xC1\xD1Oh&\xC8\xF2\x90\xAB\xDE\x89 \x8E\xE1\xBF\xB2\xF6\xB3\xA4\xE3\x98\x0C\x96!\x9B\xD1\xEA\xC1\x00\x22\x13\x01\x13\x03\x13\x02\xC0+\xC0/\xCC\xA9\xCC\xA8\xC0,\xC00\xC0" 400 163 "-" "-"
-127.0.0.1 - - [25/Nov/2025:08:48:38 +0200] "GET / HTTP/1.1" 200 123 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0"
-127.0.0.1 - - [25/Nov/2025:08:48:38 +0200] "GET /favicon.ico HTTP/1.1" 404 159 "http://localhost:8080/" "Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0"
-127.0.0.1 - - [25/Nov/2025:08:48:50 +0200] "GET / HTTP/1.1" 200 123 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0"
diff --git a/logs/error.log b/logs/error.log
deleted file mode 100644
index c6319ae..0000000
--- a/logs/error.log
+++ /dev/null
@@ -1 +0,0 @@
-2025/11/25 08:47:17 [alert] 18555#0: lua_code_cache is off; this will hurt performance in /home/lhietala/repos/koivuhaka/nginx.conf.compiled:20
diff --git a/views/index.etlua b/views/index.etlua
new file mode 100644
index 0000000..756f914
--- /dev/null
+++ b/views/index.etlua
@@ -0,0 +1,28 @@
+<!doctype html>
+<html lang="fi">
+  <head>
+    <meta charset="utf-8">
+    <meta name="viewport" content="width=device-width, initial-scale=1">
+    <title>Bootstrap demo</title>
+    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.8/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-sRIl4kxILFvY47J16cr9ZwB07vP4J8+LH7qKQnuqkuIAvNWLzeN8tE5YBujZqJLB" crossorigin="anonymous">
+  </head>
+  <body>
+    <div class="container">
+	<div class="row row-cols-3 g-3">
+	    <% for i, asunto in pairs(asunnot) do %>
+		<div class="col">
+		    <div class="card">
+			<img class="card-img-top" src="<%= asunto["kuva"] %>" alt="kuva asunnosta">
+			<div class="card-img-overlay">
+			    <h4 class="card-title">
+				<%= asunto["osoite"] %>
+			    </h4>
+			</div>
+		    </div>
+		</div>
+	    <% end %>
+	</div>
+    </div>
+    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.8/dist/js/bootstrap.bundle.min.js" integrity="sha384-FKyoEForCGlyvwx9Hj09JcYn3nv7wiPVlz7YYwJrWVcXK/BmnVDxM+D2scQbITxI" crossorigin="anonymous"></script>
+  </body>
+</html>
diff --git a/views/layout.etlua b/views/layout.etlua
new file mode 100644
index 0000000..96156f6
--- /dev/null
+++ b/views/layout.etlua
@@ -0,0 +1,10 @@
+<!DOCTYPE HTML>
+<html lang="en">
+<head>
+  <meta charset="UTF-8">
+  <title><%= page_title or "Koivuhaan asunnot" %></title>
+</head>
+<body>
+  <% content_for("inner") %>
+</body>
+</html>
-- 
2.47.3