Hi
Dne Thu, 13 Jun 2013 13:14:43 +0530 Supun Nakandala supun.nakandala@gmail.com napsal(a):
On Thu, Jun 13, 2013 at 12:38 PM, Michal Čihař michal@cihar.com wrote:
Hi
Dne Thu, 13 Jun 2013 11:51:18 +0530 Supun Nakandala supun.nakandala@gmail.com napsal(a):
I am refactoring sql.php and I see some places where parsing of the sql query done in the sql.php (eg line 445). I am planning to crate new
methods
for these tasks in sqlparser.lib.php and call them from sql.php . I would like to know the opinion from the developers about this approach.
Actually it would be better if those regular expressions would use parser because it would give it more tolerance to comments in SQL.
Hi Michal, PMA_SQP_parse($sql_query) in sqlparser.lib.php is basically checking the sql query and setting some global variables. Could you please elaborate on how to use that function instead of these regular expressions such that it gives more tolerance to comments in SQL.
It returns parsed SQL query, where you can check individial tokens.