#unit-testing
RSS- pgTAP 0.22: Test Your Results
https://justatheory.com/2009/07/pgtap-test-your-results
I’m pleased to announce that, after much thinking, committing, and not an insignificant amount of hair-pulling, pgTAP 0.22 has finally landed. Download it here. Many, many thanks to all who commented on my previous posts, made suggestions, and helped me on IRC to figure out how to get all this stuff to work. The crazy thing is that it does, quite well, all the way back to PostgreSQL 8.0.
- The Purpose of TestSimple
https://justatheory.com/2005/05/test-simple-js-purpose
In response to my TestSimple 0.03 announcement, Bill N1VUX asked a number of important questions about TestSimple’s purpose. Since this is just an alpha release and I’m still making my way though the port, I haven’t created a project page or started to promote it much, yet. Once I get the harness part written and feel like it’s stable and working well, I’ll likely start to promote it as widely as possible.
- pgTAP 0.12 Released
https://justatheory.com/2008/10/pgtap-0.12
- pgTAP Best Practices Slides Available
https://justatheory.com/2009/11/pgtap-best-practices
Last month I gave two presentations at the PostgreSQL Conference West. The first was a variation on Unit Test Your Database!, which I’ve now given about six times (and will at least two more times, including tomorrow night for Portland PLUG and in two weeks at the JPUG 10th Anniversary Conference). The second was a new talk, a 90-minute tutorial, called “pgTAP Best Practices.” And here it is (download and Slideshare). Enjoy!
- pgTAP Set-Testing Update
https://justatheory.com/2009/06/pgtap-set-testing-update
- Introducing MyTAP
https://justatheory.com/2010/07/introducing-mytap
After some prodding from the MySQL Community Manager, some OSCON hacking yields tangible results.
- More on Database Testing
https://justatheory.com/2009/05/more-on-database-testing
More thoughts on they whys and hows of database testing, and wondering why one might think that it’s pointless or useless.
- pgTAP 0.11 Released
https://justatheory.com/2008/09/pgtap-0.11
- Test XML and HTML with XPath
https://justatheory.com/2009/09/test-with-xpath
Introducing a Rails-inspired Perl module to test the structure and content of an XML or HTML document using CSS selectors.
- Need Help Naming Result Set Testing Functions
https://justatheory.com/2009/06/pgtap-result-testing-function-names
- Why Test Databases?
https://justatheory.com/2009/03/why-test-databases
- Introducing pgTAP
https://justatheory.com/2008/06/introducing-pgtap
So I started working on a new PostgreSQL data type this week. More on that soon; in the meantime, I wanted to create a test suite for it, and wasn’t sure where to go. The only PostgreSQL tests I’ve seen are those distributed with Elein Mustain’s tests for the email data type she created in a PostgreSQL General Bits posting from a couple of years ago. I used the same approach myself for my GTIN data type, but it was rather hard to use: I had to pay very close attention to what was output in order to tell the description output from the test output. It was quite a PITA, actually.
- pgTAP 0.21 Drops
https://justatheory.com/2009/05/pgtap-0.21
I just dropped a new version of pgTAP following a few marathon hack sessions since my talk at PGCon (movie here, BTW). Actually, the new performs_ok() function came about as I wrote the presentation, but all the rest came on the flight home and in the few days since. Not sure when I’ll hack on it this much again (it’s getting a bit big at 5,758 lines of PL/pgSQL and SQL).