Package Health Score

47 / 100

security
Security review needed
popularity
Limited
maintenance
Inactive
community
Limited

Explore Similar Packages

Security

Security review needed

All security vulnerabilities belong to production dependencies of direct and indirect packages.

Security and license risk for significant versions

Version				Vulnerabilities	License Risk
1.9.132	\|	01/2024	Popular	0 C 0 H 0 M 0 L	0 H 0 M 0 L
1.9.119	\|	10/2022		0 C 0 H 0 M 0 L	0 H 0 M 0 L

License

MIT

Security Policy

Is your project affected by vulnerabilities?

Scan your projects for vulnerabilities. Fix quickly with automated fixes. Get started with Snyk for free.

Get started free

Popularity

Limited

Weekly Downloads (4)

GitHub Stars: 2
Forks: 1
Contributors: 2

Direct Usage Popularity

The npm package j2sql2 receives a total of 4 downloads a week. As such, we scored j2sql2 popularity level to be Limited.

Based on project statistics from the GitHub repository for the npm package j2sql2, we found that it has been starred 2 times.

Downloads are calculated as moving averages for a period of the last 12 months, excluding weekends and known missing data points.

Community

Limited

Readme.md: Yes
Contributing.md: No
Code of Conduct: No
Contributors: 2
Funding: No

This project has seen only 10 or less contributors.

We found a way for you to contribute to the project! Looks like j2sql2 is missing a Code of Conduct.

Embed Package Health Score Badge

Maintenance

Inactive

Commit Frequency

Open Issues: 0
Open PR: 9
Last Release: 10 months ago
Last Commit: 10 months ago

Further analysis of the maintenance status of j2sql2 based on released npm versions cadence, the repository activity, and other data points determined that its maintenance is Inactive.

We found that j2sql2 demonstrates a positive version release cadence with at least one new version released in the past 12 months.

In the past month we didn't find any pull request activity or change in issues status has been detected for the GitHub repository.

Keep your project healthy

Check your package.json

Ensure all the packages you're using are healthy and well-maintained

Snyk Vulnerability Scanner

Get health score & security insights directly in your IDE

Package

Node.js Compatibility: not defined

Age: 5 years
Dependencies: 7 Direct
Versions: 106
Install Size: 66.1 kB
Dist-tags: 1
# of Files: 22
Maintainers: 1
TS Typings: No

j2sql2 has more than a single and default latest tag published for the npm package. This means, there may be other tags available for this package, such as next to indicate future releases, or stable to indicate stable releases.

Readme

j2sql2

enhance j2sql use ioredis mysql-promise mssql

npm i j2sql2

导入 sample.sql

node sample.js

关键字和表的冲突

不要使用以下关键字作为数据库表名

pool _mysql format cmd run genData

check 增强

在使用对象提交 sql 的情况下,增强如下功能

对 where 条件是否有包含此列
对 column 是否有包含此列
对 order by 是否有包含此列
对 string 和 number 类型进行预检测
同时封装 mysql 和 redis 详见 sample.js

如果数据库配置文件中打开如下配置，将返回和接受，camel 形式的列名，例如 cTime => c_time ..

extendOption: {
  columnCamelize: true
}

如果有 mysql.crudExtend 就扩展 db['tableName'].ex 属性，并检查数据库表是否有如下字段,都基于 d_flag 字段

mysql: {
  crudExtend: {
    isDevMode: 1 // 默认开发模式打印sql语句
    /* delflagField: 'd_flag', // 默认逻辑删除标记
      createTimeField: 'c_time',
      modifyTimeField: 'm_time' */
  }
}

redis: {
  keyLimit: ['x1', 'c*'] // '*' 全部允许
}
// 也可以通过redis实例 redis.keysLimit.add('*') or redis.keysLimit.status = 0 全部允许(关闭过滤)
// 详见 sample.js

    // reJson 支持    
    let r = (await rd.jset('sky', '.', { 'x': 1 })) 
    console.log('reJson Test', r)
    r = (await rd.jget('sky', '.')) 
    console.log('reJson Test', r)
    
// 详见 sample.js

详见 crud.js
page, 分页
list,
insert,
update,
remove,
clear,
getById,
removeById,
deleteById,
updateById,
addById 列增加

j2sql2 dependencies

amqp-connection-manager amqplib bluebird ioredis meeko mssql promise-mysql

j2sql2 development dependencies

cz-jt

FAQs

What is j2sql2?

j2sql2自用函数. Visit Snyk Advisor to see a full health score report for j2sql2, including popularity, security, maintenance & community analysis.

Is j2sql2 popular?

The npm package j2sql2 receives a total of 4 weekly downloads. As such, j2sql2 popularity was classified as limited. Visit the popularity section on Snyk Advisor to see the full health analysis.

Is j2sql2 well maintained?

We found indications that j2sql2 is an Inactive project. See the full package health analysis to learn more about the package maintenance status.

Is j2sql2 safe to use?

While scanning the latest version of j2sql2, we found that a security review is needed. A total of 0 vulnerabilities or license issues were detected. See the full security scan results.

Last updated on 16 November-2024, at 22:14 (UTC).

Build a secure application checklist

Select a recommended open source package

Minimize your risk by selecting secure & well maintained open source packages

DONE

Scan your app for vulnerabilities

Scan your application to find vulnerabilities in your: source code, open source dependencies, containers and configuration files

SCAN NOW

Fix identified vulnerabilities

Easily fix your code by leveraging automatically generated PRs

AUTO FIX

Monitor for new issues

New vulnerabilities are discovered every day. Get notified if your application is affected

MONITOR APP

j2sql2

j2sql2自用函数 For more information about how to use this package see README

Ensure you're using the healthiest npm packages

Package Health Score

Explore Similar Packages

Security

Security and license risk for significant versions

Is your project affected by vulnerabilities?

Popularity

Weekly Downloads (4)

Direct Usage Popularity

Community

Embed Package Health Score Badge

Maintenance

Commit Frequency

Keep your project healthy

Check your package.json

Snyk Vulnerability Scanner

Package

Readme

j2sql2

关键字和表的冲突

check 增强

j2sql2 dependencies

j2sql2 development dependencies

FAQs

What is j2sql2?

Is j2sql2 popular?

Is j2sql2 well maintained?

Is j2sql2 safe to use?

Build a secure application checklist

Select a recommended open source package

Scan your app for vulnerabilities

Fix identified vulnerabilities

Monitor for new issues

Package Health Score

Explore Similar Packages

Security and license risk for significant versions

Is your project affected by vulnerabilities?

Weekly Downloads (4)

Direct Usage Popularity

Embed Package Health Score Badge

Commit Frequency

Keep your project healthy

Check your package.json

Snyk Vulnerability Scanner

Readme

j2sql2

关键字和表的冲突

check 增强

j2sql2 dependencies

j2sql2 development dependencies

FAQs

What is j2sql2?

Is j2sql2 popular?

Is j2sql2 well maintained?

Is j2sql2 safe to use?

Build a secure application checklist

Select a recommended open source package

Scan your app for vulnerabilities

Source Code

Open Source

Container

Config

Fix identified vulnerabilities

Monitor for new issues