[Sqlalchemy-commits] [2290] sqlalchemy/trunk/test/sql/query.py: unit test for "cant execute"

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

<!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>[2290] sqlalchemy/trunk/test/sql/query.py: unit test for &quot;cant execute&quot;</title>
</head>
<body>

<div id="msg">
<dl>
<dt>Revision</dt> <dd>2290</dd>
<dt>Author</dt> <dd>zzzeek</dd>
<dt>Date</dt> <dd>2007-02-02 12:26:42 -0600 (Fri, 02 Feb 2007)</dd>
</dl>

<h3>Log Message</h3>
<pre>unit test for &quot;cant execute&quot;</pre>

<h3>Modified Paths</h3>
<ul>
<li><a href="#sqlalchemytrunktestsqlquerypy">sqlalchemy/trunk/test/sql/query.py</a></li>
</ul>

</div>
<div id="patch">
<h3>Diff</h3>
<a id="sqlalchemytrunktestsqlquerypy"></a>
<div class="modfile"><h4>Modified: sqlalchemy/trunk/test/sql/query.py (2289 => 2290)</h4>
<pre class="diff"><span>
<span class="info">--- sqlalchemy/trunk/test/sql/query.py	2007-02-02 18:18:31 UTC (rev 2289)
+++ sqlalchemy/trunk/test/sql/query.py	2007-02-02 18:26:42 UTC (rev 2290)
</span><span class="lines">@@ -7,16 +7,21 @@
</span><span class="cx"> import tables
</span><span class="cx"> from sqlalchemy import *
</span><span class="cx"> from sqlalchemy.engine import ResultProxy, RowProxy
</span><ins>+from sqlalchemy import exceptions
</ins><span class="cx"> 
</span><span class="cx"> class QueryTest(PersistTest):
</span><span class="cx">     
</span><span class="cx">     def setUpAll(self):
</span><del>-        global users, metadata
</del><ins>+        global users, addresses, metadata
</ins><span class="cx">         metadata = BoundMetaData(testbase.db)
</span><span class="cx">         users = Table('query_users', metadata,
</span><span class="cx">             Column('user_id', INT, primary_key = True),
</span><span class="cx">             Column('user_name', VARCHAR(20)),
</span><span class="cx">         )
</span><ins>+        addresses = Table('query_addresses', metadata, 
+            Column('address_id', Integer, primary_key=True),
+            Column('user_id', Integer, ForeignKey('query_users.user_id')),
+            Column('address', String(30)))
</ins><span class="cx">         metadata.create_all()
</span><span class="cx">     
</span><span class="cx">     def setUp(self):
</span><span class="lines">@@ -205,6 +210,12 @@
</span><span class="cx">         self.assertEqual(len(r), 1)
</span><span class="cx">         r.close()
</span><span class="cx">     
</span><ins>+    def test_cant_execute_join(self):
+        try:
+            users.join(addresses).execute()
+        except exceptions.ArgumentError, e:
+            assert str(e) == &quot;&quot;&quot;Not an executeable clause: query_users JOIN query_addresses ON query_users.user_id = query_addresses.user_id&quot;&quot;&quot;
+            
</ins><span class="cx">     def test_functions(self):
</span><span class="cx">         x = testbase.db.func.current_date().execute().scalar()
</span><span class="cx">         y = testbase.db.func.current_date().select().execute().scalar()
</span><span class="lines">@@ -292,7 +303,7 @@
</span><span class="cx">         self.assertEqual(r[1], 1)
</span><span class="cx">         self.assertEqual(r.keys(), ['user_name', 'user_id'])
</span><span class="cx">         self.assertEqual(r.values(), ['foo', 1])
</span><del>-       
</del><ins>+    
</ins><span class="cx">     @testbase.unsupported('oracle', 'firebird') 
</span><span class="cx">     def test_column_accessor_shadow(self):
</span><span class="cx">         meta = BoundMetaData(testbase.db)
</span></span></pre>
</div>
</div>

</body>
</html>