eslint-plugin-sequelize-node
Advanced tools
Comparing version 0.3.0 to 0.3.1
@@ -12,11 +12,11 @@ const reportMessage = ` | ||
best to add the column first, then add the constraint of NOT NULL safely, | ||
like mentioned below. | ||
like mentioned below using the four statements: | ||
ALTER TABLE $table-name ADD CONSTRAINT $constraint-name CHECK ($column-name IS NOT NULL) NOT VALID; | ||
1. ALTER TABLE $table-name ADD CONSTRAINT $constraint-name CHECK ($column-name IS NOT NULL) NOT VALID; | ||
ALTER TABLE $table-name validate CONSTRAINT $constraint-name; -- performs seq scan but doesn't block read/writes. | ||
2. ALTER TABLE $table-name validate CONSTRAINT $constraint-name; -- performs seq scan but doesn't block read/writes. | ||
ALTER TABLE $table-name ALTER COLUMN workspace SET NOT NULL; | ||
3. ALTER TABLE $table-name ALTER COLUMN workspace SET NOT NULL; | ||
ALTER TABLE $table-name DROP CONSTRAINT $constraint-name; | ||
4. ALTER TABLE $table-name DROP CONSTRAINT $constraint-name; | ||
`; | ||
@@ -23,0 +23,0 @@ |
@@ -8,3 +8,3 @@ { | ||
}, | ||
"version": "0.3.0", | ||
"version": "0.3.1", | ||
"main": "./lib/index.js", | ||
@@ -11,0 +11,0 @@ "devDependencies": { |
@@ -36,12 +36,12 @@ # eslint-plugin-sequelize-node | ||
best to add the column first, then add the constraint of NOT NULL safely, | ||
like mentioned below. | ||
like mentioned below using the four statements: | ||
```sql | ||
ALTER TABLE $table-name ADD CONSTRAINT $constraint-name CHECK ($column-name IS NOT NULL) NOT VALID; | ||
1. ALTER TABLE $table-name ADD CONSTRAINT $constraint-name CHECK ($column-name IS NOT NULL) NOT VALID; | ||
ALTER TABLE $table-name validate CONSTRAINT $constraint-name; -- performs seq scan but doesn't block read/writes. | ||
2. ALTER TABLE $table-name validate CONSTRAINT $constraint-name; -- performs seq scan but doesn't block read/writes. | ||
ALTER TABLE $table-name ALTER COLUMN workspace SET NOT NULL; | ||
3. ALTER TABLE $table-name ALTER COLUMN workspace SET NOT NULL; | ||
ALTER TABLE $table-name DROP CONSTRAINT $constraint-name; | ||
4. ALTER TABLE $table-name DROP CONSTRAINT $constraint-name; | ||
``` | ||
@@ -48,0 +48,0 @@ |
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
18782