Mercurial > p > roundup > code
comparison test/db_test_base.py @ 6638:e1588ae185dc issue2550923_computed_property
merge from default branch. Fix travis.ci so CI builds don't error out
| author | John Rouillard <rouilj@ieee.org> |
|---|---|
| date | Thu, 21 Apr 2022 16:54:17 -0400 |
| parents | 0d99ae7c8de6 |
| children | 8ab98de22df0 |
comparison
equal
deleted
inserted
replaced
| 6508:85db90cc1705 | 6638:e1588ae185dc |
|---|---|
| 250 | 250 |
| 251 # load the database | 251 # load the database |
| 252 self.db.issue.create(title="flebble frooz") | 252 self.db.issue.create(title="flebble frooz") |
| 253 self.db.commit() | 253 self.db.commit() |
| 254 | 254 |
| 255 self.assertEqual(self.db.database_schema['version'], 6, | 255 if self.db.database_schema['version'] > 6: |
| 256 "This test only runs for database version 6") | 256 # make testUpgrades run the downgrade code only. |
| 257 self.db.database_schema['version'] = 5 | 257 if hasattr(self, "downgrade_only"): |
| 258 # we are being called by an earlier test | |
| 259 self.testUpgrade_6_to_7() | |
| 260 self.assertEqual(self.db.database_schema['version'], 6) | |
| 261 else: | |
| 262 # we are being called directly | |
| 263 self.downgrade_only = True | |
| 264 self.testUpgrade_6_to_7() | |
| 265 self.assertEqual(self.db.database_schema['version'], 6) | |
| 266 del(self.downgrade_only) | |
| 267 elif self.db.database_schema['version'] != 6: | |
| 268 self.skipTest("This test only runs for database version 6") | |
| 269 | |
| 258 if self.db.dbtype == 'mysql': | 270 if self.db.dbtype == 'mysql': |
| 259 # version 6 has 5 indexes | 271 # version 6 has 5 indexes |
| 260 self.db.sql('show indexes from _user;') | 272 self.db.sql('show indexes from _user;') |
| 261 self.assertEqual(5,len(self.db.cursor.fetchall()), | 273 self.assertEqual(5,len(self.db.cursor.fetchall()), |
| 262 "Database created with wrong number of indexes") | 274 "Database created with wrong number of indexes") |
| 266 # after dropping (key.__retired__) composite index we have | 278 # after dropping (key.__retired__) composite index we have |
| 267 # 3 index entries | 279 # 3 index entries |
| 268 self.db.sql('show indexes from _user;') | 280 self.db.sql('show indexes from _user;') |
| 269 self.assertEqual(3,len(self.db.cursor.fetchall())) | 281 self.assertEqual(3,len(self.db.cursor.fetchall())) |
| 270 | 282 |
| 283 self.db.database_schema['version'] = 5 | |
| 284 | |
| 285 if hasattr(self, "downgrade_only"): | |
| 286 return | |
| 287 | |
| 271 # test upgrade adding index | 288 # test upgrade adding index |
| 272 self.db.post_init() | 289 self.db.post_init() |
| 273 | 290 |
| 274 # they're back | 291 # they're back |
| 275 self.db.sql('show indexes from _user;') | 292 self.db.sql('show indexes from _user;') |
| 282 | 299 |
| 283 # they're still here. | 300 # they're still here. |
| 284 self.db.sql('show indexes from _user;') | 301 self.db.sql('show indexes from _user;') |
| 285 self.assertEqual(5,len(self.db.cursor.fetchall())) | 302 self.assertEqual(5,len(self.db.cursor.fetchall())) |
| 286 else: | 303 else: |
| 304 if hasattr(self, "downgrade_only"): | |
| 305 return | |
| 287 # this should be a no-op | 306 # this should be a no-op |
| 288 # test upgrade | 307 # test upgrade |
| 289 self.db.post_init() | 308 self.db.post_init() |
| 309 | |
| 310 # we should be at the current db version | |
| 311 self.assertEqual(self.db.database_schema['version'], | |
| 312 self.db.current_db_version) | |
| 290 | 313 |
| 291 def drop_key_retired_idx(self): | 314 def drop_key_retired_idx(self): |
| 292 c = self.db.cursor | 315 c = self.db.cursor |
| 293 for cn, klass in self.db.classes.items(): | 316 for cn, klass in self.db.classes.items(): |
| 294 if klass.key: | 317 if klass.key: |