Skip to content

Instantly share code, notes, and snippets.

  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Embed
What would you like to do?
Returns the actual name of a given table name.

This method will strip off curly brackets from the given table name

and replace the percentage character '%' with [[tablePrefix]].

let re = /{{(.*?)}}/g
let str = 'SELECT * FROM {{%user}} FROM WHERE id IN (?)'
let tablePrefix = 'tbl_'
console.log(str.replace(re, '$1').replace('%', tablePrefix))
  • INPUT
SELECT * FROM {{%user}} FROM WHERE id IN (?)
  • OUTPUT
SELECT * FROM tbl_user FROM WHERE id IN (?)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment