Hi,
I am working on bug [0]. My plan is, if the operation is "rename" , parse the sql query and identify what is new table name and reload the page with updated info.
1.) In top of the main page (in the div "serverinfo") it points to current table, db etc... How we can change where it points if the page is reloaded.? What variables do we need to set?
2.) Is there a existing Sql parser class or function that I can use to parse a sql query by extending its functionality, to identify the new table name?
[0] http://sourceforge.net/p/phpmyadmin/bugs/3818/
Samith Dassanayake a écrit :
Hi,
I am working on bug [0]. My plan is, if the operation is "rename" , parse the sql query and identify what is new table name and reload the page with updated info.
1.) In top of the main page (in the div "serverinfo") it points to current table, db etc... How we can change where it points if the page is reloaded.? What variables do we need to set?
2.) Is there a existing Sql parser class or function that I can use to parse a sql query by extending its functionality, to identify the new table name?
Hi, there is a parser in libraries/sqlparser.lib.php, but maybe preg_match() would be enough. See this solution attempt : [1]
[1] https://github.com/hisamith/phpmyadmin/commit/b250906159d8fb261409bbb12482b3...
On Marc Delisle a écrit :
Samith Dassanayake a écrit :
Hi,
I am working on bug [0]. My plan is, if the operation is "rename" , parse the sql query and
identify
what is new table name and reload the page with updated info.
1.) In top of the main page (in the div "serverinfo") it points to
current
table, db etc... How we can change where it points if the page is reloaded.? What variables do we need to set?
2.) Is there a existing Sql parser class or function that I can use to parse a sql query by extending its functionality, to identify the new
table
name?
Hi, there is a parser in libraries/sqlparser.lib.php, but maybe preg_match() would be enough. See this solution attempt : [1]
[1]
https://github.com/hisamith/phpmyadmin/commit/b250906159d8fb261409bbb12482b3...https://github.com/hisamith/phpmyadmin/commit/b250906159d8fb261409bbb12482b343b95fc0e9
Hi
I am the one who done that attempt. But the problem is, even though it reload the left menu with the updated information, in top of the main page (in the div "serverinfo") it points to the previous table name as you mentioned in the pull request. Same problem is there with a "Drop table " request(in sql tab). It updates the left menu but not the top main page. (It points to the deleted table name).
Samith Dassanayake a écrit :
On Marc Delisle a écrit :
Samith Dassanayake a écrit :
Hi,
I am working on bug [0]. My plan is, if the operation is "rename" , parse the sql query and
identify
what is new table name and reload the page with updated info.
1.) In top of the main page (in the div "serverinfo") it points to
current
table, db etc... How we can change where it points if the page is reloaded.? What variables do we need to set?
2.) Is there a existing Sql parser class or function that I can use to parse a sql query by extending its functionality, to identify the new
table
name?
Hi, there is a parser in libraries/sqlparser.lib.php, but maybe preg_match() would be enough. See this solution attempt : [1]
[1] https://github.com/hisamith/phpmyadmin/commit/b250906159d8fb261409bbb12482b3...https://github.com/hisamith/phpmyadmin/commit/b250906159d8fb261409bbb12482b343b95fc0e9
Hi
I am the one who done that attempt. But the problem is, even though it reload the left menu with the updated information, in top of the main page (in the div "serverinfo") it points to the previous table name as you mentioned in the pull request. Same problem is there with a "Drop table " request(in sql tab). It updates the left menu but not the top main page. (It points to the deleted table name).
Hi, the major part of fixing a bug is doing the research and this is how you'll show your skills to the community.
-
Marc Delisle -
Samith Dassanayake