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:
- Sql Validator (Dron Rathore)
- Re: Sql Validator (Rouslan Placella)
- Re: Sql Validator (Marc Delisle)
- Re: Sql Validator (Rouslan Placella)
- [SPAM] Re: Sql Validator (Marc Delisle)
- navi panel and current table (Marc Delisle)
- Re: navi panel and current table (Rouslan Placella)
- 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
-
Dron Rathore