Database & Testing update

### In this PR are some structural changes to tests:
 - No database URLs or credentials are stored in the project (source code, config or otherwise)
 - All Database info & creds are retrieved via `CrsProperties`
 - All tests which interact with the database extend `AbstractTestWithDatabaseConnectivity`
 - `AbstractTestWithDatabaseConnectivity` does a refresh of the target database before each test run

### Necessary changes:
 - Add profiles which contain DB URL, user & password to maven settings.xml (usually found at ~/.m2/settings.xml).  See below for example.

### Known side effects:
 - Tests can no longer be run inside intelliJ as even when running a maven goal inside the IDE, the properties don't get set in src/test/resources/default-properties.xml
 - When running tests from CL, a profile must be specified.  See example:

### Possible gotchas:
 - Do not EVER put production creds as a profile like this, as a test run could wipe out the production database.  There is no reason to do so.  Production creds should reside only in the application properties.  Actually you could try, but I'll likely make it that the prod DB would ignore connections things other than app servers.

Example profile:
```xml
<profiles>
        <profile>
                <id>eventhub-local</id>
                <properties>
                        <database.url>jdbc:postgresql://localhost/crsdb</database.url>
                        <database.username>crsuser</database.username>
                        <database.password>[password]</database.password>
                </properties>
        </profile>

        <profile>
                <id>eventhub-unittest</id>
                <properties>
                        <database.url>jdbc:postgresql://[remote-ip/host]/crs_unittest</database.url>
                        <database.username>crs_unittest_user</database.username>
                        <database.password>[password]</database.password>
                </properties>
        </profile>
</profiles>
```
Example test run:
```
bash: mvn clean test -Dgroups=[functional-tests,dbtest,unittest] -P [eventhub-unittest]
```
Cool, i'll remove it then :)


On Fri, Jun 6, 2014 at 10:56 AM, hlbraddock <notifications@github.com>
wrote:

> In pom.xml:
>
> > @@ -201,7 +207,7 @@
> >  				<artifactId>maven-surefire-plugin</artifactId>
>
> Yup. Removed the explicit plugin from the pom, and checked the available
> plugins from IntelliJ as well as mvn command line. And, ran the tests
> from mvn command line. I was surprised at this as well (as I suppose you
> are).
>
> —
> Reply to this email directly or view it on GitHub
> <https://github.com/CruGlobal/conf-registration-api/pull/166/files#r13493648>
> .
>



-- 
*Ryan Carlson*
Sr Programmer / Analyst
Web and Moblie Development Team
ryan.t.carlson@cru.org