July 2009 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Automated testing
by Herman van Rink 17 Jul '09

17 Jul '09

Hi, I've played around with phpunit a bit as of late, and think we could make better use of this for pma. The PMA_formatNumberByteDown_test test still fails for me on a conversion.... does this pass on other systems? I've setup several new testcases that uses Selenium RC [1] to replay actual browser behaviour. My first test in this is a case where I log in and do some basic browsing and change the test users password. The test scenario's are easily recorded using the Firefox Selenium IDE add-on. [2] Testing can happen in Firefox, Internet Explorer and other browsers. I've set up a cronjob which would run the test suite e.g. every day on trunk, and plan to expand this to the latest testing branch. Any errors would be mailed to me. If others are interested I could sent this to a list address. Issues: - Using a self-signed ssl certificate with Selenium RC is a pain, using non-ssl for now. [4] - Somehow selenium does not like the language selection on the cookie login page, forced English in my config for now. - The current naming scheme for test cases seems to be a bit off, according to the phpunit defaults. When running through wui.php it works, but when running individual tests the underscores in the class/file names are interpreted as directory separator. I therefore propose a CamelCase format for the new selenium classes. - The wiki has no info about testing, I propose a Devel:UnitTesting page I hope to soon commit these changes to trunk, any feedback would be very welcome. References: 1. http://seleniumhq.org/ 2. https://addons.mozilla.org/en-US/firefox/addon/2079 2 .http://www.phpunit.de/manual/3.1/en/selenium.html 4. http://townx.org/blog/elliot/dealing-self-signed-ssl-certificates-when-runn… -- Met vriendelijke groet / Regards, Herman van Rink Initfour websolutions

3 9

[Phpmyadmin-devel] current user
by Zeeshan Mughal 17 Jul '09

17 Jul '09

Hi, I am using the following code to extract currently logged user name from PMA_DBI_fetch_value('SELECT USER();') // $userAndHost = PMA_DBI_fetch_value('SELECT USER();'); // $userAndHost = str_split($userAndHost); // while ($i=0 < count($userAndHost)-1) { // $username += $userAndHost[$i]; // $i++; // if ($userAndHost[$i] == "@") { // break; // } It takes a lot of time to load up the web page mainly due to the code above. Is there any alternative to this? Thanks! P.S. follow my live progress update streams at zixan.info. I find it is much more effective way to communicate more frequently. -------------------------------------------------- Best regards, Zeeshan Mughal Email: zeeshanmughal(a)ieee.org Web: http://www.zixan.info

4 4

[Phpmyadmin-devel] Vacation + DebConf
by Michal Čihař 17 Jul '09

17 Jul '09

Hi all I'll be till 4th August on vacation in Spain being one week in the middle on the DebConf 09. This means that I will not read emails that often and replies to private emails can take long. So especially for GSoC students it means what I've told all the time - use the mailing list to ask questions. And please write status reports, it is again end of week and I did not see much of them! I will take lack of communication as more important thing in final evaluation, which can make you fail even if you will provide working code. -- Michal Čihař | http://cihar.com | http://phpmyadmin.cz

1 0

Re: [Phpmyadmin-devel] [Phpmyadmin-svn] SF.net SVN: phpmyadmin:[12658] branches/gsoc/derek
by Michal Čihař 16 Jul '09

16 Jul '09

Hi Derek Dne Wed, 15 Jul 2009 20:09:46 +0000 drummingds1(a)users.sourceforge.net napsal(a): > @@ -262,7 +262,7 @@ > /** > * Bookmark table > * - leave blank for no bookmark support > - * SUGGESTED: 'pma_bookmark' > + * DEFAULT: 'pma_bookmark' > * > * @global string $cfg['Servers'][$i]['bookmarktable'] > */ Please do not revert changes made in trunk (there is more such changes). -- Michal Čihař | http://cihar.com | http://phpmyadmin.cz

2 1

[Phpmyadmin-devel] private student branches
by Marc Delisle 15 Jul '09

15 Jul '09

Hi, maybe students can use this to keep their private branches in sync with the trunk: http://svnbook.red-bean.com/en/1.5/svn.branchmerge.basicmerging.html#svn.br… -- Marc Delisle http://infomarc.info

1 0

[Phpmyadmin-devel] "Cannot modify header information" and strange character anomalies.
by Derek Schaefer 15 Jul '09

15 Jul '09

Hey all, I'm having a couple issues that I can't quite pin down. They aren't show-stoppers by any stretch of the imagination, but they're still something I need to work out before the end of the summer. I created a notification panel that displays the various structures created or altered on import. To accomplish this I used the PMA_Message::notice class to build a string of html, and then ->display() it, as should be done, I believe. When this panel is displayed, there are several warnings regarding not being able to modify header information, header info. already sent, etc. I know what this means and mostly understand how PHP handles headers, but I'm not entire sure why it is throwing these errors. Upon a successful import, there is a PMA_Message::success element displayed under the navigation buttons that tells how many queries were executed, etc., and that doesn't cause header problems. I imagine this is cropping up because of how I am using PMA_Message, although I'm using it in ways demonstrated elsewhere. Also, whenever the aforementioned notification panel is displayed, strange character anomalies appear at the very bottom of the import page. They change every time, but always take the form ",�<��Y". My best guess is that it is related the the header issues, but until I can get rid of them I can't know for sure. Here is a screenshot of the character anomaly and a couple of the header backtraces: http://downloads.moonlapse.org/pma/import_issues.jpg If anyone has some insight into these issues, I would greatly appreciate any direction you could give. -Derek

3 12

[Phpmyadmin-devel] GSoC student branches
by Marc Delisle 15 Jul '09

15 Jul '09

Hi Derek, creating your own branch means copying a complete branch (in our case the trunk/phpMyAdmin) to the branches/gsoc/derek structure, then copy over your files and commit. -- Marc Delisle http://infomarc.info

3 8

[Phpmyadmin-devel] Help me fetch FOREIGN KEYS from a table
by Zahra Naeem 15 Jul '09

15 Jul '09

Hi, Can any one help me fetch foreign keys (fields) information from a table? I mean any query that may be helpful or any structure in MYSQL that can work. I have already tried "SHOW TABLE STATUS WHERE NAME= 'abc' " query , and a lot of other things but none of them was helpful. If anyone knows, kindly reply me ASAP:) Best Regards, Zahra

3 2

[Phpmyadmin-devel] For the Midterm Evaluation - All My Code to Date
by Derek Schaefer 14 Jul '09

14 Jul '09

Greetings everyone! I present to you, all my code to date! If you are curious enough to look over my code, please send me any suggestions that you may have. - An SVN diff file created against revision 12637 on July 9th (http://downloads.moonlapse.org/pma/midterm/pma_trunk.diff.zip) ... and for your convenience: - All my code files in the PMA directory structure as of this afternoon (http://downloads.moonlapse.org/pma/midterm/all_code.zip) Enjoy! -Derek Schaefer

3 18

[Phpmyadmin-devel] Please remove my email from the E-mailing list. Thank you.
by Danny Taveras 14 Jul '09

14 Jul '09

I don't see any links where I can remove myself from the E-mailing list.

2 2