[Phpmyadmin-devel] Transferring some code in sql.php into parser/analyser

[Michal Čihař]

Hi

Dne Thu, 13 Jun 2013 13:14:43 +0530
Supun Nakandala <supun.nakandala at gmail.com> napsal(a):

> On Thu, Jun 13, 2013 at 12:38 PM, Michal Čihař <michal at cihar.com> wrote:
> 
> > Hi
> >
> > Dne Thu, 13 Jun 2013 11:51:18 +0530
> > Supun Nakandala <supun.nakandala at 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.

-- 
	Michal Čihař | http://cihar.com | http://blog.cihar.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20130613/97168bb9/attachment.sig>