/*
 *  This file is part of CoCalc: Copyright © 2020 Sagemath, Inc.
 *  License: AGPLv3 s.t. "Commons Clause" – see LICENSE.md for details
 */

import { Table } from "./types";

Table({
  name: "system_notifications",
  fields: {
    id: {
      type: "uuid",
      desc: "primary key",
    },
    time: {
      type: "timestamp",
      desc: "time of this message",
    },
    text: {
      type: "string",
      desc: "the text of the message",
    },
    priority: {
      type: "string",
      pg_type: "VARCHAR(6)",
      desc: 'one of "low", "medium", or "high"',
    },
    done: {
      type: "boolean",
      desc: "if true, then this notification is no longer relevant",
    },
  },
  rules: {
    primary_key: "id",
    db_standby: "unsafe",
    anonymous: true, // allow users read access, even if not signed in
    user_query: {
      get: {
        pg_where: ["time >= NOW() - INTERVAL '1 hour'"],
        pg_changefeed: "one-hour",
        throttle_changes: 3000,
        fields: {
          id: null,
          time: null,
          text: "",
          priority: "low",
          done: false,
        },
      },
      set: {
        admin: true,
        fields: {
          id: true,
          time: true,
          text: true,
          priority: true,
          done: true,
        },
      },
    },
  },
});