@saltcorn/db-common - npm Package Compare versions

Comparing version 0.7.2-beta.0 to 0.7.2-beta.2

dist/index.d.ts

@@ -10,2 +10,3 @@ /**
 export * from "./internal";
+export * from "./sqlite-commons";
 //# sourceMappingURL=index.d.ts.map

dist/index.js

@@ -39,2 +39,3 @@ "use strict";
 __exportStar(require("./internal"), exports);
+__exportStar(require("./sqlite-commons"), exports);
 //# sourceMappingURL=index.js.map

dist/internal.d.ts

@@ -34,2 +34,3 @@ /**
         searchTerm: string;
+        schema?: string;
     };
@@ -36,0 +37,0 @@ or?: Where[];

dist/internal.js

@@ -83,4 +83,4 @@ "use strict";
 const whereFTS = (v, phs) => {
-    const { fields, table } = v;
-    let flds = fields
+    const { fields, table, schema } = v;
+    let fldsArray = fields
         .filter((f) => f.type && f.type.sql_name === "text")
@@ -91,4 +91,9 @@ .map((f) => "coalesce(" +
             : `"${(0, exports.sqlsanitize)(f.name)}"`) +
-        ",'')")
-        .join(" || ' ' || ");
+        ",'')");
+    fields
+        .filter((f) => f.is_fkey && f?.attributes?.include_fts)
+        .forEach((f) => {
+        fldsArray.push(`coalesce((select ${f.attributes.summary_field} from ${schema ? `"${schema}".` : ""}"${f.reftable_name}" rt where rt.id=${table ? `"${(0, exports.sqlsanitize)(table)}".` : ""}"${f.name}"),'')`);
+    });
+    let flds = fldsArray.join(" || ' ' || ");
     const prefixMatch = !v.searchTerm?.includes(" ");
@@ -95,0 +100,0 @@ const searchTerm = prefixMatch ? `${v.searchTerm}:*` : v.searchTerm;

package.json

 {
   "name": "@saltcorn/db-common",
-  "version": "0.7.2-beta.0",
+  "version": "0.7.2-beta.2",
   "description": "Db common structures for Saltcorn, open-source no-code platform",
@@ -29,3 +29,3 @@ "homepage": "https://saltcorn.com",
   "devDependencies": {
-    "jest": "26.6.3",
+    "jest": "^27.1.0",
     "@types/node": "^16.11.9",
@@ -32,0 +32,0 @@ "typescript": "^4.4.4"

New alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Fixed alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

108161

increased by33.26%

Number of package files

30

increased by15.38%

Lines of code

1080

increased by20.81%

No dependency changes