diff options
author | René 'Necoro' Neumann <necoro@necoro.net> | 2013-04-15 00:35:25 +0200 |
---|---|---|
committer | René 'Necoro' Neumann <necoro@necoro.net> | 2013-04-15 00:35:25 +0200 |
commit | a5fdb04dca0c88822192b4b5f08b11aa55bb6d7b (patch) | |
tree | 3cb82f5fe02a6547f62a9bff9f7fee8b350d532e /convert.py | |
parent | efd12ebd857281530dd986674ccf3f1aba8f4e20 (diff) | |
download | kosten-a5fdb04dca0c88822192b4b5f08b11aa55bb6d7b.tar.gz kosten-a5fdb04dca0c88822192b4b5f08b11aa55bb6d7b.tar.bz2 kosten-a5fdb04dca0c88822192b4b5f08b11aa55bb6d7b.zip |
Remove old obsolete files
Diffstat (limited to 'convert.py')
-rw-r--r-- | convert.py | 74 |
1 files changed, 0 insertions, 74 deletions
diff --git a/convert.py b/convert.py deleted file mode 100644 index c1cd770..0000000 --- a/convert.py +++ /dev/null @@ -1,74 +0,0 @@ -#!/usr/bin/python - -import elixir -from model import * - -import csv -from decimal import Decimal -from datetime import datetime - -elixir.create_all() - -# categories -d = dict((x, Category(name = x)) for x in ("Essen", "Kneipe", "Fahrkarten", "Kino", "Mittag", "Sonstiges")) -d["Mittag"].parent = d["Essen"] - -session.commit() - -# single expenses -with open("kosten.csv") as f: - dialect = csv.Sniffer().sniff(f.read(1024)) - f.seek(0) - for row in csv.DictReader(f, dialect = dialect): - s = SingleExpense() - - # expense - s.expense = Decimal(row["betrag"]) - - # date - s.year, s.month, s.day = map(int, row["datum"].split('-')) - - # description - s.description = unicode(row["kommentar"], 'utf-8') - - # category - if row["nahrung"] == "1": - s.category = d["Essen"] - elif row["kneipe"] == "1": - s.category = d["Kneipe"] - elif row["fahrkarte"] == "1": - s.category = d["Fahrkarten"] - elif row["kino"] == "1": - s.category = d["Kino"] - elif row["mittag"] == "1": - s.category = d["Mittag"] - else: - s.category = d["Sonstiges"] - -session.commit() - -# const expenses -with open("konstkosten.csv") as f: - dialect = csv.Sniffer().sniff(f.read(1024)) - f.seek(0) - for row in csv.DictReader(f, dialect = dialect): - c = ConstExpense() - - # expense - c.expense = Decimal(row["betrag"]) - - # date - c.start = datetime.strptime(row["start"], "%Y%m") - c.end = datetime.strptime(row["ende"], "%Y%m") - - # description - c.description = unicode(row["name"], 'utf-8') - - # interval - types = {'m': 1, 'q': 3, 'h': 6, 'j': 12} - c.months = types[row["typ"]] - - # category: just 'Sonstiges' for the moment - c.category = d["Sonstiges"] - -session.commit() |