| | | |
Offset 105, 35 lines modified | Offset 105, 35 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 | ····*·_\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 |
| 113 | ······usage·of·_\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 |
| 114 | ······OrderItem·optional. |
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 | 115 | _.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·which |
113 | ······which·illustrates·nesting·of·association·proxies·to·produce·multi-level | 116 | illustrates·nesting·of·association·proxies·to·produce·multi-level·Python |
114 | ······Python·collections,·in·this·case·a·dictionary·with·string·keys·and·sets | 117 | collections,·in·this·case·a·dictionary·with·string·keys·and·sets·of·integers·as |
115 | ······of·integers·as·values,·which·conceal·the·underlying·mapped·classes. | 118 | values,·which·conceal·the·underlying·mapped·classes. |
116 | _\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 | 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 |
117 | “Order”·and·a·collection·of·“Item”·objects,·associating·a·purchase·price·with | 120 | “Order”·and·a·collection·of·“Item”·objects,·associating·a·purchase·price·with |
118 | each·via·an·association·object·called·“OrderItem” | 121 | each·via·an·association·object·called·“OrderItem” |
119 | _\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 | |
120 | _\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 | |
121 | optional. | |
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 | ····*·_\x8b_\x8a_\x8s_\x8i_\x8c_\x8._\x8p_\x8y·-·Illustrates·the·asyncio·engine·/·connection·interface. | 125 | ····*·_\x8b_\x8a_\x8s_\x8i_\x8c_\x8._\x8p_\x8y·-·Illustrates·the·asyncio·engine·/·connection·interface. |
126 | _\x8g_.r_.e_.e_.n_.l_.e_.t_\x8__\x8o_\x8r_\x8m_\x8._\x8p_\x8y·-·Illustrates·use·of·the·sqlalchemy.ext.asyncio.AsyncSession | 126 | _\x8a_.s_.y_.n_.c_\x8__\x8o_\x8r_\x8m_\x8._\x8p_\x8y·-·Illustrates·use·of·the·sqlalchemy.ext.asyncio.AsyncSession |
127 | object·for·asynchronous·ORM·use,·including·the·optional·run_sync()·method. | 127 | object·for·asynchronous·ORM·use. |
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 | _\x8a_.s_.y_.n_.c_\x8__\x8o_\x8r_\x8m_\x8._\x8p_\x8y·-·Illustrates·use·of·the·sqlalchemy.ext.asyncio.AsyncSession | 131 | _\x8g_.r_.e_.e_.n_.l_.e_.t_\x8__\x8o_\x8r_\x8m_\x8._\x8p_\x8y·-·Illustrates·use·of·the·sqlalchemy.ext.asyncio.AsyncSession |
132 | object·for·asynchronous·ORM·use. | 132 | object·for·asynchronous·ORM·use,·including·the·optional·run_sync()·method. |
133 | *\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* | 133 | *\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 | An·example·of·persistence·for·a·directed·graph·structure.·The·graph·is·stored | 134 | An·example·of·persistence·for·a·directed·graph·structure.·The·graph·is·stored |
135 | as·a·collection·of·edges,·each·referencing·both·a·“lower”·and·an·“upper”·node | 135 | as·a·collection·of·edges,·each·referencing·both·a·“lower”·and·an·“upper”·node |
136 | in·a·table·of·nodes.·Basic·persistence·and·querying·for·lower-·and·upper- | 136 | in·a·table·of·nodes.·Basic·persistence·and·querying·for·lower-·and·upper- |
137 | neighbors·are·illustrated: | 137 | neighbors·are·illustrated: |
138 | n2·=·Node(2) | 138 | n2·=·Node(2) |
139 | n5·=·Node(5) | 139 | n5·=·Node(5) |
Offset 155, 31 lines modified | Offset 155, 31 lines modified |
155 | Supplier,·both·subclassing·the·HasAddresses·mixin,·which·ensures·that·the | 155 | Supplier,·both·subclassing·the·HasAddresses·mixin,·which·ensures·that·the |
156 | parent·class·is·provided·with·an·addresses·collection·which·contains·Address | 156 | parent·class·is·provided·with·an·addresses·collection·which·contains·Address |
157 | objects. | 157 | objects. |
158 | 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 | 158 | 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 | 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 | 159 | 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 | _\x8w_\x8i_\x8t_\x8h_\x8·_\x8S_\x8Q_\x8L_\x8A_\x8l_\x8c_\x8h_\x8e_\x8m_\x8y. | 160 | _\x8w_\x8i_\x8t_\x8h_\x8·_\x8S_\x8Q_\x8L_\x8A_\x8l_\x8c_\x8h_\x8e_\x8m_\x8y. |
161 | Listing·of·files: | 161 | Listing·of·files: |
| 162 | ····*·_\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 | ······association·objects·within·individual·tables,·each·one·generated·to |
| 164 | ······persist·those·objects·on·behalf·of·a·particular·parent·class. |
162 | ····*·_.d_.i_.s_.c_.r_.i_.m_.i_.n_.a_.t_.o_.r_.__.o_.n_.__.a_.s_.s_.o_.c_.i_.a_.t_.i_.o_.n_.._.p_.y·-·Illustrates·a·mixin·which·provides·a | 165 | _.d_.i_.s_.c_.r_.i_.m_.i_.n_.a_.t_.o_.r_.__.o_.n_.__.a_.s_.s_.o_.c_.i_.a_.t_.i_.o_.n_.._.p_.y·-·Illustrates·a·mixin·which·provides·a·generic |
163 | ······generic·association·using·a·single·target·table·and·a·single·association | 166 | association·using·a·single·target·table·and·a·single·association·table, |
164 | ······table,·referred·to·by·all·parent·tables.·The·association·table·contains·a | 167 | referred·to·by·all·parent·tables.·The·association·table·contains·a |
165 | ······“discriminator”·column·which·determines·what·type·of·parent·object | 168 | “discriminator”·column·which·determines·what·type·of·parent·object·associates |
166 | ······associates·to·each·particular·row·in·the·association·table. | 169 | to·each·particular·row·in·the·association·table. |
167 | _\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 | _\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 |
168 | association·via·a·individually·generated·association·tables·for·each·parent | 171 | association·via·a·individually·generated·association·tables·for·each·parent |
169 | class.·The·associated·objects·themselves·are·persisted·in·a·single·table·shared | 172 | class.·The·associated·objects·themselves·are·persisted·in·a·single·table·shared |
170 | among·all·parents. | 173 | among·all·parents. |
171 | _\x8g_\x8e_\x8n_\x8e_\x8r_\x8i_\x8c_\x8__\x8f_\x8k_\x8._\x8p_\x8y·-·Illustrates·a·so-called·“generic·foreign·key”,·in·a·similar | 174 | _\x8g_\x8e_\x8n_\x8e_\x8r_\x8i_\x8c_\x8__\x8f_\x8k_\x8._\x8p_\x8y·-·Illustrates·a·so-called·“generic·foreign·key”,·in·a·similar |
172 | fashion·to·that·of·popular·frameworks·such·as·Django,·ROR,·etc.·This·approach | 175 | fashion·to·that·of·popular·frameworks·such·as·Django,·ROR,·etc.·This·approach |
173 | bypasses·standard·referential·integrity·practices,·in·that·the·“foreign·key” | 176 | bypasses·standard·referential·integrity·practices,·in·that·the·“foreign·key” |
174 | column·is·not·actually·constrained·to·refer·to·any·particular·table;·instead, | 177 | column·is·not·actually·constrained·to·refer·to·any·particular·table;·instead, |
175 | in-application·logic·is·used·to·determine·which·table·is·referenced. | 178 | in-application·logic·is·used·to·determine·which·table·is·referenced. |
176 | _\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 | |
177 | association·objects·within·individual·tables,·each·one·generated·to·persist | |
178 | those·objects·on·behalf·of·a·particular·parent·class. | |
179 | *\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* | 179 | *\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 | Large·collection·example. | 180 | Large·collection·example. |
181 | 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 | 181 | 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 | objects·is·very·large,·including: | 182 | objects·is·very·large,·including: |
183 | ····*·“dynamic”·relationships·which·query·slices·of·data·as·accessed | 183 | ····*·“dynamic”·relationships·which·query·slices·of·data·as·accessed |
184 | ····*·how·to·use·ON·DELETE·CASCADE·in·conjunction·with·passive_deletes=True·to | 184 | ····*·how·to·use·ON·DELETE·CASCADE·in·conjunction·with·passive_deletes=True·to |
185 | ······greatly·improve·the·performance·of·related·collection·deletion. | 185 | ······greatly·improve·the·performance·of·related·collection·deletion. |
Offset 236, 28 lines modified | Offset 236, 28 lines modified |
236 | $·python·-m·examples.performance·bulk_inserts·\ | 236 | $·python·-m·examples.performance·bulk_inserts·\ |
237 | ····--dburl·mysql+mysqldb://scott:tiger@localhost/test·\ | 237 | ····--dburl·mysql+mysqldb://scott:tiger@localhost/test·\ |
238 | ····--profile·--num·1000 | 238 | ····--profile·--num·1000 |
239 | See·also | 239 | See·also |
240 | _\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? | 240 | _\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 | *\x8**\x8**\x8*·F\x8Fi\x8il\x8le\x8e·L\x8Li\x8is\x8st\x8ti\x8in\x8ng\x8g_\x8?\x8¶·*\x8**\x8**\x8* | 241 | *\x8**\x8**\x8*·F\x8Fi\x8il\x8le\x8e·L\x8Li\x8is\x8st\x8ti\x8in\x8ng\x8g_\x8?\x8¶·*\x8**\x8**\x8* |
242 | Listing·of·files: | 242 | Listing·of·files: |
243 | ····*·_\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 | ······load·a·large·number·of·very·small·and·simple·rows. | |
245 | _.b_.u_.l_.k_.__.u_.p_.d_.a_.t_.e_.s_.._.p_.y·-·This·series·of·tests·will·illustrate·different·ways·to·UPDATE | 243 | ····*·_.b_.u_.l_.k_.__.i_.n_.s_.e_.r_.t_.s_.._.p_.y·-·This·series·of·tests·illustrates·different·ways·to |
| 244 | ······INSERT·a·large·number·of·rows·in·bulk. |
246 | a·large·number·of·rows·in·bulk·(under·construction!·there’s·just·one·test·at | |
247 | the·moment) | |
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 | 245 | _\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 |
249 | single·record·by·primary·key | 246 | single·record·by·primary·key |
250 | _\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 | |
251 | large·number·of·rows·in·bulk. | |
252 | _\x8__\x8__\x8m_\x8a_\x8i_\x8n_\x8__\x8__\x8._\x8p_\x8y·-·Allows·the·examples/performance·package·to·be·run·as·a·script. | |
253 | _\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 | 247 | _\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 |
254 | inserts·a·row·within·a·distinct·transaction,·and·afterwards·returns·to | 248 | inserts·a·row·within·a·distinct·transaction,·and·afterwards·returns·to |
255 | essentially·a·“closed”·state.·This·would·be·analogous·to·an·API·call·that | 249 | essentially·a·“closed”·state.·This·would·be·analogous·to·an·API·call·that |
256 | starts·up·a·database·connection,·inserts·the·row,·commits·and·closes. | 250 | starts·up·a·database·connection,·inserts·the·row,·commits·and·closes. |
| 251 | _\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 |
| 252 | a·large·number·of·rows·in·bulk·(under·construction!·there’s·just·one·test·at |
| 253 | the·moment) |
| 254 | _\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 |
| 255 | large·number·of·very·small·and·simple·rows. |
| 256 | _\x8__\x8__\x8m_\x8a_\x8i_\x8n_\x8__\x8__\x8._\x8p_\x8y·-·Allows·the·examples/performance·package·to·be·run·as·a·script. |
257 | *\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* | 257 | *\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 | This·is·the·default·form·of·run: | 258 | This·is·the·default·form·of·run: |
259 | $·python·-m·examples.performance·single_inserts | 259 | $·python·-m·examples.performance·single_inserts |
260 | Tests·to·run:·test_orm_commit,·test_bulk_save, | 260 | Tests·to·run:·test_orm_commit,·test_bulk_save, |
261 | ··············test_bulk_insert_dictionaries,·test_core, | 261 | ··············test_bulk_insert_dictionaries,·test_core, |
262 | ··············test_core_query_caching,·test_dbapi_raw_w_connect, | 262 | ··············test_core_query_caching,·test_dbapi_raw_w_connect, |
263 | ··············test_dbapi_raw_w_pool | 263 | ··············test_dbapi_raw_w_pool |
Offset 394, 20 lines modified | Offset 394, 20 lines modified |
394 | total·time·2.754592·sec | 394 | total·time·2.754592·sec |
395 | test_subqueryload·:·load·everything,·subquery·eager·loading.·(1000·iterations); | 395 | test_subqueryload·:·load·everything,·subquery·eager·loading.·(1000·iterations); |
396 | total·time·2.977696·sec | 396 | total·time·2.977696·sec |
397 | *\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* | 397 | *\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 | Examples·of·various·_\x8r_\x8e_\x8l_\x8a_\x8t_\x8i_\x8o_\x8n_\x8s_\x8h_\x8i_\x8p_\x8(_\x8)·configurations,·which·make·use·of·the | 398 | Examples·of·various·_\x8r_\x8e_\x8l_\x8a_\x8t_\x8i_\x8o_\x8n_\x8s_\x8h_\x8i_\x8p_\x8(_\x8)·configurations,·which·make·use·of·the |
399 | primaryjoin·argument·to·compose·special·types·of·join·conditions. | 399 | primaryjoin·argument·to·compose·special·types·of·join·conditions. |
400 | Listing·of·files: | 400 | Listing·of·files: |
| 401 | ····*·_\x8t_\x8h_\x8r_\x8e_\x8e_\x8w_\x8a_\x8y_\x8._\x8p_\x8y·-·Illustrate·a·“three·way·join”·-·where·a·primary·table·joins |
| 402 | ······to·a·remote·table·via·an·association·table,·but·then·the·primary·table |
| 403 | ······also·needs·to·refer·to·some·columns·in·the·remote·table·directly. |
401 | ····*·_\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 | 404 | _\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 |
402 | ······columns·are·not·of·the·same·type,·and·a·CAST·must·be·used·on·the·SQL·side | 405 | columns·are·not·of·the·same·type,·and·a·CAST·must·be·used·on·the·SQL·side·in |
403 | ······in·order·to·match·them. | 406 | order·to·match·them. |
404 | _\x8t_\x8h_\x8r_\x8e_\x8e_\x8w_\x8a_\x8y_\x8._\x8p_\x8y·-·Illustrate·a·“three·way·join”·-·where·a·primary·table·joins·to·a | |
405 | remote·table·via·an·association·table,·but·then·the·primary·table·also·needs·to | |
406 | refer·to·some·columns·in·the·remote·table·directly. | |
407 | *\x8**\x8**\x8**\x8*·S\x8Sp\x8pa\x8ac\x8ce\x8e·I\x8In\x8nv\x8va\x8ad\x8de\x8er\x8rs\x8s_\x8?\x8¶·*\x8**\x8**\x8**\x8* | 407 | *\x8**\x8**\x8**\x8*·S\x8Sp\x8pa\x8ac\x8ce\x8e·I\x8In\x8nv\x8va\x8ad\x8de\x8er\x8rs\x8s_\x8?\x8¶·*\x8**\x8**\x8**\x8* |
Max diff block lines reached; 9175/19675 bytes (46.63%) of diff not shown.
|