npmpackage.info

Gathering detailed insights and metrics for @mocobaas/odata-filter-to-sql

@mocobaas/odata-filter-to-sql - 1.0.7 | npmpackage.info

@mocobaas/odata-filter-to-sql

Service OData v4 requests from a PostgreSQL data store for Objection.js (knex.js) ORM for Node.js

1.0.7

MIT

TypeScript

41.78 kB

20,392 1.7

Installations

npm install @mocobaas/odata-filter-to-sql

Developer Guide

BETA

Typescript

No

Module System

CommonJS

Node Version

14.20.1

NPM Version

6.14.17 Pull Requests

Open

14

Total

18

Closed

4

Issues

Open

0

Total

0

Closed

0

Releases

Unable to fetch releases

Languages

TypeScript

JavaScript

TypeScript (99.49%)

JavaScript (0.51%)

Developer

jstott

Download Statistics

Total Downloads

20,392

Last Day

Last Week

Last Month

112

Last Year

2,427

GitHub Statistics

MIT License

1 Stars

6 Commits

1 Watchers

15 Branches

1 Contributors

Updated on Aug 02, 2023

Maintainers

View All 1 Contributors

Package Meta Information

Latest Version

1.0.7

Package Id

@mocobaas/odata-filter-to-sql@1.0.7

Unpacked Size

41.78 kB

Size

9.28 kB

File Count

NPM Version

6.14.17

Node Version

14.20.1

Total Downloads

Cumulative downloads

Total Downloads

20,392

Last Day

-66.7%

Compared to previous day

Last Week

-42.9%

Compared to previous week

Last Month

1.8%

112

Compared to previous month

Last Year

-39.9%

2,427

Compared to previous year

Weekly Downloads

Monthly Downloads

Yearly Downloads

Dependencies

odata-v4-literal odata-v4-parser odata-v4-sql

Dev Dependencies

@types/config @types/jest @types/pg config jest odata-v4-server pg rimraf ts-jest typescript

odata-objection-pg Service modules - PostgreSQL Connector

Odata services requests from a PostgreSQL data store for Objection.js (knex.js) ORM for Node.js

This is a modified and specific version of odata-v4-pg. That library has forked and moved here as I continue to develop it.

Synopsis

The odata-objection-pg Connector provides functionality to convert the various types of OData segments into SQL query statements suitable for Objection / knex.js raw() where clause

Snake_Case conversion

This library assumes your Nest/Objection/knex are leveraging Postgre snake_case for table names. As such, OData queries for camelCase properties will be converted to snake_case automatically.

Named bindings

In knex.js - Named bindings such as :name are interpreted as values and :name: interpreted as identifiers. Named bindings are processed so long as the value is anything other than undefined.

As such, odata-objection-pg will set placeholders as :0 (index value) for all placeholders. This helps alleviate issues for createDate eq null statements, that are absent of any placeholders. With named bindings, this does not present a problem.

Potential usage scenarios

Nest.js & Objection.js (or direct Knex.js) library helper

See the (index.spec.ts)[./src/lib/index.spec.ts] for sanity tests

Usage as server - TypeScript

1import { createFilter } from 'odata-objection-pg'
2
3//example request/query filter:  
4const { raw } = require('objection');
5const sDay = moment.utc().startOf('day').toISOString();
6const query = { $filter: `(startDate ne null or startDate ge '${moment.utc().startOf('day').toISOString()}')`, $expand: '' };
7Object.assign(query, req.query || {});
8
9
10await Person
11  .query()
12  .where(raw(query.where, query.parameterObject()));
13}

Supported OData segments

$filter
$select
$skip
$top
$orderby
$expand

NPM package

Change the version in your package.json or use npm version . npm version patch

After changing the version number in your package.json, run npm publish to publish the new version to NPM.

npm install will install the latest version in the NPM repository.

No vulnerabilities found.

10

Binary-Artifacts

Determines if the project has generated executable (binary) artifacts in the source repository.

10

License

Determines if the project has defined a license.

0

Maintained

Determines if the project is "actively maintained".

0

Code-Review

Determines if the project requires human code review before pull requests (aka merge requests) are merged.

0

SAST

Determines if the project uses static code analysis.

0

CII-Best-Practices

Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.

0

Security-Policy

Determines if the project has published a security policy.

0

Fuzzing

Determines if the project uses fuzzing.

0

Branch-Protection

Determines if the default and release branches are protected with GitHub's branch protection settings.

0

Vulnerabilities

Determines if the project has open, known unfixed vulnerabilities.

Reason

59 existing vulnerabilities detected

Details

