npmpackage.info

Gathering detailed insights and metrics for @n1ru4l/slonik-utilities

@n1ru4l/slonik-utilities - 0.0.1-alpha.4 | npmpackage.info

@n1ru4l/slonik-utilities

Utilities for the PostgreSQL Client Slonik

0.0.1-alpha.4

MIT

TypeScript

11.43 kB

2.5

Installations

npm install @n1ru4l/slonik-utilities

Developer Guide

BETA

Typescript

No

Module System

CommonJS

Pull Requests

Open

14

Total

17

Closed

2

Merged

1

Issues

Open

1

Total

1

Closed

0

Releases

Unable to fetch releases

Languages

TypeScript

JavaScript

TypeScript (87.73%)

JavaScript (12.27%)

Developer

n1ru4l

Download Statistics

Total Downloads

Last Day

Last Week

Last Month

Last Year

GitHub Statistics

MIT License

3 Stars

13 Commits

2 Watchers

15 Branches

1 Contributors

Updated on Mar 04, 2023

Maintainers

View All 1 Contributors

Package Meta Information

Latest Version

0.0.1-alpha.4

Package Id

@n1ru4l/slonik-utilities@0.0.1-alpha.4

Unpacked Size

11.43 kB

Size

3.77 kB

File Count

Total Downloads

Cumulative downloads

Total Downloads

NaN

Last Day

NaN

Compared to previous day

Last Week

NaN

Compared to previous week

Last Month

NaN

Compared to previous month

Last Year

NaN

Compared to previous year

Weekly Downloads

Monthly Downloads

Yearly Downloads

Peer Dependencies

slonik

Dev Dependencies

@types/jest @types/slonik @typescript-eslint/eslint-plugin @typescript-eslint/parser doctoc eslint eslint-config-prettier eslint-plugin-jest husky jest lint-staged prettier rimraf slonik ts-jest typescript

@n1ru4l/slonik-utilities

Utilities for the PostgreSQL Client Slonik.

Motivation
API
identifierList - Generate a list of identifiers

Motivation

Slonik removed some convenient methods in version 19.x.x. The new approach is a bit "too" verbose for my taste. This is why I wrote these helper methods to do common stuff more easily and quicker.

API

`valuesSingle` - Insert a single record

1import { sql } from "slonik";
2import { valuesSingle } from "@n1ru4l/slonik-utilities";
3
4const user = {
5  id: 1,
6  login: "peter",
7  email: "peter@localhost"
8};
9
10const query = sql`
11  INSERT INTO "users" (
12    "id",
13    "login",
14    "email"
15  ) VALUES (${valuesSingle([user.id, user.login, user.email])});
16`;

`valuesList` - Insert multiple records

1import { sql } from "slonik";
2import { valuesList } from "@n1ru4l/slonik-utilities";
3
4const users = [
5  {
6    id: 1,
7    login: "peter",
8    email: "peter@localhost"
9  },
10  {
11    id: 2,
12    login: "lukas",
13    email: "lukas@localhost"
14  }
15];
16
17const query = sql`
18  INSERT INTO "users" (
19    "id",
20    "login",
21    "email"
22  ) VALUES (${valuesList(users, user => [user.id, user.login, user.email])});
23`;

`assignmentList` - Update multiple columns

1import { sql } from "slonik";
2import { assignmentList } from "@n1ru4l/slonik-utilities";
3
4const query = sql`
5  UPDATE "users"
6  SET ${assignmentList({
7    email: "newemail@localhost",
8    otherValue: 10
9  })}
10  WHERE "id" = 1;
11`;

`identifierList` - Generate a list of identifiers

1import { sql } from "slonik";
2import { identifierList } from "@n1ru4l/slonik-utilities";
3
4const query = sql`
5  SELECT ${identifierList([
6    ["users", "id"],
7    ["users", "someOtheColumn"]
8  ])}
9  FROM "users";
10`;

No vulnerabilities found.

10

Dangerous-Workflow

Determines if the project's GitHub Action workflows avoid dangerous patterns.

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

Code-Review

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

0

Maintained

Determines if the project is "actively maintained".

0

Pinned-Dependencies

Determines if the project has declared and pinned the dependencies of its build process.

0

Token-Permissions

Determines if the project's workflows follow the principle of least privilege.

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

SAST

Determines if the project uses static code analysis.

0

Vulnerabilities

Determines if the project has open, known unfixed vulnerabilities.

Reason

48 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-v6h2-p8h4-qcjw
Warn: Project is vulnerable to: GHSA-grv7-fg5c-xmjg
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-8r6j-v8pm-fqw3
Warn: Project is vulnerable to: MAL-2023-462
Warn: Project is vulnerable to: GHSA-ww39-953v-wcq6
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-5fw9-fq32-wv5p
Warn: Project is vulnerable to: GHSA-hj48-42vr-x3v9
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-g4rg-993r-mgx7
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-w5p7-h5w8-2hfq
Warn: Project is vulnerable to: GHSA-cf4h-3jhx-xvhq
Warn: Project is vulnerable to: GHSA-j8xg-fqg3-53r7
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

2.5

/10

Last Scanned on 2025-07-07

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

@n1ru4l/slonik-utilities

Installations

Developer Guide

No

CommonJS

Pull Requests

14

17

2

1

Issues

1

1

0

Releases

Unable to fetch releases

Languages

Developer

n1ru4l

Download Statistics

GitHub Statistics

Maintainers

Package Meta Information

Total Downloads

NaN

Weekly Downloads

Monthly Downloads

Yearly Downloads

Peer Dependencies

Dev Dependencies

@n1ru4l/slonik-utilities

Motivation

API

valuesSingle - Insert a single record

valuesList - Insert multiple records

assignmentList - Update multiple columns

identifierList - Generate a list of identifiers

10

10

10

0

0

0

0

0

0

0

0

0

0

2.5

/10

`valuesSingle` - Insert a single record

`valuesList` - Insert multiple records

`assignmentList` - Update multiple columns

`identifierList` - Generate a list of identifiers