1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
|
* Overview
That Expense Reporting Thing (TERT) is a double entry expense
reporting application written to solve my internal expense reporting
issues that are not addressed in other software or proprietary tools.
TERT is based off of my long term usage of Ledger
(http://www.ledger-cli.org/) and the need to scale it for use by
others than myself.
TERT is licensed under the BSD license (3 clause).
* Requirements
TERT is developed under Ubuntu Server 12.04, and requires the
following packages:
- Python 3.2
- SqlAlchemy 0.7.4
- PostgreSQL 9.1
- LXML 2.3.2
- Pyside 1.1.0 w/ Qt 4
TERT requires a Postgres database to be created and configured via
environment variable, for example:
$ export TERT_DB='postgresql://user:password@localhost/TERT-Test'
SqlAlchemy will create the database schema if the database is empty,
however the unit test scripts will create a fully functional database
with sample data.
* Ideas
This is simply an area for potential improvements:
** SqlAlchemy other DB support
I'm using Postgres, but other DBs are available. Likely SQLLite would
be an excellent choice, but requires additional integration because of
date types. Maybe future versions of SqlAlchemy will fix that.
** Console client
I've been careful to keep the view and model separate, ideally
anything that can be done in the GUI could be performed via a command
line interface or language.
Really the only reason there's a GUI in the first place is the receipt
matching to a txn, otherwise it could all be console.
* Acknowledgments
Thanks to John Wiegley and his Ledger project for supplying me with an
effective solution for many years, and to everyone in the Ledger IRC
channel for their support.
|