Warn: Project is vulnerable to: GHSA-968p-4wvh-cqc8
Warn: Project is vulnerable to: GHSA-67hx-6x53-jw92
Warn: Project is vulnerable to: GHSA-6chw-6frg-f759
Warn: Project is vulnerable to: GHSA-v88g-cgmw-v5xw
Warn: Project is vulnerable to: GHSA-93q8-gq69-wqmw
Warn: Project is vulnerable to: GHSA-qwcr-r2fm-qrc7
Warn: Project is vulnerable to: GHSA-grv7-fg5c-xmjg
Warn: Project is vulnerable to: GHSA-pxg6-pf52-xh8x
Warn: Project is vulnerable to: GHSA-3xgq-45jj-v275
Warn: Project is vulnerable to: GHSA-gxpj-cx7g-858c
Warn: Project is vulnerable to: GHSA-w573-4hg7-7wgq
Warn: Project is vulnerable to: GHSA-rv95-896h-c2vc
Warn: Project is vulnerable to: GHSA-qw6h-vgh9-j6wx
Warn: Project is vulnerable to: GHSA-8r6j-v8pm-fqw3
Warn: Project is vulnerable to: MAL-2023-462
Warn: Project is vulnerable to: GHSA-w457-6q6x-cgp9
Warn: Project is vulnerable to: GHSA-62gr-4qp9-h98f
Warn: Project is vulnerable to: GHSA-f52g-6jhx-586p
Warn: Project is vulnerable to: GHSA-2cf5-4w76-r9qv
Warn: Project is vulnerable to: GHSA-3cqr-58rm-57f8
Warn: Project is vulnerable to: GHSA-g9r4-xpmj-mj65
Warn: Project is vulnerable to: GHSA-q2c6-c6pm-g3gh
Warn: Project is vulnerable to: GHSA-765h-qjxv-5f44
Warn: Project is vulnerable to: GHSA-f2jv-r9rf-7988
Warn: Project is vulnerable to: GHSA-43f8-2h32-f4cj
Warn: Project is vulnerable to: GHSA-qqgx-2p2h-9c37
Warn: Project is vulnerable to: GHSA-896r-f27r-55mw
Warn: Project is vulnerable to: GHSA-9c47-m6qq-7p4h
Warn: Project is vulnerable to: GHSA-6c8f-qphg-qjgp
Warn: Project is vulnerable to: GHSA-p6mc-m468-83gw
Warn: Project is vulnerable to: GHSA-29mw-wpgm-hmr9
Warn: Project is vulnerable to: GHSA-35jh-r3h4-6jhm
Warn: Project is vulnerable to: GHSA-952p-6rrq-rcjv
Warn: Project is vulnerable to: GHSA-f8q6-p94x-37v3
Warn: Project is vulnerable to: GHSA-vh95-rmgr-6w4m
Warn: Project is vulnerable to: GHSA-xvch-5gv4-984h
Warn: Project is vulnerable to: GHSA-8hfj-j24r-96c4
Warn: Project is vulnerable to: GHSA-wc69-rhjr-hc9g
Warn: Project is vulnerable to: GHSA-5fw9-fq32-wv5p
Warn: Project is vulnerable to: GHSA-hj48-42vr-x3v9
Warn: Project is vulnerable to: GHSA-9wv6-86v2-598j
Warn: Project is vulnerable to: GHSA-rhx6-c78j-4q9w
Warn: Project is vulnerable to: GHSA-hrpp-h998-j3pp
Warn: Project is vulnerable to: GHSA-p8p7-x288-28g6
Warn: Project is vulnerable to: GHSA-c2qf-rxjj-qqgw
Warn: Project is vulnerable to: GHSA-m6fv-jmcg-4jfg
Warn: Project is vulnerable to: GHSA-cm22-4g7w-348p
Warn: Project is vulnerable to: GHSA-3jfq-g458-7qm9
Warn: Project is vulnerable to: GHSA-r628-mhmh-qjhw
Warn: Project is vulnerable to: GHSA-9r2w-394v-53qc
Warn: Project is vulnerable to: GHSA-5955-9wpr-37jh
Warn: Project is vulnerable to: GHSA-qq89-hq3f-393p
Warn: Project is vulnerable to: GHSA-f5x3-32g6-xq36
Warn: Project is vulnerable to: GHSA-jgrx-mgxx-jf9v
Warn: Project is vulnerable to: GHSA-72xf-g2v4-qvf3
Warn: Project is vulnerable to: GHSA-6fc8-4gx4-v693
Warn: Project is vulnerable to: GHSA-3h5v-q93c-6h6q
Warn: Project is vulnerable to: GHSA-c4w7-xm78-47vh
Warn: Project is vulnerable to: GHSA-p9pc-299p-vxgp

Score

1.7

/10

Last Scanned on 2025-05-05

The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software (OSS). The Scorecard provides security health metrics for open source projects.

Learn More