From a706133ba7c15f366dba66d10bf8f556147e40f1 Mon Sep 17 00:00:00 2001
From: FChannel <=>
Date: Sun, 24 Jan 2021 21:34:37 -0800
Subject: removed cachereplies to consolidate into replies db

---
 CacheDatabase.go | 29 ++++++++++++++++++++---------
 Database.go      |  6 +++++-
 main.go          |  2 +-
 3 files changed, 26 insertions(+), 11 deletions(-)

diff --git a/CacheDatabase.go b/CacheDatabase.go
index 29bd4a0..035ffbb 100644
--- a/CacheDatabase.go
+++ b/CacheDatabase.go
@@ -1,6 +1,7 @@
 package main
 
 import "fmt"
+import "time"
 import "database/sql"
 import _ "github.com/lib/pq"
 
@@ -19,12 +20,22 @@ func WriteObjectToCache(db *sql.DB, obj ObjectBase) ObjectBase {
 		WriteActivitytoCache(db, obj)
 	}
 
-	WriteObjectReplyToCache(db, obj)
-	WriteObjectReplyCache(db, obj)		
+	writeObjectReplyToDB(db, obj)	
 
 	return obj
 }
 
+func WriteObjectUpdatesToCache(db *sql.DB, obj ObjectBase) {
+	query := `update cacheactivitystream set updated=$1 where id=$2`
+	
+	_, e := db.Exec(query, time.Now().Format(time.RFC3339), obj.Id)
+	
+	if e != nil{
+		fmt.Println("error inserting updating inreplyto")
+		panic(e)			
+	}		
+}
+
 func WriteActivitytoCache(db *sql.DB, obj ObjectBase) {
 
 	obj.Name = EscapeString(obj.Name)
@@ -194,7 +205,7 @@ func GetObjectFromCache(db *sql.DB, id string) Collection {
 	var nColl Collection
 	var result []ObjectBase
 
-	query := `select id, name, content, type, published, updated, attributedto, attachment, preview, actor from cacheactivitystream where actor=$1 and id in (select id from cachereplies where inreplyto='') and type='Note' order by updated asc`	
+	query := `select id, name, content, type, published, updated, attributedto, attachment, preview, actor from cacheactivitystream where actor=$1 and id in (select id from replies where inreplyto='') and type='Note' order by updated asc`	
 
 	rows, err := db.Query(query, id)	
 
@@ -239,7 +250,7 @@ func WriteObjectReplyToCache(db *sql.DB, obj ObjectBase) {
 	for i, e := range obj.InReplyTo {
 		if(i == 0 || IsReplyInThread(db, obj.InReplyTo[0].Id, e.Id)){
 
-			query := `select id from cachereplies where id=$1`
+			query := `select id from replies where id=$1`
 
 			rows, err := db.Query(query, obj.Id)
 
@@ -320,7 +331,7 @@ func GetObjectRepliesCache(db *sql.DB, parent ObjectBase) (*CollectionBase, int,
 	var nColl CollectionBase
 	var result []ObjectBase
 
-	query := `select id, name, content, type, published, attributedto, attachment, preview, actor from cacheactivitystream WHERE id in (select id from cachereplies where inreplyto=$1) and type='Note' order by published asc`
+	query := `select id, name, content, type, published, attributedto, attachment, preview, actor from cacheactivitystream WHERE id in (select id from replies where inreplyto=$1) and type='Note' order by published asc`
 
 	rows, err := db.Query(query, parent.Id)	
 
@@ -380,7 +391,7 @@ func GetObjectRepliesRepliesCache(db *sql.DB, parent ObjectBase) (*CollectionBas
 	var nColl CollectionBase
 	var result []ObjectBase
 
-	query := `select id, name, content, type, published, attributedto, attachment, preview, actor from cacheactivitystream where id in (select id from cachereplies where inreplyto=$1) and type='Note' order by published asc`
+	query := `select id, name, content, type, published, attributedto, attachment, preview, actor from cacheactivitystream where id in (select id from replies where inreplyto=$1) and type='Note' order by published asc`
 
 	rows, err := db.Query(query, parent.Id)	
 
@@ -524,7 +535,7 @@ func DeleteObjectFromCache(db *sql.DB, id string) {
 	_, err = db.Exec(query, id)
 	CheckError(err, "could not delete object cache activitystream")
 
-	query = `delete from cachereplies where id=$1`
+	query = `delete from replies where id=$1`
 	_, err = db.Exec(query, id)
 	CheckError(err, "could not delete  cache replies activitystream")
 }
@@ -532,7 +543,7 @@ func DeleteObjectFromCache(db *sql.DB, id string) {
 func GetObjectPostsTotalCache(db *sql.DB, actor Actor) int{
 
 	count := 0
-	query := `select count(id) from cacheactivitystream where actor=$1 and id in (select id from cachereplies where inreplyto='' and type='Note')`
+	query := `select count(id) from cacheactivitystream where actor=$1 and id in (select id from replies where inreplyto='' and type='Note')`
 
 	rows, err := db.Query(query, actor.Id)	
 
@@ -550,7 +561,7 @@ func GetObjectPostsTotalCache(db *sql.DB, actor Actor) int{
 func GetObjectImgsTotalCache(db *sql.DB, actor Actor) int{
 
 	count := 0
-	query := `select count(attachment) from cacheactivitystream where actor=$1 and id in (select id from cachereplies where inreplyto='' and type='Note' )`
+	query := `select count(attachment) from cacheactivitystream where actor=$1 and id in (select id from replies where inreplyto='' and type='Note' )`
 
 	rows, err := db.Query(query, actor.Id)	
 
diff --git a/Database.go b/Database.go
index ea1b031..cce0fcd 100644
--- a/Database.go
+++ b/Database.go
@@ -235,7 +235,11 @@ func writeObjectReplyToDB(db *sql.DB, obj ObjectBase) {
 		}
 		
 		if update {
-			WriteObjectUpdatesToDB(db, e)
+			if IsObjectLocal(db, e.Id) {
+				WriteObjectUpdatesToDB(db, e)
+			} else {
+				WriteObjectUpdatesToCache(db, e)
+			}
 		}			
 	}
 }
diff --git a/main.go b/main.go
index 7887138..e740232 100644
--- a/main.go
+++ b/main.go
@@ -1027,7 +1027,7 @@ func CreateObject(objType string) ObjectBase {
 }
 
 func AddFollowersToActivity(db *sql.DB, activity Activity) Activity{
-	followers := GetActorFollowingDB(db, activity.Actor.Id)
+	followers := GetActorFollowDB(db, activity.Actor.Id)
 
 	for _, e := range followers {
 		activity.To = append(activity.To, e.Id)
-- 
cgit v1.2.3