From 4acf04d8dd5ede19e16f9cca7945969e4e711897 Mon Sep 17 00:00:00 2001
From: Adhityaa Chandrasekar <adtac@adtac.in>
Date: Wed, 8 May 2019 22:28:20 -0700
Subject: [PATCH] comment_new.go: create page before inserting comment

Fixes https://gitlab.com/commento/commento/issues/173
---
 api/comment_new.go                | 8 ++++----
 db/20190508222848-reset-count.sql | 2 ++
 2 files changed, 6 insertions(+), 4 deletions(-)
 create mode 100644 db/20190508222848-reset-count.sql

diff --git a/api/comment_new.go b/api/comment_new.go
index 5cb3656..c31695f 100644
--- a/api/comment_new.go
+++ b/api/comment_new.go
@@ -30,6 +30,10 @@ func commentNew(commenterHex string, domain string, path string, parentHex strin
 
 	html := markdownToHtml(markdown)
 
+	if err = pageNew(domain, path); err != nil {
+		return "", err
+	}
+
 	statement := `
 		INSERT INTO
 		comments (commentHex, domain, path, commenterHex, parentHex, markdown, html, creationDate, state)
@@ -41,10 +45,6 @@ func commentNew(commenterHex string, domain string, path string, parentHex strin
 		return "", errorInternal
 	}
 
-	if err = pageNew(domain, path); err != nil {
-		return "", err
-	}
-
 	return commentHex, nil
 }
 
diff --git a/db/20190508222848-reset-count.sql b/db/20190508222848-reset-count.sql
new file mode 100644
index 0000000..d3162f4
--- /dev/null
+++ b/db/20190508222848-reset-count.sql
@@ -0,0 +1,2 @@
+UPDATE pages
+SET commentCount = commentCount + 1;
-- 
GitLab