Changeset 774 in code for trunk/db_postgres.go

Timestamp:

Feb 8, 2022, 2:38:41 PM (3 years ago)

Author:

contact

Message:

db_postgres: use enum for sasl_mechanism

Ensures only supported mechanisms get stored in the DB.

File:

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

trunk/db_postgres.go

@@ -33 +33 @@
         realname VARCHAR(255)
 );
+
+CREATE TYPE sasl_mechanism AS ENUM ('PLAIN', 'EXTERNAL');
 
 CREATE TABLE "Network" (
@@ -44 +46 @@
         pass VARCHAR(255),
         connect_commands VARCHAR(1023),
-        sasl_mechanism VARCHAR(255),
+        sasl_mechanism sasl_mechanism,
         sasl_plain_username VARCHAR(255),
         sasl_plain_password VARCHAR(255),
@@ -81 +83 @@
         "", // migration #0 is reserved for schema initialization
         `ALTER TABLE "Network" ALTER COLUMN nick DROP NOT NULL`,
+        `
+                CREATE TYPE sasl_mechanism AS ENUM ('PLAIN', 'EXTERNAL');
+                ALTER TABLE "Network"
+                        ALTER COLUMN sasl_mechanism
+                        TYPE sasl_mechanism
+                        USING sasl_mechanism::sasl_mechanism;
+        `,
 }