diff --git a/api/comment_new.go b/api/comment_new.go index 5cb3656e5f79894015f68e7e35c945b6c087a393..c31695f6df54f247d88266b9e285a1cd9cf308d8 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 0000000000000000000000000000000000000000..d3162f4791bf24423ee7fe6bc0a9244a93c0274a --- /dev/null +++ b/db/20190508222848-reset-count.sql @@ -0,0 +1,2 @@ +UPDATE pages +SET commentCount = commentCount + 1;