Changeset 149 in code for trunk/db.go

Timestamp:

Mar 25, 2020, 1:23:41 PM (5 years ago)

Author:

contact

Message:

Correctly set Channel.ID in DB.StoreChannel

File:

• trunk/db.go (modified) (3 diffs)

trunk/db.go

@@ -32 +32 @@
         Pass     string
         SASL     SASL
+}
+
+func (net *Network) GetName() string {
+        if net.Name != "" {
+                return net.Name
+        }
+        return net.Addr
 }
 
@@ -226 +233 @@
 
         key := toStringPtr(ch.Key)
-        _, err := db.db.Exec(`INSERT OR REPLACE INTO Channel(network, name, key)
-                VALUES (?, ?, ?)`, networkID, ch.Name, key)
+
+        var err error
+        if ch.ID != 0 {
+                _, err = db.db.Exec(`UPDATE Channel
+                        SET network = ?, name = ?, key = ?
+                        WHERE id = ?`, networkID, ch.Name, key, ch.ID)
+        } else {
+                var res sql.Result
+                res, err = db.db.Exec(`INSERT INTO Channel(network, name, key)
+                        VALUES (?, ?, ?)`, networkID, ch.Name, key)
+                if err != nil {
+                        return err
+                }
+                ch.ID, err = res.LastInsertId()
+        }
         return err
 }
@@ -238 +258 @@
         return err
 }
-
-func (net *Network) GetName() string {
-        if net.Name != "" {
-                return net.Name
-        }
-        return net.Addr
-}