Re: Deciding on a default company setup for BDD tests

On Sun, Jan 24, 2016 at 7:24 PM, Michael Richardson <..hidden..> wrote:

David G <..hidden..> wrote:
> This was sort of my point too, I don't think it is worth the extra effort to
> try and clean up the DB so tests can be re-run. Just drop the db and re-clone
> it before rerunning the test. You don't want to drop it after running the
> tests incase you need to manually verify something. hence the suggestion to
> use a known naming scheme so it is obvious what a db is for.

It would be ideal if we could run the tests in a transaction, and then just
roll it back. That's what Rails and Django do.

I wonder if we could use some other postgresql magic here... for instance,
maybe the new feature that makes the database hide anything that isn't
between the valid time stamps. (I learnt of this at PGcon, I can't find the
feature at the moment).

If not, maybe:
CREATE DATABASE newdb WITH TEMPLATE originaldb OWNER dbuser;

would make it nice and fast to run between test cases... getting the test
cases to run really fast, is pretty important, and I don't think going behind
the applications' back to clean it is unreasaonable.

I think this is a great idea. I also think our lsmb_test_db template should be set up for all tests. I.e. it should be sufficiently realistic data to provide a starting point for all testing scenarios. In other words right now we set up the database for specific test cases, such as reconciliation. We should probably also include the test result table.

I don';t think that would be hard at present. I think I could merge all the special test setup scripts and adjust the test cases pretty quickly.

Any thoughts beyond adding the data we currently have?

--
] Never tell me the odds! | ipv6 mesh networks [
] Michael Richardson, Sandelman Software Works | network architect [
] ..hidden.. http://www.sandelman.ca/ | ruby on rails [

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

Best Wishes,

Chris Travers

Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.

http://www.efficito.com/learn_more