MCPcopy Create free account
hub / github.com/outerbase/studio / generateConstraintScript

Function generateConstraintScript

src/drivers/postgres/generate-schema.ts:121–138  ·  view source on GitHub ↗
(
  driver: BaseDriver,
  con: DatabaseTableColumnConstraint
)

Source from the content-addressed store, hash-verified

119}
120
121function generateConstraintScript(
122 driver: BaseDriver,
123 con: DatabaseTableColumnConstraint
124) {
125 if (con.primaryKey) {
126 return `PRIMARY KEY (${con.primaryColumns?.map(driver.escapeId).join(", ")})`;
127 } else if (con.unique) {
128 return `UNIQUE (${con.uniqueColumns?.map(driver.escapeId).join(", ")})`;
129 } else if (con.checkExpression !== undefined) {
130 return `CHECK (${con.checkExpression})`;
131 } else if (con.foreignKey) {
132 return (
133 `FOREIGN KEY (${con.foreignKey.columns?.map(driver.escapeId).join(", ")}) ` +
134 `REFERENCES ${driver.escapeId(con.foreignKey.foreignTableName ?? "")} ` +
135 `(${con.foreignKey.foreignColumns?.map(driver.escapeId).join(", ")})`
136 );
137 }
138}
139
140function generateConstraintModifyScript(
141 driver: BaseDriver,

Callers 2

Calls 1

escapeIdMethod · 0.45

Tested by

no test coverage detected