[Sqlalchemy-commits] [1320] sqlalchemy/branches/schema/test/selectresults.py: sel

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><style type="text/css"><!--
#msg dl { border: 1px #006 solid; background: #369; padding: 6px; color: #fff; }
#msg dt { float: left; width: 6em; font-weight: bold; }
#msg dt:after { content:':';}
#msg dl, #msg dt, #msg ul, #msg li { font-family: verdana,arial,helvetica,sans-serif; font-size: 10pt;  }
#msg dl a { font-weight: bold}
#msg dl a:link    { color:#fc3; }
#msg dl a:active  { color:#ff0; }
#msg dl a:visited { color:#cc6; }
h3 { font-family: verdana,arial,helvetica,sans-serif; font-size: 10pt; font-weight: bold; }
#msg pre { overflow: auto; background: #ffc; border: 1px #fc0 solid; padding: 6px; }
#msg ul, pre { overflow: auto; }
#patch { width: 100%; }
#patch h4 {font-family: verdana,arial,helvetica,sans-serif;font-size:10pt;padding:8px;background:#369;color:#fff;margin:0;}
#patch .propset h4, #patch .binary h4 {margin:0;}
#patch pre {padding:0;line-height:1.2em;margin:0;}
#patch .diff {width:100%;background:#eee;padding: 0 0 10px 0;overflow:auto;}
#patch .propset .diff, #patch .binary .diff  {padding:10px 0;}
#patch span {display:block;padding:0 10px;}
#patch .modfile, #patch .addfile, #patch .delfile, #patch .propset, #patch .binary, #patch .copfile {border:1px solid #ccc;margin:10px 0;}
#patch ins {background:#dfd;text-decoration:none;display:block;padding:0 10px;}
#patch del {background:#fdd;text-decoration:none;display:block;padding:0 10px;}
#patch .lines, .info {color:#888;background:#fff;}
--></style>
<title>[1320] sqlalchemy/branches/schema/test/selectresults.py: sel</title>
</head>
<body>

<div id="msg">
<dl>
<dt>Revision</dt> <dd>1320</dd>
<dt>Author</dt> <dd>zzzeek</dd>
<dt>Date</dt> <dd>2006-04-22 17:15:36 -0500 (Sat, 22 Apr 2006)</dd>
</dl>

<h3>Log Message</h3>
<pre>sel</pre>

<h3>Added Paths</h3>
<ul>
<li><a href="#sqlalchemybranchesschematestselectresultspy">sqlalchemy/branches/schema/test/selectresults.py</a></li>
</ul>

</div>
<div id="patch">
<h3>Diff</h3>
<a id="sqlalchemybranchesschematestselectresultspy"></a>
<div class="addfile"><h4>Added: sqlalchemy/branches/schema/test/selectresults.py (1319 => 1320)</h4>
<pre class="diff"><span>
<span class="info">--- sqlalchemy/branches/schema/test/selectresults.py	2006-04-22 21:14:43 UTC (rev 1319)
+++ sqlalchemy/branches/schema/test/selectresults.py	2006-04-22 22:15:36 UTC (rev 1320)
</span><span class="lines">@@ -0,0 +1,68 @@
</span><ins>+from testbase import PersistTest
+import testbase
+
+from sqlalchemy import *
+
+from sqlalchemy.ext.selectresults import SelectResultsExt
+
+class Foo(object):
+    pass
+
+class SelectResultsTest(PersistTest):
+    def setUpAll(self):
+        global foo
+        foo = Table('foo', testbase.db,
+                    Column('id', Integer, Sequence('foo_id_seq'), primary_key=True),
+                    Column('bar', Integer))
+        
+        assign_mapper(Foo, foo, extension=SelectResultsExt())
+        foo.create()
+        for i in range(100):
+            Foo(bar=i)
+        objectstore.flush()
+    
+    def setUp(self):
+        self.orig = Foo.mapper.select_whereclause()
+        self.res = Foo.select()
+        
+    def tearDownAll(self):
+        global foo
+        foo.drop()
+        
+    def test_slice(self):
+        assert self.res[1] == self.orig[1]
+        assert list(self.res[10:20]) == self.orig[10:20]
+        assert list(self.res[10:]) == self.orig[10:]
+        assert list(self.res[:10]) == self.orig[:10]
+        assert list(self.res[:10]) == self.orig[:10]
+        assert list(self.res[10:40:3]) == self.orig[10:40:3]
+        assert list(self.res[-5:]) == self.orig[-5:]
+
+    def test_aggregate(self):
+        assert self.res.count() == 100
+        assert self.res.filter(foo.c.bar&lt;30).min(foo.c.bar) == 0
+        assert self.res.filter(foo.c.bar&lt;30).max(foo.c.bar) == 29
+        # this one fails in mysql as the result comes back as a string
+        assert self.res.filter(foo.c.bar&lt;30).sum(foo.c.bar) == 435
+        # this one fails with postgres, the floating point comparison fails
+        assert self.res.filter(foo.c.bar&lt;30).avg(foo.c.bar) == 14.5
+
+    def test_filter(self):
+        assert self.res.count() == 100
+        assert self.res.filter(Foo.c.bar &lt; 30).count() == 30
+        res2 = self.res.filter(Foo.c.bar &lt; 30).filter(Foo.c.bar &gt; 10)
+        assert res2.count() == 19
+        
+    def test_order_by(self):
+        assert self.res.order_by([Foo.c.bar])[0].bar == 0
+        assert self.res.order_by([desc(Foo.c.bar)])[0].bar == 99
+
+    def test_offset(self):
+        assert list(self.res.order_by([Foo.c.bar]).offset(10))[0].bar == 10
+        
+    def test_offset(self):
+        assert len(list(self.res.limit(10))) == 10
+
+
+if __name__ == &quot;__main__&quot;:
+    testbase.main()        
</ins></span></pre>
</div>
</div>

</body>
</html>