diff options
author | Emile <hanemile@protonmail.com> | 2019-03-07 16:14:12 +0100 |
---|---|---|
committer | Emile <hanemile@protonmail.com> | 2019-03-07 16:14:12 +0100 |
commit | c8ca77ad65e9c0b31c6bd5289de0c1d332c06e63 (patch) | |
tree | ead406696f0c02a6b51e49a7dbcbbd1afce848c4 /backend/delete.go | |
parent | 4d7880421ddc732d2f9fd3a2eaf1ca2c22a485c6 (diff) |
subdivided the project into multiple logical compartments
Diffstat (limited to 'backend/delete.go')
-rw-r--r-- | backend/delete.go | 47 |
1 files changed, 47 insertions, 0 deletions
diff --git a/backend/delete.go b/backend/delete.go new file mode 100644 index 0000000..bc463dd --- /dev/null +++ b/backend/delete.go @@ -0,0 +1,47 @@ +package backend + +import ( + "database/sql" + "fmt" + "log" +) + +// deleteAll Stars deletes all the rows in the stars table +func DeleteAllStars(database *sql.DB) { + db = database + // build the query creating a new node + query := "DELETE FROM stars WHERE TRUE" + + // execute the query + rows, err := db.Query(query) + defer rows.Close() + if err != nil { + log.Fatalf("[ E ] deleteAllStars query: %v\n\t\t\t query: %s\n", err, query) + } +} + +// deleteAll Stars deletes all the rows in the nodes table +func DeleteAllNodes(database *sql.DB) { + db = database + // build the query creating a new node + query := "DELETE FROM nodes WHERE TRUE" + + // execute the query + _, err := db.Query(query) + if err != nil { + log.Fatalf("[ E ] deleteAllStars query: %v\n\t\t\t query: %s\n", err, query) + } +} + +// removeStarFromNode removes the star from the node with the given ID +func removeStarFromNode(nodeID int64) { + // build the query + query := fmt.Sprintf("UPDATE nodes SET star_id=0 WHERE node_id=%d", nodeID) + + // Execute the query + rows, err := db.Query(query) + defer rows.Close() + if err != nil { + log.Fatalf("[ E ] removeStarFromNode query: %v\n\t\t\t query: %s\n", err, query) + } +} |