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
Rinaldo Bonazzo's Blog, outdoor passionate - sometimes likes to blog about Disruptive Technology #EnterprisePortal #BigData #Analytics #Cloud #Iot #node.js ...
Wednesday, April 14, 2010
MySQL :: Top Reasons to Use MySQL
MySQL® database maybe the world most popular open source why?
MySQL :: Top Reasons to Use MySQL
MySQL :: Top Reasons to Use MySQL
Tuesday, April 13, 2010
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
Install Open ERP 5.0.6 on Mac OS X 10.5.8 Leopard
Saturday, April 10, 2010
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
Again surfing on Google and I found COALESCE
The postgresql manual say:
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
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 1Fine my problem was solved NO!! openERP use postgresql and postgresql doesn't support IFNULL
SELECT IFNULL(null, 0) this query return 0
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
Thursday, April 8, 2010
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
Rinaldo
Subscribe to:
Posts (Atom)