Re: [Ledger-smb-devel] Why no LedgerSMB name space

2012-12-02 Thread Chris Travers
On Sat, Dec 1, 2012 at 8:50 AM, Berend Tober wrote: > I am wondering why all the LedgerSMB tables are not created in an > application-specific namespace, rather than the PUBLIC schema? > > By default that is correct as far as what we do. It is quite possible to alter the user that creates the db

Re: [Ledger-smb-devel] Why no LedgerSMB name space

2012-12-02 Thread Chris Travers
Reading this I get the impression that we have a fair number of secrets that are probably kept too well. The most obvious is our current db test framework which runs scripts which can be found in sql/modules/test/ but the second is the fact that the test framework can be told to install, set up, a

Re: [Ledger-smb-devel] Data base sanity checks

2012-12-02 Thread Chris Travers
Our sanity checks right now are limited to the tests in t/43-dbtest.t and defined in the files of sql/modules/test/ These tests are not comprehensive. We don't test to make sure that every table is created, etc, but generally if you are missing a table you are going to get errors somewhere, since