[Phpmyadmin-devel] GSoC tracking mechanism, status report July 13th - 17th

Hi all, here is my report: KEY ACCOMPLISHMENTS LAST WEEK ============================= - I got my own SVN branch phpmyadmin/branches/gsoc/alex/phpMyAdmin (thanks to Marc for the permissions). - SVN copy from trunk/phpMyAdmin was unexpected not easy for me, because I made the mistake to use http instead of https and so I got the error message "502 BAD GATEWAY". First I thought it was a problem with my subclipse plugin but then I found the hint about the protocol and then the copy process worked fine. - Switched from Eclipse 3.2 to NetBeans IDE 6.7. PHP eclipse nerved me because it was sometimes unstable and did not open some files. NetBeans seems to be more optimized for PHP development. - Did some work on my code too :) Here is a summary of my committed changes to SVN branch: + First tracking mechanism patch applied. + Problems causing PHP notices solved. + Some useless PMA_DBI_select_db() calls removed. + Bug: after renaming a table the list of tracking versions is broken (Fixed) + Using PMA_query_as_controluser where it is possible. + New tab "Tracking" for the table view added. + A little bit PMA_Tracker code refactoring. + SQL dump of pma_tracking to scripts/create_tables.sql added. + Localization introduced, using string vars in english-utf-8.inc.php for outputs. + Short php tags and short print instruction removed how it is recommended in PEAR coding standards. (Thanks to Michal for the helpful hints). KEY TASKS THAT STALLED ====================== Parsing for additional commands like ALTER VIEW etc. First I want to read and tryout PMA SQL parse functions. It makes more sense to optimize the parser of PMA_Tracker before adding new types of SQL statements. KEY CONCERNS ============ Tracking functionality for whole databases. At current status a user has to select every single table that he wants to track. Is it possible to forward prepared SQL dump code to the export script of PMA ? When yes I could use it to deliver more export types than SQL dump and SQL execution. TASKS IN THE UPCOMING WEEK ========================== - Make me familiar with the PMA SQL parser library / functions. - Try to use PMA SQL parser library. - I think it would be a good idea to track the usernames too. I will add this attribute to the tracker log and build a filter to the tracking report. Best regards and have a nice WE Alexander