Changeset 90 in code for trunk/db.go

Timestamp:

Mar 12, 2020, 6:17:06 PM (5 years ago)

Author:

contact

Message:

Store NICK changes in the DB

File:

• trunk/db.go (modified) (1 diff)

trunk/db.go

@@ -118 +118 @@
 }
 
+func (db *DB) StoreNetwork(username string, network *Network) error {
+        db.lock.Lock()
+        defer db.lock.Unlock()
+
+        var netUsername, netRealname *string
+        if network.Username != "" {
+                netUsername = &network.Username
+        }
+        if network.Realname != "" {
+                netRealname = &network.Realname
+        }
+
+        var err error
+        if network.ID != 0 {
+                _, err = db.db.Exec("UPDATE Network SET addr = ?, nick = ?, username = ?, realname = ? WHERE id = ?", network.Addr, network.Nick, netUsername, netRealname, network.ID)
+        } else {
+                var res sql.Result
+                res, err = db.db.Exec("INSERT INTO Network(user, addr, nick, username, realname) VALUES (?, ?, ?, ?, ?)", username, network.Addr, network.Nick, netUsername, netRealname)
+                if err != nil {
+                        return err
+                }
+                network.ID, err = res.LastInsertId()
+        }
+        return err
+}
+
 func (db *DB) ListChannels(networkID int64) ([]Channel, error) {
         db.lock.RLock()