| | | | |
| Offset 109, 24 lines modified | Offset 109, 24 lines modified |
| 109 | optional. | 109 | optional. |
| 110 | _\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 | 110 | _\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 |
| 111 | “Order”·and·a·collection·of·“Item”·objects,·associating·a·purchase·price·with | 111 | “Order”·and·a·collection·of·“Item”·objects,·associating·a·purchase·price·with |
| 112 | each·via·an·association·object·called·“OrderItem” | 112 | each·via·an·association·object·called·“OrderItem” |
| 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 | ····*·_\x8a_\x8s_\x8y_\x8n_\x8c_\x8__\x8o_\x8r_\x8m_\x8._\x8p_\x8y·-·Illustrates·use·of·the·sqlalchemy.ext.asyncio.AsyncSession | |
| 117 | ······object·for·asynchronous·ORM·use. | |
| 118 | _\x8g_\x8r_\x8e_\x8e_\x8n_\x8l_\x8e_\x8t_\x8__\x8o_\x8r_\x8m_\x8._\x8p_\x8y·-·Illustrates·use·of·the·sqlalchemy.ext.asyncio.AsyncSession | |
| 119 | object·for·asynchronous·ORM·use,·including·the·optional·run_sync()·method. | |
| 120 | _\x8b_\x8a_\x8s_\x8i_\x8c_\x8._\x8p_\x8y·-·Illustrates·the·asyncio·engine·/·connection·interface. | |
| 121 | _.a_.s_.y_.n_.c_.__.o_.r_.m_.__.w_.r_.i_.t_.e_.o_.n_.l_.y_.._.p_.y·-·Illustrates·using·w.wr.ri.it.te.e·o.on.nl.ly.y·r.re.el.la.at.ti.io.on.ns.sh.hi.ip.ps.s·for·simpler | 116 | ····*·_.a_.s_.y_.n_.c_.__.o_.r_.m_.__.w_.r_.i_.t_.e_.o_.n_.l_.y_.._.p_.y·-·Illustrates·using·w.wr.ri.it.te.e·o.on.nl.ly.y·r.re.el.la.at.ti.io.on.ns.sh.hi.ip.ps.s·for |
| 122 | handling·of·ORM·collections·under·asyncio. | 117 | ······simpler·handling·of·ORM·collections·under·asyncio. |
| 123 | _\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 | 118 | _\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 |
| 124 | using·asyncio.gather()·along·many·asyncio·database·connections,·merging·ORM | 119 | using·asyncio.gather()·along·many·asyncio·database·connections,·merging·ORM |
| 125 | results·into·a·single·AsyncSession. | 120 | results·into·a·single·AsyncSession. |
| | 121 | _\x8g_\x8r_\x8e_\x8e_\x8n_\x8l_\x8e_\x8t_\x8__\x8o_\x8r_\x8m_\x8._\x8p_\x8y·-·Illustrates·use·of·the·sqlalchemy.ext.asyncio.AsyncSession |
| | 122 | object·for·asynchronous·ORM·use,·including·the·optional·run_sync()·method. |
| | 123 | _\x8a_\x8s_\x8y_\x8n_\x8c_\x8__\x8o_\x8r_\x8m_\x8._\x8p_\x8y·-·Illustrates·use·of·the·sqlalchemy.ext.asyncio.AsyncSession |
| | 124 | object·for·asynchronous·ORM·use. |
| | 125 | _\x8b_\x8a_\x8s_\x8i_\x8c_\x8._\x8p_\x8y·-·Illustrates·the·asyncio·engine·/·connection·interface. |
| 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* | 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* |
| 127 | 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 |
| 128 | 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 |
| 129 | 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- |
| 130 | neighbors·are·illustrated: | 130 | neighbors·are·illustrated: |
| 131 | n2·=·Node(2) | 131 | n2·=·Node(2) |
| 132 | n5·=·Node(5) | 132 | n5·=·Node(5) |
| Offset 148, 32 lines modified | Offset 148, 31 lines modified |
| 148 | Supplier,·both·subclassing·the·HasAddresses·mixin,·which·ensures·that·the | 148 | Supplier,·both·subclassing·the·HasAddresses·mixin,·which·ensures·that·the |
| 149 | parent·class·is·provided·with·an·addresses·collection·which·contains·Address | 149 | parent·class·is·provided·with·an·addresses·collection·which·contains·Address |
| 150 | objects. | 150 | objects. |
| 151 | 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 | 151 | 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 |
| 152 | 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 | 152 | 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 |
| 153 | _\x8w_\x8i_\x8t_\x8h_\x8·_\x8S_\x8Q_\x8L_\x8A_\x8l_\x8c_\x8h_\x8e_\x8m_\x8y. | 153 | _\x8w_\x8i_\x8t_\x8h_\x8·_\x8S_\x8Q_\x8L_\x8A_\x8l_\x8c_\x8h_\x8e_\x8m_\x8y. |
| 154 | Listing·of·files: | 154 | Listing·of·files: |
| 155 | ····*·_\x8g_\x8e_\x8n_\x8e_\x8r_\x8i_\x8c_\x8__\x8f_\x8k_\x8._\x8p_\x8y·-·Illustrates·a·so-called·“generic·foreign·key”,·in·a | |
| 156 | ······similar·fashion·to·that·of·popular·frameworks·such·as·Django,·ROR,·etc. | |
| 157 | ······This·approach·bypasses·standard·referential·integrity·practices,·in·that | |
| 158 | ······the·“foreign·key”·column·is·not·actually·constrained·to·refer·to·any | |
| 159 | ······particular·table;·instead,·in-application·logic·is·used·to·determine | |
| 160 | ······which·table·is·referenced. | |
| 161 | _\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 | 155 | ····*·_\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 |
| 162 | association·via·a·individually·generated·association·tables·for·each·parent | 156 | ······association·via·a·individually·generated·association·tables·for·each |
| 163 | class.·The·associated·objects·themselves·are·persisted·in·a·single·table·shared | 157 | ······parent·class.·The·associated·objects·themselves·are·persisted·in·a·single |
| 164 | among·all·parents. | |
| 165 | _\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 | |
| 166 | association·objects·within·individual·tables,·each·one·generated·to·persist | |
| 167 | those·objects·on·behalf·of·a·particular·parent·class. | 158 | ······table·shared·among·all·parents. |
| | 159 | _\x8g_\x8e_\x8n_\x8e_\x8r_\x8i_\x8c_\x8__\x8f_\x8k_\x8._\x8p_\x8y·-·Illustrates·a·so-called·“generic·foreign·key”,·in·a·similar |
| | 160 | fashion·to·that·of·popular·frameworks·such·as·Django,·ROR,·etc.·This·approach |
| | 161 | bypasses·standard·referential·integrity·practices,·in·that·the·“foreign·key” |
| | 162 | column·is·not·actually·constrained·to·refer·to·any·particular·table;·instead, |
| | 163 | in-application·logic·is·used·to·determine·which·table·is·referenced. |
| 168 | _\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 | 164 | _\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 |
| 169 | association·using·a·single·target·table·and·a·single·association·table, | 165 | association·using·a·single·target·table·and·a·single·association·table, |
| 170 | referred·to·by·all·parent·tables.·The·association·table·contains·a | 166 | referred·to·by·all·parent·tables.·The·association·table·contains·a |
| 171 | “discriminator”·column·which·determines·what·type·of·parent·object·associates | 167 | “discriminator”·column·which·determines·what·type·of·parent·object·associates |
| 172 | to·each·particular·row·in·the·association·table. | 168 | to·each·particular·row·in·the·association·table. |
| | 169 | _\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 |
| | 170 | association·objects·within·individual·tables,·each·one·generated·to·persist |
| | 171 | those·objects·on·behalf·of·a·particular·parent·class. |
| 173 | *\x8**\x8**\x8**\x8*·M\x8Ma\x8at\x8te\x8er\x8ri\x8ia\x8al\x8li\x8iz\x8ze\x8ed\x8d·P\x8Pa\x8at\x8th\x8hs\x8s_\x8?\x8¶·*\x8**\x8**\x8**\x8* | 172 | *\x8**\x8**\x8**\x8*·M\x8Ma\x8at\x8te\x8er\x8ri\x8ia\x8al\x8li\x8iz\x8ze\x8ed\x8d·P\x8Pa\x8at\x8th\x8hs\x8s_\x8?\x8¶·*\x8**\x8**\x8**\x8* |
| 174 | Illustrates·the·“materialized·paths”·pattern·for·hierarchical·data·using·the | 173 | Illustrates·the·“materialized·paths”·pattern·for·hierarchical·data·using·the |
| 175 | SQLAlchemy·ORM. | 174 | SQLAlchemy·ORM. |
| 176 | Listing·of·files: | 175 | Listing·of·files: |
| 177 | ····*·_\x8m_\x8a_\x8t_\x8e_\x8r_\x8i_\x8a_\x8l_\x8i_\x8z_\x8e_\x8d_\x8__\x8p_\x8a_\x8t_\x8h_\x8s_\x8._\x8p_\x8y·-·Illustrates·the·“materialized·paths”·pattern. | 176 | ····*·_\x8m_\x8a_\x8t_\x8e_\x8r_\x8i_\x8a_\x8l_\x8i_\x8z_\x8e_\x8d_\x8__\x8p_\x8a_\x8t_\x8h_\x8s_\x8._\x8p_\x8y·-·Illustrates·the·“materialized·paths”·pattern. |
| 178 | *\x8**\x8**\x8**\x8*·N\x8Ne\x8es\x8st\x8te\x8ed\x8d·S\x8Se\x8et\x8ts\x8s_\x8?\x8¶·*\x8**\x8**\x8**\x8* | 177 | *\x8**\x8**\x8**\x8*·N\x8Ne\x8es\x8st\x8te\x8ed\x8d·S\x8Se\x8et\x8ts\x8s_\x8?\x8¶·*\x8**\x8**\x8**\x8* |
| 179 | Illustrates·a·rudimentary·way·to·implement·the·“nested·sets”·pattern·for | 178 | Illustrates·a·rudimentary·way·to·implement·the·“nested·sets”·pattern·for |
| Offset 221, 28 lines modified | Offset 220, 28 lines modified |
| 221 | $·python·-m·examples.performance·bulk_inserts·\ | 220 | $·python·-m·examples.performance·bulk_inserts·\ |
| 222 | ····--dburl·mysql+mysqldb://scott:tiger@localhost/test·\ | 221 | ····--dburl·mysql+mysqldb://scott:tiger@localhost/test·\ |
| 223 | ····--profile·--num·1000 | 222 | ····--profile·--num·1000 |
| 224 | See·also | 223 | See·also |
| 225 | _\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? | 224 | _\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? |
| 226 | *\x8**\x8**\x8*·F\x8Fi\x8il\x8le\x8e·L\x8Li\x8is\x8st\x8ti\x8in\x8ng\x8g_\x8?\x8¶·*\x8**\x8**\x8* | 225 | *\x8**\x8**\x8*·F\x8Fi\x8il\x8le\x8e·L\x8Li\x8is\x8st\x8ti\x8in\x8ng\x8g_\x8?\x8¶·*\x8**\x8**\x8* |
| 227 | Listing·of·files: | 226 | Listing·of·files: |
| 228 | ····*·_\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 | |
| 229 | ······load·a·large·number·of·very·small·and·simple·rows. | 227 | ····*·_.s_.h_.o_.r_.t_.__.s_.e_.l_.e_.c_.t_.s_.._.p_.y·-·This·series·of·tests·illustrates·different·ways·to |
| | 228 | ······SELECT·a·single·record·by·primary·key |
| | 229 | _\x8__\x8__\x8m_\x8a_\x8i_\x8n_\x8__\x8__\x8._\x8p_\x8y·-·Allows·the·examples/performance·package·to·be·run·as·a·script. |
| 230 | _\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 | 230 | _\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 |
| 231 | inserts·a·row·within·a·distinct·transaction,·and·afterwards·returns·to | 231 | inserts·a·row·within·a·distinct·transaction,·and·afterwards·returns·to |
| 232 | essentially·a·“closed”·state.·This·would·be·analogous·to·an·API·call·that | 232 | essentially·a·“closed”·state.·This·would·be·analogous·to·an·API·call·that |
| 233 | starts·up·a·database·connection,·inserts·the·row,·commits·and·closes. | 233 | starts·up·a·database·connection,·inserts·the·row,·commits·and·closes. |
| 234 | _\x8s_.h_.o_.r_.t_.__.s_.e_.l_.e_.c_.t_.s_.._.p_.y·-·This·series·of·tests·illustrates·different·ways·to·SELECT·a | 234 | _\x8b_.u_.l_.k_.__.i_.n_.s_.e_.r_.t_.s_.._.p_.y·-·This·series·of·tests·illustrates·different·ways·to·INSERT·a |
| 235 | single·record·by·primary·key | |
| 236 | _.__.__.m_.a_.i_.n_.__.__.._.p_.y·-·Allows·the·examples/performance·package·to·be·run·as·a·script. | 235 | large·number·of·rows·in·bulk. |
| | 236 | _\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·load·a |
| | 237 | large·number·of·very·small·and·simple·rows. |
| 237 | _\x8b_\x8u_\x8l_\x8k_\x8__\x8u_\x8p_\x8d_\x8a_\x8t_\x8e_\x8s_\x8._\x8p_\x8y·-·This·series·of·tests·will·illustrate·different·ways·to·UPDATE | 238 | _\x8b_\x8u_\x8l_\x8k_\x8__\x8u_\x8p_\x8d_\x8a_\x8t_\x8e_\x8s_\x8._\x8p_\x8y·-·This·series·of·tests·will·illustrate·different·ways·to·UPDATE |
| 238 | a·large·number·of·rows·in·bulk·(under·construction!·there’s·just·one·test·at | 239 | a·large·number·of·rows·in·bulk·(under·construction!·there’s·just·one·test·at |
| 239 | the·moment) | 240 | the·moment) |
| 240 | _\x8b_\x8u_\x8l_\x8k_\x8__\x8i_\x8n_\x8s_\x8e_\x8r_\x8t_\x8s_\x8._\x8p_\x8y·-·This·series·of·tests·illustrates·different·ways·to·INSERT·a | |
| 241 | large·number·of·rows·in·bulk. | |
| 242 | *\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* | 241 | *\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* |
| 243 | This·is·the·default·form·of·run: | 242 | This·is·the·default·form·of·run: |
| 244 | $·python·-m·examples.performance·single_inserts | 243 | $·python·-m·examples.performance·single_inserts |
| 245 | Tests·to·run:·test_orm_commit,·test_bulk_save, | 244 | Tests·to·run:·test_orm_commit,·test_bulk_save, |
| 246 | ··············test_bulk_insert_dictionaries,·test_core, | 245 | ··············test_bulk_insert_dictionaries,·test_core, |
| 247 | ··············test_core_query_caching,·test_dbapi_raw_w_connect, | 246 | ··············test_core_query_caching,·test_dbapi_raw_w_connect, |
| 248 | ··············test_dbapi_raw_w_pool | 247 | ··············test_dbapi_raw_w_pool |
| Offset 468, 28 lines modified | Offset 467, 28 lines modified |
| 468 | Several·examples·that·illustrate·the·technique·of·intercepting·changes·that | 467 | Several·examples·that·illustrate·the·technique·of·intercepting·changes·that |
| 469 | would·be·first·interpreted·as·an·UPDATE·on·a·row,·and·instead·turning·it·into | 468 | would·be·first·interpreted·as·an·UPDATE·on·a·row,·and·instead·turning·it·into |
| 470 | an·INSERT·of·a·new·row,·leaving·the·previous·row·intact·as·a·historical | 469 | an·INSERT·of·a·new·row,·leaving·the·previous·row·intact·as·a·historical |
| 471 | version. | 470 | version. |
| 472 | Compare·to·the·_\x8V_\x8e_\x8r_\x8s_\x8i_\x8o_\x8n_\x8i_\x8n_\x8g_\x8·_\x8w_\x8i_\x8t_\x8h_\x8·_\x8a_\x8·_\x8H_\x8i_\x8s_\x8t_\x8o_\x8r_\x8y_\x8·_\x8T_\x8a_\x8b_\x8l_\x8e·example·which·writes·a·history | 471 | Compare·to·the·_\x8V_\x8e_\x8r_\x8s_\x8i_\x8o_\x8n_\x8i_\x8n_\x8g_\x8·_\x8w_\x8i_\x8t_\x8h_\x8·_\x8a_\x8·_\x8H_\x8i_\x8s_\x8t_\x8o_\x8r_\x8y_\x8·_\x8T_\x8a_\x8b_\x8l_\x8e·example·which·writes·a·history |
| 473 | row·to·a·separate·history·table. | 472 | row·to·a·separate·history·table. |
| 474 | Listing·of·files: | 473 | Listing·of·files: |
| 475 | ····*·_\x8v_\x8e_\x8r_\x8s_\x8i_\x8o_\x8n_\x8e_\x8d_\x8__\x8r_\x8o_\x8w_\x8s_\x8__\x8w_\x8__\x8v_\x8e_\x8r_\x8s_\x8i_\x8o_\x8n_\x8i_\x8d_\x8._\x8p_\x8y·-·Illustrates·a·method·to·intercept·changes | |
| 476 | ······on·objects,·turning·an·UPDATE·statement·on·a·single·row·into·an·INSERT | |
| 477 | ······statement,·so·that·a·new·row·is·inserted·with·the·new·data,·keeping·the | |
| 478 | ······old·row·intact. | |
| 479 | _.v_.e_.r_.s_.i_.o_.n_.e_.d_.__.u_.p_.d_.a_.t_.e_.__.o_.l_.d_.__.r_.o_.w_.._.p_.y·-·Illustrates·the·same·UPDATE·into·INSERT·technique | 474 | ····*·_.v_.e_.r_.s_.i_.o_.n_.e_.d_.__.u_.p_.d_.a_.t_.e_.__.o_.l_.d_.__.r_.o_.w_.._.p_.y·-·Illustrates·the·same·UPDATE·into·INSERT |
| 480 | of·versioned_rows.py,·but·also·emits·an·UPDATE·on·the·o.ol.ld.d·row·to·affect·a | 475 | ······technique·of·versioned_rows.py,·but·also·emits·an·UPDATE·on·the·o.ol.ld.d·row |
| | 476 | ······to·affect·a·change·in·timestamp.·Also·includes·a |
| 481 | change·in·timestamp.·Also·includes·a·_.S_.e_.s_.s_.i_.o_.n_.E_.v_.e_.n_.t_.s_.._.d_.o_.__.o_.r_.m_.__.e_.x_.e_.c_.u_.t_.e_.(_.)·hook·to | 477 | ······_.S_.e_.s_.s_.i_.o_.n_.E_.v_.e_.n_.t_.s_.._.d_.o_.__.o_.r_.m_.__.e_.x_.e_.c_.u_.t_.e_.(_.)·hook·to·limit·queries·to·only·the·most |
| | 478 | ······recent·version. |
| 482 | limit·queries·to·only·the·most·recent·version. | |
| 483 | _\x8v_\x8e_\x8r_\x8s_\x8i_\x8o_\x8n_\x8e_\x8d_\x8__\x8r_\x8o_\x8w_\x8s_\x8._\x8p_\x8y·-·Illustrates·a·method·to·intercept·changes·on·objects, | |
| 484 | turning·an·UPDATE·statement·on·a·single·row·into·an·INSERT·statement,·so·that·a | |
| 485 | new·row·is·inserted·with·the·new·data,·keeping·the·old·row·intact. | |
| 486 | _\x8v_\x8e_\x8r_\x8s_\x8i_\x8o_\x8n_\x8e_\x8d_\x8__\x8m_\x8a_\x8p_\x8._\x8p_\x8y·-·A·variant·of·the·versioned_rows·example·built·around·the | 479 | _\x8v_\x8e_\x8r_\x8s_\x8i_\x8o_\x8n_\x8e_\x8d_\x8__\x8m_\x8a_\x8p_\x8._\x8p_\x8y·-·A·variant·of·the·versioned_rows·example·built·around·the |
| 487 | concept·of·a·“vertical·table”·structure,·like·those·illustrated·in·_\x8V_\x8e_\x8r_\x8t_\x8i_\x8c_\x8a_\x8l | 480 | concept·of·a·“vertical·table”·structure,·like·those·illustrated·in·_\x8V_\x8e_\x8r_\x8t_\x8i_\x8c_\x8a_\x8l |
| 488 | _\x8A_\x8t_\x8t_\x8r_\x8i_\x8b_\x8u_\x8t_\x8e_\x8·_\x8M_\x8a_\x8p_\x8p_\x8i_\x8n_\x8g·examples. | 481 | _\x8A_\x8t_\x8t_\x8r_\x8i_\x8b_\x8u_\x8t_\x8e_\x8·_\x8M_\x8a_\x8p_\x8p_\x8i_\x8n_\x8g·examples. |
|
Max diff block lines reached; 7243/18155 bytes (39.90%) of diff not shown.
|