From 93dfe2be64e8658839bcfe5356adf35f8cde7075 Mon Sep 17 00:00:00 2001
From: Nicolas James <Eele1Ephe7uZahRie@tutanota.com>
Date: Thu, 13 Feb 2025 18:04:18 +1100
Subject: initial commit

---
 src/server/database/post.go | 28 ++++++++++++++++++++++++++++
 1 file changed, 28 insertions(+)
 create mode 100644 src/server/database/post.go

(limited to 'src/server/database/post.go')

diff --git a/src/server/database/post.go b/src/server/database/post.go
new file mode 100644
index 0000000..d73344a
--- /dev/null
+++ b/src/server/database/post.go
@@ -0,0 +1,28 @@
+package database
+
+import (
+	"time"
+)
+
+// Writes a post to the database, returns the uid of the new post.
+func WritePost(author int,
+	parent *int,
+	title string,
+	contents string,
+	subreact string,
+	image []byte,
+	thumbnail []byte) (int, error) {
+
+	var db = GetDb()
+
+	var uid int
+	row := db.QueryRow("INSERT INTO Posts "+
+		"(author, parent, time, subreact, title, contents, thumbnail, image) "+
+		"VALUES(?, ?, ?, ?, ?, ?, ?, ?) RETURNING Posts.uid;",
+		author, parent, time.Now().Unix(), subreact, title, contents, thumbnail, image)
+	if err := row.Scan(&uid); err != nil {
+		return 0, err
+	}
+
+	return uid, nil
+}
-- 
cgit v1.2.3