Digital Sandwich - Comments

osisus: PHPUnit Database Extension (DBUnit Port)

nospam@example.com (osisus) — Thu, 14 Aug 2008 09:28:57 -0400

Thanks a lot for your work. It is very helpful. I didn't find a way to build quickly a dataset from the database, so I develop the following php script. I hope it will be useful to some people... Cheers ! OS.

CODE:

//Deals with the optional GET parameter $displayInBrowser = FALSE; $openMarkupChar = '\n"; //Loop on each table to retrieve its content foreach ($tablesListArray as $tableName) { $queryResult = mysql_query('SELECT * FROM `' . $tableName . '`'); while ($tableRowArray = mysql_fetch_assoc($queryResult)) { //Open the database item XML markup echo " $openMarkupChar$tableName"; //Loop on each column to get the values. foreach ($tableRowArray as $columnName => $value) { echo " $columnName="" . htmlentities($value) . """; } //Close the database item XML markup echo " />\n"; } } //Close the Dataset XML node echo "$openMarkupChar/dataset>\n"; if ($displayInBrowser) { echo ""; }

Mathieu: Late Static Binding (LSB) forward_static_call()

nospam@example.com (Mathieu) — Mon, 11 Aug 2008 02:06:07 -0400

A few months later, but it seems that parent:: does forwarding by itself now:

class ActiveRecord
{
public static function findByPk($id)
{
$class = get_called_class();
echo "ID: $id\n";
echo "CLASS: $class\n";
}
}

class Blog extends ActiveRecord
{
public static function findByPk($id)
{
echo "Hello, world! I am BLOG!\n";
parent::findByPk($id);
}
}

Blog::findByPk(15);

with a recent PHP 5.3 checkout results in: [geshi] Hello, world! I am BLOG! ID: 15 CLASS: Blog [/geshi]

Logan: Las Vegas PHP Group: It's Alive

nospam@example.com (Logan) — Sun, 03 Aug 2008 22:16:59 -0400

Thanks for the update. I'll be in las vegas next week.

mjimenez: PHPUnit Database Extension (DBUnit Port)

nospam@example.com (mjimenez) — Fri, 18 Jul 2008 06:32:02 -0400

Every public testWhatever() method tests some functionality of the class we want to test. Do they all share the dataset returned by getDataSet()? Is there a way to specify different initial state for different testWhatever() methods? The initial state dataset is class-level or can it be method-level? Or maybe the latter is not a good idea whatsoever? I want to test a class that is like a finite state machine, and every testWhatever() method is a transition. Therefore, every test method focuses on a different initial state. If I design a class-level dataset as the union of the initial testmethod-level datasets, phpunit forces me to include them again in every final dataset to compare with -except the corresponding to the current test method, substituted by the end state of the transition. That's very verbose and redundant, and scales badly when you add test methods. Alternatively, I can use a test class for each test, but that's class-verbose; for a system class to test, I need as many test classes as functionalities I want to test; It doesn't look as a clean implementation of a unit test to me, does it? Thanks!

mjimenez: Adding Database Tests to Existing PHPUnit Test Cases

nospam@example.com (mjimenez) — Thu, 17 Jul 2008 09:49:58 -0400

You said "Yes, this is in fact possible utilizing the PHPUnit_Extensions_DBUnit_DataSet_DataSetFilter decorator" In my 3.2.21 setting I have to use PHPUnit_Extensions_Database_DataSet_DataSetFilter class instead

Adrian Schoenig: Adding Database Tests to Existing PHPUnit Test Cases

nospam@example.com (Adrian Schoenig) — Sun, 06 Jul 2008 22:59:46 -0400

PHPUnit_Extensions_Database_Operation_RowBased::execute() is the bottle neck to be precise.

Adrian Schoenig: Adding Database Tests to Existing PHPUnit Test Cases

nospam@example.com (Adrian Schoenig) — Sun, 06 Jul 2008 22:55:32 -0400

I had the problem that loading the database with contents from an XML file was horribly slow (took more than a minute per test case on my setup!) even though there are just a dozen tables in the file with a handful of rows in each. PHPUnit_Extensions_Database_Operation_RowBased is the bottle neck. I got it to speed up by a factor of almost 40 by changing to transactions and most importantly by replacing $databaseTableMetaData = $databaseDataSet->getTableMetaData($table->getTableMetaData()->getTableName()); with: $databaseTableMetaData = $table->getTableMetaData();

Catalin Z. Alexandru: More Form Generator

nospam@example.com (Catalin Z. Alexandru) — Fri, 27 Jun 2008 05:07:44 -0400

I already have a working one, generating all types of inputs with all their HTML attributes. It was easy, it took me two days for the core and a week for input validation and some other short little features.

Andreas Wiik: PHPUnit Database Extension (DBUnit Port)

nospam@example.com (Andreas Wiik) — Mon, 16 Jun 2008 04:12:56 -0400

Ahh, you use the same object for both the system and the test. Thanks for the answer! PS: When are you and Sebastian going to update the handbook? http://www.phpunit.de/pocket_guide/3.2/en/database.html

Udo: Who needs pear...propel does just fine

nospam@example.com (Udo) — Sun, 15 Jun 2008 12:48:02 -0400

A small "How-To" would have been nice Thanks anyway, I am wrestling with Propel for about 4 Days now - the PEAR-Version...

Mike Lively: PHPUnit Database Extension (DBUnit Port)

nospam@example.com (Mike Lively) — Sat, 14 Jun 2008 19:50:09 -0400

you don't have to use a pdo object in the code you are testing. In fact it is preferred (imo) that you use a completely different connection anyways. I just used the same connection for brevity of the example. The only requirement for PDO is for the setting up of the tests themselves. You are not required to use PDO in your code.

Andreas Wiik: PHPUnit Database Extension (DBUnit Port)

nospam@example.com (Andreas Wiik) — Fri, 13 Jun 2008 07:18:12 -0400

Can you give an example of what BankAccount() and createTable looks like?

Andreas Wiik: PHPUnit Database Extension (DBUnit Port)

nospam@example.com (Andreas Wiik) — Fri, 13 Jun 2008 07:13:44 -0400

It's probably me being stupid, but... I don't really get it. You create a PDO-object and then you send it to the function you are testing. I am not prepared to rewrite my project to make all functions accept a PDO-object. What am I missing?

Brian Kowalsky: Windows 98 Drivers for Dell Memory Key

nospam@example.com (Brian Kowalsky) — Tue, 10 Jun 2008 06:23:19 -0400

I had the same roblem with the memory key. it drove me insane :((

Adrian: Adding Database Tests to Existing PHPUnit Test Cases

nospam@example.com (Adrian) — Tue, 10 Jun 2008 02:59:53 -0400

Hi Mark, Great extension! I've noticed that you used to work on the official documentation of this feature (http://www.phpunit.de/pocket_guide/3.2/en/database.html). However, it hasn't been updated in last 6 months. Any chance you will find some time to finish it? Cheers.