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@lists.sourceforge.net <phpmyadmin-devel-request@lists.sourceforge.net> wrote:
Send Phpmyadmin-devel mailing list submissions to phpmyadmin-devel@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@lists.sourceforge.net
You can reach the person managing the list at phpmyadmin-devel-owner@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@gmail.com> Subject: [Phpmyadmin-devel] Sql Validator To: phpmyadmin-devel@lists.sourceforge.net Message-ID: <CAK4icChoWY-kmfVODai9p6H+9LWZAe7W=++0O9Wn3Pb5x_S1Hg@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@placella.com> Subject: Re: [Phpmyadmin-devel] Sql Validator To: phpmyadmin-devel@lists.sourceforge.net Message-ID: <50B4C45D.1050700@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@infomarc.info> Subject: Re: [Phpmyadmin-devel] Sql Validator To: phpmyadmin-devel@lists.sourceforge.net Message-ID: <50B4DB5D.8000804@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@placella.com> Subject: Re: [Phpmyadmin-devel] Sql Validator To: phpmyadmin-devel@lists.sourceforge.net Message-ID: <50B4DD69.1050608@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@infomarc.info> Subject: [Phpmyadmin-devel] [SPAM] Re: Sql Validator To: phpmyadmin-devel@lists.sourceforge.net Message-ID: <50B4FCC6.1060802@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@infomarc.info> Subject: [Phpmyadmin-devel] navi panel and current table To: phpmyadmin-devel@lists.sf.net Message-ID: <50B4FE85.6090905@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@placella.com> Subject: Re: [Phpmyadmin-devel] navi panel and current table To: phpmyadmin-devel@lists.sourceforge.net Message-ID: <50B52251.9080209@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@infomarc.info> Subject: Re: [Phpmyadmin-devel] navi panel and current table To: phpmyadmin-devel@lists.sourceforge.net Message-ID: <50B61776.7020007@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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
End of Phpmyadmin-devel Digest, Vol 76, Issue 11 ************************************************