[Phpmyadmin-devel] Phpmyadmin-devel Digest, Vol 76, Issue 11

Wed Nov 28 16:37:29 CET 2012

Thanks Mark for showing interest. :)

well the parser has a 2 things to offer:
1. Auto completing syntaxes.
2. Figure out and notify the user about basic and a bit more specific
syntax errors. Specific, like for a create table syntax, every colum
must have a datatype defined and so on.

The parser can help if implemented on both client/server side in not
sparing a query for no use on the server and the db can be utilised in
that time for some usefull work(we can do this for atleast the silly
mistakes but i am coding it for major).
Well, i havnt pulled the request yet because i am testing it through
various tests, will update soon.
- Regards
Dron Rathore

On 11/28/12, phpmyadmin-devel-request at lists.sourceforge.net
<phpmyadmin-devel-request at lists.sourceforge.net> wrote:
> Send Phpmyadmin-devel mailing list submissions to
> 	phpmyadmin-devel at lists.sourceforge.net
>
> To subscribe or unsubscribe via the World Wide Web, visit
> 	https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
> or, via email, send a message with subject or body 'help' to
> 	phpmyadmin-devel-request at lists.sourceforge.net
>
> You can reach the person managing the list at
> 	phpmyadmin-devel-owner at lists.sourceforge.net
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Phpmyadmin-devel digest..."
>
>
> Today's Topics:
>
>    1. Sql Validator (Dron Rathore)
>    2. Re: Sql Validator (Rouslan Placella)
>    3. Re: Sql Validator (Marc Delisle)
>    4. Re: Sql Validator (Rouslan Placella)
>    5. [SPAM] Re:  Sql Validator (Marc Delisle)
>    6. navi panel and current table (Marc Delisle)
>    7. Re: navi panel and current table (Rouslan Placella)
>    8. Re: navi panel and current table (Marc Delisle)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 27 Nov 2012 21:38:20 +0800
> From: Dron Rathore <dron.rathore at gmail.com>
> Subject: [Phpmyadmin-devel] Sql Validator
> To: phpmyadmin-devel at lists.sourceforge.net
> Message-ID:
> 	<CAK4icChoWY-kmfVODai9p6H+9LWZAe7W=++0O9Wn3Pb5x_S1Hg at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi all!,
> i wanted to know that is there any sql parser to validate queries
> before firing them? I guess there is one which uses zend.
> Actually i have coded a parser(client side js validator, can work as
> JIT, i can transform it into php codes too) and eager to share it with
> pma.
> - Regards
> Dron Rathore
>
>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 27 Nov 2012 13:47:09 +0000
> From: Rouslan Placella <rouslan at placella.com>
> Subject: Re: [Phpmyadmin-devel] Sql Validator
> To: phpmyadmin-devel at lists.sourceforge.net
> Message-ID: <50B4C45D.1050700 at placella.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> On 27/11/12 13:38, Dron Rathore wrote:
>> Hi all!,
>> i wanted to know that is there any sql parser to validate queries
>> before firing them? I guess there is one which uses zend.
>> Actually i have coded a parser(client side js validator, can work as
>> JIT, i can transform it into php codes too) and eager to share it with
>> pma.
>> - Regards
>> Dron Rathore
>
> Hi Dron,
>
> What is the purpose of validating queries? If the query is invalid MySQL
> will just throw an error.
>
> Besides, we already have an SQL parser in the code base...
>
> Byem
> Rouslan
>
>
>
> ------------------------------
>
> Message: 3
> Date: Tue, 27 Nov 2012 10:25:17 -0500
> From: Marc Delisle <marc at infomarc.info>
> Subject: Re: [Phpmyadmin-devel] Sql Validator
> To: phpmyadmin-devel at lists.sourceforge.net
> Message-ID: <50B4DB5D.8000804 at infomarc.info>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Rouslan Placella a ?crit :
>> On 27/11/12 13:38, Dron Rathore wrote:
>>> Hi all!,
>>> i wanted to know that is there any sql parser to validate queries
>>> before firing them? I guess there is one which uses zend.
>>> Actually i have coded a parser(client side js validator, can work as
>>> JIT, i can transform it into php codes too) and eager to share it with
>>> pma.
>>> - Regards
>>> Dron Rathore
>>
>> Hi Dron,
>>
>> What is the purpose of validating queries? If the query is invalid MySQL
>> will just throw an error.
>
> One of the goals is to verify whether the query is compliant with
> standard SQL, which is not the same as MySQL. Look for "Validator" in
> Documentation.html.
>>
>> Besides, we already have an SQL parser in the code base...
>>
>> Byem
>> Rouslan
>
>
> --
> Marc Delisle
> http://infomarc.info
>
>
>
> ------------------------------
>
> Message: 4
> Date: Tue, 27 Nov 2012 15:34:01 +0000
> From: Rouslan Placella <rouslan at placella.com>
> Subject: Re: [Phpmyadmin-devel] Sql Validator
> To: phpmyadmin-devel at lists.sourceforge.net
> Message-ID: <50B4DD69.1050608 at placella.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> On 27/11/12 15:25, Marc Delisle wrote:
>> Rouslan Placella a ?crit :
>>> On 27/11/12 13:38, Dron Rathore wrote:
>>>> Hi all!,
>>>> i wanted to know that is there any sql parser to validate queries
>>>> before firing them? I guess there is one which uses zend.
>>>> Actually i have coded a parser(client side js validator, can work as
>>>> JIT, i can transform it into php codes too) and eager to share it with
>>>> pma.
>>>> - Regards
>>>> Dron Rathore
>>>
>>> Hi Dron,
>>>
>>> What is the purpose of validating queries? If the query is invalid MySQL
>>> will just throw an error.
>>
>> One of the goals is to verify whether the query is compliant with
>> standard SQL, which is not the same as MySQL. Look for "Validator" in
>> Documentation.html.
>>>
>>> Besides, we already have an SQL parser in the code base...
>>>
>
> Ok, I see.
>
> Bye,
> Rouslan
>
>
>
> ------------------------------
>
> Message: 5
> Date: Tue, 27 Nov 2012 12:47:50 -0500
> From: Marc Delisle <marc at infomarc.info>
> Subject: [Phpmyadmin-devel] [SPAM] Re:  Sql Validator
> To: phpmyadmin-devel at lists.sourceforge.net
> Message-ID: <50B4FCC6.1060802 at infomarc.info>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Dron Rathore a ?crit :
>> Hi all!,
>> i wanted to know that is there any sql parser to validate queries
>> before firing them? I guess there is one which uses zend.
>> Actually i have coded a parser(client side js validator, can work as
>> JIT, i can transform it into php codes too) and eager to share it with
>> pma.
>> - Regards
>> Dron Rathore
>
> So Dron, where would your parser fit into phpMyAdmin?
> - code completion in the query windows?
> - validation ?
> - syntax highlighting?
>
>
> --
> Marc Delisle
> http://infomarc.info
>
>
>
> ------------------------------
>
> Message: 6
> Date: Tue, 27 Nov 2012 12:55:17 -0500
> From: Marc Delisle <marc at infomarc.info>
> Subject: [Phpmyadmin-devel] navi panel and current table
> To: phpmyadmin-devel at lists.sf.net
> Message-ID: <50B4FE85.6090905 at infomarc.info>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi Rouslan and list,
>
> I wonder whether this is a bug or a missing feature :) but I noticed
> that in some situations, for example following a foreign link or picking
> a table from the output of db_structure.php, the navi panel does not
> position itself to the new table.
>
> --
> Marc Delisle
> http://infomarc.info
>
>
>
> ------------------------------
>
> Message: 7
> Date: Tue, 27 Nov 2012 20:28:01 +0000
> From: Rouslan Placella <rouslan at placella.com>
> Subject: Re: [Phpmyadmin-devel] navi panel and current table
> To: phpmyadmin-devel at lists.sourceforge.net
> Message-ID: <50B52251.9080209 at placella.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> On 27/11/12 17:55, Marc Delisle wrote:
>> Hi Rouslan and list,
>>
>> I wonder whether this is a bug or a missing feature :) but I noticed
>> that in some situations, for example following a foreign link or picking
>> a table from the output of db_structure.php, the navi panel does not
>> position itself to the new table.
>
> Sorry, but I don't understand what you mean.
>
> Bye,
> Rouslan
>
>
>
>
> ------------------------------
>
> Message: 8
> Date: Wed, 28 Nov 2012 08:53:58 -0500
> From: Marc Delisle <marc at infomarc.info>
> Subject: Re: [Phpmyadmin-devel] navi panel and current table
> To: phpmyadmin-devel at lists.sourceforge.net
> Message-ID: <50B61776.7020007 at infomarc.info>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Rouslan Placella a ?crit :
>> On 27/11/12 17:55, Marc Delisle wrote:
>>> Hi Rouslan and list,
>>>
>>> I wonder whether this is a bug or a missing feature :) but I noticed
>>> that in some situations, for example following a foreign link or picking
>>> a table from the output of db_structure.php, the navi panel does not
>>> position itself to the new table.
>>
>> Sorry, but I don't understand what you mean.
>
> Example 1:
> - in navi, click on sakila
> - in main, click on the Browse Action on the actor line
> - navi should show that actor is the current table
>
> Example 2:
> - in navi, click on sakila
> - in navi, under sakila, click on Tables then click on inventory
> - in main, for inventory_id 1, click on the film_id 1
> - now, in main you are seeing a row from film, but the navi panel no
> longer shows that the current db is sakila
>
>
> --
> Marc Delisle
> http://infomarc.info
>
>
>
> ------------------------------
>
> ------------------------------------------------------------------------------
> Keep yourself connected to Go Parallel:
> INSIGHTS What's next for parallel hardware, programming and related areas?
> Interviews and blogs by thought leaders keep you ahead of the curve.
> http://goparallel.sourceforge.net
>
> ------------------------------
>
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>
>
> End of Phpmyadmin-devel Digest, Vol 76, Issue 11
> ************************************************
>