| Offset 1, 5 lines modified | Offset 1, 5 lines modified | ||
| 1 | · | 1 | ·c5bd45a5e6d96786bca36fe287ccf3e8·3720132·doc·optional·python-sqlalchemy-doc_1.4.50+ds1-1_all.deb |
| 2 | ·b1d86e9da816c172b0fc0e45dea4561f·62108·debug·optional·python3-sqlalchemy-ext-dbgsym_1.4.50+ds1-1_i386.deb | 2 | ·b1d86e9da816c172b0fc0e45dea4561f·62108·debug·optional·python3-sqlalchemy-ext-dbgsym_1.4.50+ds1-1_i386.deb |
| 3 | ·e7e5b15fa9e5288be1114927792977f8·21468·python·optional·python3-sqlalchemy-ext_1.4.50+ds1-1_i386.deb | 3 | ·e7e5b15fa9e5288be1114927792977f8·21468·python·optional·python3-sqlalchemy-ext_1.4.50+ds1-1_i386.deb |
| 4 | ·7b9b7746123a45060be2c12bd6e80ed4·1009400·python·optional·python3-sqlalchemy_1.4.50+ds1-1_all.deb | 4 | ·7b9b7746123a45060be2c12bd6e80ed4·1009400·python·optional·python3-sqlalchemy_1.4.50+ds1-1_all.deb |
| Offset 1, 3 lines modified | Offset 1, 3 lines modified | ||
| 1 | -rw-r--r--···0········0········0········4·2024-01-05·13:47:47.000000·debian-binary | 1 | -rw-r--r--···0········0········0········4·2024-01-05·13:47:47.000000·debian-binary |
| 2 | -rw-r--r--···0········0········0····133 | 2 | -rw-r--r--···0········0········0····13380·2024-01-05·13:47:47.000000·control.tar.xz |
| 3 | -rw-r--r--···0········0········0··3706 | 3 | -rw-r--r--···0········0········0··3706560·2024-01-05·13:47:47.000000·data.tar.xz |
| Offset 1, 13 lines modified | Offset 1, 13 lines modified | ||
| 1 | ··Streams:···········1 | 1 | ··Streams:···········1 |
| 2 | ··Blocks:············1 | 2 | ··Blocks:············1 |
| 3 | ··Compressed·size:···13.1·KiB·(133 | 3 | ··Compressed·size:···13.1·KiB·(13380·B) |
| 4 | ··Uncompressed·size:·60.0·KiB·(61440·B) | 4 | ··Uncompressed·size:·60.0·KiB·(61440·B) |
| 5 | ··Ratio:·············0.218 | 5 | ··Ratio:·············0.218 |
| 6 | ··Check:·············CRC64 | 6 | ··Check:·············CRC64 |
| 7 | ··Stream·Padding:····0·B | 7 | ··Stream·Padding:····0·B |
| 8 | ··Streams: | 8 | ··Streams: |
| 9 | ····Stream····Blocks······CompOffset····UncompOffset········CompSize······UncompSize··Ratio··Check······Padding | 9 | ····Stream····Blocks······CompOffset····UncompOffset········CompSize······UncompSize··Ratio··Check······Padding |
| 10 | ·········1·········1···············0···············0···········133 | 10 | ·········1·········1···············0···············0···········13380···········61440··0.218··CRC64············0 |
| 11 | ··Blocks: | 11 | ··Blocks: |
| 12 | ····Stream·····Block······CompOffset····UncompOffset·······TotalSize······UncompSize··Ratio··Check | 12 | ····Stream·····Block······CompOffset····UncompOffset·······TotalSize······UncompSize··Ratio··Check |
| 13 | ·········1·········1··············12···············0···········133 | 13 | ·········1·········1··············12···············0···········13344···········61440··0.217··CRC64 |
| Offset 9028, 22 lines modified | Offset 9028, 15 lines modified | ||
| 9028 | <div·class="admonition·seealso"> | 9028 | <div·class="admonition·seealso"> |
| 9029 | <p·class="admonition-title">See·also</p> | 9029 | <p·class="admonition-title">See·also</p> |
| 9030 | <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> | 9030 | <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> |
| 9031 | </div> | 9031 | </div> |
| 9032 | <p>References:·<a·class="reference·external"·href="https://www.sqlalchemy.org/trac/ticket/4710">#4710</a></p> | 9032 | <p>References:·<a·class="reference·external"·href="https://www.sqlalchemy.org/trac/ticket/4710">#4710</a></p> |
| 9033 | </p> | 9033 | </p> |
| 9034 | </li> | 9034 | </li> |
| 9035 | <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 | ||
| 9036 | connection·that·was·just·opened·in·the·same·checkout·operation.··pre·ping | ||
| 9037 | only·applies·to·a·DBAPI·connection·that’s·been·checked·into·the·pool | ||
| 9038 | and·is·being·checked·out·again.</p> | ||
| 9039 | <p>References:·<a·class="reference·external"·href="https://www.sqlalchemy.org/trac/ticket/4524">#4524</a></p> | ||
| 9040 | </p> | ||
| 9041 | </li> | ||
| 9042 | <li><p·class="caption"·id="change-1.4.0b1-5 | 9035 | <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 |
| 9043 | running·under·Python·3,·which·for·many·years·has·occurred·in·order·to·test | 9036 | running·under·Python·3,·which·for·many·years·has·occurred·in·order·to·test |
| 9044 | the·current·DBAPI’s·behavior·for·whether·or·not·it·returns·Python·Unicode | 9037 | the·current·DBAPI’s·behavior·for·whether·or·not·it·returns·Python·Unicode |
| 9045 | or·Py2K·strings·for·the·VARCHAR·and·NVARCHAR·datatypes.··The·check·still | 9038 | or·Py2K·strings·for·the·VARCHAR·and·NVARCHAR·datatypes.··The·check·still |
| 9046 | occurs·by·default·under·Python·2,·however·the·mechanism·to·test·the | 9039 | occurs·by·default·under·Python·2,·however·the·mechanism·to·test·the |
| 9047 | behavior·will·be·removed·in·SQLAlchemy·2.0·when·Python·2·support·is·also | 9040 | behavior·will·be·removed·in·SQLAlchemy·2.0·when·Python·2·support·is·also |
| 9048 | removed.</p> | 9041 | removed.</p> |
| 9049 | <p>This·logic·was·very·effective·when·it·was·needed,·however·now·that·Python·3 | 9042 | <p>This·logic·was·very·effective·when·it·was·needed,·however·now·that·Python·3 |
| Offset 9054, 14 lines modified | Offset 9047, 21 lines modified | ||
| 9054 | dialect·flags·by·setting·the·dialect·level·flag·<code·class="docutils·literal·notranslate"><span·class="pre">returns_unicode_strings</span></code> | 9047 | dialect·flags·by·setting·the·dialect·level·flag·<code·class="docutils·literal·notranslate"><span·class="pre">returns_unicode_strings</span></code> |
| 9055 | to·one·of·<a·class="reference·internal"·href="../core/type_basics.html#sqlalchemy.types.String.RETURNS_CONDITIONAL"·title="sqlalchemy.types.String.RETURNS_CONDITIONAL"><code·class="xref·py·py-attr·docutils·literal·notranslate"><span·class="pre">String.RETURNS_CONDITIONAL</span></code></a>·or | 9048 | to·one·of·<a·class="reference·internal"·href="../core/type_basics.html#sqlalchemy.types.String.RETURNS_CONDITIONAL"·title="sqlalchemy.types.String.RETURNS_CONDITIONAL"><code·class="xref·py·py-attr·docutils·literal·notranslate"><span·class="pre">String.RETURNS_CONDITIONAL</span></code></a>·or |
| 9056 | <a·class="reference·internal"·href="../core/type_basics.html#sqlalchemy.types.String.RETURNS_BYTES"·title="sqlalchemy.types.String.RETURNS_BYTES"><code·class="xref·py·py-attr·docutils·literal·notranslate"><span·class="pre">String.RETURNS_BYTES</span></code></a>,·both·of·which·will·enable·Unicode·conversion | 9049 | <a·class="reference·internal"·href="../core/type_basics.html#sqlalchemy.types.String.RETURNS_BYTES"·title="sqlalchemy.types.String.RETURNS_BYTES"><code·class="xref·py·py-attr·docutils·literal·notranslate"><span·class="pre">String.RETURNS_BYTES</span></code></a>,·both·of·which·will·enable·Unicode·conversion |
| 9057 | even·under·Python·3.</p> | 9050 | even·under·Python·3.</p> |
| 9058 | <p>References:·<a·class="reference·external"·href="https://www.sqlalchemy.org/trac/ticket/5315">#5315</a></p> | 9051 | <p>References:·<a·class="reference·external"·href="https://www.sqlalchemy.org/trac/ticket/5315">#5315</a></p> |
| 9059 | </p> | 9052 | </p> |
| 9060 | </li> | 9053 | </li> |
| 9054 | <li><p·class="caption"·id="change-1.4.0b1-55"><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 | ||
| 9055 | connection·that·was·just·opened·in·the·same·checkout·operation.··pre·ping | ||
| 9056 | only·applies·to·a·DBAPI·connection·that’s·been·checked·into·the·pool | ||
| 9057 | and·is·being·checked·out·again.</p> | ||
| 9058 | <p>References:·<a·class="reference·external"·href="https://www.sqlalchemy.org/trac/ticket/4524">#4524</a></p> | ||
| 9059 | </p> | ||
| 9060 | </li> | ||
| 9061 | <li><p·class="caption"·id="change-1.4.0b1-56"><span·class="target"·id="change-f8a130923cff752e26f7be9cf1ea18eb"><strong>[engine]·[bug]</strong>·<a·class="changelog-reference·headerlink·reference·internal"·href="#change-f8a130923cff752e26f7be9cf1ea18eb">¶</a></span><p>Revised·the·<a·class="reference·internal"·href="../core/connections.html#sqlalchemy.engine.Connection.execution_options.params.schema_translate_map"·title="sqlalchemy.engine.Connection.execution_options"><code·class="xref·py·py-paramref·docutils·literal·notranslate"><span·class="pre">Connection.execution_options.schema_translate_map</span></code></a> | 9061 | <li><p·class="caption"·id="change-1.4.0b1-56"><span·class="target"·id="change-f8a130923cff752e26f7be9cf1ea18eb"><strong>[engine]·[bug]</strong>·<a·class="changelog-reference·headerlink·reference·internal"·href="#change-f8a130923cff752e26f7be9cf1ea18eb">¶</a></span><p>Revised·the·<a·class="reference·internal"·href="../core/connections.html#sqlalchemy.engine.Connection.execution_options.params.schema_translate_map"·title="sqlalchemy.engine.Connection.execution_options"><code·class="xref·py·py-paramref·docutils·literal·notranslate"><span·class="pre">Connection.execution_options.schema_translate_map</span></code></a> |
| 9062 | feature·such·that·the·processing·of·the·SQL·statement·to·receive·a·specific | 9062 | feature·such·that·the·processing·of·the·SQL·statement·to·receive·a·specific |
| 9063 | schema·name·occurs·within·the·execution·phase·of·the·statement,·rather·than | 9063 | schema·name·occurs·within·the·execution·phase·of·the·statement,·rather·than |
| 9064 | at·the·compile·phase.···This·is·to·support·the·statement·being·efficiently | 9064 | at·the·compile·phase.···This·is·to·support·the·statement·being·efficiently |
| 9065 | cached.···Previously,·the·current·schema·being·rendered·into·the·statement | 9065 | cached.···Previously,·the·current·schema·being·rendered·into·the·statement |
| 9066 | for·a·particular·run·would·be·considered·as·part·of·the·cache·key·itself, | 9066 | for·a·particular·run·would·be·considered·as·part·of·the·cache·key·itself, |
| 9067 | meaning·that·for·a·run·against·hundreds·of·schemas,·there·would·be·hundreds | 9067 | meaning·that·for·a·run·against·hundreds·of·schemas,·there·would·be·hundreds |
| Offset 6223, 21 lines modified | Offset 6223, 15 lines modified | ||
| 6223 | returned·by·the·ResultProxy·is·now·the·_\x8L_\x8e_\x8g_\x8a_\x8c_\x8y_\x8R_\x8o_\x8w·subclass,·which·maintains | 6223 | returned·by·the·ResultProxy·is·now·the·_\x8L_\x8e_\x8g_\x8a_\x8c_\x8y_\x8R_\x8o_\x8w·subclass,·which·maintains |
| 6224 | mapping/tuple·hybrid·behavior,·however·the·base·_\x8R_\x8o_\x8w·class·now·behaves·more | 6224 | mapping/tuple·hybrid·behavior,·however·the·base·_\x8R_\x8o_\x8w·class·now·behaves·more |
| 6225 | fully·like·a·named·tuple. | 6225 | fully·like·a·named·tuple. |
| 6226 | See·also | 6226 | See·also |
| 6227 | _\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 | 6227 | _\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 |
| 6228 | _\x8n_\x8a_\x8m_\x8e_\x8d_\x8·_\x8t_\x8u_\x8p_\x8l_\x8e | 6228 | _\x8n_\x8a_\x8m_\x8e_\x8d_\x8·_\x8t_\x8u_\x8p_\x8l_\x8e |
| 6229 | References:·_\x8#_\x84_\x87_\x81_\x80 | 6229 | References:·_\x8#_\x84_\x87_\x81_\x80 |
| 6230 | [\x8[e\x8en\x8ng\x8gi\x8in\x8ne\x8e]\x8]·[\x8[p\x8pe\x8er\x8rf\x8fo\x8or\x8rm\x8ma\x8an\x8nc\x8ce\x8e]\x8]·_\x8¶ | ||
| 6231 | The·pool·“pre-ping”·feature·has·been·refined·to·not·invoke·for·a·DBAPI | ||
| 6232 | connection·that·was·just·opened·in·the·same·checkout·operation.·pre·ping·only | ||
| 6233 | applies·to·a·DBAPI·connection·that’s·been·checked·into·the·pool·and·is·being | ||
| 6234 | checked·out·again. | ||
| 6235 | References:·_\x8#_\x84_\x85_\x82_\x84 | ||
| 6236 | [\x8[e\x8en\x8ng\x8gi\x8in\x8ne\x8e]\x8]·[\x8[ | 6230 | [\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¶ |
| 6237 | Disabled·the·“unicode·returns”·check·that·runs·on·dialect·startup·when·running | 6231 | Disabled·the·“unicode·returns”·check·that·runs·on·dialect·startup·when·running |
| 6238 | under·Python·3,·which·for·many·years·has·occurred·in·order·to·test·the·current | 6232 | under·Python·3,·which·for·many·years·has·occurred·in·order·to·test·the·current |
| 6239 | DBAPI’s·behavior·for·whether·or·not·it·returns·Python·Unicode·or·Py2K·strings | 6233 | DBAPI’s·behavior·for·whether·or·not·it·returns·Python·Unicode·or·Py2K·strings |
| 6240 | for·the·VARCHAR·and·NVARCHAR·datatypes.·The·check·still·occurs·by·default·under | 6234 | for·the·VARCHAR·and·NVARCHAR·datatypes.·The·check·still·occurs·by·default·under |
| 6241 | Python·2,·however·the·mechanism·to·test·the·behavior·will·be·removed·in | 6235 | Python·2,·however·the·mechanism·to·test·the·behavior·will·be·removed·in |
| 6242 | SQLAlchemy·2.0·when·Python·2·support·is·also·removed. | 6236 | SQLAlchemy·2.0·when·Python·2·support·is·also·removed. |
| 6243 | This·logic·was·very·effective·when·it·was·needed,·however·now·that·Python·3·is | 6237 | This·logic·was·very·effective·when·it·was·needed,·however·now·that·Python·3·is |
| Offset 6245, 14 lines modified | Offset 6239, 20 lines modified | ||
| 6245 | datatypes.·In·the·unlikely·case·that·a·third·party·DBAPI·does·not·support·this, | 6239 | datatypes.·In·the·unlikely·case·that·a·third·party·DBAPI·does·not·support·this, |
| 6246 | the·conversion·logic·within·_\x8S_\x8t_\x8r_\x8i_\x8n_\x8g·is·still·available·and·the·third·party | 6240 | the·conversion·logic·within·_\x8S_\x8t_\x8r_\x8i_\x8n_\x8g·is·still·available·and·the·third·party |
| 6247 | dialect·may·specify·this·in·its·upfront·dialect·flags·by·setting·the·dialect | 6241 | dialect·may·specify·this·in·its·upfront·dialect·flags·by·setting·the·dialect |
| 6248 | level·flag·returns_unicode_strings·to·one·of·_\x8S_\x8t_\x8r_\x8i_\x8n_\x8g_\x8._\x8R_\x8E_\x8T_\x8U_\x8R_\x8N_\x8S_\x8__\x8C_\x8O_\x8N_\x8D_\x8I_\x8T_\x8I_\x8O_\x8N_\x8A_\x8L·or | 6242 | level·flag·returns_unicode_strings·to·one·of·_\x8S_\x8t_\x8r_\x8i_\x8n_\x8g_\x8._\x8R_\x8E_\x8T_\x8U_\x8R_\x8N_\x8S_\x8__\x8C_\x8O_\x8N_\x8D_\x8I_\x8T_\x8I_\x8O_\x8N_\x8A_\x8L·or |
| 6249 | _\x8S_\x8t_\x8r_\x8i_\x8n_\x8g_\x8._\x8R_\x8E_\x8T_\x8U_\x8R_\x8N_\x8S_\x8__\x8B_\x8Y_\x8T_\x8E_\x8S,·both·of·which·will·enable·Unicode·conversion·even·under | 6243 | _\x8S_\x8t_\x8r_\x8i_\x8n_\x8g_\x8._\x8R_\x8E_\x8T_\x8U_\x8R_\x8N_\x8S_\x8__\x8B_\x8Y_\x8T_\x8E_\x8S,·both·of·which·will·enable·Unicode·conversion·even·under |
| 6250 | Python·3. | 6244 | Python·3. |
| 6251 | References:·_\x8#_\x85_\x83_\x81_\x85 | 6245 | References:·_\x8#_\x85_\x83_\x81_\x85 |
| 6246 | [\x8[e\x8en\x8ng\x8gi\x8in\x8ne\x8e]\x8]·[\x8[p\x8pe\x8er\x8rf\x8fo\x8or\x8rm\x8ma\x8an\x8nc\x8ce\x8e]\x8]·_\x8¶ | ||
| 6247 | The·pool·“pre-ping”·feature·has·been·refined·to·not·invoke·for·a·DBAPI | ||
| 6248 | connection·that·was·just·opened·in·the·same·checkout·operation.·pre·ping·only | ||
| 6249 | applies·to·a·DBAPI·connection·that’s·been·checked·into·the·pool·and·is·being | ||
| 6250 | checked·out·again. | ||
| 6251 | References:·_\x8#_\x84_\x85_\x82_\x84 | ||
| 6252 | [\x8[e\x8en\x8ng\x8gi\x8in\x8ne\x8e]\x8]·[\x8[b\x8bu\x8ug\x8g]\x8]·_\x8¶ | 6252 | [\x8[e\x8en\x8ng\x8gi\x8in\x8ne\x8e]\x8]·[\x8[b\x8bu\x8ug\x8g]\x8]·_\x8¶ |
| 6253 | Revised·the·_\x8C_\x8o_\x8n_\x8n_\x8e_\x8c_\x8t_\x8i_\x8o_\x8n_\x8._\x8e_\x8x_\x8e_\x8c_\x8u_\x8t_\x8i_\x8o_\x8n_\x8__\x8o_\x8p_\x8t_\x8i_\x8o_\x8n_\x8s_\x8._\x8s_\x8c_\x8h_\x8e_\x8m_\x8a_\x8__\x8t_\x8r_\x8a_\x8n_\x8s_\x8l_\x8a_\x8t_\x8e_\x8__\x8m_\x8a_\x8p·feature·such·that | 6253 | Revised·the·_\x8C_\x8o_\x8n_\x8n_\x8e_\x8c_\x8t_\x8i_\x8o_\x8n_\x8._\x8e_\x8x_\x8e_\x8c_\x8u_\x8t_\x8i_\x8o_\x8n_\x8__\x8o_\x8p_\x8t_\x8i_\x8o_\x8n_\x8s_\x8._\x8s_\x8c_\x8h_\x8e_\x8m_\x8a_\x8__\x8t_\x8r_\x8a_\x8n_\x8s_\x8l_\x8a_\x8t_\x8e_\x8__\x8m_\x8a_\x8p·feature·such·that |
| 6254 | the·processing·of·the·SQL·statement·to·receive·a·specific·schema·name·occurs | 6254 | the·processing·of·the·SQL·statement·to·receive·a·specific·schema·name·occurs |
| 6255 | within·the·execution·phase·of·the·statement,·rather·than·at·the·compile·phase. | 6255 | within·the·execution·phase·of·the·statement,·rather·than·at·the·compile·phase. |
| 6256 | This·is·to·support·the·statement·being·efficiently·cached.·Previously,·the | 6256 | This·is·to·support·the·statement·being·efficiently·cached.·Previously,·the |
| 6257 | current·schema·being·rendered·into·the·statement·for·a·particular·run·would·be | 6257 | current·schema·being·rendered·into·the·statement·for·a·particular·run·would·be |
| 6258 | considered·as·part·of·the·cache·key·itself,·meaning·that·for·a·run·against | 6258 | considered·as·part·of·the·cache·key·itself,·meaning·that·for·a·run·against |
| Offset 308, 26 lines modified | Offset 308, 26 lines modified | ||
| 308 | </section> | 308 | </section> |
| 309 | <section·id="module-examples.association"> | 309 | <section·id="module-examples.association"> |
| 310 | <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> | 310 | <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> |
| 311 | <p>Examples·illustrating·the·usage·of·the·“association·object”·pattern, | 311 | <p>Examples·illustrating·the·usage·of·the·“association·object”·pattern, |
| 312 | where·an·intermediary·class·mediates·the·relationship·between·two | 312 | where·an·intermediary·class·mediates·the·relationship·between·two |
| 313 | classes·that·are·associated·in·a·many-to-many·pattern.</p> | 313 | classes·that·are·associated·in·a·many-to-many·pattern.</p> |
| 314 | <p>Listing·of·files:<ul·class="simple"> | 314 | <p>Listing·of·files:<ul·class="simple"> |
| 315 | <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 | ||
| 316 | “Order”·and·a·collection·of·“Item”·objects,·associating·a·purchase·price | ||
| 317 | 315 | <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 | |
| 316 | illustrates·nesting·of·association·proxies·to·produce·multi-level·Python | ||
| 317 | collections,·in·this·case·a·dictionary·with·string·keys·and·sets·of·integers | ||
| 318 | as·values,·which·conceal·the·underlying·mapped·classes.</p> | ||
| 318 | </p></li> | 319 | </p></li> |
| 319 | <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 | 320 | <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 |
| 320 | 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 | 321 | 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 |
| 321 | to·<code·class="docutils·literal·notranslate"><span·class="pre">OrderItem</span></code>·optional.</p> | 322 | to·<code·class="docutils·literal·notranslate"><span·class="pre">OrderItem</span></code>·optional.</p> |
| 322 | </p></li> | 323 | </p></li> |
| 324 | <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 | ||
| 325 | “Order”·and·a·collection·of·“Item”·objects,·associating·a·purchase·price | ||
| 326 | with·each·via·an·association·object·called·“OrderItem”</p> | ||
| 323 | <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 | ||
| 324 | illustrates·nesting·of·association·proxies·to·produce·multi-level·Python | ||
| 325 | collections,·in·this·case·a·dictionary·with·string·keys·and·sets·of·integers | ||
| 326 | as·values,·which·conceal·the·underlying·mapped·classes.</p> | ||
| 327 | </p></li> | 327 | </p></li> |
| 328 | </ul> | 328 | </ul> |
| 329 | </p> | 329 | </p> |
| 330 | </section> | 330 | </section> |
| 331 | <section·id="module-examples.asyncio"> | 331 | <section·id="module-examples.asyncio"> |
| 332 | <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> | 332 | <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> |
| 333 | <p>Examples·illustrating·the·asyncio·engine·feature·of·SQLAlchemy.</p> | 333 | <p>Examples·illustrating·the·asyncio·engine·feature·of·SQLAlchemy.</p> |
| Offset 335, 19 lines modified | Offset 335, 19 lines modified | ||
| 335 | <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 | 335 | <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 |
| 336 | for·asynchronous·ORM·use,·including·the·optional·run_sync()·method.</p> | 336 | for·asynchronous·ORM·use,·including·the·optional·run_sync()·method.</p> |
| 337 | </p></li> | 337 | </p></li> |
| 338 | <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 | <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> |
| 339 | along·many·asyncio·database·connections,·merging·ORM·results·into·a·single | 339 | along·many·asyncio·database·connections,·merging·ORM·results·into·a·single |
| 340 | <code·class="docutils·literal·notranslate"><span·class="pre">AsyncSession</span></code>.</p> | 340 | <code·class="docutils·literal·notranslate"><span·class="pre">AsyncSession</span></code>.</p> |
| 341 | </p></li> | 341 | </p></li> |
| 342 | <li><p><p><a·class="reference·external"·href="../_modules/examples/asyncio/basic.html">basic.py</a>·-·Illustrates·the·asyncio·engine·/·connection·interface.</p> | ||
| 343 | </p></li> | ||
| 342 | <li><p><p><a·class="reference·external"·href="../_modules/examples/asyncio/async_orm.html">async_orm.py</a>·-·Illustrates·use·of·the·sqlalchemy.ext.asyncio.AsyncSession·object | 344 | <li><p><p><a·class="reference·external"·href="../_modules/examples/asyncio/async_orm.html">async_orm.py</a>·-·Illustrates·use·of·the·sqlalchemy.ext.asyncio.AsyncSession·object |
| 343 | for·asynchronous·ORM·use.</p> | 345 | for·asynchronous·ORM·use.</p> |
| 344 | </p></li> | 346 | </p></li> |
| 345 | <li><p><p><a·class="reference·external"·href="../_modules/examples/asyncio/basic.html">basic.py</a>·-·Illustrates·the·asyncio·engine·/·connection·interface.</p> | ||
| 346 | </p></li> | ||
| 347 | </ul> | 347 | </ul> |
| 348 | </p> | 348 | </p> |
| 349 | </section> | 349 | </section> |
| 350 | <section·id="module-examples.graphs"> | 350 | <section·id="module-examples.graphs"> |
| 351 | <span·id="directed-graphs"></span><h3>Directed·Graphs<a·class="headerlink"·href="#module-examples.graphs"·title="Link·to·this·heading">¶</a></h3> | 351 | <span·id="directed-graphs"></span><h3>Directed·Graphs<a·class="headerlink"·href="#module-examples.graphs"·title="Link·to·this·heading">¶</a></h3> |
| 352 | <p>An·example·of·persistence·for·a·directed·graph·structure.···The | 352 | <p>An·example·of·persistence·for·a·directed·graph·structure.···The |
| 353 | graph·is·stored·as·a·collection·of·edges,·each·referencing·both·a | 353 | graph·is·stored·as·a·collection·of·edges,·each·referencing·both·a |
| Offset 384, 37 lines modified | Offset 384, 37 lines modified | ||
| 384 | subclassing·the·<code·class="docutils·literal·notranslate"><span·class="pre">HasAddresses</span></code>·mixin,·which·ensures·that·the | 384 | subclassing·the·<code·class="docutils·literal·notranslate"><span·class="pre">HasAddresses</span></code>·mixin,·which·ensures·that·the |
| 385 | parent·class·is·provided·with·an·<code·class="docutils·literal·notranslate"><span·class="pre">addresses</span></code>·collection | 385 | parent·class·is·provided·with·an·<code·class="docutils·literal·notranslate"><span·class="pre">addresses</span></code>·collection |
| 386 | which·contains·<code·class="docutils·literal·notranslate"><span·class="pre">Address</span></code>·objects.</p> | 386 | which·contains·<code·class="docutils·literal·notranslate"><span·class="pre">Address</span></code>·objects.</p> |
| 387 | <p>The·<a·class="reference·external"·href="../_modules/examples/generic_associations/discriminator_on_association.html">discriminator_on_association.py</a>·and·<a·class="reference·external"·href="../_modules/examples/generic_associations/generic_fk.html">generic_fk.py</a>·scripts | 387 | <p>The·<a·class="reference·external"·href="../_modules/examples/generic_associations/discriminator_on_association.html">discriminator_on_association.py</a>·and·<a·class="reference·external"·href="../_modules/examples/generic_associations/generic_fk.html">generic_fk.py</a>·scripts |
| 388 | are·modernized·versions·of·recipes·presented·in·the·2007·blog·post | 388 | are·modernized·versions·of·recipes·presented·in·the·2007·blog·post |
| 389 | <a·class="reference·external"·href="https://techspot.zzzeek.org/2007/05/29/polymorphic-associations-with-sqlalchemy/">Polymorphic·Associations·with·SQLAlchemy</a>.</p> | 389 | <a·class="reference·external"·href="https://techspot.zzzeek.org/2007/05/29/polymorphic-associations-with-sqlalchemy/">Polymorphic·Associations·with·SQLAlchemy</a>.</p> |
| 390 | <p>Listing·of·files:<ul·class="simple"> | 390 | <p>Listing·of·files:<ul·class="simple"> |
| 391 | <li><p><p><a·class="reference·external"·href="../_modules/examples/generic_associations/table_per_related.html">table_per_related.py</a>·-·Illustrates·a·generic·association·which·persists·association | ||
| 392 | objects·within·individual·tables,·each·one·generated·to·persist | ||
| 393 | those·objects·on·behalf·of·a·particular·parent·class.</p> | ||
| 394 | </p></li> | ||
| 391 | <li><p><p><a·class="reference·external"·href="../_modules/examples/generic_associations/generic_fk.html">generic_fk.py</a>·-·Illustrates·a·so-called·“generic·foreign·key”,·in·a·similar·fashion | 395 | <li><p><p><a·class="reference·external"·href="../_modules/examples/generic_associations/generic_fk.html">generic_fk.py</a>·-·Illustrates·a·so-called·“generic·foreign·key”,·in·a·similar·fashion |
| 392 | to·that·of·popular·frameworks·such·as·Django,·ROR,·etc.··This | 396 | to·that·of·popular·frameworks·such·as·Django,·ROR,·etc.··This |
| 393 | approach·bypasses·standard·referential·integrity | 397 | approach·bypasses·standard·referential·integrity |
| 394 | practices,·in·that·the·“foreign·key”·column·is·not·actually | 398 | practices,·in·that·the·“foreign·key”·column·is·not·actually |
| 395 | constrained·to·refer·to·any·particular·table;·instead, | 399 | constrained·to·refer·to·any·particular·table;·instead, |
| 396 | in-application·logic·is·used·to·determine·which·table·is·referenced.</p> | 400 | in-application·logic·is·used·to·determine·which·table·is·referenced.</p> |
| 397 | </p></li> | 401 | </p></li> |
| 398 | <li><p><p><a·class="reference·external"·href="../_modules/examples/generic_associations/table_per_association.html">table_per_association.py</a>·-·Illustrates·a·mixin·which·provides·a·generic·association | ||
| 399 | via·a·individually·generated·association·tables·for·each·parent·class. | ||
| 400 | The·associated·objects·themselves·are·persisted·in·a·single·table | ||
| 401 | shared·among·all·parents.</p> | ||
| 402 | </p></li> | ||
| 403 | <li><p><p><a·class="reference·external"·href="../_modules/examples/generic_associations/table_per_related.html">table_per_related.py</a>·-·Illustrates·a·generic·association·which·persists·association | ||
| 404 | objects·within·individual·tables,·each·one·generated·to·persist | ||
| 405 | those·objects·on·behalf·of·a·particular·parent·class.</p> | ||
| 406 | </p></li> | ||
| 407 | <li><p><p><a·class="reference·external"·href="../_modules/examples/generic_associations/discriminator_on_association.html">discriminator_on_association.py</a>·-·Illustrates·a·mixin·which·provides·a·generic·association | 402 | <li><p><p><a·class="reference·external"·href="../_modules/examples/generic_associations/discriminator_on_association.html">discriminator_on_association.py</a>·-·Illustrates·a·mixin·which·provides·a·generic·association |
| 408 | using·a·single·target·table·and·a·single·association·table, | 403 | using·a·single·target·table·and·a·single·association·table, |
| 409 | referred·to·by·all·parent·tables.··The·association·table | 404 | referred·to·by·all·parent·tables.··The·association·table |
| 410 | contains·a·“discriminator”·column·which·determines·what·type·of | 405 | contains·a·“discriminator”·column·which·determines·what·type·of |
| 411 | parent·object·associates·to·each·particular·row·in·the·association | 406 | parent·object·associates·to·each·particular·row·in·the·association |
| 412 | table.</p> | 407 | table.</p> |
| 413 | </p></li> | 408 | </p></li> |
| 409 | <li><p><p><a·class="reference·external"·href="../_modules/examples/generic_associations/table_per_association.html">table_per_association.py</a>·-·Illustrates·a·mixin·which·provides·a·generic·association | ||
| 410 | via·a·individually·generated·association·tables·for·each·parent·class. | ||
| 411 | The·associated·objects·themselves·are·persisted·in·a·single·table | ||
| 412 | shared·among·all·parents.</p> | ||
| 413 | </p></li> | ||
| 414 | </ul> | 414 | </ul> |
| 415 | </p> | 415 | </p> |
| 416 | </section> | 416 | </section> |
| 417 | <section·id="module-examples.large_collection"> | 417 | <section·id="module-examples.large_collection"> |
| 418 | <span·id="large-collections"></span><h3>Large·Collections<a·class="headerlink"·href="#module-examples.large_collection"·title="Link·to·this·heading">¶</a></h3> | 418 | <span·id="large-collections"></span><h3>Large·Collections<a·class="headerlink"·href="#module-examples.large_collection"·title="Link·to·this·heading">¶</a></h3> |
| 419 | <p>Large·collection·example.</p> | 419 | <p>Large·collection·example.</p> |
| 420 | <p>Illustrates·the·options·to·use·with | 420 | <p>Illustrates·the·options·to·use·with |
| Offset 503, 29 lines modified | Offset 503, 29 lines modified | ||
| 503 | </div> | 503 | </div> |
| 504 | <section·id="file-listing"> | 504 | <section·id="file-listing"> |
| 505 | <h4>File·Listing<a·class="headerlink"·href="#file-listing"·title="Link·to·this·heading">¶</a></h4> | 505 | <h4>File·Listing<a·class="headerlink"·href="#file-listing"·title="Link·to·this·heading">¶</a></h4> |
| 506 | <p>Listing·of·files:<ul·class="simple"> | 506 | <p>Listing·of·files:<ul·class="simple"> |
| 507 | <li><p><p><a·class="reference·external"·href="../_modules/examples/performance/large_resultsets.html">large_resultsets.py</a>·-·In·this·series·of·tests,·we·are·looking·at·time·to·load·a·large·number | 507 | <li><p><p><a·class="reference·external"·href="../_modules/examples/performance/large_resultsets.html">large_resultsets.py</a>·-·In·this·series·of·tests,·we·are·looking·at·time·to·load·a·large·number |
| 508 | of·very·small·and·simple·rows.</p> | 508 | of·very·small·and·simple·rows.</p> |
| 509 | </p></li> | 509 | </p></li> |
| 510 | <li><p><p><a·class="reference·external"·href="../_modules/examples/performance/bulk_ | 510 | <li><p><p><a·class="reference·external"·href="../_modules/examples/performance/bulk_inserts.html">bulk_inserts.py</a>·-·This·series·of·tests·illustrates·different·ways·to·INSERT·a·large·number |
| 511 | of·rows·in·bulk | 511 | of·rows·in·bulk.</p> |
| 512 | </p></li> | 512 | </p></li> |
| 513 | <li><p><p><a·class="reference·external"·href="../_modules/examples/performance/short_selects.html">short_selects.py</a>·-·This·series·of·tests·illustrates·different·ways·to·SELECT·a·single | 513 | <li><p><p><a·class="reference·external"·href="../_modules/examples/performance/short_selects.html">short_selects.py</a>·-·This·series·of·tests·illustrates·different·ways·to·SELECT·a·single |
| 514 | record·by·primary·key</p> | 514 | record·by·primary·key</p> |
| 515 | </p></li> | 515 | </p></li> |
| 516 | <li><p><p><a·class="reference·external"·href="../_modules/examples/performance/__main__.html">__main__.py</a>·-·Allows·the·examples/performance·package·to·be·run·as·a·script.</p> | ||
| 517 | </p></li> | ||
| 516 | <li><p><p><a·class="reference·external"·href="../_modules/examples/performance/single_inserts.html">single_inserts.py</a>·-·In·this·series·of·tests,·we’re·looking·at·a·method·that·inserts·a·row | 518 | <li><p><p><a·class="reference·external"·href="../_modules/examples/performance/single_inserts.html">single_inserts.py</a>·-·In·this·series·of·tests,·we’re·looking·at·a·method·that·inserts·a·row |
| 517 | within·a·distinct·transaction,·and·afterwards·returns·to·essentially·a | 519 | within·a·distinct·transaction,·and·afterwards·returns·to·essentially·a |
| 518 | “closed”·state.···This·would·be·analogous·to·an·API·call·that·starts·up | 520 | “closed”·state.···This·would·be·analogous·to·an·API·call·that·starts·up |
| 519 | a·database·connection,·inserts·the·row,·commits·and·closes.</p> | 521 | a·database·connection,·inserts·the·row,·commits·and·closes.</p> |
| 520 | </p></li> | 522 | </p></li> |
| 521 | <li><p><p><a·class="reference·external"·href="../_modules/examples/performance/__main__.html">__main__.py</a>·-·Allows·the·examples/performance·package·to·be·run·as·a·script.</p> | ||
| 522 | </p></li> | ||
| 523 | <li><p><p><a·class="reference·external"·href="../_modules/examples/performance/bulk_ | 523 | <li><p><p><a·class="reference·external"·href="../_modules/examples/performance/bulk_updates.html">bulk_updates.py</a>·-·This·series·of·tests·will·illustrate·different·ways·to·UPDATE·a·large·number |
| 524 | of·rows·in·bulk | 524 | of·rows·in·bulk·(under·construction!·there’s·just·one·test·at·the·moment)</p> |
| 525 | </p></li> | 525 | </p></li> |
| Max diff block lines reached; 17647/28416 bytes (62.10%) of diff not shown. | |||
| Offset 105, 36 lines modified | Offset 105, 36 lines modified | ||
| 105 | Listing·of·files: | 105 | Listing·of·files: |
| 106 | ····*·_\x8a_\x8d_\x8j_\x8a_\x8c_\x8e_\x8n_\x8c_\x8y_\x8__\x8l_\x8i_\x8s_\x8t_\x8._\x8p_\x8y | 106 | ····*·_\x8a_\x8d_\x8j_\x8a_\x8c_\x8e_\x8n_\x8c_\x8y_\x8__\x8l_\x8i_\x8s_\x8t_\x8._\x8p_\x8y |
| 107 | *\x8**\x8**\x8**\x8*·A\x8As\x8ss\x8so\x8oc\x8ci\x8ia\x8at\x8ti\x8io\x8on\x8ns\x8s_\x8?\x8¶·*\x8**\x8**\x8**\x8* | 107 | *\x8**\x8**\x8**\x8*·A\x8As\x8ss\x8so\x8oc\x8ci\x8ia\x8at\x8ti\x8io\x8on\x8ns\x8s_\x8?\x8¶·*\x8**\x8**\x8**\x8* |
| 108 | Examples·illustrating·the·usage·of·the·“association·object”·pattern,·where·an | 108 | Examples·illustrating·the·usage·of·the·“association·object”·pattern,·where·an |
| 109 | intermediary·class·mediates·the·relationship·between·two·classes·that·are | 109 | intermediary·class·mediates·the·relationship·between·two·classes·that·are |
| 110 | associated·in·a·many-to-many·pattern. | 110 | associated·in·a·many-to-many·pattern. |
| 111 | Listing·of·files: | 111 | Listing·of·files: |
| 112 | ····*·_\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 | ||
| 113 | ······“Order”·and·a·collection·of·“Item”·objects,·associating·a·purchase·price | ||
| 114 | ····· | 112 | ····*·_.d_.i_.c_.t_.__.o_.f_.__.s_.e_.t_.s_.__.w_.i_.t_.h_.__.d_.e_.f_.a_.u_.l_.t_.._.p_.y·-·An·advanced·association·proxy·example |
| 113 | ······which·illustrates·nesting·of·association·proxies·to·produce·multi-level | ||
| 114 | ······Python·collections,·in·this·case·a·dictionary·with·string·keys·and·sets | ||
| 115 | ······of·integers·as·values,·which·conceal·the·underlying·mapped·classes. | ||
| 115 | _\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 | 116 | _\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 |
| 116 | _\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 | 117 | _\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 |
| 117 | optional. | 118 | optional. |
| 119 | _\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 | ||
| 120 | “Order”·and·a·collection·of·“Item”·objects,·associating·a·purchase·price·with | ||
| 121 | each·via·an·association·object·called·“OrderItem” | ||
| 118 | _\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 | ||
| 119 | illustrates·nesting·of·association·proxies·to·produce·multi-level·Python | ||
| 120 | collections,·in·this·case·a·dictionary·with·string·keys·and·sets·of·integers·as | ||
| 121 | values,·which·conceal·the·underlying·mapped·classes. | ||
| 122 | *\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* | 122 | *\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* |
| 123 | Examples·illustrating·the·asyncio·engine·feature·of·SQLAlchemy. | 123 | Examples·illustrating·the·asyncio·engine·feature·of·SQLAlchemy. |
| 124 | Listing·of·files: | 124 | Listing·of·files: |
| 125 | ····*·_\x8g_\x8r_\x8e_\x8e_\x8n_\x8l_\x8e_\x8t_\x8__\x8o_\x8r_\x8m_\x8._\x8p_\x8y·-·Illustrates·use·of·the | 125 | ····*·_\x8g_\x8r_\x8e_\x8e_\x8n_\x8l_\x8e_\x8t_\x8__\x8o_\x8r_\x8m_\x8._\x8p_\x8y·-·Illustrates·use·of·the |
| 126 | ······sqlalchemy.ext.asyncio.AsyncSession·object·for·asynchronous·ORM·use, | 126 | ······sqlalchemy.ext.asyncio.AsyncSession·object·for·asynchronous·ORM·use, |
| 127 | ······including·the·optional·run_sync()·method. | 127 | ······including·the·optional·run_sync()·method. |
| 128 | _\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 | 128 | _\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 |
| 129 | using·asyncio.gather()·along·many·asyncio·database·connections,·merging·ORM | 129 | using·asyncio.gather()·along·many·asyncio·database·connections,·merging·ORM |
| 130 | results·into·a·single·AsyncSession. | 130 | results·into·a·single·AsyncSession. |
| 131 | _\x8b_\x8a_\x8s_\x8i_\x8c_\x8._\x8p_\x8y·-·Illustrates·the·asyncio·engine·/·connection·interface. | ||
| 131 | _\x8a_\x8s_\x8y_\x8n_\x8c_\x8__\x8o_\x8r_\x8m_\x8._\x8p_\x8y·-·Illustrates·use·of·the·sqlalchemy.ext.asyncio.AsyncSession | 132 | _\x8a_\x8s_\x8y_\x8n_\x8c_\x8__\x8o_\x8r_\x8m_\x8._\x8p_\x8y·-·Illustrates·use·of·the·sqlalchemy.ext.asyncio.AsyncSession |
| 132 | object·for·asynchronous·ORM·use. | 133 | object·for·asynchronous·ORM·use. |
| 133 | _\x8b_\x8a_\x8s_\x8i_\x8c_\x8._\x8p_\x8y·-·Illustrates·the·asyncio·engine·/·connection·interface. | ||
| 134 | *\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* | 134 | *\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* |
| 135 | An·example·of·persistence·for·a·directed·graph·structure.·The·graph·is·stored | 135 | An·example·of·persistence·for·a·directed·graph·structure.·The·graph·is·stored |
| 136 | as·a·collection·of·edges,·each·referencing·both·a·“lower”·and·an·“upper”·node | 136 | as·a·collection·of·edges,·each·referencing·both·a·“lower”·and·an·“upper”·node |
| 137 | in·a·table·of·nodes.·Basic·persistence·and·querying·for·lower-·and·upper- | 137 | in·a·table·of·nodes.·Basic·persistence·and·querying·for·lower-·and·upper- |
| 138 | neighbors·are·illustrated: | 138 | neighbors·are·illustrated: |
| 139 | n2·=·Node(2) | 139 | n2·=·Node(2) |
| 140 | n5·=·Node(5) | 140 | n5·=·Node(5) |
| Offset 156, 32 lines modified | Offset 156, 31 lines modified | ||
| 156 | Supplier,·both·subclassing·the·HasAddresses·mixin,·which·ensures·that·the | 156 | Supplier,·both·subclassing·the·HasAddresses·mixin,·which·ensures·that·the |
| 157 | parent·class·is·provided·with·an·addresses·collection·which·contains·Address | 157 | parent·class·is·provided·with·an·addresses·collection·which·contains·Address |
| 158 | objects. | 158 | objects. |
| 159 | The·_\x8d_\x8i_\x8s_\x8c_\x8r_\x8i_\x8m_\x8i_\x8n_\x8a_\x8t_\x8o_\x8r_\x8__\x8o_\x8n_\x8__\x8a_\x8s_\x8s_\x8o_\x8c_\x8i_\x8a_\x8t_\x8i_\x8o_\x8n_\x8._\x8p_\x8y·and·_\x8g_\x8e_\x8n_\x8e_\x8r_\x8i_\x8c_\x8__\x8f_\x8k_\x8._\x8p_\x8y·scripts·are·modernized | 159 | The·_\x8d_\x8i_\x8s_\x8c_\x8r_\x8i_\x8m_\x8i_\x8n_\x8a_\x8t_\x8o_\x8r_\x8__\x8o_\x8n_\x8__\x8a_\x8s_\x8s_\x8o_\x8c_\x8i_\x8a_\x8t_\x8i_\x8o_\x8n_\x8._\x8p_\x8y·and·_\x8g_\x8e_\x8n_\x8e_\x8r_\x8i_\x8c_\x8__\x8f_\x8k_\x8._\x8p_\x8y·scripts·are·modernized |
| 160 | versions·of·recipes·presented·in·the·2007·blog·post·_\x8P_\x8o_\x8l_\x8y_\x8m_\x8o_\x8r_\x8p_\x8h_\x8i_\x8c_\x8·_\x8A_\x8s_\x8s_\x8o_\x8c_\x8i_\x8a_\x8t_\x8i_\x8o_\x8n_\x8s | 160 | versions·of·recipes·presented·in·the·2007·blog·post·_\x8P_\x8o_\x8l_\x8y_\x8m_\x8o_\x8r_\x8p_\x8h_\x8i_\x8c_\x8·_\x8A_\x8s_\x8s_\x8o_\x8c_\x8i_\x8a_\x8t_\x8i_\x8o_\x8n_\x8s |
| 161 | _\x8w_\x8i_\x8t_\x8h_\x8·_\x8S_\x8Q_\x8L_\x8A_\x8l_\x8c_\x8h_\x8e_\x8m_\x8y. | 161 | _\x8w_\x8i_\x8t_\x8h_\x8·_\x8S_\x8Q_\x8L_\x8A_\x8l_\x8c_\x8h_\x8e_\x8m_\x8y. |
| 162 | Listing·of·files: | 162 | Listing·of·files: |
| 163 | ····*·_\x8g_\x8e_\x8n_\x8e_\x8r_\x8i_\x8c_\x8__\x8f_\x8k_\x8._\x8p_\x8y·-·Illustrates·a·so-called·“generic·foreign·key”,·in·a | ||
| 164 | ······similar·fashion·to·that·of·popular·frameworks·such·as·Django,·ROR,·etc. | ||
| 165 | ······This·approach·bypasses·standard·referential·integrity·practices,·in·that | ||
| 166 | ······the·“foreign·key”·column·is·not·actually·constrained·to·refer·to·any | ||
| 167 | ······particular·table;·instead,·in-application·logic·is·used·to·determine | ||
| 168 | ······which·table·is·referenced. | ||
| 169 | _\x8t_\x8a_\x8b_\x8l_\x8e_\x8__\x8p_\x8e_\x8r_\x8__\x8a_\x8s_\x8s_\x8o_\x8c_\x8i_\x8a_\x8t_\x8i_\x8o_\x8n_\x8._\x8p_\x8y·-·Illustrates·a·mixin·which·provides·a·generic | ||
| 170 | association·via·a·individually·generated·association·tables·for·each·parent | ||
| 171 | class.·The·associated·objects·themselves·are·persisted·in·a·single·table·shared | ||
| 172 | among·all·parents. | ||
| 173 | _\x8t_\x8a_\x8b_\x8l_\x8e_\x8__\x8p_\x8e_\x8r_\x8__\x8r_\x8e_\x8l_\x8a_\x8t_\x8e_\x8d_\x8._\x8p_\x8y·-·Illustrates·a·generic·association·which·persists | 163 | ····*·_\x8t_\x8a_\x8b_\x8l_\x8e_\x8__\x8p_\x8e_\x8r_\x8__\x8r_\x8e_\x8l_\x8a_\x8t_\x8e_\x8d_\x8._\x8p_\x8y·-·Illustrates·a·generic·association·which·persists |
| 174 | association·objects·within·individual·tables,·each·one·generated·to | 164 | ······association·objects·within·individual·tables,·each·one·generated·to |
| 175 | those·objects·on·behalf·of·a·particular·parent·class. | 165 | ······persist·those·objects·on·behalf·of·a·particular·parent·class. |
| 166 | _\x8g_\x8e_\x8n_\x8e_\x8r_\x8i_\x8c_\x8__\x8f_\x8k_\x8._\x8p_\x8y·-·Illustrates·a·so-called·“generic·foreign·key”,·in·a·similar | ||
| 167 | fashion·to·that·of·popular·frameworks·such·as·Django,·ROR,·etc.·This·approach | ||
| 168 | bypasses·standard·referential·integrity·practices,·in·that·the·“foreign·key” | ||
| 169 | column·is·not·actually·constrained·to·refer·to·any·particular·table;·instead, | ||
| 170 | in-application·logic·is·used·to·determine·which·table·is·referenced. | ||
| 176 | _\x8d_\x8i_\x8s_\x8c_\x8r_\x8i_\x8m_\x8i_\x8n_\x8a_\x8t_\x8o_\x8r_\x8__\x8o_\x8n_\x8__\x8a_\x8s_\x8s_\x8o_\x8c_\x8i_\x8a_\x8t_\x8i_\x8o_\x8n_\x8._\x8p_\x8y·-·Illustrates·a·mixin·which·provides·a·generic | 171 | _\x8d_\x8i_\x8s_\x8c_\x8r_\x8i_\x8m_\x8i_\x8n_\x8a_\x8t_\x8o_\x8r_\x8__\x8o_\x8n_\x8__\x8a_\x8s_\x8s_\x8o_\x8c_\x8i_\x8a_\x8t_\x8i_\x8o_\x8n_\x8._\x8p_\x8y·-·Illustrates·a·mixin·which·provides·a·generic |
| 177 | association·using·a·single·target·table·and·a·single·association·table, | 172 | association·using·a·single·target·table·and·a·single·association·table, |
| 178 | referred·to·by·all·parent·tables.·The·association·table·contains·a | 173 | referred·to·by·all·parent·tables.·The·association·table·contains·a |
| 179 | “discriminator”·column·which·determines·what·type·of·parent·object·associates | 174 | “discriminator”·column·which·determines·what·type·of·parent·object·associates |
| 180 | to·each·particular·row·in·the·association·table. | 175 | to·each·particular·row·in·the·association·table. |
| 176 | _\x8t_\x8a_\x8b_\x8l_\x8e_\x8__\x8p_\x8e_\x8r_\x8__\x8a_\x8s_\x8s_\x8o_\x8c_\x8i_\x8a_\x8t_\x8i_\x8o_\x8n_\x8._\x8p_\x8y·-·Illustrates·a·mixin·which·provides·a·generic | ||
| 177 | association·via·a·individually·generated·association·tables·for·each·parent | ||
| 178 | class.·The·associated·objects·themselves·are·persisted·in·a·single·table·shared | ||
| 179 | among·all·parents. | ||
| 181 | *\x8**\x8**\x8**\x8*·L\x8La\x8ar\x8rg\x8ge\x8e·C\x8Co\x8ol\x8ll\x8le\x8ec\x8ct\x8ti\x8io\x8on\x8ns\x8s_\x8?\x8¶·*\x8**\x8**\x8**\x8* | 180 | *\x8**\x8**\x8**\x8*·L\x8La\x8ar\x8rg\x8ge\x8e·C\x8Co\x8ol\x8ll\x8le\x8ec\x8ct\x8ti\x8io\x8on\x8ns\x8s_\x8?\x8¶·*\x8**\x8**\x8**\x8* |
| 182 | Large·collection·example. | 181 | Large·collection·example. |
| 183 | Illustrates·the·options·to·use·with·_\x8r_\x8e_\x8l_\x8a_\x8t_\x8i_\x8o_\x8n_\x8s_\x8h_\x8i_\x8p_\x8(_\x8)·when·the·list·of·related | 182 | Illustrates·the·options·to·use·with·_\x8r_\x8e_\x8l_\x8a_\x8t_\x8i_\x8o_\x8n_\x8s_\x8h_\x8i_\x8p_\x8(_\x8)·when·the·list·of·related |
| 184 | objects·is·very·large,·including: | 183 | objects·is·very·large,·including: |
| 185 | ····*·“dynamic”·relationships·which·query·slices·of·data·as·accessed | 184 | ····*·“dynamic”·relationships·which·query·slices·of·data·as·accessed |
| 186 | ····*·how·to·use·ON·DELETE·CASCADE·in·conjunction·with·passive_deletes=True·to | 185 | ····*·how·to·use·ON·DELETE·CASCADE·in·conjunction·with·passive_deletes=True·to |
| 187 | ······greatly·improve·the·performance·of·related·collection·deletion. | 186 | ······greatly·improve·the·performance·of·related·collection·deletion. |
| Offset 240, 26 lines modified | Offset 239, 26 lines modified | ||
| 240 | ····--profile·--num·1000 | 239 | ····--profile·--num·1000 |
| 241 | See·also | 240 | See·also |
| 242 | _\x8H_\x8o_\x8w_\x8·_\x8c_\x8a_\x8n_\x8·_\x8I_\x8·_\x8p_\x8r_\x8o_\x8f_\x8i_\x8l_\x8e_\x8·_\x8a_\x8·_\x8S_\x8Q_\x8L_\x8A_\x8l_\x8c_\x8h_\x8e_\x8m_\x8y_\x8·_\x8p_\x8o_\x8w_\x8e_\x8r_\x8e_\x8d_\x8·_\x8a_\x8p_\x8p_\x8l_\x8i_\x8c_\x8a_\x8t_\x8i_\x8o_\x8n_\x8? | 241 | _\x8H_\x8o_\x8w_\x8·_\x8c_\x8a_\x8n_\x8·_\x8I_\x8·_\x8p_\x8r_\x8o_\x8f_\x8i_\x8l_\x8e_\x8·_\x8a_\x8·_\x8S_\x8Q_\x8L_\x8A_\x8l_\x8c_\x8h_\x8e_\x8m_\x8y_\x8·_\x8p_\x8o_\x8w_\x8e_\x8r_\x8e_\x8d_\x8·_\x8a_\x8p_\x8p_\x8l_\x8i_\x8c_\x8a_\x8t_\x8i_\x8o_\x8n_\x8? |
| 243 | *\x8**\x8**\x8*·F\x8Fi\x8il\x8le\x8e·L\x8Li\x8is\x8st\x8ti\x8in\x8ng\x8g_\x8?\x8¶·*\x8**\x8**\x8* | 242 | *\x8**\x8**\x8*·F\x8Fi\x8il\x8le\x8e·L\x8Li\x8is\x8st\x8ti\x8in\x8ng\x8g_\x8?\x8¶·*\x8**\x8**\x8* |
| 244 | Listing·of·files: | 243 | Listing·of·files: |
| 245 | ····*·_\x8l_\x8a_\x8r_\x8g_\x8e_\x8__\x8r_\x8e_\x8s_\x8u_\x8l_\x8t_\x8s_\x8e_\x8t_\x8s_\x8._\x8p_\x8y·-·In·this·series·of·tests,·we·are·looking·at·time·to | 244 | ····*·_\x8l_\x8a_\x8r_\x8g_\x8e_\x8__\x8r_\x8e_\x8s_\x8u_\x8l_\x8t_\x8s_\x8e_\x8t_\x8s_\x8._\x8p_\x8y·-·In·this·series·of·tests,·we·are·looking·at·time·to |
| 246 | ······load·a·large·number·of·very·small·and·simple·rows. | 245 | ······load·a·large·number·of·very·small·and·simple·rows. |
| 247 | _\x8b_\x8u_\x8l_\x8k_\x8__\x8 | 246 | _\x8b_\x8u_\x8l_\x8k_\x8__\x8i_.n_.s_.e_.r_.t_.s_.._.p_.y·-·This·series·of·tests·illustrates·different·ways·to·INSERT·a |
| 247 | large·number·of·rows·in·bulk. | ||
| 248 | a·large·number·of·rows·in·bulk·(under·construction!·there’s·just·one·test·at | ||
| 249 | the·moment) | ||
| 250 | _\x8s_\x8h_\x8o_\x8r_\x8t_\x8__\x8s_\x8e_\x8l_\x8e_\x8c_\x8t_\x8s_\x8._\x8p_\x8y·-·This·series·of·tests·illustrates·different·ways·to·SELECT·a | 248 | _\x8s_\x8h_\x8o_\x8r_\x8t_\x8__\x8s_\x8e_\x8l_\x8e_\x8c_\x8t_\x8s_\x8._\x8p_\x8y·-·This·series·of·tests·illustrates·different·ways·to·SELECT·a |
| 251 | single·record·by·primary·key | 249 | single·record·by·primary·key |
| 250 | _\x8__\x8__\x8m_\x8a_\x8i_\x8n_\x8__\x8__\x8._\x8p_\x8y·-·Allows·the·examples/performance·package·to·be·run·as·a·script. | ||
| 252 | _\x8s_\x8i_\x8n_\x8g_\x8l_\x8e_\x8__\x8i_\x8n_\x8s_\x8e_\x8r_\x8t_\x8s_\x8._\x8p_\x8y·-·In·this·series·of·tests,·we’re·looking·at·a·method·that | 251 | _\x8s_\x8i_\x8n_\x8g_\x8l_\x8e_\x8__\x8i_\x8n_\x8s_\x8e_\x8r_\x8t_\x8s_\x8._\x8p_\x8y·-·In·this·series·of·tests,·we’re·looking·at·a·method·that |
| 253 | inserts·a·row·within·a·distinct·transaction,·and·afterwards·returns·to | 252 | inserts·a·row·within·a·distinct·transaction,·and·afterwards·returns·to |
| 254 | essentially·a·“closed”·state.·This·would·be·analogous·to·an·API·call·that | 253 | essentially·a·“closed”·state.·This·would·be·analogous·to·an·API·call·that |
| 255 | starts·up·a·database·connection,·inserts·the·row,·commits·and·closes. | 254 | starts·up·a·database·connection,·inserts·the·row,·commits·and·closes. |
| 256 | _\x8__\x8__\x8m_\x8a_\x8i_\x8n_\x8__\x8__\x8._\x8p_\x8y·-·Allows·the·examples/performance·package·to·be·run·as·a·script. | ||
| 257 | _\x8b_\x8u_\x8l_\x8k_\x8__\x8 | 255 | _\x8b_\x8u_\x8l_\x8k_\x8__\x8u_.p_.d_.a_.t_.e_.s_.._.p_.y·-·This·series·of·tests·will·illustrate·different·ways·to·UPDATE |
| 258 | large·number·of·rows·in·bulk | 256 | a·large·number·of·rows·in·bulk·(under·construction!·there’s·just·one·test·at |
| 257 | the·moment) | ||
| 259 | *\x8**\x8**\x8*·R\x8Ru\x8un\x8nn\x8ni\x8in\x8ng\x8g·a\x8al\x8ll\x8l·t\x8te\x8es\x8st\x8ts\x8s·w\x8wi\x8it\x8th\x8h·t\x8ti\x8im\x8me\x8e_\x8?\x8¶·*\x8**\x8**\x8* | 258 | *\x8**\x8**\x8*·R\x8Ru\x8un\x8nn\x8ni\x8in\x8ng\x8g·a\x8al\x8ll\x8l·t\x8te\x8es\x8st\x8ts\x8s·w\x8wi\x8it\x8th\x8h·t\x8ti\x8im\x8me\x8e_\x8?\x8¶·*\x8**\x8**\x8* |
| 260 | This·is·the·default·form·of·run: | 259 | This·is·the·default·form·of·run: |
| 261 | $·python·-m·examples.performance·single_inserts | 260 | $·python·-m·examples.performance·single_inserts |
| 262 | Tests·to·run:·test_orm_commit,·test_bulk_save, | 261 | Tests·to·run:·test_orm_commit,·test_bulk_save, |
| 263 | ··············test_bulk_insert_dictionaries,·test_core, | 262 | ··············test_bulk_insert_dictionaries,·test_core, |
| 264 | ··············test_core_query_caching,·test_dbapi_raw_w_connect, | 263 | ··············test_core_query_caching,·test_dbapi_raw_w_connect, |
| 265 | ··············test_dbapi_raw_w_pool | 264 | ··············test_dbapi_raw_w_pool |
| Offset 396, 20 lines modified | Offset 395, 20 lines modified | ||
| 396 | total·time·2.754592·sec | 395 | total·time·2.754592·sec |
| 397 | test_subqueryload·:·load·everything,·subquery·eager·loading.·(1000·iterations); | 396 | test_subqueryload·:·load·everything,·subquery·eager·loading.·(1000·iterations); |
| 398 | total·time·2.977696·sec | 397 | total·time·2.977696·sec |
| 399 | *\x8**\x8**\x8**\x8*·R\x8Re\x8el\x8la\x8at\x8ti\x8io\x8on\x8ns\x8sh\x8hi\x8ip\x8p·J\x8Jo\x8oi\x8in\x8n·C\x8Co\x8on\x8nd\x8di\x8it\x8ti\x8io\x8on\x8ns\x8s_\x8?\x8¶·*\x8**\x8**\x8**\x8* | 398 | *\x8**\x8**\x8**\x8*·R\x8Re\x8el\x8la\x8at\x8ti\x8io\x8on\x8ns\x8sh\x8hi\x8ip\x8p·J\x8Jo\x8oi\x8in\x8n·C\x8Co\x8on\x8nd\x8di\x8it\x8ti\x8io\x8on\x8ns\x8s_\x8?\x8¶·*\x8**\x8**\x8**\x8* |
| 400 | Examples·of·various·_\x8r_\x8e_\x8l_\x8a_\x8t_\x8i_\x8o_\x8n_\x8s_\x8h_\x8i_\x8p_\x8(_\x8)·configurations,·which·make·use·of·the | 399 | Examples·of·various·_\x8r_\x8e_\x8l_\x8a_\x8t_\x8i_\x8o_\x8n_\x8s_\x8h_\x8i_\x8p_\x8(_\x8)·configurations,·which·make·use·of·the |
| 401 | primaryjoin·argument·to·compose·special·types·of·join·conditions. | 400 | primaryjoin·argument·to·compose·special·types·of·join·conditions. |
| 402 | Listing·of·files: | 401 | Listing·of·files: |
| 402 | ····*·_\x8t_\x8h_\x8r_\x8e_\x8e_\x8w_\x8a_\x8y_\x8._\x8p_\x8y·-·Illustrate·a·“three·way·join”·-·where·a·primary·table·joins | ||
| 403 | ······to·a·remote·table·via·an·association·table,·but·then·the·primary·table | ||
| 404 | ······also·needs·to·refer·to·some·columns·in·the·remote·table·directly. | ||
| 403 | 405 | _\x8c_\x8a_\x8s_\x8t_\x8._\x8p_\x8y·-·Illustrate·a·_\x8r_\x8e_\x8l_\x8a_\x8t_\x8i_\x8o_\x8n_\x8s_\x8h_\x8i_\x8p_\x8(_\x8)·that·joins·two·columns·where·those | |
| Max diff block lines reached; 10882/21096 bytes (51.58%) of diff not shown. | |||
| Offset 8521, 20 lines modified | Offset 8521, 20 lines modified | ||
| 8521 | ········"3414":·[13,·25], | 8521 | ········"3414":·[13,·25], |
| 8522 | ········"alchemy2":·13, | 8522 | ········"alchemy2":·13, |
| 8523 | ········"4644":·13, | 8523 | ········"4644":·13, |
| 8524 | ········"5649":·13, | 8524 | ········"5649":·13, |
| 8525 | ········"get_sequence_nam":·[13,·48,·52], | 8525 | ········"get_sequence_nam":·[13,·48,·52], |
| 8526 | ········"2056":·13, | 8526 | ········"2056":·13, |
| 8527 | ········"4755":·13, | 8527 | ········"4755":·13, |
| 8528 | ········"4524":·13, | ||
| 8529 | ········"upfront":·13, | 8528 | ········"upfront":·13, |
| 8530 | ········"returns_unicode_str":·[13,·48], | 8529 | ········"returns_unicode_str":·[13,·48], |
| 8531 | ········"returns_condit":·[13,·59], | 8530 | ········"returns_condit":·[13,·59], |
| 8532 | ········"returns_byt":·[13,·59], | 8531 | ········"returns_byt":·[13,·59], |
| 8533 | ········"5315":·13, | 8532 | ········"5315":·13, |
| 8533 | ········"4524":·13, | ||
| 8534 | ········"hundr":·[13,·21,·24,·25,·31,·76,·136,·137,·155], | 8534 | ········"hundr":·[13,·21,·24,·25,·31,·76,·136,·137,·155], |
| 8535 | ········"4645":·[13,·25], | 8535 | ········"4645":·[13,·25], |
| 8536 | ········"4808":·[13,·25], | 8536 | ········"4808":·[13,·25], |
| 8537 | ········"5004":·[13,·25], | 8537 | ········"5004":·[13,·25], |
| 8538 | ········"har":·[13,·25], | 8538 | ········"har":·[13,·25], |
| 8539 | ········"4712":·13, | 8539 | ········"4712":·13, |
| 8540 | ········"5526":·[13,·25], | 8540 | ········"5526":·[13,·25], |
| Offset 12459, 29 lines modified | Offset 12459, 29 lines modified | ||
| 12459 | ········"receive_class_uninstru":·97, | 12459 | ········"receive_class_uninstru":·97, |
| 12460 | ········"rootnod":·98, | 12460 | ········"rootnod":·98, |
| 12461 | ········"node1":·98, | 12461 | ········"node1":·98, |
| 12462 | ········"node3":·98, | 12462 | ········"node3":·98, |
| 12463 | ········"dump_tre":·98, | 12463 | ········"dump_tre":·98, |
| 12464 | ········"adjacency_list":·98, | 12464 | ········"adjacency_list":·98, |
| 12465 | ········"basic_associ":·98, | 12465 | ········"basic_associ":·98, |
| 12466 | ········"purchas":·98, | ||
| 12467 | ········"orderitem":·98, | 12466 | ········"orderitem":·98, |
| 12467 | ········"purchas":·98, | ||
| 12468 | ········"gather_orm_stat":·98, | 12468 | ········"gather_orm_stat":·98, |
| 12469 | ········"async_orm":·98, | 12469 | ········"async_orm":·98, |
| 12470 | ········"neighbor":·98, | 12470 | ········"neighbor":·98, |
| 12471 | ········"n5":·98, | 12471 | ········"n5":·98, |
| 12472 | ········"add_neighbor":·98, | 12472 | ········"add_neighbor":·98, |
| 12473 | ········"higher_neighbor":·98, | 12473 | ········"higher_neighbor":·98, |
| 12474 | ········"directed_graph":·98, | 12474 | ········"directed_graph":·98, |
| 12475 | ········"supplier":·98, | 12475 | ········"supplier":·98, |
| 12476 | ········"hasaddress":·98, | 12476 | ········"hasaddress":·98, |
| 12477 | ········"generic_fk":·98, | 12477 | ········"generic_fk":·98, |
| 12478 | ········"table_per_rel":·98, | ||
| 12478 | ········"ror":·98, | 12479 | ········"ror":·98, |
| 12479 | ········"table_per_associ":·98, | 12480 | ········"table_per_associ":·98, |
| 12480 | ········"table_per_rel":·98, | ||
| 12481 | ········"materialized_path":·98, | 12481 | ········"materialized_path":·98, |
| 12482 | ········"nested_set":·98, | 12482 | ········"nested_set":·98, |
| 12483 | ········"single_insert":·98, | 12483 | ········"single_insert":·98, |
| 12484 | ········"bulk_upd":·98, | 12484 | ········"bulk_upd":·98, |
| 12485 | ········"test_orm_commit":·98, | 12485 | ········"test_orm_commit":·98, |
| 12486 | ········"test_bulk_insert_dictionari":·98, | 12486 | ········"test_bulk_insert_dictionari":·98, |
| 12487 | ········"test_cor":·98, | 12487 | ········"test_cor":·98, |
| Offset 12536, 34 lines modified | Offset 12536, 34 lines modified | ||
| 12536 | ········"sc1":·98, | 12536 | ········"sc1":·98, |
| 12537 | ········"sc1modifi":·98, | 12537 | ········"sc1modifi":·98, |
| 12538 | ········"someclasshistori":·98, | 12538 | ········"someclasshistori":·98, |
| 12539 | ········"__history_mapper__":·98, | 12539 | ········"__history_mapper__":·98, |
| 12540 | ········"_history_mapp":·98, | 12540 | ········"_history_mapp":·98, |
| 12541 | ········"somehistoryclass":·98, | 12541 | ········"somehistoryclass":·98, |
| 12542 | ········"use_mapper_vers":·98, | 12542 | ········"use_mapper_vers":·98, |
| 12543 | ········"versioned_rows_w_versionid":·98, | ||
| 12544 | ········"versioned_update_old_row":·98, | ||
| 12545 | ········"versioned_map":·98, | 12543 | ········"versioned_map":·98, |
| 12544 | ········"versioned_update_old_row":·98, | ||
| 12545 | ········"versioned_rows_w_versionid":·98, | ||
| 12546 | ········"breviti":·98, | 12546 | ········"breviti":·98, |
| 12547 | ········"shrew":·98, | 12547 | ········"shrew":·98, |
| 12548 | ········"anim":·98, | 12548 | ········"anim":·98, |
| 12549 | ········"cute":·98, | 12549 | ········"cute":·98, |
| 12550 | ········"weasel":·98, | 12550 | ········"weasel":·98, |
| 12551 | ········"poison":·98, | 12551 | ········"poison":·98, |
| 12552 | ········"animalfact":·98, | 12552 | ········"animalfact":·98, |
| 12553 | ········"custom_manag":·98, | 12553 | ········"custom_manag":·98, |
| 12554 | ········"weather":·98, | 12554 | ········"weather":·98, |
| 12555 | ········"contin":·98, | 12555 | ········"contin":·98, |
| 12556 | ········"spoken":·98, | 12556 | ········"spoken":·98, |
| 12557 | ········"separate_databas":·98, | ||
| 12558 | ········"separate_schema_transl":·98, | 12557 | ········"separate_schema_transl":·98, |
| 12559 | ········"schema_translates_map":·98, | 12558 | ········"schema_translates_map":·98, |
| 12560 | ········"separate_t":·98, | 12559 | ········"separate_t":·98, |
| 12561 | ········" | 12560 | ········"separate_databas":·98, |
| 12562 | ········"temporal_rang":·98, | 12561 | ········"temporal_rang":·98, |
| 12562 | ········"filter_publ":·98, | ||
| 12563 | ········"demo":·98, | 12563 | ········"demo":·98, |
| 12564 | ········"datafil":·98, | 12564 | ········"datafil":·98, |
| 12565 | ········"helloworld":·98, | 12565 | ········"helloworld":·98, |
| 12566 | ········"local_session_cach":·98, | 12566 | ········"local_session_cach":·98, |
| 12567 | ········"datamodel":·98, | 12567 | ········"datamodel":·98, |
| 12568 | ········"postalcod":·98, | 12568 | ········"postalcod":·98, |
| 12569 | ········"citi":·[98,·124,·133], | 12569 | ········"citi":·[98,·124,·133], |
| Offset 1, 14 lines modified | Offset 1, 14 lines modified | ||
| 1 | ··Streams:···········1 | 1 | ··Streams:···········1 |
| 2 | ··Blocks:············2 | 2 | ··Blocks:············2 |
| 3 | ··Compressed·size:···3619. | 3 | ··Compressed·size:···3619.7·KiB·(3706560·B) |
| 4 | ··Uncompressed·size:·36.3·MiB·(38051840·B) | 4 | ··Uncompressed·size:·36.3·MiB·(38051840·B) |
| 5 | ··Ratio:·············0.097 | 5 | ··Ratio:·············0.097 |
| 6 | ··Check:·············CRC64 | 6 | ··Check:·············CRC64 |
| 7 | ··Stream·Padding:····0·B | 7 | ··Stream·Padding:····0·B |
| 8 | ··Streams: | 8 | ··Streams: |
| 9 | ····Stream····Blocks······CompOffset····UncompOffset········CompSize······UncompSize··Ratio··Check······Padding | 9 | ····Stream····Blocks······CompOffset····UncompOffset········CompSize······UncompSize··Ratio··Check······Padding |
| 10 | ·········1·········2···············0···············0·········3706 | 10 | ·········1·········2···············0···············0·········3706560········38051840··0.097··CRC64············0 |
| 11 | ··Blocks: | 11 | ··Blocks: |
| 12 | ····Stream·····Block······CompOffset····UncompOffset·······TotalSize······UncompSize··Ratio··Check | 12 | ····Stream·····Block······CompOffset····UncompOffset·······TotalSize······UncompSize··Ratio··Check |
| 13 | ·········1·········1··············12···············0·········2076 | 13 | ·········1·········1··············12···············0·········2076520········25165824··0.083··CRC64 |
| 14 | ·········1·········2·········2076 | 14 | ·········1·········2·········2076532········25165824·········1629996········12886016··0.126··CRC64 |