From 428283a2a067f8d0b3a0f7df7190df293b44e3de Mon Sep 17 00:00:00 2001
From: René 'Necoro' Neumann <necoro@necoro.net>
Date: Tue, 15 Feb 2011 04:12:02 +0100
Subject: mysql fix

---
 controller.py | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

(limited to 'controller.py')

diff --git a/controller.py b/controller.py
index 21684ee..1ac5132 100644
--- a/controller.py
+++ b/controller.py
@@ -141,7 +141,12 @@ class Const:
             d = datetime.date.today()
 
             current = ConstExpense.of_month(d.month, d.year)
-            old = ConstExpense.query.except_(current).order_by(ConstExpense.start)
+            
+            csub = current.subquery()
+            
+            # if only mysql would allow "EXCEPT" -.-
+            old = ConstExpense.query.outerjoin((csub, csub.c.id == ConstExpense.id)).filter(csub.c.id == None)
+            old = old.order_by(ConstExpense.start)
 
             return render("constlist", current = current.order_by(ConstExpense.start).all(), old = old.all())
         
-- 
cgit v1.2.3-70-g09d2