Changeset 568 in code for trunk/db_sqlite.go

Timestamp:

Jun 25, 2021, 6:33:13 PM (4 years ago)

Author:

contact

Message:

Add per-user realname setting

This allows users to set a default realname used if the per-network
realname isn't set.

A new "user update" command is introduced and can be extended to edit
other user properties and other users in the future.

File:

• trunk/db_sqlite.go (modified) (4 diffs)

trunk/db_sqlite.go

@@ -17 +17 @@
         username VARCHAR(255) NOT NULL UNIQUE,
         password VARCHAR(255),
-        admin INTEGER NOT NULL DEFAULT 0
+        admin INTEGER NOT NULL DEFAULT 0,
+        realname VARCHAR(255)
 );
 
@@ -134 +135 @@
         "ALTER TABLE Channel ADD COLUMN detached_internal_msgid VARCHAR(255)",
         "ALTER TABLE Network ADD COLUMN enabled INTEGER NOT NULL DEFAULT 1",
+        "ALTER TABLE User ADD COLUMN realname VARCHAR(255)",
 }
 
@@ -243 +245 @@
         user := &User{Username: username}
 
-        var password sql.NullString
-        row := db.db.QueryRow("SELECT id, password, admin FROM User WHERE username = ?", username)
-        if err := row.Scan(&user.ID, &password, &user.Admin); err != nil {
+        var password, realname sql.NullString
+        row := db.db.QueryRow("SELECT id, password, admin, realname FROM User WHERE username = ?", username)
+        if err := row.Scan(&user.ID, &password, &user.Admin, &realname); err != nil {
                 return nil, err
         }
         user.Password = password.String
+        user.Realname = realname.String
         return user, nil
 }
@@ -257 +260 @@
 
         password := toNullString(user.Password)
+        realname := toNullString(user.Realname)
 
         var err error
         if user.ID != 0 {
-                _, err = db.db.Exec("UPDATE User SET password = ?, admin = ? WHERE username = ?",
-                        password, user.Admin, user.Username)
+                _, err = db.db.Exec("UPDATE User SET password = ?, admin = ?, realname = ? WHERE username = ?",
+                        password, user.Admin, realname, user.Username)
         } else {
                 var res sql.Result
-                res, err = db.db.Exec("INSERT INTO User(username, password, admin) VALUES (?, ?, ?)",
-                        user.Username, password, user.Admin)
+                res, err = db.db.Exec("INSERT INTO User(username, password, admin, realname) VALUES (?, ?, ?, ?)",
+                        user.Username, password, user.Admin, realname)
                 if err != nil {
                         return err