dungeonsoffear - 2016-04-29

Tonight was a good night, one of those maintenance work nights that's going to really impact automation of this project in the future.

Wrote a tool that updates the server by creating a db backup, pulling down svn, running tests, and doing database migration. Database migration works of a series of scripts in tools/migrations, where each is named migration_0.php, migration_1.php, etc. It then goes through the list of scripts, checks to see if the db version is less than the scipt, and if so, runs it. The idea is that the scripts should be able to change the database while making it compatible with the old version of code; therefore a blue/green deployment is possible.

Next up I have to do some security stuff on the server like getting the db out of the document root, and then I'm going to add a page for confirming rooms. By the weekend we should have some rooms in and do some play testing.

3 Hours