vn-mysql

v1.0.3

A node.js driver for mysql. It is written in JavaScript, does not require compiling, and is 100% MIT licensed. For more information about how to use this package see README

Latest version published 8 years ago

License: MIT

NPM

GitHub

Package Health Score

53 / 100

security
No known security issues
popularity
Small
maintenance
Inactive
community
Sustainable

Security

No known security issues

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

Security and license risk for significant versions

All Versions

Version				Vulnerabilities	License Risk
1.0.3	\|	07/2016	Popular	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

Small

Weekly Downloads (0)

GitHub Stars: 18.3K
Forks: 2.53K
Contributors: 120

Direct Usage Popularity

The npm package vn-mysql receives a total of 0 downloads a week. As such, we scored vn-mysql popularity level to be Small.

Based on project statistics from the GitHub repository for the npm package vn-mysql, we found that it has been starred 18,303 times.

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

Community

Sustainable

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

A good and healthy external contribution signal for vn-mysql project, which invites more than one hundred open source maintainers to collaborate on the repository.

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

Embed Package Health Score Badge

Maintenance

Inactive

Commit Frequency

No Recent Commits

Open Issues: 139
Open PR: 34
Last Release: 8 years ago
Last Commit: 3 years ago

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

An important project maintenance signal to consider for vn-mysql is that it hasn't seen any new versions released to npm in the past 12 months, and could be considered as a discontinued project, or that which receives low attention from its maintainers.

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: >= 0.6

Age: 8 years
Dependencies: 3 Direct
Versions: 5
Install Size: 0 B
Dist-tags: 1
# of Files: 0
Maintainers: 1
TS Typings: Yes

vn-mysql 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

This module custom from module "mysql".

Install

npm i vn-define vn-mysql --save

Examples

var mysql = require("vn-mysql");
var db = new mysql("database");
var callback = function(e){ console.log(e) };

// fetch or fetchAll
db.table("user")
  .column("id,fname,lname");
  .where({id: 1})
  .fetch(callback)
  .catch(callback);

// join
db.table("post as p")
  .column([
    "p.id as post_id, p.user as post_user, p.title, p.content, p.created",
    "a.id as album_id, a.name as album_name",
    "u.fname as user_fname, u.lname as user_lname"
  ])
  .leftJoin({
    "album as a": "a.aid = p.aid",
    "user as u": "u.id = p.user"
  })
  .where("id", ">", 10)
  .limit(20)
  .fetchAll(callback);

// select in
db.table("post").column("id, title").in("name", ["Thuan", "Chi"]).fetchAll(callback);

db.table("post").column("id, title").in("name", function(){
  return this.table("user").column("lname").where({fname: "Nguyen"});
})
.fetchAll(callback)
.catch(callback);

// insert
db.table("user").insert({fname: "Nguyen", lname: "Thuan"}, callback);

db.table("post").column("name").insert(function(){
  return this.table("user").where({id: 1}).column("concat(fname, ' ', lname)");
});

db.table("user").insertArray([
  {fname: "Fname1", lname: "Lname1"},
  {fname: "Fname2", lname: "Lname2"}
]);

// update
db.table("user").where({id: 1}).update({fname: "New Fname"});

// delete
db.table("user").where({id: 1}).remove();

db.table("post").remove(function(){
  this.table("user").where({username: 'nguyenthuan'});
  return this;
});

vn-mysql dependencies

bignumber.js readable-stream sqlstring

vn-mysql development dependencies

after eslint istanbul mkdirp require-all rimraf timezone-mock urun utest

FAQs

What is vn-mysql?

A node.js driver for mysql. It is written in JavaScript, does not require compiling, and is 100% MIT licensed. Visit Snyk Advisor to see a full health score report for vn-mysql, including popularity, security, maintenance & community analysis.

Is vn-mysql popular?

We’re still processing downloads data for the npm package vn-mysql. Visit the popularity section on Snyk Advisor to see the full popularity analysis.

Is vn-mysql well maintained?

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

Is vn-mysql safe to use?

The npm package vn-mysql was scanned for known vulnerabilities and missing license, and no issues were found. Thus the package was deemed as safe to use. See the full health analysis review.

Last updated on 19 November-2024, at 19:24 (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