How to implement UI testing without shooting yourself in the foot

From Gojko Adzic
in this post Gojko present what he consider a very good practice for how to do UI test automation efficiently.

How to implement UI testing without shooting yourself in the foot

Rinaldo

MySQL :: Top Reasons to Use MySQL

MySQL® database maybe the world most popular open source why?
MySQL :: Top Reasons to Use MySQL

Install Open ERP 5.0.6 on Mac OS X 10.5.8 Leopard | Christopher R. Shackleton, MD

From Cristopher R.Shackleton I suggest you this post

Install Open ERP 5.0.6 on Mac OS X 10.5.8 Leopard

Intercept null value on a query

These last days working to create a Pentaho report with openERP data, I came across a serious problem:
if a query return a null value arithmetic operations are in error. The question was how to intercept the null value, surfing on Google I found this

SELECT IFNULL (1,0) this query return 1
SELECT IFNULL(null, 0) this query return 0

Fine my problem was solved NO!!  openERP use postgresql and postgresql doesn't support IFNULL
Again surfing on Google and I found COALESCE
The postgresql manual say:

The COALESCE function returns the first arguments of ITS THAT IS NOT NULL. Returned is null only if all arguments are null. Often it is used to substitute a default value for null values 

Finally my problem was solved my query now  is something like this
SELECT COALESCE(sum(aal.amount * -1) , 0) FROM account_analytic_line AS aal WHERE (aal.account_id=83) and aal.journal_id = 3

Rinaldo

5 Levels of Agile Planning: From Enterprise Product Vision to Team Stand-up

To day I need to suggest a paper that evaluates agile practices when applied in multi-team and multi-person-year projects. Download it here  


Rinaldo