/project/migrations/0005_link_invoicerow_proposal.py

https://github.com/splanquart/aemanager · Python · 160 lines · 149 code · 7 blank · 4 comment · 1 complexity · fabc5ae9d7bd3e2a72bcc97db0bdef14 MD5 · raw file 

    

  1. # encoding: utf-8
    2. 

  2. import datetime
    3. 

  3. from south.db import db
    4. 

  4. from south.v2 import DataMigration
    5. 

  5. from django.db import models
    6. 

  6. 

  7. class Migration(DataMigration):
    8. 

  8. 

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

  10.         """
    11. 

  11.         Copy the link invoice-proposal to invoicerow-proposal
    12. 

  12.         """
    13. 

  13.         for invoice_row in orm.InvoiceRow.objects.all():
    14. 

  14.             proposal = invoice_row.invoice.proposal
    15. 

  15.             invoice_row.proposal = proposal
    16. 

  16.             invoice_row.save()
    17. 

  17. 

  18. 

  19.     def backwards(self, orm):
    20. 

  20.         pass
    21. 

  21. 

  22. 

  23.     models = {
    24. 

  24.         'auth.group': {
    25. 

  25.             'Meta': {'object_name': 'Group'},
    26. 

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

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

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

  29.         },
    30. 

  30.         'auth.permission': {
    31. 

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

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

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

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

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

  36.         },
    37. 

  37.         'auth.user': {
    38. 

  38.             'Meta': {'object_name': 'User'},
    39. 

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

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

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

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

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

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

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

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

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

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

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

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

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

  52.         },
    53. 

  53.         'contact.address': {
    54. 

  54.             'Meta': {'object_name': 'Address', '_ormbases': ['core.OwnedObject']},
    55. 

  55.             'city': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '255', 'blank': 'True'}),
    56. 

  56.             'country': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contact.Country']", 'null': 'True', 'blank': 'True'}),
    57. 

  57.             'ownedobject_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.OwnedObject']", 'unique': 'True', 'primary_key': 'True'}),
    58. 

  58.             'street': ('django.db.models.fields.TextField', [], {'default': "''", 'blank': 'True'}),
    59. 

  59.             'zipcode': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '10', 'blank': 'True'})
    60. 

  60.         },
    61. 

  61.         'contact.contact': {
    62. 

  62.             'Meta': {'object_name': 'Contact', '_ormbases': ['core.OwnedObject']},
    63. 

  63.             'address': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contact.Address']"}),
    64. 

  64.             'company_id': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '50', 'blank': 'True'}),
    65. 

  65.             'contact_type': ('django.db.models.fields.IntegerField', [], {}),
    66. 

  66.             'contacts': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'to': "orm['contact.Contact']", 'null': 'True', 'blank': 'True'}),
    67. 

  67.             'email': ('django.db.models.fields.EmailField', [], {'default': "''", 'max_length': '75', 'blank': 'True'}),
    68. 

  68.             'firstname': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '255', 'blank': 'True'}),
    69. 

  69.             'function': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '100', 'blank': 'True'}),
    70. 

  70.             'legal_form': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '255', 'blank': 'True'}),
    71. 

  71.             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
    72. 

  72.             'ownedobject_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.OwnedObject']", 'unique': 'True', 'primary_key': 'True'}),
    73. 

  73.             'representative': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '255', 'blank': 'True'}),
    74. 

  74.             'representative_function': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '100', 'blank': 'True'})
    75. 

  75.         },
    76. 

  76.         'contact.country': {
    77. 

  77.             'Meta': {'ordering': "['country_name']", 'object_name': 'Country'},
    78. 

  78.             'country_code2': ('django.db.models.fields.CharField', [], {'max_length': '2'}),
    79. 

  79.             'country_code3': ('django.db.models.fields.CharField', [], {'max_length': '3'}),
    80. 

  80.             'country_name': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
    81. 

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

  82.         },
    83. 

  83.         'contenttypes.contenttype': {
    84. 

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

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

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

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

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

  89.         },
    90. 

  90.         'core.ownedobject': {
    91. 

  91.             'Meta': {'object_name': 'OwnedObject'},
    92. 

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

  93.             'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['auth.User']"})
    94. 

  94.         },
    95. 

  95.         'project.contract': {
    96. 

  96.             'Meta': {'object_name': 'Contract', '_ormbases': ['core.OwnedObject']},
    97. 

  97.             'content': ('django.db.models.fields.TextField', [], {}),
    98. 

  98.             'customer': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'contracts'", 'to': "orm['contact.Contact']"}),
    99. 

  99.             'ownedobject_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.OwnedObject']", 'unique': 'True', 'primary_key': 'True'}),
    100. 

  100.             'title': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
    101. 

  101.             'update_date': ('django.db.models.fields.DateField', [], {})
    102. 

  102.         },
    103. 

  103.         'project.invoice': {
    104. 

  104.             'Meta': {'object_name': 'Invoice', '_ormbases': ['core.OwnedObject']},
    105. 

  105.             'amount': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}),
    106. 

  106.             'balance_payments': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    107. 

  107.             'customer': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contact.Contact']", 'null': 'True', 'blank': 'True'}),
    108. 

  108.             'discount_conditions': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True', 'blank': 'True'}),
    109. 

  109.             'edition_date': ('django.db.models.fields.DateField', [], {}),
    110. 

  110.             'execution_begin_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
    111. 

  111.             'execution_end_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
    112. 

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

  113.             'ownedobject_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.OwnedObject']", 'unique': 'True', 'primary_key': 'True'}),
    114. 

  114.             'paid_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
    115. 

  115.             'payment_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
    116. 

  116.             'penalty_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
    117. 

  117.             'penalty_rate': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '4', 'decimal_places': '2', 'blank': 'True'}),
    118. 

  118.             'proposal': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'invoices'", 'to': "orm['project.Proposal']"}),
    119. 

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

  120.         },
    121. 

  121.         'project.invoicerow': {
    122. 

  122.             'Meta': {'object_name': 'InvoiceRow'},
    123. 

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

  124.             'invoice': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'invoice_rows'", 'to': "orm['project.Invoice']"}),
    125. 

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

  126.             'ownedobject_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.OwnedObject']", 'unique': 'True', 'primary_key': 'True'}),
    127. 

  127.             'proposal': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'invoice_rows'", 'to': "orm['project.Proposal']"}),
    128. 

  128.             'quantity': ('django.db.models.fields.DecimalField', [], {'max_digits': '5', 'decimal_places': '1'}),
    129. 

  129.             'unit_price': ('django.db.models.fields.DecimalField', [], {'max_digits': '12', 'decimal_places': '2'})
    130. 

  130.         },
    131. 

  131.         'project.project': {
    132. 

  132.             'Meta': {'object_name': 'Project', '_ormbases': ['core.OwnedObject']},
    133. 

  133.             'customer': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contact.Contact']", 'null': 'True', 'blank': 'True'}),
    134. 

  134.             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
    135. 

  135.             'ownedobject_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.OwnedObject']", 'unique': 'True', 'primary_key': 'True'}),
    136. 

  136.             'state': ('django.db.models.fields.IntegerField', [], {'default': '1'})
    137. 

  137.         },
    138. 

  138.         'project.proposal': {
    139. 

  139.             'Meta': {'object_name': 'Proposal', '_ormbases': ['core.OwnedObject']},
    140. 

  140.             'amount': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}),
    141. 

  141.             'begin_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
    142. 

  142.             'contract_content': ('django.db.models.fields.TextField', [], {'default': "''", 'blank': 'True'}),
    143. 

  143.             'end_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
    144. 

  144.             'ownedobject_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.OwnedObject']", 'unique': 'True', 'primary_key': 'True'}),
    145. 

  145.             'project': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['project.Project']"}),
    146. 

  146.             'state': ('django.db.models.fields.IntegerField', [], {'default': '1'}),
    147. 

  147.             'update_date': ('django.db.models.fields.DateField', [], {})
    148. 

  148.         },
    149. 

  149.         'project.proposalrow': {
    150. 

  150.             'Meta': {'object_name': 'ProposalRow'},
    151. 

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

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

  153.             'ownedobject_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.OwnedObject']", 'unique': 'True', 'primary_key': 'True'}),
    154. 

  154.             'proposal': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'proposal_rows'", 'to': "orm['project.Proposal']"}),
    155. 

  155.             'quantity': ('django.db.models.fields.DecimalField', [], {'max_digits': '5', 'decimal_places': '1'}),
    156. 

  156.             'unit_price': ('django.db.models.fields.DecimalField', [], {'max_digits': '12', 'decimal_places': '2'})
    157. 

  157.         }
    158. 

  158.     }
    159. 

  159. 

  160.     complete_apps = ['project']
    161.