@ftchinese/sql-trim
v0.0.1
Published
Tag function to trim whitespace in ES6 template string
Downloads
2
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
.