README
======

This directory should be used to place project specfic documentation including
but not limited to project notes, generated API/phpdoc documentation, or
manual files generated or hand written.  Ideally, this directory would remain
in your development environment only and should not be deployed with your
application to it's final production location.

CONFIGURATION
=============

Setting Up Your VHOST
=====================

The following is a sample VHOST you might want to consider for your project.

<VirtualHost *:80>
   DocumentRoot "/var/www/financeapp/public"
   ServerName financeapp.local

   # This should be omitted in the production environment
   SetEnv APPLICATION_ENV development

   <Directory "/var/www/financeapp/public">
       Options Indexes MultiViews FollowSymLinks
       AllowOverride All
       Order allow,deny
       Allow from all
   </Directory>

</VirtualHost>

Database
========

Create the databse
------------------

CREATE DATABASE `financeapp` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Create a user and set permissions
----------------------------------

CREATE USER 'financeapp'@'localhost' IDENTIFIED BY 'financeapp';
GRANT ALL ON financeapp.* TO 'financeapp'@'%';


Generating schema and initial data
----------------------------------

Go to the bin folder and execute ./doctrine orm:schema-tool:create

Execute following insert queries:

INSERT INTO `account_types` (`id`,`tag`)
VALUES
	(1, 'accountTypeBank'),
	(2, 'accountTypeCash'),
	(3, 'accountTypeCreditCard');


INSERT INTO `transaction_types` (`id`,`tag`)
VALUES
	(1, 'transactionTypeTransfer'),
	(2, 'transactionTypeDeposit'),
	(3, 'transactionTypeWithdrawal');

INSERT INTO `settings`
VALUES ('currency', 'USD');

Updating schema
---------------

Go to the bin folder and execute ./doctrine orm:schema-tool:update  --force