@dataform/assertion_utils - npm Package Compare versions

Comparing version 1.3.6 to 1.3.7

index.d.ts

@@ -9,2 +9,4 @@ /// <amd-module name="@dataform/assertion_utils" />
     getUniqueRowQuery(): string;
+    getNotNullQuery(field: string): string;
+    getAcceptedValuesQuery(field: string, acceptedValues: string | string[]): string;
 }

index.js

@@ -45,5 +45,23 @@ (function (factory) {
         }
+        getNotNullQuery(field) {
+            return `
+    SELECT
+      *
+    FROM ${this.dataset}
+    WHERE
+      ${field} IS NULL
+    `;
+        }
+        getAcceptedValuesQuery(field, acceptedValues) {
+            return `
+    SELECT
+      *
+    FROM ${this.dataset}
+    WHERE
+      ${field} NOT IN ${acceptedValues}
+    `;
+        }
     }
     exports.DatasetAssertion = DatasetAssertion;
 });
-//# sourceMappingURL=data:application/json;base64,eyJ2ZXJzaW9uIjozLCJmaWxlIjoiaW5kZXguanMiLCJzb3VyY2VSb290IjoiIiwic291cmNlcyI6WyIuLi8uLi8uLi8uLi9hc3NlcnRpb25fdXRpbHMvaW5kZXgudHMiXSwibmFtZXMiOltdLCJtYXBwaW5ncyI6Ijs7Ozs7Ozs7Ozs7SUFBQSxTQUFnQixVQUFVLENBQUMsT0FBZTtRQUN4QyxPQUFPLElBQUksZ0JBQWdCLENBQUMsT0FBTyxDQUFDLENBQUM7SUFDdkMsQ0FBQztJQUZELGdDQUVDO0lBRUQsTUFBYSxnQkFBZ0I7UUFHM0IsWUFBWSxPQUFlO1lBRG5CLGNBQVMsR0FBYSxFQUFFLENBQUM7WUFFL0IsSUFBSSxDQUFDLE9BQU8sR0FBRyxPQUFPLENBQUM7UUFDekIsQ0FBQztRQUVNLFNBQVMsQ0FBQyxJQUF1QjtZQUN0QyxJQUFJLENBQUMsU0FBUyxHQUFHLE9BQU8sSUFBSSxLQUFLLFFBQVEsQ0FBQyxDQUFDLENBQUMsQ0FBQyxJQUFJLENBQUMsQ0FBQyxDQUFDLENBQUMsSUFBSSxDQUFDO1lBQzFELE9BQU8sSUFBSSxDQUFDO1FBQ2QsQ0FBQztRQUVNLGlCQUFpQjtZQUN0QixPQUFPOzs7O1FBSUgsSUFBSSxDQUFDLFNBQVMsQ0FBQyxJQUFJLENBQUMsSUFBSSxDQUFDOztXQUV0QixJQUFJLENBQUMsT0FBTzs7UUFFZixJQUFJLENBQUMsU0FBUyxDQUFDLElBQUksQ0FBQyxJQUFJLENBQUM7Ozs7Ozs7OztLQVM1QixDQUFDO1FBQ0osQ0FBQztLQUNGO0lBaENELDRDQWdDQyIsInNvdXJjZXNDb250ZW50IjpbImV4cG9ydCBmdW5jdGlvbiBmb3JEYXRhc2V0KGRhdGFzZXQ6IHN0cmluZykge1xuICByZXR1cm4gbmV3IERhdGFzZXRBc3NlcnRpb24oZGF0YXNldCk7XG59XG5cbmV4cG9ydCBjbGFzcyBEYXRhc2V0QXNzZXJ0aW9uIHtcbiAgcHJpdmF0ZSByZWFkb25seSBkYXRhc2V0OiBzdHJpbmc7XG4gIHByaXZhdGUgZ3JvdXBDb2xzOiBzdHJpbmdbXSA9IFtdO1xuICBjb25zdHJ1Y3RvcihkYXRhc2V0OiBzdHJpbmcpIHtcbiAgICB0aGlzLmRhdGFzZXQgPSBkYXRhc2V0O1xuICB9XG5cbiAgcHVibGljIGdyb3VwZWRCeShjb2xzOiBzdHJpbmcgfCBzdHJpbmdbXSkge1xuICAgIHRoaXMuZ3JvdXBDb2xzID0gdHlwZW9mIGNvbHMgPT09IFwic3RyaW5nXCIgPyBbY29sc10gOiBjb2xzO1xuICAgIHJldHVybiB0aGlzO1xuICB9XG5cbiAgcHVibGljIGdldFVuaXF1ZVJvd1F1ZXJ5KCk6IHN0cmluZyB7XG4gICAgcmV0dXJuIGBcbiAgICBXSVRIIGJhc2UgQVMgKFxuICAgIFxuICAgIFNFTEVDVFxuICAgICAgJHt0aGlzLmdyb3VwQ29scy5qb2luKFwiLCBcIil9LFxuICAgICAgU1VNKDEpIGFzIHJvd19jb3VudFxuICAgIEZST00gJHt0aGlzLmRhdGFzZXR9XG4gICAgR1JPVVAgQlkgXG4gICAgICAke3RoaXMuZ3JvdXBDb2xzLmpvaW4oXCIsIFwiKX1cbiAgICApXG4gIFxuICAgIFNFTEVDVFxuICAgICAgKlxuICAgIEZST01cbiAgICAgIGJhc2VcbiAgICBXSEVSRVxuICAgICAgcm93X2NvdW50ID4gMVxuICAgIGA7XG4gIH1cbn1cbiJdfQ==
+//# sourceMappingURL=data:application/json;base64,eyJ2ZXJzaW9uIjozLCJmaWxlIjoiaW5kZXguanMiLCJzb3VyY2VSb290IjoiIiwic291cmNlcyI6WyIuLi8uLi8uLi8uLi9hc3NlcnRpb25fdXRpbHMvaW5kZXgudHMiXSwibmFtZXMiOltdLCJtYXBwaW5ncyI6Ijs7Ozs7Ozs7Ozs7SUFBQSxTQUFnQixVQUFVLENBQUMsT0FBZTtRQUN4QyxPQUFPLElBQUksZ0JBQWdCLENBQUMsT0FBTyxDQUFDLENBQUM7SUFDdkMsQ0FBQztJQUZELGdDQUVDO0lBRUQsTUFBYSxnQkFBZ0I7UUFHM0IsWUFBWSxPQUFlO1lBRG5CLGNBQVMsR0FBYSxFQUFFLENBQUM7WUFFL0IsSUFBSSxDQUFDLE9BQU8sR0FBRyxPQUFPLENBQUM7UUFDekIsQ0FBQztRQUVNLFNBQVMsQ0FBQyxJQUF1QjtZQUN0QyxJQUFJLENBQUMsU0FBUyxHQUFHLE9BQU8sSUFBSSxLQUFLLFFBQVEsQ0FBQyxDQUFDLENBQUMsQ0FBQyxJQUFJLENBQUMsQ0FBQyxDQUFDLENBQUMsSUFBSSxDQUFDO1lBQzFELE9BQU8sSUFBSSxDQUFDO1FBQ2QsQ0FBQztRQUVNLGlCQUFpQjtZQUN0QixPQUFPOzs7O1FBSUgsSUFBSSxDQUFDLFNBQVMsQ0FBQyxJQUFJLENBQUMsSUFBSSxDQUFDOztXQUV0QixJQUFJLENBQUMsT0FBTzs7UUFFZixJQUFJLENBQUMsU0FBUyxDQUFDLElBQUksQ0FBQyxJQUFJLENBQUM7Ozs7Ozs7OztLQVM1QixDQUFDO1FBQ0osQ0FBQztRQUVNLGVBQWUsQ0FBQyxLQUFhO1lBQ2xDLE9BQU87OztXQUdBLElBQUksQ0FBQyxPQUFPOztRQUVmLEtBQUs7S0FDUixDQUFBO1FBQ0gsQ0FBQztRQUVNLHNCQUFzQixDQUFDLEtBQWEsRUFBRSxjQUFpQztZQUM1RSxPQUFPOzs7V0FHQSxJQUFJLENBQUMsT0FBTzs7UUFFZixLQUFLLFdBQVcsY0FBYztLQUNqQyxDQUFBO1FBQ0gsQ0FBQztLQUNGO0lBcERELDRDQW9EQyIsInNvdXJjZXNDb250ZW50IjpbImV4cG9ydCBmdW5jdGlvbiBmb3JEYXRhc2V0KGRhdGFzZXQ6IHN0cmluZykge1xuICByZXR1cm4gbmV3IERhdGFzZXRBc3NlcnRpb24oZGF0YXNldCk7XG59XG5cbmV4cG9ydCBjbGFzcyBEYXRhc2V0QXNzZXJ0aW9uIHtcbiAgcHJpdmF0ZSByZWFkb25seSBkYXRhc2V0OiBzdHJpbmc7XG4gIHByaXZhdGUgZ3JvdXBDb2xzOiBzdHJpbmdbXSA9IFtdO1xuICBjb25zdHJ1Y3RvcihkYXRhc2V0OiBzdHJpbmcpIHtcbiAgICB0aGlzLmRhdGFzZXQgPSBkYXRhc2V0O1xuICB9XG5cbiAgcHVibGljIGdyb3VwZWRCeShjb2xzOiBzdHJpbmcgfCBzdHJpbmdbXSkge1xuICAgIHRoaXMuZ3JvdXBDb2xzID0gdHlwZW9mIGNvbHMgPT09IFwic3RyaW5nXCIgPyBbY29sc10gOiBjb2xzO1xuICAgIHJldHVybiB0aGlzO1xuICB9XG5cbiAgcHVibGljIGdldFVuaXF1ZVJvd1F1ZXJ5KCk6IHN0cmluZyB7XG4gICAgcmV0dXJuIGBcbiAgICBXSVRIIGJhc2UgQVMgKFxuICAgIFxuICAgIFNFTEVDVFxuICAgICAgJHt0aGlzLmdyb3VwQ29scy5qb2luKFwiLCBcIil9LFxuICAgICAgU1VNKDEpIGFzIHJvd19jb3VudFxuICAgIEZST00gJHt0aGlzLmRhdGFzZXR9XG4gICAgR1JPVVAgQlkgXG4gICAgICAke3RoaXMuZ3JvdXBDb2xzLmpvaW4oXCIsIFwiKX1cbiAgICApXG4gIFxuICAgIFNFTEVDVFxuICAgICAgKlxuICAgIEZST01cbiAgICAgIGJhc2VcbiAgICBXSEVSRVxuICAgICAgcm93X2NvdW50ID4gMVxuICAgIGA7XG4gIH1cblxuICBwdWJsaWMgZ2V0Tm90TnVsbFF1ZXJ5KGZpZWxkOiBzdHJpbmcpOiBzdHJpbmcge1xuICAgIHJldHVybiBgXG4gICAgU0VMRUNUXG4gICAgICAqXG4gICAgRlJPTSAke3RoaXMuZGF0YXNldH1cbiAgICBXSEVSRVxuICAgICAgJHtmaWVsZH0gSVMgTlVMTFxuICAgIGBcbiAgfVxuXG4gIHB1YmxpYyBnZXRBY2NlcHRlZFZhbHVlc1F1ZXJ5KGZpZWxkOiBzdHJpbmcsIGFjY2VwdGVkVmFsdWVzOiBzdHJpbmcgfCBzdHJpbmdbXSk6IHN0cmluZyB7XG4gICAgcmV0dXJuIGBcbiAgICBTRUxFQ1RcbiAgICAgICpcbiAgICBGUk9NICR7dGhpcy5kYXRhc2V0fVxuICAgIFdIRVJFXG4gICAgICAke2ZpZWxkfSBOT1QgSU4gJHthY2NlcHRlZFZhbHVlc31cbiAgICBgXG4gIH1cbn1cbiJdfQ==

package.json

 {
-    "version": "1.3.6",
+    "version": "1.3.7",
     "homepage": "https://github.com/dataform-co/dataform",
@@ -22,3 +22,3 @@ "license": "MIT",
     "dependencies": {
-        "@dataform/core": "1.3.6"
+        "@dataform/core": "1.3.7"
     },
@@ -25,0 +25,0 @@ "main": "index.js",

No alert changes

Improved metrics

Total package byte prevSize

5338

increased by29.94%

Lines of code

74

increased by37.04%

Dependency changes

• + Added@dataform/core@1.3.7(transitive)

• + Added@dataform/protos@1.3.7(transitive)

• + Added@dataform/sqlx@1.3.7(transitive)

• - Removed@dataform/core@1.3.6(transitive)

• - Removed@dataform/protos@1.3.6(transitive)

• - Removed@dataform/sqlx@1.3.6(transitive)

• Updated@dataform/core@1.3.7