Skip to content

neefrankie/sql-trim

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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.

About

No description, website, or topics provided.

Resources

License

Stars

Watchers

Forks

Packages

No packages published