@ftchinese/sql-trim
v0.0.1
Published
Tag function to trim whitespace in ES6 template string
Readme
Tag function to trim whitespaces and turn template string into one line. This is mainly used to write fomatted sql statement.
Example
const sql = require('@ftchinese/sql-trim');
const stmt = sql`
SELECT name AS name,
email AS email,
mobile_phone AS mobilePhone
FROM user
WHERE id = :id
LIMIT 1`;
const [rows, ] = conn.execute(stmt, {1});stmt will be one line of string: SELECT name AS name, email AS email, mobile_phone AS mobilePhone FROM user WHERE id = :id LIMIT 1.
