Function columnDefinition

src/utils/migrations/diffToSQL.js:31–69

(field, db)

}

function columnDefinition(field, db) {
  const meta =
    dbToTypes[db]?.[field.type] || dbToTypes[DB.GENERIC]?.[field.type];

  let typeStr = field.type;
  if (db === DB.MYSQL || db === DB.MARIADB) {
    typeStr = parseType(field, db);
  } else if (meta?.isSized || meta?.hasPrecision) {
    typeStr += field.size ? `(${field.size})` : "";
  }

  let sql = typeStr;

  if (db === DB.MYSQL || db === DB.MARIADB) {
    if (meta?.signed && field.unsigned) sql += " UNSIGNED";
  }
  if (field.notNull) sql += " NOT NULL";
  if (field.unique) sql += " UNIQUE";
  if (field.primary) sql += " PRIMARY KEY";

  if (field.increment) {
    if (db === DB.POSTGRES) sql += " GENERATED BY DEFAULT AS IDENTITY";
    else if (db === DB.MYSQL || db === DB.MARIADB) sql += " AUTO_INCREMENT";
    else if (db === DB.MSSQL) sql += " IDENTITY";
    else if (db === DB.ORACLESQL) sql += " GENERATED BY DEFAULT AS IDENTITY";
    else if (db === DB.SQLITE) sql += " AUTOINCREMENT";
  }

  if (field.default != null && field.default !== "") {
    sql += ` DEFAULT ${parseDefault(field, db)}`;
  }
  if (field.check && meta?.hasCheck) sql += ` CHECK(${field.check})`;
  if ((db === DB.MYSQL || db === DB.MARIADB) && field.comment?.trim()) {
    sql += ` COMMENT '${escapeQuotes(field.comment)}'`;
  }
  if (db === DB.POSTGRES && field.isArray) sql += " ARRAY";

  return sql;
}

function toTable(table, db) {
  const q = getQuote(db);