Piecash

~~~~~~~~~~~~~~~~~~~~~~~~~~

- requires sqlalchemy < 1.4 (fix 149)
- fix example with wrong post_date type
- update currency_ISO
- update use of deprecated function in xml (fix 147, tx bxbrenden)
- add example of program to modify an existing transaction

~~~~~~~~~~~~~~~~~~~~~~~~~~

- import requests from functions using it to avoid making it a required dependency (fix 90)
- adapt setup.py to avoid depending on SQLAlchemy-Utils 0.36.8 (fix 91)
- updated gnucash projects page: https://piecash.readthedocs.io/en/latest/doc/github_links.html

~~~~~~~~~~~~~~~~~~~~~~~~~~

- add a check_exists flag to allow bypassing check existence of DB on opening (fix 91, tx williamjacksn)

~~~~~~~~~~~~~~~~~~~~~~~~~~

- fix use of ISO date for ledger export (fix 115 by MisterY)
- add field is_credit and is_debit to split (fix 105)
- fix get_balance sign when recursing + add natural_sign keyword to specify if sign should be reverse or not
- add support for Gnucash 4.1 (fix 136)
- fix table names not matching in case (fix 137)
- fix test suite to support 3.8
- deprecate python 3.5
- quandl will retrieve API KEY from environment variable QUANDL_API_KEY (if defined)
- yahoo will use exchangeTimezoneName for timezone (vs exchangeTimezoneShortName before), thanks geoffwright240
- add possibility to export accounts with their short name in ledger (fix 123)

~~~~~~~~~~~~~~~~~~~~~~~~~~

- drop support of py27 and py34 (fix 53)
- support gnucash 3.0.x format (code + test and book migration)
- set autoflush to False for open_book (was only done for create_book before) (fix 93)
- remove tz info when serialising DateTime to SQL (issue with postgresql doing some TZ conversion)
- add basic support for Jobs

~~~~~~~~~~~~~~~~~~~~~~~~~~~

Mostly refactoring:
- refactor common parts of vendor, customer and employee into person
- add 'on_book_add' protocol called when object is added to a book
- set autoflush to False to prevent weird behavior when using slots (that retrigger a query in the middle of a flush)
- refactor slots
- align sql schema 100% with 2.6.21 (based on sqlite reference)
- support business slots