Function toMSSQL

src/utils/exportSQL/mssql.js:39–127

(diagram)

}

export function toMSSQL(diagram) {
  const tablesSql = diagram.tables
    .map((table) => {
      const fieldsSql = table.fields
        .map((field) => {
          const typeMetaData = dbToTypes[DB.MSSQL][field.type.toUpperCase()];
          const isSized = typeMetaData.isSized || typeMetaData.hasPrecision;

          return `\t[${field.name}] ${field.type}${field.size && isSized ? `(${field.size})` : ""}${
            field.notNull ? " NOT NULL" : ""
          }${field.increment ? " IDENTITY" : ""}${
            field.unique ? " UNIQUE" : ""
          }${
            field.default !== ""
              ? ` DEFAULT ${parseDefault(field, diagram.database)}`
              : ""
          }${
            field.check === "" ||
            !dbToTypes[diagram.database][field.type].hasCheck
              ? ""
              : ` CHECK(${field.check})`
          }`;
        })
        .join(",\n");

      const primaryKeys = table.fields.filter((f) => f.primary);
      const primaryKeySql =
        primaryKeys.length > 0
          ? `,\n\tPRIMARY KEY(${primaryKeys
              .map((f) => `[${f.name}]`)
              .join(", ")})`
          : "";

      const uniqueSql = uniqueConstraintClause(table, (s) => `[${s}]`);

      const createTableSql = `CREATE TABLE [${table.name}] (\n${fieldsSql}${primaryKeySql}${uniqueSql}\n);\nGO\n`;

      const tableCommentSql = generateAddExtendedPropertySQL(
        table.comment,
        table.name,
      );

      const columnCommentsSql = table.fields
        .map((field) =>
          generateAddExtendedPropertySQL(field.comment, table.name, field.name),
        )
        .join("");

      const indicesSql = table.indices
        .map(
          (i) =>
            `\nCREATE ${i.unique ? "UNIQUE " : ""}INDEX [${
              i.name
            }]\nON [${table.name}] (${i.fields
              .map((f) => `[${f}]`)
              .join(", ")});\nGO\n`,
        )
        .join("");