/main/migrations/0007_populate_player.py

https://github.com/jeffder/legends · Python · 193 lines · 182 code · 10 blank · 1 comment · 1 complexity · 08a5ef6180d050b847b3705147da95b1 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.         club_map = migration.club_map(old_db, orm.Club)
    14. 

  14.         season_map = migration.season_map(old_db, orm.Season)
    15. 

  15. 

  16.         old_players = old_db.execute("select * from player")
    17. 

  17. 

  18.         for p in old_players:
    19. 

  19.             player_args = {
    20. 

  20.                 'first_name': p[0],
    21. 

  21.                 'last_name': p[1],
    22. 

  22.                 'initial': p[2],
    23. 

  23.                 'club': club_map[p[3]],
    24. 

  24.                 'supercoach_name': p[4],
    25. 

  25.                 'season': season_map[p[5]]
    26. 

  26.             }
    27. 

  27.             player = orm.Player(**player_args)
    28. 

  28.             player.save()
    29. 

  29. 

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

  31.         orm.Player.objects.all().delete
    32. 

  32. 

  33.     models = {
    34. 

  34.         'auth.group': {
    35. 

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

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

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

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

  39.         },
    40. 

  40.         'auth.permission': {
    41. 

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

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

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

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

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

  46.         },
    47. 

  47.         'auth.user': {
    48. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  62.         },
    63. 

  63.         'contenttypes.contenttype': {
    64. 

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

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

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

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

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

  69.         },
    70. 

  70.         'main.bye': {
    71. 

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

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

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

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

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

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

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

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

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

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

  81.         },
    82. 

  82.         'main.club': {
    83. 

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

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

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

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

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

  88.         },
    89. 

  89.         'main.coach': {
    90. 

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

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

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

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

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

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

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

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

  98.         },
    99. 

  99.         'main.game': {
    100. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  127.         },
    128. 

  128.         'main.ground': {
    129. 

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

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

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

  132.         },
    133. 

  133.         'main.player': {
    134. 

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

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

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

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

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

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

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

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

  142.         },
    143. 

  143.         'main.round': {
    144. 

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

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

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

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

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

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

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

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

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

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

  154.         },
    155. 

  155.         'main.season': {
    156. 

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

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

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

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

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

  161.         },
    162. 

  162.         'main.supercoachranking': {
    163. 

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

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

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

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

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

  168.         },
    169. 

  169.         'main.supercoachtip': {
    170. 

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

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

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

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

  174.         },
    175. 

  175.         'main.tip': {
    176. 

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

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

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

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

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

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

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

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

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

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

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

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

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

  189.         }
    190. 

  190.     }
    191. 

  191. 

  192.     complete_apps = ['main']
    193. 

  193.     symmetrical = True
    194.