YAML Now Supported by PHPUnit Database Extension

Sunday, February 1. 2009

YAML Now Supported by PHPUnit Database Extension

I have now just committed YAML data sets to the Database Extension for PHPUnit. So now all those that love the simplicity and straightforwardness of YAML can use it with your data sets. I have also created a persistor for YAML datasets so you can easily convert existing data sets or database data into YAML representations.

This is really the first I have dealt with YAML and it is definitely a viable alternative for data sets. Here is what they will look like.

table1:
-
table1_id: 1
columnName1: "tgfahgasdf"
columnName2: 200
columnName3: 34.64
columnName4: yghkf;a hahfg8ja h;
table2:
-
table2_id: 1
column5: fhah
column6: 456
column7: 46.5
column8: "fsdb, ghfdas"
-
table2_id: 3
column5: ajsdlkfguitah
column6: 654
column7: blah
column8: |-
thesethasdl
asdflkjsadf asdfsadfhl "adsf, halsdf" sadfhlasdf

The biggest issue I had was figuring out how YAML dealt with trailing line breaks. It appears that '|-' did the trick. It will strip the final line break. Another thing to take note is that indention is important. It doesn't HAVE to be spaces (it can be tabs) it just needs to be consistent. The last thing is that strings do not need to be quoted, but if they are you can use escape characters (like \n.)

This was committed to the trunk of PHPUnit and I anticipate Sebastian will be merging it back into 3.4 shortly.

Posted by Mike Lively in PHP Testing at 13:22 | Comments (8) | Trackbacks (0)

Trackbacks

Trackback specific URI for this entry

No Trackbacks

Comments

Display comments as (Linear | Threaded)

I browsed phpunit's trac a bit and looks like it is not commited properly. You reference PHPUnit/Util/YAML/sfYaml.class.php file, but it is not in the tree…

#1 Alexey Zakhlestin (Homepage) on 2009-02-03 06:58 (Reply)

It should be externalled at PHPUnit/Util/YAML?

#1.1 Mike Lively on 2009-02-03 22:52 (Reply)

Check the bottom of this page and you'll see the external:

http://www.phpunit.de/browser/phpunit/trunk/PHPUnit/Util

#1.1.1 Mike Lively on 2009-02-03 22:56 (Reply)

Can you give an example of how to use it? I've looked around in the API documentation but I didn't see a PHPUnit_Extensions_Database_DataSet_YamlDataSet or anything similar.

Thanks!

#2 Jack on 2009-02-26 18:17 (Reply)

Can't anybody update documentation?
Database extension has no info about this at all.
http://www.phpunit.de/manual/3.4/en/database.html#database.operations

#3 MK on 2010-02-20 17:50 (Reply)

Largely a lack of time on my part. There will be a fairly thorough description of this functionality in a soon to be released book. I am also attempting to put some more time in on my personal projects which would include some long awaited documentation and bug fixes. I have to feed the family first

#3.1 Mike Lively (Homepage) on 2010-04-06 19:53 (Reply)

hello~ thanks for your efforts
what's going on here?
i cannot find the yaml classes anywhere

#4 kiddyfurby on 2010-05-19 23:13 (Reply)

found it, with 3.4.12 (current stable), there's actually a yaml data set class
thanks for the great work, yaml is great for fixture

[geshi lang=php]
require_once 'PHPUnit/Extensions/Database/DataSet/YamlDataSet.php';
protected function getDataSet() {
return new PHPUnit_Extensions_Database_DataSet_YamlDataSet($path_to_yaml);
}
[/lang]

#4.1 kiddyfurby on 2010-05-20 00:13 (Reply)

Add Comment

Name
Email
Homepage
In reply to
Comment	BBCode format allowed Standard emoticons like :-) and ;-) are converted to images. E-Mail addresses will not be displayed and will only be used for E-Mail notifications To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly. Enter the string from the spam-prevention image above: You can use [geshi lang=lang_name [,ln={y\|n}]][/lang] tags to embed source code snippets
	Remember Information? Subscribe to this entry

Paying for the Site

Looking for Dell Memory, HP Memory, Apple Memory, Compaq Memory or other system memory?
Find all your memory needs at EDGE Tech Corp..

DSO Special Offer - Save an additional 5%
Use

Coupon Code: ACM-CLUB

Quicksearch

Daily Reads

The PHP WTF
Sebastian Bergmann
Wez Furlong
Tom Sommer
Tobias Schlitt
Chris Shiflett
Ben Ramsey
adam trachtenberg
Sklar
george schlossnagle
Dynamically Typed (Harry Fuecks)
John Coggeshall
John Lim
Marco Tabini
PHP Application Tools
Planet PHP
PHPCommunity.org