Coverage for ivatar/ivataraccount/migrations/0022_confirmedopenid_digest_indexes.py: 100%

1# Generated for performance optimization: add db_index=True to ConfirmedOpenId digest fields 

2# These indexes eliminate full table scans on every OpenID avatar lookup. 

3# 

4# Views queries that benefit from these indexes: 

5# Q(digest=digest) | Q(alt_digest1=digest) | Q(alt_digest2=digest) | Q(alt_digest3=digest) 

6# 

7# See: ivatar/views.py lines ~216-220 and ~551-554 

8 

9from django.db import migrations, models 

10 

11 

12class Migration(migrations.Migration): 

13 """Add database indexes to ConfirmedOpenId digest lookup fields.""" 

14 

15 dependencies = [ 

16 ("ivataraccount", "0021_add_performance_indexes"), 

17 ] 

18 

19 operations = [ 

20 migrations.AlterField( 

21 model_name="confirmedopenid", 

22 name="digest", 

23 field=models.CharField(db_index=True, max_length=64), 

24 ), 

25 migrations.AlterField( 

26 model_name="confirmedopenid", 

27 name="alt_digest1", 

28 field=models.CharField( 

29 blank=True, db_index=True, default=None, max_length=64, null=True 

30 ), 

31 ), 

32 migrations.AlterField( 

33 model_name="confirmedopenid", 

34 name="alt_digest2", 

35 field=models.CharField( 

36 blank=True, db_index=True, default=None, max_length=64, null=True 

37 ), 

38 ), 

39 migrations.AlterField( 

40 model_name="confirmedopenid", 

41 name="alt_digest3", 

42 field=models.CharField( 

43 blank=True, db_index=True, default=None, max_length=64, null=True 

44 ), 

45 ), 

46 ]