{"library":"mysql-composer","type":"library","category":null,"description":"A lightweight Node.js MySQL query composer for building insert and update statements without an ORM. Version 2.0.3 simplifies dynamic SQL generation for scrapers and ETL tasks. Offers methods: insert, update, query, beginTransaction, rollback, commit. Unlike sequelize it does not require table modeling, but does not provide schema validation or migrations. Supports callbacks and optional promise wrappers. No active development since 2019.","language":"javascript","status":"maintenance","version":"2.0.3","tags":["javascript","mysql","sql","node-mysql","node"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install mysql-composer","imports":["const Composer = require('mysql-composer')","import mysql from 'mysql'; const connection = mysql.createConnection({...})","composer.insert({table:'users', data:{name:'Tom'}}, callback)","composer.update({table:'users', data:{age:18}, where:'id=1'}, callback)"]},{"cmd":"yarn add mysql-composer","imports":[]},{"cmd":"pnpm add mysql-composer","imports":[]}],"homepage":"https://github.com/awayisblue/node-mysql-composer#readme","github":"https://github.com/awayisblue/node-mysql-composer","docs":null,"changelog":null,"pypi":null,"npm":"mysql-composer","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}