[Phpmyadmin-devel] Sql Validator

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

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

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

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

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
participants (3)
-
Dron Rathore
-
Marc Delisle
-
Rouslan Placella