Security News
tea.xyz Spam Plagues npm and RubyGems Package Registries
Tea.xyz, a crypto project aimed at rewarding open source contributions, is once again facing backlash due to an influx of spam packages flooding public package registries.
mysql-upsert
Advanced tools
Readme
Upsert (insert or update) multiple rows into MySQL
Upsert = An operation that inserts rows into a database table if they do not already exist, or updates them if they do.
npm install mysql-upsert --save
Basic usage is:
const upsert = require('mysql-upsert')
upsert(mysqlConnection)(table, data, fields)
mysqlConnection
is a mysql connection that has a query
function that returns a Promise.table
is a the table name to upsert intodata
is an array of objects. Each object is a row to insertfields
is an array of fields to upsert. (optional, defaults to the keys of the first object in data
)Following examples use async
/await
syntax but can be used with regular Promise syntax.
const mysql = require('promise-mysql')
const upsert = require('mysql-upsert')
const table = 'users'
const data = [
{ id: 1, name: 'Steve', company: 'Apple' },
{ id: 2, name: 'Bill', company: 'Microsoft' }
]
// With single connection
const connection = await mysql.createConnection({ ...config })
const { affectedRows } = await upsert(connection)(table, data)
await connection.end()
// Limit fields
const { affectedRows } = await upsert(connection)(table, data, ['name', 'company'])
// With pools
const pool = mysql.createPool({ ...config })
const { affectedRows } = await upsert(pool)(table, data, ['name', 'company'])
// With single connection from pool
const connection = await pool.getConnection()
const { affectedRows } = await upsert(connection)(table, data)
await connection.release()
FAQs
Upsert (insert or update) multiple rows into MySQL
The npm package mysql-upsert receives a total of 4 weekly downloads. As such, mysql-upsert popularity was classified as not popular.
We found that mysql-upsert demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
Tea.xyz, a crypto project aimed at rewarding open source contributions, is once again facing backlash due to an influx of spam packages flooding public package registries.
Security News
As cyber threats become more autonomous, AI-powered defenses are crucial for businesses to stay ahead of attackers who can exploit software vulnerabilities at scale.
Security News
UnitedHealth Group disclosed that the ransomware attack on Change Healthcare compromised protected health information for millions in the U.S., with estimated costs to the company expected to reach $1 billion.