Please apply.

cu bart
>From 25b9ebd484a89bbfeebf53fec7159600c3923656 Mon Sep 17 00:00:00 2001
From: Bart Vanhauwaert <b...@vanhauwaert.org>
Date: Tue, 29 Nov 2011 17:59:12 +0100
Subject: [PATCH] Fixes invalid SQL queries when mapping the AuthInfo<User>
 class to a non standard SQL tablename (ie, not auth_info).
 auth_info_id is hardcoded as the reference id in the
 persist<Action>(Action&) implementation of both
 AuthToken<AuthInfoType> and AuthIdentity<AuthInfoType>

---
 src/Wt/Auth/Dbo/UserDatabase |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/src/Wt/Auth/Dbo/UserDatabase b/src/Wt/Auth/Dbo/UserDatabase
index 4a7d1d9..bb3dabb 100644
--- a/src/Wt/Auth/Dbo/UserDatabase
+++ b/src/Wt/Auth/Dbo/UserDatabase
@@ -77,7 +77,7 @@ public:
       (std::string() +
        "select u from " + session_.tableName<DboType>() + " u "
        "join " + session_.tableName<AuthIdentityType>() + " i "
-       "on u.id = i." + session_.tableName<DboType>() + "_id")
+       "on u.id = i.auth_info_id")
       .where("i.provider = ?").bind(provider)
       .where("i.identity = ?").bind(identity);
     t.commit();
@@ -269,7 +269,7 @@ public:
       (std::string() +
        "select u from " + session_.tableName<DboType>() + " u "
        "join " + session_.tableName<AuthTokenType>() + " t "
-       "on u.id = t." + session_.tableName<DboType>() + "_id")
+       "on u.id = t.auth_info_id")
       .where("t.value = ?").bind(hash)
       .where("t.expires > ?").bind(WDateTime::currentDateTime());
     t.commit();
-- 
1.7.5.1

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure 
contains a definitive record of customers, application performance, 
security threats, fraudulent activity, and more. Splunk takes this 
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
witty-interest mailing list
witty-interest@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/witty-interest

Reply via email to