/main/migrations/0013_populate_supercoach_tip.py

https://github.com/jeffder/legends · Python · 194 lines · 182 code · 11 blank · 1 comment · 1 complexity · dcfc091392ade70e3f0b8193e9b59756 MD5 · raw file 

    

  1. # -*- coding: utf-8 -*-
    2. 

  2. from south.db import dbs
    3. 

  3. from south.v2 import DataMigration
    4. 

  4. 

  5. from main.utils import migration
    6. 

  6. 

  7. 

  8. class Migration(DataMigration):
    9. 

  9. 

  10.     def forwards(self, orm):
    11. 

  11.         old_db = dbs['old']
    12. 

  12. 

  13.         player_map = migration.player_map(
    14. 

  14.             old_db, orm.Player, fk_models={'club': orm.Club})
    15. 

  15.         tip_map = migration.tip_map(
    16. 

  16.             old_db, orm.Tip, fk_models={
    17. 

  17.                 'round': orm.Round, 'club': orm.Club, 'game': orm.Game}
    18. 

  18.         )
    19. 

  19. 

  20.         votes = old_db.execute('select * from bog_tip')
    21. 

  21. 

  22.         for v in votes:
    23. 

  23.             vote_args = {
    24. 

  24.                 'player': player_map[v[0]],
    25. 

  25.                 'tip': tip_map[v[2]],
    26. 

  26.                 }
    27. 

  27. 

  28.             vote = orm.SupercoachTip(**vote_args)
    29. 

  29.             vote.save()
    30. 

  30. 

  31.     def backwards(self, orm):
    32. 

  32.         orm.SupercoachTip.objects.all().delete()
    33. 

  33. 

  34.     models = {
    35. 

  35.         'auth.group': {
    36. 

  36.             'Meta': {'object_name': 'Group'},
    37. 

  37.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    38. 

  38.             'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '80'}),
    39. 

  39.             'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'to': "orm['auth.Permission']", 'blank': 'True'})
    40. 

  40.         },
    41. 

  41.         'auth.permission': {
    42. 

  42.             'Meta': {'unique_together': "(('content_type', 'codename'),)", 'ordering': "('content_type__app_label', 'content_type__model', 'codename')", 'object_name': 'Permission'},
    43. 

  43.             'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
    44. 

  44.             'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}),
    45. 

  45.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    46. 

  46.             'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
    47. 

  47.         },
    48. 

  48.         'auth.user': {
    49. 

  49.             'Meta': {'object_name': 'User'},
    50. 

  50.             'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
    51. 

  51.             'email': ('django.db.models.fields.EmailField', [], {'blank': 'True', 'max_length': '75'}),
    52. 

  52.             'first_name': ('django.db.models.fields.CharField', [], {'blank': 'True', 'max_length': '30'}),
    53. 

  53.             'groups': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'to': "orm['auth.Group']", 'related_name': "'user_set'", 'blank': 'True'}),
    54. 

  54.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    55. 

  55.             'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
    56. 

  56.             'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    57. 

  57.             'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    58. 

  58.             'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
    59. 

  59.             'last_name': ('django.db.models.fields.CharField', [], {'blank': 'True', 'max_length': '30'}),
    60. 

  60.             'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
    61. 

  61.             'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'to': "orm['auth.Permission']", 'related_name': "'user_set'", 'blank': 'True'}),
    62. 

  62.             'username': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'})
    63. 

  63.         },
    64. 

  64.         'contenttypes.contenttype': {
    65. 

  65.             'Meta': {'unique_together': "(('app_label', 'model'),)", 'ordering': "('name',)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"},
    66. 

  66.             'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
    67. 

  67.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    68. 

  68.             'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
    69. 

  69.             'name': ('django.db.models.fields.CharField', [], {'max_length': '100'})
    70. 

  70.         },
    71. 

  71.         'main.bye': {
    72. 

  72.             'Meta': {'ordering': "('-round__season', 'round', 'club')", 'object_name': 'Bye'},
    73. 

  73.             'club': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['main.Club']", 'related_name': "'byes'"}),
    74. 

  74.             'crowds_score': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    75. 

  75.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    76. 

  76.             'margins_score': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    77. 

  77.             'round': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['main.Round']", 'related_name': "'byes'"}),
    78. 

  78.             'score': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    79. 

  79.             'supercoach_score': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    80. 

  80.             'winners_bonus': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    81. 

  81.             'winners_score': ('django.db.models.fields.IntegerField', [], {'default': '0'})
    82. 

  82.         },
    83. 

  83.         'main.club': {
    84. 

  84.             'Meta': {'ordering': "['name']", 'object_name': 'Club'},
    85. 

  85.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    86. 

  86.             'name': ('django.db.models.fields.CharField', [], {'max_length': '20'}),
    87. 

  87.             'nickname': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
    88. 

  88.             'user': ('django.db.models.fields.related.ForeignKey', [], {'unique': 'True', 'to': "orm['auth.User']", 'related_name': "'clubs'"})
    89. 

  89.         },
    90. 

  90.         'main.coach': {
    91. 

  91.             'Meta': {'ordering': "['-season', 'club', 'last_name', 'first_name']", 'object_name': 'Coach'},
    92. 

  92.             'club': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['main.Club']", 'related_name': "'coaches'"}),
    93. 

  93.             'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
    94. 

  94.             'has_paid_fees': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    95. 

  95.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    96. 

  96.             'is_assistant': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    97. 

  97.             'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
    98. 

  98.             'season': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['main.Season']", 'related_name': "'coaches'"})
    99. 

  99.         },
    100. 

  100.         'main.game': {
    101. 

  101.             'Meta': {'ordering': "('-round__season', 'round', 'game_date', 'afl_home')", 'object_name': 'Game'},
    102. 

  102.             'afl_away': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['main.Club']", 'related_name': "'afl_game_away'"}),
    103. 

  103.             'afl_away_score': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    104. 

  104.             'afl_home': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['main.Club']", 'related_name': "'afl_game_home'"}),
    105. 

  105.             'afl_home_score': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    106. 

  106.             'crowd': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    107. 

  107.             'finals_game': ('django.db.models.fields.IntegerField', [], {'blank': 'True', 'null': 'True'}),
    108. 

  108.             'game_date': ('django.db.models.fields.DateTimeField', [], {'blank': 'True', 'null': 'True'}),
    109. 

  109.             'ground': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['main.Ground']", 'related_name': "'games'"}),
    110. 

  110.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    111. 

  111.             'legends_away': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['main.Club']", 'related_name': "'legends_game_away'"}),
    112. 

  112.             'legends_away_crowds_score': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    113. 

  113.             'legends_away_margins_score': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    114. 

  114.             'legends_away_score': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    115. 

  115.             'legends_away_supercoach_score': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    116. 

  116.             'legends_away_winners_bonus': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    117. 

  117.             'legends_away_winners_score': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    118. 

  118.             'legends_home': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['main.Club']", 'related_name': "'legends_game_home'"}),
    119. 

  119.             'legends_home_crowds_score': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    120. 

  120.             'legends_home_margins_score': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    121. 

  121.             'legends_home_score': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    122. 

  122.             'legends_home_supercoach_score': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    123. 

  123.             'legends_home_winners_bonus': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    124. 

  124.             'legends_home_winners_score': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    125. 

  125.             'round': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['main.Round']", 'related_name': "'games'"}),
    126. 

  126.             'status': ('django.db.models.fields.CharField', [], {'max_length': '15'}),
    127. 

  127.             'tipping_deadline': ('django.db.models.fields.DateTimeField', [], {'blank': 'True', 'null': 'True'})
    128. 

  128.         },
    129. 

  129.         'main.ground': {
    130. 

  130.             'Meta': {'ordering': "['name']", 'object_name': 'Ground'},
    131. 

  131.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    132. 

  132.             'name': ('django.db.models.fields.CharField', [], {'max_length': '20'})
    133. 

  133.         },
    134. 

  134.         'main.player': {
    135. 

  135.             'Meta': {'ordering': "['-season', 'club', 'last_name', 'initial', 'first_name']", 'object_name': 'Player'},
    136. 

  136.             'club': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['main.Club']", 'related_name': "'players'"}),
    137. 

  137.             'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
    138. 

  138.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    139. 

  139.             'initial': ('django.db.models.fields.CharField', [], {'blank': 'True', 'max_length': '1', 'null': 'True'}),
    140. 

  140.             'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
    141. 

  141.             'season': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['main.Season']", 'related_name': "'players'"}),
    142. 

  142.             'supercoach_name': ('django.db.models.fields.CharField', [], {'blank': 'True', 'max_length': '30', 'null': 'True'})
    143. 

  143.         },
    144. 

  144.         'main.round': {
    145. 

  145.             'Meta': {'ordering': "('-season', 'start_time')", 'object_name': 'Round'},
    146. 

  146.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    147. 

  147.             'is_finals': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    148. 

  148.             'name': ('django.db.models.fields.CharField', [], {'max_length': '20'}),
    149. 

  149.             'num_bogs': ('django.db.models.fields.IntegerField', [], {}),
    150. 

  150.             'num_games': ('django.db.models.fields.IntegerField', [], {}),
    151. 

  151.             'season': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['main.Season']", 'related_name': "'rounds'"}),
    152. 

  152.             'start_time': ('django.db.models.fields.DateTimeField', [], {'null': 'True'}),
    153. 

  153.             'status': ('django.db.models.fields.CharField', [], {'max_length': '15'}),
    154. 

  154.             'tipping_deadline': ('django.db.models.fields.DateTimeField', [], {'null': 'True'})
    155. 

  155.         },
    156. 

  156.         'main.season': {
    157. 

  157.             'Meta': {'ordering': "['-season']", 'object_name': 'Season'},
    158. 

  158.             'has_full_data': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
    159. 

  159.             'has_no_data': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    160. 

  160.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    161. 

  161.             'season': ('django.db.models.fields.IntegerField', [], {})
    162. 

  162.         },
    163. 

  163.         'main.supercoachranking': {
    164. 

  164.             'Meta': {'object_name': 'SupercoachRanking', 'db_table': "'main_supercoach_ranking'"},
    165. 

  165.             'game': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['main.Game']", 'related_name': "'supercoach_rankings'"}),
    166. 

  166.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    167. 

  167.             'player': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['main.Player']", 'related_name': "'supercoach_rankings'"}),
    168. 

  168.             'ranking': ('django.db.models.fields.IntegerField', [], {})
    169. 

  169.         },
    170. 

  170.         'main.supercoachtip': {
    171. 

  171.             'Meta': {'ordering': "('player__last_name', 'player__initial', 'player__first_name')", 'object_name': 'SupercoachTip', 'db_table': "'main_supercoach_tip'"},
    172. 

  172.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    173. 

  173.             'player': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['main.Player']", 'related_name': "'supercoach_tips'", 'null': 'True'}),
    174. 

  174.             'tip': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['main.Tip']", 'related_name': "'supercoach_tips'"})
    175. 

  175.         },
    176. 

  176.         'main.tip': {
    177. 

  177.             'Meta': {'ordering': "('-game', 'club')", 'object_name': 'Tip'},
    178. 

  178.             'club': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['main.Club']", 'related_name': "'tips'"}),
    179. 

  179.             'crowd': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
    180. 

  180.             'crowds_score': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    181. 

  181.             'game': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['main.Game']", 'related_name': "'tips'"}),
    182. 

  182.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    183. 

  183.             'is_default': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    184. 

  184.             'margin': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
    185. 

  185.             'margins_score': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    186. 

  186.             'supercoach_score': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    187. 

  187.             'total': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    188. 

  188.             'winner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['main.Club']", 'related_name': "'tip_winners'", 'null': 'True'}),
    189. 

  189.             'winners_score': ('django.db.models.fields.IntegerField', [], {'default': '0'})
    190. 

  190.         }
    191. 

  191.     }
    192. 

  192. 

  193.     complete_apps = ['main']
    194. 

  194.     symmetrical = True
    195.