From 81e7480e7526025ce27f0ca234104b039631cf3d Mon Sep 17 00:00:00 2001
From: René 'Necoro' Neumann <necoro@necoro.net>
Date: Mon, 3 May 2010 23:11:52 +0200
Subject: started modelling

---
 model.py | 49 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 49 insertions(+)
 create mode 100644 model.py

(limited to 'model.py')

diff --git a/model.py b/model.py
new file mode 100644
index 0000000..903797b
--- /dev/null
+++ b/model.py
@@ -0,0 +1,49 @@
+import elixir
+from elixir import has_field, belongs_to, has_many, using_options, using_options_defaults
+from sqlalchemy import types as T
+
+from functools import partial
+
+elixir.metadata.bind = "sqlite:///test.sqlite"
+elixir.metadata.bind.echo = True
+
+has_req_field = partial(has_field, required = True)
+
+class Entity (elixir.Entity):
+    using_options(abstract = True)
+
+    using_options_defaults(shortnames = True)
+
+class Category (Entity):
+    
+    has_field('name', T.String(50), unique = True)
+
+    def __repr__ (self):
+        return '<Category "%s">' % self.name
+
+class Expense (Entity):
+    using_options(inheritance='multi')
+
+    has_field('description', T.String(50))
+    has_req_field('expense', T.Numeric(scale = 2))
+
+    belongs_to('category', of_kind = 'Category', required = True)
+
+class SingleExpense (Expense):
+    using_options(inheritance='multi')
+
+    has_req_field('date', T.Date)
+
+class ConstExpense (Expense):
+    using_options(inheritance='multi')
+
+    has_req_field('months', T.Integer)
+    has_req_field('start', T.Date)
+    has_req_field('end', T.Date)
+
+elixir.setup_all()
+
+session = elixir.session
+
+if __name__ == "__main__":
+    elixir.create_all()
-- 
cgit v1.2.3-70-g09d2