44
44
<script type="text/javascript" src="../_static/doctools.js"></script>
45
45
<!-- end iterate through sphinx environment script_files -->
47
<script type="text/javascript" src="../_static/detectmobile.js"></script>
47
48
<script type="text/javascript" src="../_static/init.js"></script>
48
49
<link rel="index" title="Index" href="../genindex.html" />
49
50
<link rel="search" title="Search" href="../search.html" />
72
74
<div id="docs-container">
80
<div id="docs-top-navigation-container" class="body-background">
77
81
<div id="docs-header">
82
<div id="docs-version-header">
83
Release: <span class="version-num">0.9.6</span> | Release Date: June 23, 2014
78
86
<h1>SQLAlchemy 0.9 Documentation</h1>
80
<div id="docs-search">
82
<form class="search" action="../search.html" method="get">
83
<input type="text" name="q" size="18" /> <input type="submit" value="Search" />
84
<input type="hidden" name="check_keywords" value="yes" />
85
<input type="hidden" name="area" value="default" />
89
<div id="docs-version-header">
90
Release: <span class="version-num">0.9.4</span> | Release Date: March 28, 2014
97
<div id="docs-top-navigation">
98
<div id="docs-top-page-control" class="docs-navigation-links">
91
<div id="docs-body-container">
93
<div id="fixed-sidebar" class="withsidebar">
96
<div id="docs-sidebar-popout">
97
<h3><a href="../index.html">SQLAlchemy 0.9 Documentation</a></h3>
99
<p id="sidebar-paginate">
100
<a href="index.html" title="SQLAlchemy ORM">Up</a> |
102
<a href="session.html" title="Using the Session">Prev</a> |
103
<a href="loading.html" title="Relationship Loading Techniques">Next</a>
106
<p id="sidebar-topnav">
107
<a href="../index.html">Contents</a> |
108
<a href="../genindex.html">Index</a>
111
<div id="sidebar-search">
112
<form class="search" action="../search.html" method="get">
113
<input type="text" name="q" size="12" /> <input type="submit" value="Search" />
114
<input type="hidden" name="check_keywords" value="yes" />
115
<input type="hidden" name="area" value="default" />
121
<div id="docs-sidebar">
101
<a href="session.html" title="previous chapter">Using the Session</a>
104
<a href="loading.html" title="next chapter">Relationship Loading Techniques</a>
108
<a href="../contents.html">Table of Contents</a> |
109
<a href="../genindex.html">Index</a>
110
| <a href="../_sources/orm/query.txt">view source
115
<div id="docs-navigation-banner">
116
<a href="../index.html">SQLAlchemy 0.9 Documentation</a>
117
» <a href="index.html" title="SQLAlchemy ORM">SQLAlchemy ORM</a>
131
<div id="docs-body-container">
133
<div id="docs-sidebar">
134
<h3><a href="../index.html">Table of Contents</a></h3>
136
128
<li><a class="reference internal" href="#">Querying</a><ul>
137
129
<li><a class="reference internal" href="#the-query-object">The Query Object</a></li>
138
130
<li><a class="reference internal" href="#orm-specific-query-constructs">ORM-Specific Query Constructs</a></li>
144
<h4>Previous Topic</h4>
146
<a href="session.html" title="previous chapter">Using the Session</a>
150
<a href="loading.html" title="next chapter">Relationship Loading Techniques</a>
154
<h4>Quick Search</h4>
156
<form class="search" action="../search.html" method="get">
157
<input type="text" name="q" size="18" /> <input type="submit" value="Search" />
158
<input type="hidden" name="check_keywords" value="yes" />
159
<input type="hidden" name="area" value="default" />
165
144
<div id="docs-body" class="withsidebar" >
167
146
<div class="section" id="querying">
368
347
<span class="n">parts_alias</span> <span class="o">=</span> <span class="n">aliased</span><span class="p">(</span><span class="n">Part</span><span class="p">,</span> <span class="n">name</span><span class="o">=</span><span class="s">"p"</span><span class="p">)</span>
369
348
<span class="n">included_parts</span> <span class="o">=</span> <span class="n">included_parts</span><span class="o">.</span><span class="n">union_all</span><span class="p">(</span>
370
349
<span class="n">session</span><span class="o">.</span><span class="n">query</span><span class="p">(</span>
350
<span class="n">parts_alias</span><span class="o">.</span><span class="n">sub_part</span><span class="p">,</span>
371
351
<span class="n">parts_alias</span><span class="o">.</span><span class="n">part</span><span class="p">,</span>
372
<span class="n">parts_alias</span><span class="o">.</span><span class="n">sub_part</span><span class="p">,</span>
373
352
<span class="n">parts_alias</span><span class="o">.</span><span class="n">quantity</span><span class="p">)</span><span class="o">.</span>\
374
353
<span class="nb">filter</span><span class="p">(</span><span class="n">parts_alias</span><span class="o">.</span><span class="n">part</span><span class="o">==</span><span class="n">incl_alias</span><span class="o">.</span><span class="n">c</span><span class="o">.</span><span class="n">sub_part</span><span class="p">)</span>
375
354
<span class="p">)</span>