Technical stuff Requirements are like water. They're easier to build on when they're frozen.

Archive for the ‘testing’ Category

QQA in Software Projects with Sebastian Bergmann @ Dutch PHP Conference | Part 2 | Notes

06.10.2010 · Posted in testing

-> Continuous Integration —> build automation [write build script to get latest code version; run tools to detect problems; run unit tests & publish these results; package; deploy] —> summary of the tools enumerated below can be found in this presentation: http://www.slideshare.net/sebastian_bergmann/continuous-integration-of-php-projects-4354597 -> static code analysis —> LOC [= lines of code] metric —> CLOC ...

QA in Software Projects with Sebastian Bergmann @ Dutch PHP Conference | Part 1 | Notes

06.10.2010 · Posted in testing

-> what is SW quality? -> the BankAccount example —> PHPUnit 3.4.12 is used for these examples —> CLI run using phpunit BankAccountTest —> phpunit –testdox BankAccountTest —> used for instance to present functionality summary before the actual coding —> setUp() —> Q&A —> use @expectedException annotation instead of the try/catch block inside the method ...

mySQL: find out distinct values of a column and the number of their occurrences

06.20.2009 · Posted in Quick and dirty, Software, testing

So, we need to find out different values of a column and the number of their occurrences. Let’s set up a small test first: -- Step #1: prepare the ground CREATE DATABASE IF NOT EXISTS `test`; DROP TABLE IF EXISTS `test`.`test_count_distinct`; CREATE TABLE `test`.`test_count_distinct` ( `id` INT(11) NOT NULL auto_increment PRIMARY KEY, `title` VARCHAR(50) NOT ...