db initialization

[gnomicosuw]

Here are the updates for the database. I assume they will work for you.

• new default.sql file for the base v3 database. This is scrubbed. It ONLY includes data for "schema_migrations" since that is the only thing we want to pre-populate with the build automatically (it will prevent Rails from thinking you have migrations to run, since they have already been "run" in the dump)
• I'm not sure why you had a "create_aquarium_test.sql" file. The base database for development and test should both be exactly the same (i.e., the "default.sql" file). I kept the file for you but it is exactly the same as the "default.sql" file. You may want to keep both as references for the documentation, etc.
• for development, you should run rake db:seed (or rails db:seed, both work). This adds the permissions and the "neptune" user
• for testing, you should run rake db:seed:test_seeds (or rails db:seed:testseeds). This adds the permissions and the "user" users. Note you will need the custom_seeds.rake file, I added it, it was not in the v3-refactor branch.

Let me know if you have any questions.

[bjkeller]

The "create_aquarium_test.sql" file was because you wanted to run tests from the test database rather than from development. This is there to allow the default mysql_init mechanism to load the database when there is none.

this code at the top of the existing file is the difference:

 DROP DATABASE IF EXISTS `aquarium_test`;
 CREATE DATABASE `aquarium_test` CHARACTER SET latin1 COLLATE latin1_swedish_ci;
 GRANT ALL ON `aquarium_test`.* TO 'aquarium'@'%' ;
 USE `aquarium_test`;

If we can get away with having the backend service setting this database up, then we don't need this file.

[bjkeller]

starting in development, backend crashes with

Mysql2::Error::ConnectionError: Access denied for user 'aquarium'@'%' to database 'aquarium_test'

This probably relates to the change in the create_aquarium_test.sql file

[bjkeller]

merged into #574 closing