aboutsummaryrefslogtreecommitdiff
path: root/db/blacklist.go
diff options
context:
space:
mode:
Diffstat (limited to 'db/blacklist.go')
-rw-r--r--db/blacklist.go76
1 files changed, 0 insertions, 76 deletions
diff --git a/db/blacklist.go b/db/blacklist.go
deleted file mode 100644
index 4d88e10..0000000
--- a/db/blacklist.go
+++ /dev/null
@@ -1,76 +0,0 @@
-package db
-
-import "regexp"
-
-type PostBlacklist struct {
- Id int
- Regex string
-}
-
-func WriteRegexBlacklistDB(regex string) error {
- query := `select from postblacklist where regex=$1`
-
- rows, err := db.Query(query, regex)
- if err != nil {
- return err
- }
- defer rows.Close()
-
- var re string
- rows.Next()
- rows.Scan(&re)
-
- if re != "" {
- return nil
- }
-
- query = `insert into postblacklist (regex) values ($1)`
-
- _, err = db.Exec(query, regex)
- return err
-}
-
-func GetRegexBlacklistDB() ([]PostBlacklist, error) {
- var list []PostBlacklist
-
- query := `select id, regex from postblacklist`
-
- rows, err := db.Query(query)
- if err != nil {
- return list, err
- }
-
- defer rows.Close()
- for rows.Next() {
- var temp PostBlacklist
- rows.Scan(&temp.Id, &temp.Regex)
-
- list = append(list, temp)
- }
-
- return list, nil
-}
-
-func DeleteRegexBlacklistDB(id int) error {
- query := `delete from postblacklist where id=$1`
-
- _, err := db.Exec(query, id)
- return err
-}
-
-func IsPostBlacklist(comment string) (bool, error) {
- postblacklist, err := GetRegexBlacklistDB()
- if err != nil {
- return false, err
- }
-
- for _, e := range postblacklist {
- re := regexp.MustCompile(e.Regex)
-
- if re.MatchString(comment) {
- return true, nil
- }
- }
-
- return false, nil
-}