使用 JavaScript 从 SQL 查询字符串中删除注释的正则表达式

Question

我设法找到了用于处理 /* */ 案例的正则表达式，但它不适用于 -- 案例。如何更改我的正则表达式来解决这个问题？var s = `SELECT * FROM TABLE_A/* first line of comment   second line of comment */   -- remove this comment too   SELECT * FROM TABLE_B`;var stringWithoutComments = s.replace(/(\/\*[^*]*\*\/)|(\/\/[^*]*)|(--[^*]*)/g, '');/*Expected:SELECT * FROM TABLE_ASELECT * FROM TABLE_B*/console.log(stringWithoutComments);谢谢https://jsfiddle.net/8fuz7sxd/1/

Answer 1

var s = `SELECT * FROM TABLE_A

/* first line of comment

   second line of comment */

   -- remove this comment too

   SELECT * FROM TABLE_B`;

var stringWithoutComments = s.replace(/(\/\*[^*]*\*\/)|(\/\/[^*]*)|(--[^.].*)/gm, '');

/*

Expected:

SELECT * FROM TABLE_A

SELECT * FROM TABLE_B

*/

console.log(stringWithoutComments);

// without linebreak

stringWithoutComments = stringWithoutComments.replace(/^\s*\n/gm, "")

console.log(stringWithoutComments);

// without whitespace

stringWithoutComments = stringWithoutComments.replace(/^\s+/gm, "")

console.log(stringWithoutComments);