Function generateConstraintScript

src/drivers/sqlite/sqlite-generate-schema.ts:102–116

(con: DatabaseTableColumnConstraint)

}

function generateConstraintScript(con: DatabaseTableColumnConstraint) {
  if (con.primaryKey) {
    return `PRIMARY KEY (${con.primaryColumns?.map(escapeIdentity).join(", ")})`;
  } else if (con.unique) {
    return `UNIQUE (${con.uniqueColumns?.map(escapeIdentity).join(", ")})`;
  } else if (con.checkExpression !== undefined) {
    return `CHECK (${con.checkExpression})`;
  } else if (con.foreignKey) {
    return (
      `FOREIGN KEY (${con.foreignKey.columns?.map(escapeIdentity).join(", ")}) ` +
      `REFERENCES ${escapeIdentity(con.foreignKey.foreignTableName ?? "")} ` +
      `(${con.foreignKey.foreignColumns?.map(escapeIdentity).join(", ")})`
    );
  }
}

export default function generateSqlSchemaChange(
  change: DatabaseTableSchemaChange