Changeset 421 in code for trunk/contrib

Timestamp:

Oct 24, 2020, 1:14:23 PM (5 years ago)

Author:

contact

Message:

Switch DB API to user IDs

This commit changes the Network schema to use user IDs instead of
usernames. While at it, a new UNIQUE(user, name) constraint ensures
there is no conflict with custom network names.

Closes: ​https://todo.sr.ht/~emersion/soju/86
References: ​https://todo.sr.ht/~emersion/soju/29

File:

• trunk/contrib/znc-import.go (modified) (2 diffs)

trunk/contrib/znc-import.go

@@ -115 +115 @@
                         log.Fatalf("failed to store user %q: %v", username, err)
                 }
-
-                l, err := db.ListNetworks(username)
+                userID := u.ID
+
+                l, err := db.ListNetworks(userID)
                 if err != nil {
                         log.Fatalf("failed to list networks for user %q: %v", username, err)
@@ -182 +183 @@
                         n.Pass = pass
 
-                        if err := db.StoreNetwork(username, n); err != nil {
+                        if err := db.StoreNetwork(userID, n); err != nil {
                                 logger.Fatalf("failed to store network: %v", err)
                         }