github.com/minio/console@v1.4.1/web-app/src/screens/Console/EventDestinations/CustomForms/ConfPostgres.tsx

// This file is part of MinIO Console Server
// Copyright (c) 2021 MinIO, Inc.
//
// This program is free software: you can redistribute it and/or modify
// it under the terms of the GNU Affero General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU Affero General Public License for more details.
//
// You should have received a copy of the GNU Affero General Public License
// along with this program.  If not, see <http://www.gnu.org/licenses/>.

import React, { Fragment, useCallback, useEffect, useState } from "react";
import {
  Box,
  CommentBox,
  FormLayout,
  Grid,
  InputBox,
  RadioGroup,
  ReadBox,
  Select,
  Switch,
} from "mds";
import { IElementValue } from "../../Configurations/types";

interface IConfPostgresProps {
  onChange: (newValue: IElementValue[]) => void;
}

const ConfPostgres = ({ onChange }: IConfPostgresProps) => {
  //Local States
  const [useConnectionString, setUseConnectionString] =
    useState<boolean>(false);
  const [connectionString, setConnectionString] = useState<string>("");
  const [host, setHostname] = useState<string>("");
  const [dbName, setDbName] = useState<string>("");
  const [port, setPort] = useState<string>("");
  const [user, setUser] = useState<string>("");
  const [password, setPassword] = useState<string>("");
  const [sslMode, setSslMode] = useState<string>(" ");

  const [table, setTable] = useState<string>("");
  const [format, setFormat] = useState<string>("namespace");
  const [queueDir, setQueueDir] = useState<string>("");
  const [queueLimit, setQueueLimit] = useState<string>("");
  const [comment, setComment] = useState<string>("");

  // connection_string*  (string)             Postgres server connection-string e.g. "host=localhost port=5432 dbname=minio_events user=postgres password=password sslmode=disable"

  //  "host=localhost
  // port=5432
  //dbname=minio_events
  //user=postgres
  //password=password
  //sslmode=disable"

  // table*              (string)             DB table name to store/update events, table is auto-created
  // format*             (namespace*|access)  'namespace' reflects current bucket/object list and 'access' reflects a journal of object operations, defaults to 'namespace'
  // queue_dir           (path)               staging dir for undelivered messages e.g. '/home/events'
  // queue_limit         (number)             maximum limit for undelivered messages, defaults to '10000'
  // comment             (sentence)           optionally add a comment to this setting

  const KvSeparator = "=";
  const parseConnectionString = (
    input: string,
    keys: string[],
  ): Map<string, string> => {
    let valueIndexes: number[] = [];

    for (const key of keys) {
      const i = input.indexOf(key + KvSeparator);
      if (i === -1) {
        continue;
      }
      valueIndexes.push(i);
    }
    valueIndexes.sort((n1, n2) => n1 - n2);

    let kvFields = new Map<string, string>();
    let fields: string[] = new Array<string>(valueIndexes.length);
    for (let i = 0; i < valueIndexes.length; i++) {
      const j = i + 1;
      if (j < valueIndexes.length) {
        fields[i] = input.slice(valueIndexes[i], valueIndexes[j]);
      } else {
        fields[i] = input.slice(valueIndexes[i]);
      }
    }

    for (let field of fields) {
      if (field === undefined) {
        continue;
      }
      const key = field.slice(0, field.indexOf("="));
      const value = field.slice(field.indexOf("=") + 1).trim();
      kvFields.set(key, value);
    }
    return kvFields;
  };

  const configToString = useCallback((): string => {
    let strValue = "";
    if (host !== "") {
      strValue = `${strValue} host=${host}`;
    }
    if (dbName !== "") {
      strValue = `${strValue} dbname=${dbName}`;
    }
    if (user !== "") {
      strValue = `${strValue} user=${user}`;
    }
    if (password !== "") {
      strValue = `${strValue} password=${password}`;
    }
    if (port !== "") {
      strValue = `${strValue} port=${port}`;
    }
    if (sslMode !== " ") {
      strValue = `${strValue} sslmode=${sslMode}`;
    }

    strValue = `${strValue} `;

    return strValue.trim();
  }, [host, dbName, user, password, port, sslMode]);

  useEffect(() => {
    if (connectionString !== "") {
      const formValues = [
        { key: "connection_string", value: connectionString },
        { key: "table", value: table },
        { key: "format", value: format },
        { key: "queue_dir", value: queueDir },
        { key: "queue_limit", value: queueLimit },
        { key: "comment", value: comment },
      ];

      onChange(formValues);
    }
  }, [
    connectionString,
    table,
    format,
    queueDir,
    queueLimit,
    comment,
    onChange,
  ]);

  useEffect(() => {
    const cs = configToString();
    setConnectionString(cs);
  }, [
    user,
    dbName,
    password,
    port,
    sslMode,
    host,
    setConnectionString,
    configToString,
  ]);

  useEffect(() => {
    if (useConnectionString) {
      // build connection_string
      const cs = configToString();
      setConnectionString(cs);

      return;
    }
    // parse connection_string
    const kv = parseConnectionString(connectionString, [
      "host",
      "port",
      "dbname",
      "user",
      "password",
      "sslmode",
    ]);
    setHostname(kv.get("host") ? kv.get("host") + "" : "");
    setPort(kv.get("port") ? kv.get("port") + "" : "");
    setDbName(kv.get("dbname") ? kv.get("dbname") + "" : "");
    setUser(kv.get("user") ? kv.get("user") + "" : "");
    setPassword(kv.get("password") ? kv.get("password") + "" : "");
    setSslMode(kv.get("sslmode") ? kv.get("sslmode") + "" : " ");

    // eslint-disable-next-line react-hooks/exhaustive-deps
  }, [useConnectionString]);

  return (
    <FormLayout containerPadding={false} withBorders={false}>
      <Switch
        label={"Manually Configure String"}
        checked={useConnectionString}
        id="manualString"
        name="manualString"
        onChange={(e) => {
          setUseConnectionString(e.target.checked);
        }}
        value={"manualString"}
      />
      {useConnectionString ? (
        <Fragment>
          <InputBox
            id="connection-string"
            name="connection_string"
            label="Connection String"
            value={connectionString}
            onChange={(e: React.ChangeEvent<HTMLInputElement>) => {
              setConnectionString(e.target.value);
            }}
          />
        </Fragment>
      ) : (
        <Fragment>
          <Grid item xs={12}>
            <Box
              withBorders
              useBackground
              sx={{
                overflowY: "auto",
                height: 170,
                marginBottom: 12,
              }}
            >
              <InputBox
                id="host"
                name="host"
                label=""
                placeholder="Enter Host"
                value={host}
                onChange={(e: React.ChangeEvent<HTMLInputElement>) => {
                  setHostname(e.target.value);
                }}
              />
              <InputBox
                id="db-name"
                name="db-name"
                label=""
                placeholder="Enter DB Name"
                value={dbName}
                onChange={(e: React.ChangeEvent<HTMLInputElement>) => {
                  setDbName(e.target.value);
                }}
              />
              <InputBox
                id="port"
                name="port"
                label=""
                placeholder="Enter Port"
                value={port}
                onChange={(e: React.ChangeEvent<HTMLInputElement>) => {
                  setPort(e.target.value);
                }}
              />
              <Select
                value={sslMode}
                label=""
                id="sslmode"
                name="sslmode"
                onChange={(value): void => {
                  if (value) {
                    setSslMode(value + "");
                  }
                }}
                options={[
                  { label: "Enter SSL Mode", value: " " },
                  { label: "Require", value: "require" },
                  { label: "Disable", value: "disable" },
                  { label: "Verify CA", value: "verify-ca" },
                  { label: "Verify Full", value: "verify-full" },
                ]}
              />
              <InputBox
                id="user"
                name="user"
                label=""
                placeholder="Enter User"
                value={user}
                onChange={(e: React.ChangeEvent<HTMLInputElement>) => {
                  setUser(e.target.value);
                }}
              />
              <InputBox
                id="password"
                name="password"
                label=""
                type="password"
                placeholder="Enter Password"
                value={password}
                onChange={(e: React.ChangeEvent<HTMLInputElement>) => {
                  setPassword(e.target.value);
                }}
              />
            </Box>
          </Grid>
          <ReadBox label={"Connection String"} multiLine>
            {connectionString}
          </ReadBox>
        </Fragment>
      )}
      <InputBox
        id="table"
        name="table"
        label="Table"
        placeholder={"Enter Table Name"}
        value={table}
        tooltip="DB table name to store/update events, table is auto-created"
        onChange={(e: React.ChangeEvent<HTMLInputElement>) => {
          setTable(e.target.value);
        }}
      />
      <RadioGroup
        currentValue={format}
        id="format"
        name="format"
        label="Format"
        onChange={(e) => {
          setFormat(e.target.value);
        }}
        tooltip="'namespace' reflects current bucket/object list and 'access' reflects a journal of object operations, defaults to 'namespace'"
        selectorOptions={[
          { label: "Namespace", value: "namespace" },
          { label: "Access", value: "access" },
        ]}
      />
      <InputBox
        id="queue-dir"
        name="queue_dir"
        label="Queue Dir"
        placeholder="Enter Queue Directory"
        value={queueDir}
        tooltip="Staging directory for undelivered messages e.g. '/home/events'"
        onChange={(e: React.ChangeEvent<HTMLInputElement>) => {
          setQueueDir(e.target.value);
        }}
      />
      <InputBox
        id="queue-limit"
        name="queue_limit"
        label="Queue Limit"
        placeholder="Enter Queue Limit"
        type="number"
        value={queueLimit}
        tooltip="Maximum limit for undelivered messages, defaults to '10000'"
        onChange={(e: React.ChangeEvent<HTMLInputElement>) => {
          setQueueLimit(e.target.value);
        }}
      />
      <CommentBox
        id="comment"
        name="comment"
        label="Comment"
        placeholder="Enter custom notes if any"
        value={comment}
        onChange={(e) => {
          setComment(e.target.value);
        }}
      />
    </FormLayout>
  );
};

export default ConfPostgres;