constants.js

export const sqlDataTypes = [
  "INT",
  "SMALLINT",
  "BIGINT",
  "DECIMAL",
  "NUMERIC",
  "FLOAT",
  "DOUBLE",
  "REAL",
  "CHAR",
  "VARCHAR",
  "TEXT",
  "DATE",
  "TIME",
  "TIMESTAMP",
  "DATETIME",
  "BOOLEAN",
  "BINARY",
  "VARBINARY",
  "BLOB",
  "JSON",
  "UUID",
  "ENUM",
  "SET",
];

export const tableThemes = [
  "#f03c3c",
  "#ff4f81",
  "#bc49c4",
  "#a751e8",
  "#7c4af0",
  "#6360f7",
  "#7d9dff",
  "#32c9b0",
  "#3cde7d",
  "#89e667",
  "#ffe159",
  "#ff9159",
];

export const noteThemes = [
  "#ffdfd9",
  "#fcf7ac",
  "#cffcb1",
  "#c7d2ff",
  "#e7c7ff",
];

export const defaultBlue = "#175e7a";
export const defaultNoteTheme = "#fcf7ac";
export const tableHeaderHeight = 50;
export const tableWidth = 200;
export const tableFieldHeight = 36;
export const tableColorStripHeight = 7;

export const Cardinality = {
  ONE_TO_ONE: "One to one",
  ONE_TO_MANY: "One to many",
  MANY_TO_ONE: "Many to one",
};

export const Constraint = {
  NONE: "No action",
  RESTRICT: "Restrict",
  CASCADE: "Cascade",
  SET_NULL: "Set null",
  SET_DEFAULT: "Set default",
};

export const Tab = {
  TABLES: "1",
  RELATIONSHIPS: "2",
  AREAS: "3",
  NOTES: "4",
  TYPES: "5",
};

export const ObjectType = {
  NONE: 0,
  TABLE: 1,
  AREA: 2,
  NOTE: 3,
  RELATIONSHIP: 4,
  TYPE: 5,
};

export const Action = {
  ADD: 0,
  MOVE: 1,
  DELETE: 2,
  EDIT: 3,
  PAN: 4,
};

export const State = {
  NONE: 0,
  SAVING: 1,
  SAVED: 2,
  LOADING: 3,
  ERROR: 4,
};

export const MODAL = {
  NONE: 0,
  IMG: 1,
  CODE: 2,
  IMPORT: 3,
  RENAME: 4,
  OPEN: 5,
  SAVEAS: 6,
  NEW: 7,
  IMPORT_SRC: 8,
  TABLE_WIDTH: 9,
};

export const STATUS = {
  NONE: 0,
  WARNING: 1,
  ERROR: 2,
  OK: 3,
};

export const SIDESHEET = {
  NONE: 0,
  TODO: 1,
  TIMELINE: 2,
};

export const SQL_TO_DJANGO_TYPE_MAPPING = {
  'INT': 'IntegerField',
  'TINYINT': 'SmallIntegerField',
  'SMALLINT': 'SmallIntegerField',
  'MEDIUMINT': 'IntegerField',
  'BIGINT': 'BigIntegerField',
  'FLOAT': 'FloatField',
  'DOUBLE': 'FloatField',
  'DECIMAL': 'DecimalField',
  'DATE': 'DateField',
  'TIME': 'TimeField',
  'DATETIME': 'DateTimeField',
  'TIMESTAMP': 'DateTimeField',
  'YEAR': 'IntegerField',
  'CHAR': 'CharField',
  'VARCHAR': 'CharField',
  'TEXT': 'TextField',
  'BLOB': 'BinaryField',
  'MEDIUMBLOB': 'BinaryField',
  'LONGBLOB': 'BinaryField',
  'TINYBLOB': 'BinaryField',
};

export const SQL_TO_DJANGO_DELETE_CONSTRAINT_MAPPING = {
  'NO ACTION': 'DO_NOTHING',
  'RESTRICT': 'PROTECT',
  'CASCADE': 'CASCADE',
  'SET NULL': 'SET_NULL',
  'SET DEFAULT': 'SET_DEFAULT',
};

export const SQL_TO_DJANGO_UPDATE_CONSTRAINT_MAPPING = {
  'NO ACTION': 'DO_NOTHING',
  'RESTRICT': 'PROTECT',
  'CASCADE': 'CASCADE',
  'SET NULL': 'SET_NULL',
  'SET DEFAULT': 'SET_DEFAULT',
};