/site/core/migrations/0025_auto__add_valuehistorymem__add_valuehistory.py

https://bitbucket.org/mohjive/automagically
Python | 186 lines | 173 code | 8 blank | 5 comment | 0 complexity | 9b464a8f4508ff6b866688594ee89d8a MD5 | raw file
    

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

  2. import datetime
    3. 

  3. from south.db import db
    4. 

  4. from south.v2 import SchemaMigration
    5. 

  5. from django.db import models
    6. 

  6. 

  7. 

  8. class Migration(SchemaMigration):
    9. 

  9. 

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

  11.         # Adding model 'ValueHistoryMem'
    12. 

  12.         db.create_table('core_valuehistorymem', (
    13. 

  13.             ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
    14. 

  14.             ('key', self.gf('django.db.models.fields.CharField')(max_length=10, blank=True)),
    15. 

  15.             ('value', self.gf('django.db.models.fields.CharField')(max_length=30)),
    16. 

  16.             ('dataType', self.gf('django.db.models.fields.IntegerField')(default=0)),
    17. 

  17.             ('timestamp', self.gf('django.db.models.fields.DateTimeField')()),
    18. 

  18.         ))
    19. 

  19.         db.send_create_signal('core', ['ValueHistoryMem'])
    20. 

  20. 

  21.         # Adding model 'ValueHistory'
    22. 

  22.         db.create_table('core_valuehistory', (
    23. 

  23.             ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
    24. 

  24.             ('key', self.gf('django.db.models.fields.CharField')(max_length=10, blank=True)),
    25. 

  25.             ('value', self.gf('django.db.models.fields.CharField')(max_length=30)),
    26. 

  26.             ('dataType', self.gf('django.db.models.fields.IntegerField')(default=0)),
    27. 

  27.             ('timestamp', self.gf('django.db.models.fields.DateTimeField')()),
    28. 

  28.         ))
    29. 

  29.         db.send_create_signal('core', ['ValueHistory'])
    30. 

  30. 

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

  32.         # Deleting model 'ValueHistoryMem'
    33. 

  33.         db.delete_table('core_valuehistorymem')
    34. 

  34. 

  35.         # Deleting model 'ValueHistory'
    36. 

  36.         db.delete_table('core_valuehistory')
    37. 

  37. 

  38.     models = {
    39. 

  39.         'core.command': {
    40. 

  40.             'Meta': {'object_name': 'Command'},
    41. 

  41.             'argInt': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
    42. 

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

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

  44.         },
    45. 

  45.         'core.currentvalue': {
    46. 

  46.             'Meta': {'object_name': 'CurrentValue'},
    47. 

  47.             'dataType': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    48. 

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

  49.             'key': ('django.db.models.fields.CharField', [], {'max_length': '10', 'blank': 'True'}),
    50. 

  50.             'lastUpdated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
    51. 

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

  52.         },
    53. 

  53.         'core.device': {
    54. 

  54.             'Meta': {'object_name': 'Device'},
    55. 

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

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

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

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

  59.             'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '40'}),
    60. 

  60.             'onOff': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    61. 

  61.             'order': ('django.db.models.fields.PositiveIntegerField', [], {'default': '100'})
    62. 

  62.         },
    63. 

  63.         'core.deviceevent': {
    64. 

  64.             'Meta': {'object_name': 'DeviceEvent'},
    65. 

  65.             'command': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['core.Command']"}),
    66. 

  66.             'device': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['core.RawTellstickDevice']"}),
    67. 

  67.             'doneAt': ('django.db.models.fields.DateTimeField', [], {}),
    68. 

  68.             'external': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    69. 

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

  70.         },
    71. 

  71.         'core.event': {
    72. 

  72.             'Meta': {'object_name': 'Event'},
    73. 

  73.             'command': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['core.Command']"}),
    74. 

  74.             'condition': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['core.GlobalVariable']", 'null': 'True', 'blank': 'True'}),
    75. 

  75.             'device': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['core.Device']"}),
    76. 

  76.             'doAt': ('django.db.models.fields.DateTimeField', [], {}),
    77. 

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

  78.             'schedule': ('django.db.models.fields.related.ForeignKey', [], {'default': 'None', 'to': "orm['core.ScheduledEvent']", 'null': 'True', 'blank': 'True'})
    79. 

  79.         },
    80. 

  80.         'core.globalvariable': {
    81. 

  81.             'Meta': {'object_name': 'GlobalVariable'},
    82. 

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

  83.             'hidden': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
    84. 

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

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

  86.         },
    87. 

  87.         'core.groupdevice': {
    88. 

  88.             'Meta': {'object_name': 'GroupDevice', '_ormbases': ['core.Device']},
    89. 

  89.             'device_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.Device']", 'unique': 'True', 'primary_key': 'True'}),
    90. 

  90.             'subDevices': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'subdevices'", 'symmetrical': 'False', 'to': "orm['core.Device']"})
    91. 

  91.         },
    92. 

  92.         'core.preset': {
    93. 

  93.             'Meta': {'object_name': 'Preset', '_ormbases': ['core.Device']},
    94. 

  94.             'device_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.Device']", 'unique': 'True', 'primary_key': 'True'})
    95. 

  95.         },
    96. 

  96.         'core.presetentry': {
    97. 

  97.             'Meta': {'object_name': 'PresetEntry'},
    98. 

  98.             'command': ('django.db.models.fields.related.ForeignKey', [], {'default': '102', 'to': "orm['core.Command']"}),
    99. 

  99.             'device': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['core.Device']"}),
    100. 

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

  101.             'order': ('django.db.models.fields.PositiveIntegerField', [], {'default': '1'}),
    102. 

  102.             'presetDevice': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'entries'", 'to': "orm['core.Preset']"})
    103. 

  103.         },
    104. 

  104.         'core.rawdeviceevent': {
    105. 

  105.             'Meta': {'object_name': 'RawDeviceEvent'},
    106. 

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

  107.             'data': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '100'}),
    108. 

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

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

  110.         },
    111. 

  111.         'core.rawtellstickdevice': {
    112. 

  112.             'Meta': {'object_name': 'RawTellstickDevice', '_ormbases': ['core.Device']},
    113. 

  113.             'code': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '20', 'blank': 'True'}),
    114. 

  114.             'deviceId': ('django.db.models.fields.PositiveIntegerField', [], {'default': '9999'}),
    115. 

  115.             'device_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.Device']", 'unique': 'True', 'primary_key': 'True'}),
    116. 

  116.             'house': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '20', 'blank': 'True'}),
    117. 

  117.             'protocol': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '40'}),
    118. 

  118.             'rawName': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '100'}),
    119. 

  119.             'unit': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '20', 'blank': 'True'})
    120. 

  120.         },
    121. 

  121.         'core.scheduledevent': {
    122. 

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

  123.             'command': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['core.Command']"}),
    124. 

  124.             'condition': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['core.GlobalVariable']", 'null': 'True', 'blank': 'True'}),
    125. 

  125.             'device': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['core.Device']"}),
    126. 

  126.             'doAt': ('django.db.models.fields.TimeField', [], {'default': 'datetime.time(6, 0)'}),
    127. 

  127.             'doFriday': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    128. 

  128.             'doMonday': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    129. 

  129.             'doSaturday': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    130. 

  130.             'doSunday': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    131. 

  131.             'doThursday': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    132. 

  132.             'doTuesday': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    133. 

  133.             'doWednesday': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    134. 

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

  135.             'relativeTime': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    136. 

  136.             'relativeTo': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'})
    137. 

  137.         },
    138. 

  138.         'core.sendsignaldevice': {
    139. 

  139.             'Meta': {'object_name': 'SendSignalDevice', '_ormbases': ['core.Device']},
    140. 

  140.             'device_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.Device']", 'unique': 'True', 'primary_key': 'True'}),
    141. 

  141.             'signalOff': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '100', 'blank': 'True'}),
    142. 

  142.             'signalOn': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '100'})
    143. 

  143.         },
    144. 

  144.         'core.sensoreventraw': {
    145. 

  145.             'Meta': {'object_name': 'SensorEventRaw'},
    146. 

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

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

  148.             'model': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '40'}),
    149. 

  149.             'protocol': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '100'}),
    150. 

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

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

  152.             'value': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '20'})
    153. 

  153.         },
    154. 

  154.         'core.timerdevice': {
    155. 

  155.             'Meta': {'object_name': 'TimerDevice', '_ormbases': ['core.Device']},
    156. 

  156.             'command': ('django.db.models.fields.related.ForeignKey', [], {'default': '102', 'to': "orm['core.Command']"}),
    157. 

  157.             'condition': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['core.GlobalVariable']", 'null': 'True', 'blank': 'True'}),
    158. 

  158.             'delayMinutes': ('django.db.models.fields.PositiveIntegerField', [], {'default': '1'}),
    159. 

  159.             'device_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.Device']", 'unique': 'True', 'primary_key': 'True'}),
    160. 

  160.             'subDevice': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'subdevice'", 'to': "orm['core.Device']"})
    161. 

  161.         },
    162. 

  162.         'core.valuehistory': {
    163. 

  163.             'Meta': {'object_name': 'ValueHistory'},
    164. 

  164.             'dataType': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    165. 

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

  166.             'key': ('django.db.models.fields.CharField', [], {'max_length': '10', 'blank': 'True'}),
    167. 

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

  168.             'value': ('django.db.models.fields.CharField', [], {'max_length': '30'})
    169. 

  169.         },
    170. 

  170.         'core.valuehistorymem': {
    171. 

  171.             'Meta': {'object_name': 'ValueHistoryMem'},
    172. 

  172.             'dataType': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    173. 

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

  174.             'key': ('django.db.models.fields.CharField', [], {'max_length': '10', 'blank': 'True'}),
    175. 

  175.             'timestamp': ('django.db.models.fields.DateTimeField', [], {}),
    176. 

  176.             'value': ('django.db.models.fields.CharField', [], {'max_length': '30'})
    177. 

  177.         },
    178. 

  178.         'core.woldevice': {
    179. 

  179.             'Meta': {'object_name': 'WolDevice', '_ormbases': ['core.Device']},
    180. 

  180.             'device_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.Device']", 'unique': 'True', 'primary_key': 'True'}),
    181. 

  181.             'ip': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '15', 'blank': 'True'}),
    182. 

  182.             'mac': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '17'})
    183. 

  183.         }
    184. 

  184.     }
    185. 

  185. 

  186.     complete_apps = ['core']
    187.