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
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
|
##
# This file is part of TALER
# (C) 2014, 2015, 2106 INRIA
#
# TALER is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published
# by the Free Software Foundation; either version 3, or (at your
# option) any later version.
#
# TALER is distributed in the hope that it will be useful, but
# WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
# General Public License for more details.
#
# You should have received a copy of the GNU General Public
# License along with TALER; see the file COPYING. If not, see
# <http://www.gnu.org/licenses/>
#
# @author Marcello Stanisci
# @brief dump database content in a pretty format.
import sys
import logging
from django.core.management.base import BaseCommand
from django.db.utils import OperationalError, ProgrammingError
from ...models import BankAccount, BankTransaction
LOGGER = logging.getLogger(__name__)
##
# Dump bank accounts that exist in the database.
def dump_accounts():
try:
accounts = BankAccount.objects.all()
if accounts.count() < 1:
print("No accounts created yet..")
return
for acc in accounts:
print(acc.user.username + \
" has account number " + \
str(acc.account_no))
except (OperationalError, ProgrammingError):
LOGGER.error("Hard database error, does it exist?")
sys.exit(1)
##
# Dump all the transactions that exist in the database.
def dump_history():
try:
history = BankTransaction.objects.all()
for item in history:
msg = []
msg.append("+%s, " % item.credit_account.account_no)
msg.append("-%s, " % item.debit_account.account_no)
msg.append(item.amount.stringify(2))
msg.append(" '" + item.subject + "'")
print(''.join(msg))
except (OperationalError, ProgrammingError):
LOGGER.error("Hard database error, does it exist?")
sys.exit(1)
##
# Django-specific class that register this CLI utility.
class Command(BaseCommand):
##
# Django-specific callable that gets invoked when the user
# calls the CLI utility: simply, it calls the two helper
# functions defined above.
#
# @param self this object itself.
# @param args argument list (as passed by Django)
# @param options CLI options (also as passed by Django)
def handle(self, *args, **options):
dump_accounts()
dump_history()
|