Changeset 542 in code for trunk/db_sqlite.go

Timestamp:

May 26, 2021, 8:51:02 AM (4 years ago)

Author:

contact

Message:

Allow networks to be disabled

File:

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

trunk/db_sqlite.go

@@ -35 +35 @@
         sasl_external_cert BLOB DEFAULT NULL,
         sasl_external_key BLOB DEFAULT NULL,
+        enabled INTEGER NOT NULL DEFAULT 1,
         FOREIGN KEY(user) REFERENCES User(id),
         UNIQUE(user, addr, nick),
@@ -132 +133 @@
         `,
         "ALTER TABLE Channel ADD COLUMN detached_internal_msgid VARCHAR(255)",
+        "ALTER TABLE Network ADD COLUMN enabled INTEGER NOT NULL DEFAULT 1",
 }
 
@@ -313 +315 @@
         rows, err := db.db.Query(`SELECT id, name, addr, nick, username, realname, pass,
                         connect_commands, sasl_mechanism, sasl_plain_username, sasl_plain_password,
-                        sasl_external_cert, sasl_external_key
+                        sasl_external_cert, sasl_external_key, enabled
                 FROM Network
                 WHERE user = ?`,
@@ -329 +331 @@
                 err := rows.Scan(&net.ID, &name, &net.Addr, &net.Nick, &username, &realname,
                         &pass, &connectCommands, &saslMechanism, &saslPlainUsername, &saslPlainPassword,
-                        &net.SASL.External.CertBlob, &net.SASL.External.PrivKeyBlob)
+                        &net.SASL.External.CertBlob, &net.SASL.External.PrivKeyBlob, &net.Enabled)
                 if err != nil {
                         return nil, err
@@ -383 +385 @@
                         SET name = ?, addr = ?, nick = ?, username = ?, realname = ?, pass = ?, connect_commands = ?,
                                 sasl_mechanism = ?, sasl_plain_username = ?, sasl_plain_password = ?,
-                                sasl_external_cert = ?, sasl_external_key = ?
+                                sasl_external_cert = ?, sasl_external_key = ?, enabled = ?
                         WHERE id = ?`,
                         netName, network.Addr, network.Nick, netUsername, realname, pass, connectCommands,
                         saslMechanism, saslPlainUsername, saslPlainPassword,
-                        network.SASL.External.CertBlob, network.SASL.External.PrivKeyBlob,
+                        network.SASL.External.CertBlob, network.SASL.External.PrivKeyBlob, network.Enabled,
                         network.ID)
         } else {
@@ -393 +395 @@
                 res, err = db.db.Exec(`INSERT INTO Network(user, name, addr, nick, username,
                                 realname, pass, connect_commands, sasl_mechanism, sasl_plain_username,
-                                sasl_plain_password, sasl_external_cert, sasl_external_key)
-                        VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,
+                                sasl_plain_password, sasl_external_cert, sasl_external_key, enabled)
+                        VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,
                         userID, netName, network.Addr, network.Nick, netUsername, realname, pass, connectCommands,
                         saslMechanism, saslPlainUsername, saslPlainPassword, network.SASL.External.CertBlob,
-                        network.SASL.External.PrivKeyBlob)
+                        network.SASL.External.PrivKeyBlob, network.Enabled)
                 if err != nil {
                         return err