From 0f8c00b18ec7a123f6ede9163a16df7cdaa05e38 Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Sun, 13 Nov 2005 16:34:56 +0000
Subject: [PATCH] added 'selectone' method

---
 lib/sqlalchemy/mapper.py | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

diff --git a/lib/sqlalchemy/mapper.py b/lib/sqlalchemy/mapper.py
index 64d8558baf..2b51abe50d 100644
--- a/lib/sqlalchemy/mapper.py
+++ b/lib/sqlalchemy/mapper.py
@@ -364,7 +364,15 @@ class Mapper(object):
                 option.process(mapper)
             return _mappers.setdefault(hashkey, mapper)
 
-    
+    def selectone(self, *args, **params):
+        """works like select(), but only returns the first result by itself, or None if no 
+        objects returned."""
+        ret = self.select(*args, **params)
+        if len(ret):
+            return ret[0]
+        else:
+            return None
+            
     def select(self, arg = None, **params):
         """selects instances of the object from the database.  
         
-- 
2.47.2