| Offset 1, 5 lines modified | Offset 1, 5 lines modified | ||
| 1 | · | 1 | ·78a74f9f393acb8dae9c6efa565e7e04·3987200·doc·optional·python-sqlalchemy-doc_2.0.19+ds1-1_all.deb |
| 2 | ·b22acb2642b551b3117b100e4eb4a5aa·1583408·debug·optional·python3-sqlalchemy-ext-dbgsym_2.0.19+ds1-1_i386.deb | 2 | ·b22acb2642b551b3117b100e4eb4a5aa·1583408·debug·optional·python3-sqlalchemy-ext-dbgsym_2.0.19+ds1-1_i386.deb |
| 3 | ·9bb0e2bc16ca5be1edb1ea3d8eff620d·233576·python·optional·python3-sqlalchemy-ext_2.0.19+ds1-1_i386.deb | 3 | ·9bb0e2bc16ca5be1edb1ea3d8eff620d·233576·python·optional·python3-sqlalchemy-ext_2.0.19+ds1-1_i386.deb |
| 4 | ·9796ef149b40120a63428bfee9fa60a2·1175628·python·optional·python3-sqlalchemy_2.0.19+ds1-1_all.deb | 4 | ·9796ef149b40120a63428bfee9fa60a2·1175628·python·optional·python3-sqlalchemy_2.0.19+ds1-1_all.deb |
| Offset 1, 3 lines modified | Offset 1, 3 lines modified | ||
| 1 | -rw-r--r--···0········0········0········4·2023-07-21·11:51:22.000000·debian-binary | 1 | -rw-r--r--···0········0········0········4·2023-07-21·11:51:22.000000·debian-binary |
| 2 | -rw-r--r--···0········0········0····1372 | 2 | -rw-r--r--···0········0········0····13720·2023-07-21·11:51:22.000000·control.tar.xz |
| 3 | -rw-r--r--···0········0········0··39732 | 3 | -rw-r--r--···0········0········0··3973288·2023-07-21·11:51:22.000000·data.tar.xz |
| Offset 8934, 22 lines modified | Offset 8934, 15 lines modified | ||
| 8934 | <div·class="admonition·seealso"> | 8934 | <div·class="admonition·seealso"> |
| 8935 | <p·class="admonition-title">See·also</p> | 8935 | <p·class="admonition-title">See·also</p> |
| 8936 | <p><a·class="reference·internal"·href="migration_14.html#change-4710-core"><span·class="std·std-ref">RowProxy·is·no·longer·a·“proxy”;·is·now·called·Row·and·behaves·like·an·enhanced·named·tuple</span></a></p> | 8936 | <p><a·class="reference·internal"·href="migration_14.html#change-4710-core"><span·class="std·std-ref">RowProxy·is·no·longer·a·“proxy”;·is·now·called·Row·and·behaves·like·an·enhanced·named·tuple</span></a></p> |
| 8937 | </div> | 8937 | </div> |
| 8938 | <p>References:·<a·class="reference·external"·href="https://www.sqlalchemy.org/trac/ticket/4710">#4710</a></p> | 8938 | <p>References:·<a·class="reference·external"·href="https://www.sqlalchemy.org/trac/ticket/4710">#4710</a></p> |
| 8939 | </p> | 8939 | </p> |
| 8940 | </li> | 8940 | </li> |
| 8941 | <li><p·class="caption"·id="change-1.4.0b1-54"><span·class="target"·id="change-6bc91a2bef8d8afd244e6dbd38439c4d"><strong>[engine]·[performance]</strong>·<a·class="changelog-reference·headerlink·reference·internal"·href="#change-6bc91a2bef8d8afd244e6dbd38439c4d">¶</a></span><p>The·pool·“pre-ping”·feature·has·been·refined·to·not·invoke·for·a·DBAPI | ||
| 8942 | connection·that·was·just·opened·in·the·same·checkout·operation.··pre·ping | ||
| 8943 | only·applies·to·a·DBAPI·connection·that’s·been·checked·into·the·pool | ||
| 8944 | and·is·being·checked·out·again.</p> | ||
| 8945 | <p>References:·<a·class="reference·external"·href="https://www.sqlalchemy.org/trac/ticket/4524">#4524</a></p> | ||
| 8946 | </p> | ||
| 8947 | </li> | ||
| 8948 | <li><p·class="caption"·id="change-1.4.0b1-5 | 8941 | <li><p·class="caption"·id="change-1.4.0b1-54"><span·class="target"·id="change-d3650b27f4c852ac687ea55326051ed0"><strong>[engine]·[change]·[performance]·[py3k]</strong>·<a·class="changelog-reference·headerlink·reference·internal"·href="#change-d3650b27f4c852ac687ea55326051ed0">¶</a></span><p>Disabled·the·“unicode·returns”·check·that·runs·on·dialect·startup·when |
| 8949 | running·under·Python·3,·which·for·many·years·has·occurred·in·order·to·test | 8942 | running·under·Python·3,·which·for·many·years·has·occurred·in·order·to·test |
| 8950 | the·current·DBAPI’s·behavior·for·whether·or·not·it·returns·Python·Unicode | 8943 | the·current·DBAPI’s·behavior·for·whether·or·not·it·returns·Python·Unicode |
| 8951 | or·Py2K·strings·for·the·VARCHAR·and·NVARCHAR·datatypes.··The·check·still | 8944 | or·Py2K·strings·for·the·VARCHAR·and·NVARCHAR·datatypes.··The·check·still |
| 8952 | occurs·by·default·under·Python·2,·however·the·mechanism·to·test·the | 8945 | occurs·by·default·under·Python·2,·however·the·mechanism·to·test·the |
| 8953 | behavior·will·be·removed·in·SQLAlchemy·2.0·when·Python·2·support·is·also | 8946 | behavior·will·be·removed·in·SQLAlchemy·2.0·when·Python·2·support·is·also |
| 8954 | removed.</p> | 8947 | removed.</p> |
| 8955 | <p>This·logic·was·very·effective·when·it·was·needed,·however·now·that·Python·3 | 8948 | <p>This·logic·was·very·effective·when·it·was·needed,·however·now·that·Python·3 |
| Offset 6166, 21 lines modified | Offset 6166, 15 lines modified | ||
| 6166 | returned·by·the·ResultProxy·is·now·the·LegacyRow·subclass,·which·maintains | 6166 | returned·by·the·ResultProxy·is·now·the·LegacyRow·subclass,·which·maintains |
| 6167 | mapping/tuple·hybrid·behavior,·however·the·base·_\x8R_\x8o_\x8w·class·now·behaves·more | 6167 | mapping/tuple·hybrid·behavior,·however·the·base·_\x8R_\x8o_\x8w·class·now·behaves·more |
| 6168 | fully·like·a·named·tuple. | 6168 | fully·like·a·named·tuple. |
| 6169 | See·also | 6169 | See·also |
| 6170 | _\x8R_\x8o_\x8w_\x8P_\x8r_\x8o_\x8x_\x8y_\x8·_\x8i_\x8s_\x8·_\x8n_\x8o_\x8·_\x8l_\x8o_\x8n_\x8g_\x8e_\x8r_\x8·_\x8a_\x8·_\x8“_\x8p_\x8r_\x8o_\x8x_\x8y_\x8”_\x8;_\x8·_\x8i_\x8s_\x8·_\x8n_\x8o_\x8w_\x8·_\x8c_\x8a_\x8l_\x8l_\x8e_\x8d_\x8·_\x8R_\x8o_\x8w_\x8·_\x8a_\x8n_\x8d_\x8·_\x8b_\x8e_\x8h_\x8a_\x8v_\x8e_\x8s_\x8·_\x8l_\x8i_\x8k_\x8e_\x8·_\x8a_\x8n_\x8·_\x8e_\x8n_\x8h_\x8a_\x8n_\x8c_\x8e_\x8d | 6170 | _\x8R_\x8o_\x8w_\x8P_\x8r_\x8o_\x8x_\x8y_\x8·_\x8i_\x8s_\x8·_\x8n_\x8o_\x8·_\x8l_\x8o_\x8n_\x8g_\x8e_\x8r_\x8·_\x8a_\x8·_\x8“_\x8p_\x8r_\x8o_\x8x_\x8y_\x8”_\x8;_\x8·_\x8i_\x8s_\x8·_\x8n_\x8o_\x8w_\x8·_\x8c_\x8a_\x8l_\x8l_\x8e_\x8d_\x8·_\x8R_\x8o_\x8w_\x8·_\x8a_\x8n_\x8d_\x8·_\x8b_\x8e_\x8h_\x8a_\x8v_\x8e_\x8s_\x8·_\x8l_\x8i_\x8k_\x8e_\x8·_\x8a_\x8n_\x8·_\x8e_\x8n_\x8h_\x8a_\x8n_\x8c_\x8e_\x8d |
| 6171 | _\x8n_\x8a_\x8m_\x8e_\x8d_\x8·_\x8t_\x8u_\x8p_\x8l_\x8e | 6171 | _\x8n_\x8a_\x8m_\x8e_\x8d_\x8·_\x8t_\x8u_\x8p_\x8l_\x8e |
| 6172 | References:·_\x8#_\x84_\x87_\x81_\x80 | 6172 | References:·_\x8#_\x84_\x87_\x81_\x80 |
| 6173 | [\x8[e\x8en\x8ng\x8gi\x8in\x8ne\x8e]\x8]·[\x8[p\x8pe\x8er\x8rf\x8fo\x8or\x8rm\x8ma\x8an\x8nc\x8ce\x8e]\x8]·_\x8¶ | ||
| 6174 | The·pool·“pre-ping”·feature·has·been·refined·to·not·invoke·for·a·DBAPI | ||
| 6175 | connection·that·was·just·opened·in·the·same·checkout·operation.·pre·ping·only | ||
| 6176 | applies·to·a·DBAPI·connection·that’s·been·checked·into·the·pool·and·is·being | ||
| 6177 | checked·out·again. | ||
| 6178 | References:·_\x8#_\x84_\x85_\x82_\x84 | ||
| 6179 | [\x8[e\x8en\x8ng\x8gi\x8in\x8ne\x8e]\x8]·[\x8[ | 6173 | [\x8[e\x8en\x8ng\x8gi\x8in\x8ne\x8e]\x8]·[\x8[c.ch.ha.an.ng.ge.e].]·[.[p.pe.er.rf.fo.or.rm.ma.an.nc.ce\x8e]\x8]·[\x8[p\x8py\x8y3\x83k\x8k]\x8]·_\x8¶ |
| 6180 | Disabled·the·“unicode·returns”·check·that·runs·on·dialect·startup·when·running | 6174 | Disabled·the·“unicode·returns”·check·that·runs·on·dialect·startup·when·running |
| 6181 | under·Python·3,·which·for·many·years·has·occurred·in·order·to·test·the·current | 6175 | under·Python·3,·which·for·many·years·has·occurred·in·order·to·test·the·current |
| 6182 | DBAPI’s·behavior·for·whether·or·not·it·returns·Python·Unicode·or·Py2K·strings | 6176 | DBAPI’s·behavior·for·whether·or·not·it·returns·Python·Unicode·or·Py2K·strings |
| 6183 | for·the·VARCHAR·and·NVARCHAR·datatypes.·The·check·still·occurs·by·default·under | 6177 | for·the·VARCHAR·and·NVARCHAR·datatypes.·The·check·still·occurs·by·default·under |
| 6184 | Python·2,·however·the·mechanism·to·test·the·behavior·will·be·removed·in | 6178 | Python·2,·however·the·mechanism·to·test·the·behavior·will·be·removed·in |
| 6185 | SQLAlchemy·2.0·when·Python·2·support·is·also·removed. | 6179 | SQLAlchemy·2.0·when·Python·2·support·is·also·removed. |
| 6186 | This·logic·was·very·effective·when·it·was·needed,·however·now·that·Python·3·is | 6180 | This·logic·was·very·effective·when·it·was·needed,·however·now·that·Python·3·is |
| Offset 299, 49 lines modified | Offset 299, 49 lines modified | ||
| 299 | </section> | 299 | </section> |
| 300 | <section·id="module-examples.association"> | 300 | <section·id="module-examples.association"> |
| 301 | <span·id="associations"></span><span·id="examples-associations"></span><h3>Associations<a·class="headerlink"·href="#module-examples.association"·title="Link·to·this·heading">¶</a></h3> | 301 | <span·id="associations"></span><span·id="examples-associations"></span><h3>Associations<a·class="headerlink"·href="#module-examples.association"·title="Link·to·this·heading">¶</a></h3> |
| 302 | <p>Examples·illustrating·the·usage·of·the·“association·object”·pattern, | 302 | <p>Examples·illustrating·the·usage·of·the·“association·object”·pattern, |
| 303 | where·an·intermediary·class·mediates·the·relationship·between·two | 303 | where·an·intermediary·class·mediates·the·relationship·between·two |
| 304 | classes·that·are·associated·in·a·many-to-many·pattern.</p> | 304 | classes·that·are·associated·in·a·many-to-many·pattern.</p> |
| 305 | <p>Listing·of·files:<ul·class="simple"> | 305 | <p>Listing·of·files:<ul·class="simple"> |
| 306 | <li><p><p><a·class="reference·external"·href="../_modules/examples/association/dict_of_sets_with_default.html">dict_of_sets_with_default.py</a>·-·An·advanced·association·proxy·example·which | ||
| 307 | illustrates·nesting·of·association·proxies·to·produce·multi-level·Python | ||
| 308 | collections,·in·this·case·a·dictionary·with·string·keys·and·sets·of·integers | ||
| 309 | as·values,·which·conceal·the·underlying·mapped·classes.</p> | ||
| 310 | </p></li> | ||
| 311 | <li><p><p><a·class="reference·external"·href="../_modules/examples/association/basic_association.html">basic_association.py</a>·-·Illustrate·a·many-to-many·relationship·between·an | 306 | <li><p><p><a·class="reference·external"·href="../_modules/examples/association/basic_association.html">basic_association.py</a>·-·Illustrate·a·many-to-many·relationship·between·an |
| 312 | “Order”·and·a·collection·of·“Item”·objects,·associating·a·purchase·price | 307 | “Order”·and·a·collection·of·“Item”·objects,·associating·a·purchase·price |
| 313 | with·each·via·an·association·object·called·“OrderItem”</p> | 308 | with·each·via·an·association·object·called·“OrderItem”</p> |
| 314 | </p></li> | 309 | </p></li> |
| 315 | <li><p><p><a·class="reference·external"·href="../_modules/examples/association/proxied_association.html">proxied_association.py</a>·-·Same·example·as·basic_association,·adding·in | 310 | <li><p><p><a·class="reference·external"·href="../_modules/examples/association/proxied_association.html">proxied_association.py</a>·-·Same·example·as·basic_association,·adding·in |
| 316 | usage·of·<a·class="reference·internal"·href="extensions/associationproxy.html#module-sqlalchemy.ext.associationproxy"·title="sqlalchemy.ext.associationproxy"><code·class="xref·py·py-mod·docutils·literal·notranslate"><span·class="pre">sqlalchemy.ext.associationproxy</span></code></a>·to·make·explicit·references | 311 | usage·of·<a·class="reference·internal"·href="extensions/associationproxy.html#module-sqlalchemy.ext.associationproxy"·title="sqlalchemy.ext.associationproxy"><code·class="xref·py·py-mod·docutils·literal·notranslate"><span·class="pre">sqlalchemy.ext.associationproxy</span></code></a>·to·make·explicit·references |
| 317 | to·<code·class="docutils·literal·notranslate"><span·class="pre">OrderItem</span></code>·optional.</p> | 312 | to·<code·class="docutils·literal·notranslate"><span·class="pre">OrderItem</span></code>·optional.</p> |
| 318 | </p></li> | 313 | </p></li> |
| 314 | <li><p><p><a·class="reference·external"·href="../_modules/examples/association/dict_of_sets_with_default.html">dict_of_sets_with_default.py</a>·-·An·advanced·association·proxy·example·which | ||
| 315 | illustrates·nesting·of·association·proxies·to·produce·multi-level·Python | ||
| 316 | collections,·in·this·case·a·dictionary·with·string·keys·and·sets·of·integers | ||
| 317 | as·values,·which·conceal·the·underlying·mapped·classes.</p> | ||
| 318 | </p></li> | ||
| 319 | </ul> | 319 | </ul> |
| 320 | </p> | 320 | </p> |
| 321 | </section> | 321 | </section> |
| 322 | <section·id="module-examples.asyncio"> | 322 | <section·id="module-examples.asyncio"> |
| 323 | <span·id="asyncio-integration"></span><span·id="examples-asyncio"></span><h3>Asyncio·Integration<a·class="headerlink"·href="#module-examples.asyncio"·title="Link·to·this·heading">¶</a></h3> | 323 | <span·id="asyncio-integration"></span><span·id="examples-asyncio"></span><h3>Asyncio·Integration<a·class="headerlink"·href="#module-examples.asyncio"·title="Link·to·this·heading">¶</a></h3> |
| 324 | <p>Examples·illustrating·the·asyncio·engine·feature·of·SQLAlchemy.</p> | 324 | <p>Examples·illustrating·the·asyncio·engine·feature·of·SQLAlchemy.</p> |
| 325 | <p>Listing·of·files:<ul·class="simple"> | 325 | <p>Listing·of·files:<ul·class="simple"> |
| 326 | <li><p><p><a·class="reference·external"·href="../_modules/examples/asyncio/greenlet_orm.html">greenlet_orm.py</a>·-·Illustrates·use·of·the·sqlalchemy.ext.asyncio.AsyncSession·object | ||
| 327 | for·asynchronous·ORM·use,·including·the·optional·run_sync()·method.</p> | ||
| 328 | </p></li> | ||
| 329 | <li><p><p><a·class="reference·external"·href="../_modules/examples/asyncio/async_orm.html">async_orm.py</a>·-·Illustrates·use·of·the·<code·class="docutils·literal·notranslate"><span·class="pre">sqlalchemy.ext.asyncio.AsyncSession</span></code>·object | 326 | <li><p><p><a·class="reference·external"·href="../_modules/examples/asyncio/async_orm.html">async_orm.py</a>·-·Illustrates·use·of·the·<code·class="docutils·literal·notranslate"><span·class="pre">sqlalchemy.ext.asyncio.AsyncSession</span></code>·object |
| 330 | for·asynchronous·ORM·use.</p> | 327 | for·asynchronous·ORM·use.</p> |
| 331 | </p></li> | 328 | </p></li> |
| 332 | <li><p><p><a·class="reference·external"·href="../_modules/examples/asyncio/async_orm_writeonly.html">async_orm_writeonly.py</a>·-·Illustrates·using·<strong>write·only·relationships</strong>·for·simpler·handling | 329 | <li><p><p><a·class="reference·external"·href="../_modules/examples/asyncio/async_orm_writeonly.html">async_orm_writeonly.py</a>·-·Illustrates·using·<strong>write·only·relationships</strong>·for·simpler·handling |
| 333 | of·ORM·collections·under·asyncio.</p> | 330 | of·ORM·collections·under·asyncio.</p> |
| 334 | </p></li> | 331 | </p></li> |
| 335 | <li><p><p><a·class="reference·external"·href="../_modules/examples/asyncio/basic.html">basic.py</a>·-·Illustrates·the·asyncio·engine·/·connection·interface.</p> | ||
| 336 | </p></li> | ||
| 337 | <li><p><p><a·class="reference·external"·href="../_modules/examples/asyncio/gather_orm_statements.html">gather_orm_statements.py</a>·-·Illustrates·how·to·run·many·statements·concurrently·using·<code·class="docutils·literal·notranslate"><span·class="pre">asyncio.gather()</span></code> | 332 | <li><p><p><a·class="reference·external"·href="../_modules/examples/asyncio/gather_orm_statements.html">gather_orm_statements.py</a>·-·Illustrates·how·to·run·many·statements·concurrently·using·<code·class="docutils·literal·notranslate"><span·class="pre">asyncio.gather()</span></code> |
| 338 | along·many·asyncio·database·connections,·merging·ORM·results·into·a·single | 333 | along·many·asyncio·database·connections,·merging·ORM·results·into·a·single |
| 339 | <code·class="docutils·literal·notranslate"><span·class="pre">AsyncSession</span></code>.</p> | 334 | <code·class="docutils·literal·notranslate"><span·class="pre">AsyncSession</span></code>.</p> |
| 340 | </p></li> | 335 | </p></li> |
| 336 | <li><p><p><a·class="reference·external"·href="../_modules/examples/asyncio/basic.html">basic.py</a>·-·Illustrates·the·asyncio·engine·/·connection·interface.</p> | ||
| 337 | </p></li> | ||
| 338 | <li><p><p><a·class="reference·external"·href="../_modules/examples/asyncio/greenlet_orm.html">greenlet_orm.py</a>·-·Illustrates·use·of·the·sqlalchemy.ext.asyncio.AsyncSession·object | ||
| 339 | for·asynchronous·ORM·use,·including·the·optional·run_sync()·method.</p> | ||
| 340 | </p></li> | ||
| 341 | </ul> | 341 | </ul> |
| 342 | </p> | 342 | </p> |
| 343 | </section> | 343 | </section> |
| 344 | <section·id="module-examples.graphs"> | 344 | <section·id="module-examples.graphs"> |
| 345 | <span·id="directed-graphs"></span><h3>Directed·Graphs<a·class="headerlink"·href="#module-examples.graphs"·title="Link·to·this·heading">¶</a></h3> | 345 | <span·id="directed-graphs"></span><h3>Directed·Graphs<a·class="headerlink"·href="#module-examples.graphs"·title="Link·to·this·heading">¶</a></h3> |
| 346 | <p>An·example·of·persistence·for·a·directed·graph·structure.···The | 346 | <p>An·example·of·persistence·for·a·directed·graph·structure.···The |
| 347 | graph·is·stored·as·a·collection·of·edges,·each·referencing·both·a | 347 | graph·is·stored·as·a·collection·of·edges,·each·referencing·both·a |
| Offset 96, 38 lines modified | Offset 96, 37 lines modified | ||
| 96 | Listing·of·files: | 96 | Listing·of·files: |
| 97 | ····*·_\x8a_\x8d_\x8j_\x8a_\x8c_\x8e_\x8n_\x8c_\x8y_\x8__\x8l_\x8i_\x8s_\x8t_\x8._\x8p_\x8y | 97 | ····*·_\x8a_\x8d_\x8j_\x8a_\x8c_\x8e_\x8n_\x8c_\x8y_\x8__\x8l_\x8i_\x8s_\x8t_\x8._\x8p_\x8y |
| 98 | *\x8**\x8**\x8**\x8*·A\x8As\x8ss\x8so\x8oc\x8ci\x8ia\x8at\x8ti\x8io\x8on\x8ns\x8s_\x8?\x8¶·*\x8**\x8**\x8**\x8* | 98 | *\x8**\x8**\x8**\x8*·A\x8As\x8ss\x8so\x8oc\x8ci\x8ia\x8at\x8ti\x8io\x8on\x8ns\x8s_\x8?\x8¶·*\x8**\x8**\x8**\x8* |
| 99 | Examples·illustrating·the·usage·of·the·“association·object”·pattern,·where·an | 99 | Examples·illustrating·the·usage·of·the·“association·object”·pattern,·where·an |
| 100 | intermediary·class·mediates·the·relationship·between·two·classes·that·are | 100 | intermediary·class·mediates·the·relationship·between·two·classes·that·are |
| 101 | associated·in·a·many-to-many·pattern. | 101 | associated·in·a·many-to-many·pattern. |
| 102 | Listing·of·files: | 102 | Listing·of·files: |
| 103 | ····*·_\x8d_\x8i_\x8c_\x8t_\x8__\x8o_\x8f_\x8__\x8s_\x8e_\x8t_\x8s_\x8__\x8w_\x8i_\x8t_\x8h_\x8__\x8d_\x8e_\x8f_\x8a_\x8u_\x8l_\x8t_\x8._\x8p_\x8y·-·An·advanced·association·proxy·example | ||
| 104 | ······which·illustrates·nesting·of·association·proxies·to·produce·multi-level | ||
| 105 | ······Python·collections,·in·this·case·a·dictionary·with·string·keys·and·sets | ||
| 106 | ······of·integers·as·values,·which·conceal·the·underlying·mapped·classes. | ||
| 107 | _\x8b_\x8a_\x8s_\x8i_\x8c_\x8__\x8a_\x8s_\x8s_\x8o_\x8c_\x8i_\x8a_\x8t_\x8i_\x8o_\x8n_\x8._\x8p_\x8y·-·Illustrate·a·many-to-many·relationship·between·an | 103 | ····*·_\x8b_\x8a_\x8s_\x8i_\x8c_\x8__\x8a_\x8s_\x8s_\x8o_\x8c_\x8i_\x8a_\x8t_\x8i_\x8o_\x8n_\x8._\x8p_\x8y·-·Illustrate·a·many-to-many·relationship·between·an |
| 108 | “Order”·and·a·collection·of·“Item”·objects,·associating·a·purchase·price | 104 | ······“Order”·and·a·collection·of·“Item”·objects,·associating·a·purchase·price |
| 109 | each·via·an·association·object·called·“OrderItem” | 105 | ······with·each·via·an·association·object·called·“OrderItem” |
| 110 | _\x8p_\x8r_\x8o_\x8x_\x8i_\x8e_\x8d_\x8__\x8a_\x8s_\x8s_\x8o_\x8c_\x8i_\x8a_\x8t_\x8i_\x8o_\x8n_\x8._\x8p_\x8y·-·Same·example·as·basic_association,·adding·in·usage·of | 106 | _\x8p_\x8r_\x8o_\x8x_\x8i_\x8e_\x8d_\x8__\x8a_\x8s_\x8s_\x8o_\x8c_\x8i_\x8a_\x8t_\x8i_\x8o_\x8n_\x8._\x8p_\x8y·-·Same·example·as·basic_association,·adding·in·usage·of |
| 111 | _\x8s_\x8q_\x8l_\x8a_\x8l_\x8c_\x8h_\x8e_\x8m_\x8y_\x8._\x8e_\x8x_\x8t_\x8._\x8a_\x8s_\x8s_\x8o_\x8c_\x8i_\x8a_\x8t_\x8i_\x8o_\x8n_\x8p_\x8r_\x8o_\x8x_\x8y·to·make·explicit·references·to·OrderItem | 107 | _\x8s_\x8q_\x8l_\x8a_\x8l_\x8c_\x8h_\x8e_\x8m_\x8y_\x8._\x8e_\x8x_\x8t_\x8._\x8a_\x8s_\x8s_\x8o_\x8c_\x8i_\x8a_\x8t_\x8i_\x8o_\x8n_\x8p_\x8r_\x8o_\x8x_\x8y·to·make·explicit·references·to·OrderItem |
| 112 | optional. | 108 | optional. |
| 109 | _\x8d_\x8i_\x8c_\x8t_\x8__\x8o_\x8f_\x8__\x8s_\x8e_\x8t_\x8s_\x8__\x8w_\x8i_\x8t_\x8h_\x8__\x8d_\x8e_\x8f_\x8a_\x8u_\x8l_\x8t_\x8._\x8p_\x8y·-·An·advanced·association·proxy·example·which | ||
| 110 | illustrates·nesting·of·association·proxies·to·produce·multi-level·Python | ||
| 111 | collections,·in·this·case·a·dictionary·with·string·keys·and·sets·of·integers·as | ||
| 112 | values,·which·conceal·the·underlying·mapped·classes. | ||
| 113 | *\x8**\x8**\x8**\x8*·A\x8As\x8sy\x8yn\x8nc\x8ci\x8io\x8o·I\x8In\x8nt\x8te\x8eg\x8gr\x8ra\x8at\x8ti\x8io\x8on\x8n_\x8?\x8¶·*\x8**\x8**\x8**\x8* | 113 | *\x8**\x8**\x8**\x8*·A\x8As\x8sy\x8yn\x8nc\x8ci\x8io\x8o·I\x8In\x8nt\x8te\x8eg\x8gr\x8ra\x8at\x8ti\x8io\x8on\x8n_\x8?\x8¶·*\x8**\x8**\x8**\x8* |
| 114 | Examples·illustrating·the·asyncio·engine·feature·of·SQLAlchemy. | 114 | Examples·illustrating·the·asyncio·engine·feature·of·SQLAlchemy. |
| 115 | Listing·of·files: | 115 | Listing·of·files: |
| 116 | ····*·_\x8g_\x8r_\x8e_\x8e_\x8n_\x8l_\x8e_\x8t_\x8__\x8o_\x8r_\x8m_\x8._\x8p_\x8y·-·Illustrates·use·of·the | ||
| 117 | ······sqlalchemy.ext.asyncio.AsyncSession·object·for·asynchronous·ORM·use, | ||
| 118 | ······including·the·optional·run_sync()·method. | ||
| 119 | _\x8a_\x8s_\x8y_\x8n_\x8c_\x8__\x8o_\x8r_\x8m_\x8._\x8p_\x8y·-·Illustrates·use·of·the·sqlalchemy.ext.asyncio.AsyncSession | 116 | ····*·_\x8a_\x8s_\x8y_\x8n_\x8c_\x8__\x8o_\x8r_\x8m_\x8._\x8p_\x8y·-·Illustrates·use·of·the·sqlalchemy.ext.asyncio.AsyncSession |
| 120 | object·for·asynchronous·ORM·use. | 117 | ······object·for·asynchronous·ORM·use. |
| 121 | _\x8a_\x8s_\x8y_\x8n_\x8c_\x8__\x8o_\x8r_\x8m_\x8__\x8w_\x8r_\x8i_\x8t_\x8e_\x8o_\x8n_\x8l_\x8y_\x8._\x8p_\x8y·-·Illustrates·using·w\x8wr\x8ri\x8it\x8te\x8e·o\x8on\x8nl\x8ly\x8y·r\x8re\x8el\x8la\x8at\x8ti\x8io\x8on\x8ns\x8sh\x8hi\x8ip\x8ps\x8s·for·simpler | 118 | _\x8a_\x8s_\x8y_\x8n_\x8c_\x8__\x8o_\x8r_\x8m_\x8__\x8w_\x8r_\x8i_\x8t_\x8e_\x8o_\x8n_\x8l_\x8y_\x8._\x8p_\x8y·-·Illustrates·using·w\x8wr\x8ri\x8it\x8te\x8e·o\x8on\x8nl\x8ly\x8y·r\x8re\x8el\x8la\x8at\x8ti\x8io\x8on\x8ns\x8sh\x8hi\x8ip\x8ps\x8s·for·simpler |
| 122 | handling·of·ORM·collections·under·asyncio. | 119 | handling·of·ORM·collections·under·asyncio. |
| 123 | _\x8b_\x8a_\x8s_\x8i_\x8c_\x8._\x8p_\x8y·-·Illustrates·the·asyncio·engine·/·connection·interface. | ||
| 124 | _\x8g_\x8a_\x8t_\x8h_\x8e_\x8r_\x8__\x8o_\x8r_\x8m_\x8__\x8s_\x8t_\x8a_\x8t_\x8e_\x8m_\x8e_\x8n_\x8t_\x8s_\x8._\x8p_\x8y·-·Illustrates·how·to·run·many·statements·concurrently | 120 | _\x8g_\x8a_\x8t_\x8h_\x8e_\x8r_\x8__\x8o_\x8r_\x8m_\x8__\x8s_\x8t_\x8a_\x8t_\x8e_\x8m_\x8e_\x8n_\x8t_\x8s_\x8._\x8p_\x8y·-·Illustrates·how·to·run·many·statements·concurrently |
| 125 | using·asyncio.gather()·along·many·asyncio·database·connections,·merging·ORM | 121 | using·asyncio.gather()·along·many·asyncio·database·connections,·merging·ORM |
| 126 | results·into·a·single·AsyncSession. | 122 | results·into·a·single·AsyncSession. |
| 123 | _\x8b_\x8a_\x8s_\x8i_\x8c_\x8._\x8p_\x8y·-·Illustrates·the·asyncio·engine·/·connection·interface. | ||
| 124 | _\x8g_\x8r_\x8e_\x8e_\x8n_\x8l_\x8e_\x8t_\x8__\x8o_\x8r_\x8m_\x8._\x8p_\x8y·-·Illustrates·use·of·the·sqlalchemy.ext.asyncio.AsyncSession | ||
| 125 | object·for·asynchronous·ORM·use,·including·the·optional·run_sync()·method. | ||
| 127 | *\x8**\x8**\x8**\x8*·D\x8Di\x8ir\x8re\x8ec\x8ct\x8te\x8ed\x8d·G\x8Gr\x8ra\x8ap\x8ph\x8hs\x8s_\x8?\x8¶·*\x8**\x8**\x8**\x8* | 126 | *\x8**\x8**\x8**\x8*·D\x8Di\x8ir\x8re\x8ec\x8ct\x8te\x8ed\x8d·G\x8Gr\x8ra\x8ap\x8ph\x8hs\x8s_\x8?\x8¶·*\x8**\x8**\x8**\x8* |
| 128 | An·example·of·persistence·for·a·directed·graph·structure.·The·graph·is·stored | 127 | An·example·of·persistence·for·a·directed·graph·structure.·The·graph·is·stored |
| 129 | as·a·collection·of·edges,·each·referencing·both·a·“lower”·and·an·“upper”·node | 128 | as·a·collection·of·edges,·each·referencing·both·a·“lower”·and·an·“upper”·node |
| 130 | in·a·table·of·nodes.·Basic·persistence·and·querying·for·lower-·and·upper- | 129 | in·a·table·of·nodes.·Basic·persistence·and·querying·for·lower-·and·upper- |
| 131 | neighbors·are·illustrated: | 130 | neighbors·are·illustrated: |
| 132 | n2·=·Node(2) | 131 | n2·=·Node(2) |
| 133 | n5·=·Node(5) | 132 | n5·=·Node(5) |
| Offset 8512, 20 lines modified | Offset 8512, 20 lines modified | ||
| 8512 | ········"3414":·[13,·26], | 8512 | ········"3414":·[13,·26], |
| 8513 | ········"alchemy2":·13, | 8513 | ········"alchemy2":·13, |
| 8514 | ········"4644":·13, | 8514 | ········"4644":·13, |
| 8515 | ········"5649":·13, | 8515 | ········"5649":·13, |
| 8516 | ········"get_sequence_nam":·[13,·28,·50,·54], | 8516 | ········"get_sequence_nam":·[13,·28,·50,·54], |
| 8517 | ········"2056":·13, | 8517 | ········"2056":·13, |
| 8518 | ········"4755":·13, | 8518 | ········"4755":·13, |
| 8519 | ········"4524":·13, | ||
| 8520 | ········"upfront":·[13,·14], | 8519 | ········"upfront":·[13,·14], |
| 8521 | ········"returns_unicode_str":·13, | 8520 | ········"returns_unicode_str":·13, |
| 8522 | ········"returns_condit":·13, | 8521 | ········"returns_condit":·13, |
| 8523 | ········"returns_byt":·13, | 8522 | ········"returns_byt":·13, |
| 8524 | ········"5315":·13, | 8523 | ········"5315":·13, |
| 8524 | ········"4524":·13, | ||
| 8525 | ········"hundr":·[13,·22,·25,·26,·33,·76,·152,·171], | 8525 | ········"hundr":·[13,·22,·25,·26,·33,·76,·152,·171], |
| 8526 | ········"4645":·[13,·26], | 8526 | ········"4645":·[13,·26], |
| 8527 | ········"4808":·[13,·26], | 8527 | ········"4808":·[13,·26], |
| 8528 | ········"5004":·[13,·26], | 8528 | ········"5004":·[13,·26], |
| 8529 | ········"har":·[13,·26], | 8529 | ········"har":·[13,·26], |
| 8530 | ········"4712":·13, | 8530 | ········"4712":·13, |
| 8531 | ········"5526":·[13,·26], | 8531 | ········"5526":·[13,·26], |