On Sun, Jan 24, 2016 at 7:24 PM, Michael Richardson <m...@sandelman.ca>
wrote:
> David G <lsmb...@sbts.com.au> 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 [
> ] m...@sandelman.ca 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
> Ledger-smb-devel@lists.sourceforge.net
> 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
------------------------------------------------------------------------------
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=272487151&iu=/4140
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
