Backend

The Avengers!

Purpose

To be a backend written in PHP

Setting up local development

1. Install Composer https://getcomposer.org/doc/00-intro.md
2. enable ast https://github.com/nikic/php-ast#installation
3. On the commandline run composer install

Setup local mysql db:

1. Install mysql if not already installed: sudo apt-get install mysql-server
2. sudo mysql

Setup MySQL Users

Scripts are written under the assumption that you have a dedicated git user in your sql database. If you want to use a single user for all, just erase the one you don't care about and update the scripts to use your chosen username.

1. Open the db_setup.sql and replace all instances of username with your chosen username.
2. In the commandline run sudo mysql < db_setup.sql.

Setup Git Automatic Database Commits

1. Open db_setup.sh replace all instances of [path to backend repo] with the directory where the git repository is stored. For example, mine is at ~/Documents/Backend. Please look at the script and ensure that it is not overwriting any files you have already setup.
2. run the db setup command sh db_setup.sh

Setup MySQL Workbench

1. Download Mysql Workbench here --> https://dev.mysql.com/downloads/file/?id=479197
2. Open MySQL Workbench, The Localhost instance should be listed under MySQL Connections. Right-click on it and select edit connection. Put your username you created above in the username field, enter your password, and then click test connection at the bottom. If everything is setup correctly, it should provide basic information about the database connection.
3. Open a query Tab for the localhost connection by clicking on it. If you have another database on your computer, you must first add the line USE SASMA;. An example query:

   USE SASMA;
   SELECT * FROM User;