The unified diff between revisions [d1300337..] and [48ba9497..] is displayed below. It can also be downloaded as a raw diff.
# # # patch "Chart.py" # from [da39a3ee5e6b4b0d3255bfef95601890afd80709] # to [88cd1b20e465633f22d117d2a575d78d1ea09e99] # # patch "DESIGN" # from [2caed883a8615d04b9212e3c3c8aa4ff272df44c] # to [864c1d68f63db13d6add3a69fd31e396eb8eb67b] # # patch "Journal.py" # from [da39a3ee5e6b4b0d3255bfef95601890afd80709] # to [f3ab3eb8e35053f8498b37d7ce0a9cef2799b06d] # # patch "Ledger.py" # from [da39a3ee5e6b4b0d3255bfef95601890afd80709] # to [0fcc36eac7feebc59f13145025da178c2651d74a] # # patch "Store.py" # from [46cf7b359d6a697fe15821fb006bb617648afbe1] # to [8e9a432a290abbfc9667db4638df747ff9c4de6a] # # patch "System.py" # from [62e0fdf1e97d2eb94277df2570c9ca7674887307] # to [3e2a9d2a57fd7a35306c1a1fb7adbae3b09af3ae] # # patch "fourstar.py" # from [246595cc1b4fdd2daca822102fdf75b2a8af73c2] # to [dfd16c349b19cd2b2435ff2671db0ca1a1c4af29] # ============================================================ --- Chart.py da39a3ee5e6b4b0d3255bfef95601890afd80709 +++ Chart.py 88cd1b20e465633f22d117d2a575d78d1ea09e99 @@ -0,0 +1,9 @@ +#!/usr/bin/env python + +# chart.py +# + +class Chart: + def __init__(self): + pass + ============================================================ --- DESIGN 2caed883a8615d04b9212e3c3c8aa4ff272df44c +++ DESIGN 864c1d68f63db13d6add3a69fd31e396eb8eb67b @@ -46,42 +46,28 @@ Credit +DATABASE +======== +Refer fourstar.sql +OBJECTS +======= -Chart -====== -integer Account ID -string Details -boolean Debit/Credit Positive? +System + - Store +Chart + - System (Store) +Ledger + - System (Store) + - Chart -4 Column Ledger -=============== - -integer Account ID -??? Date -string Item (Explanation) -integer Journal Ref (ID) -float Debit -float Credit -float Balance Debit -float Balance Credit - Journal -======= + - System (Store) + - Ledger -integer Journal ID -??? Date -string Account (Explanation) -integer Post Ref -integer Account -float Debit -float Credit -(Dr/Cr == 2 entries in accounts) - - ============================================================ --- Journal.py da39a3ee5e6b4b0d3255bfef95601890afd80709 +++ Journal.py f3ab3eb8e35053f8498b37d7ce0a9cef2799b06d @@ -0,0 +1,9 @@ +#!/usr/bin/env python + +# journal.py +# + +class Journal: + def __init__(self): + pass + ============================================================ --- Ledger.py da39a3ee5e6b4b0d3255bfef95601890afd80709 +++ Ledger.py 0fcc36eac7feebc59f13145025da178c2651d74a @@ -0,0 +1,9 @@ +#!/usr/bin/env python + +# ledger.py +# + +class Ledger: + def __init__(self): + pass + ============================================================ --- Store.py 46cf7b359d6a697fe15821fb006bb617648afbe1 +++ Store.py 8e9a432a290abbfc9667db4638df747ff9c4de6a @@ -2,7 +2,40 @@ # # Abstraction around shelves / data stores used by Fourstar +# +# provides an abstraction to arbitary store backend +# +# Store as a shelf + + +import sqlite3 + class Store: def __init__(self): + self.file = None + self.db = None + self.cursor = None + self.store = None pass + + def create(self,file): + pass + + def connect(self,file): + pass + + def check_schema(self): + pass + + def status(self): + pass + +# + + +# is there any reason why this needs to abstract anything other than +# SQL? +# +# command, arg list +# select blah from foo where thing=%s ============================================================ --- System.py 62e0fdf1e97d2eb94277df2570c9ca7674887307 +++ System.py 3e2a9d2a57fd7a35306c1a1fb7adbae3b09af3ae @@ -12,25 +12,14 @@ # # Store as a shelf -import sqlite3 - class System: def __init__(self): self.connected = False self.file = None self.db = None self.cursor = None + self.store = None pass - def create(self,file): - pass - - def connect(self,file): - pass - - def check_schema(self): - pass - - def status(self): pass ============================================================ --- fourstar.py 246595cc1b4fdd2daca822102fdf75b2a8af73c2 +++ fourstar.py dfd16c349b19cd2b2435ff2671db0ca1a1c4af29 @@ -30,10 +30,19 @@ from System import System # import from System import System +from Store import Store +# print "Hello Cruel World!" fs = System() print fs + + + + +# real code below here + +