Need to look up a character in a book you're reading, but worried about finding spoilers in the process? We've got you covered.

Tell us how far you've read before searching this wiki, and it will only return information discovered up to the point you've reached.

built with Propel ORM and Slim. Developed using Vagrant with Scotch Box.

1. git clone git@github.com:sam-higton/spoiler-wiki.git /path/to/webroot/

2. cd /path/to/webroot

3. composer install

4. vagrant up

   • if you're having issues in windows 10, this is probably why, and make sure you're using the latest version of VirtualBox
   • vagrant will probably complain about the connection timing out an awful lot. Just ignore it for a minute or so; it'll sort itself out eventually

5. You now need ssh into the virtual box (vagrant ssh) and open up mysql to external traffic. this explains it better than I can (todo: mess about with vagrant provisions to find a way of automating this)

6. make a copy of propel.json.example and call it propel.json

7. update with your database connections.

8. spoilerwiki-local is the connection that will be used by the application on the server, and hence will probably be pointing to localhost.

9. spoilerwiki-remote is the connection that will be used when you run propel from the command line. As this will be running on the host machine, the connection will need to be pointed at hte IP of your vagrant box (192.168.10.33, if you're using the default settings. In fact, if you're using the default settings, you can just use the connection settings that are already in the example. I know, the password is "root", but it's only running locally. Don't be so quick to judge.)

10. vendor/bin/propel config:convert

11. vendor/bin/propel sql:build --overwrite

12. vendor/bin/propel sql:insert

If the schema has been modified since the last commit, run the following to preserve your data (note: this doesn't actually work yet (update: I have this sort of working now! You just have to pass the dsn to the diff command. It's not very convenient, but hey, it works!)):

1. vendor/bin/propel diff --connection='<insert fully qualified dsn here>'
2. vendor/bin/propel migrate

You may also need to run composer dump-autoload, if the model structure has been changed