API tools faq
paste
Advertisement
Guest User

migration 0003

a guest
Sep 2nd, 2014
192
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 17.31 KB | None | 0 0
raw download clone embed print report
  1. # -*- coding: utf-8 -*-
  2. import datetime
  3. from south.db import db
  4. from south.v2 import SchemaMigration
  5. from django.db import models
  6.  
  7.  
  8. class Migration(SchemaMigration):
  9.  
  10.     def forwards(self, orm):
  11.         # Adding model 'SubscriptionInterval'
  12.         db.add_column('resources_subscriptioninterval', 'content_type', self.gf('django.db.models.fields.related.ForeignKey')(default=1, to=orm['contenttypes.ContentType']), keep_default=False)
  13.  
  14.         db.add_column('resources_subscriptioninterval', 'object_id', self.gf('django.db.models.fields.PositiveIntegerField')(default=1),
  15.                       keep_default=False)
  16.  
  17.  
  18.         # Adding unique constraint on 'SubscriptionInterval', fields ['content_type', 'object_id', 'datetime_subscribed', 'datetime_unsubscribed']
  19.         db.create_unique('resources_subscriptioninterval', ['content_type_id', 'object_id', 'datetime_subscribed', 'datetime_unsubscribed'])
  20.  
  21.         # Adding model 'BaseReport'
  22.         db.create_table('resources_basereport', (
  23.             ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
  24.             ('resource_subscription', self.gf('django.db.models.fields.related.ForeignKey')(related_name='reports', db_column='yandex_account_subscription_id', to=orm['resources.ResourceSubscription'])),
  25.             ('position', self.gf('django.db.models.fields.IntegerField')()),
  26.             ('search_depth', self.gf('django.db.models.fields.IntegerField')()),
  27.             ('datestamp', self.gf('django.db.models.fields.DateField')()),
  28.         ))
  29.         db.send_create_signal('resources', ['BaseReport'])
  30.  
  31.         # Adding field 'ViewEntry.content_type'
  32.         db.add_column('monitoringengine_ui_viewentry', 'content_type',
  33.                       self.gf('django.db.models.fields.related.ForeignKey')(default=1, to=orm['contenttypes.ContentType']),
  34.                       keep_default=False)
  35.  
  36.         # Adding field 'ViewEntry.object_id'
  37.         db.add_column('monitoringengine_ui_viewentry', 'object_id',
  38.                       self.gf('django.db.models.fields.PositiveIntegerField')(default=1),
  39.                       keep_default=False)
  40.  
  41.  
  42.         # Adding M2M table for field google_regions on 'Resource'
  43.         db.create_table('monitoringengine_ui_resource_google_regions', (
  44.             ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
  45.             ('resource', models.ForeignKey(orm['resources.resource'], null=False)),
  46.             ('googleregion', models.ForeignKey(orm['queries.googleregion'], null=False))
  47.         ))
  48.         db.create_unique('monitoringengine_ui_resource_google_regions', ['resource_id', 'googleregion_id'])
  49.  
  50.  
  51.     def backwards(self, orm):
  52.         # Removing unique constraint on 'SubscriptionInterval', fields ['content_type', 'object_id', 'datetime_subscribed', 'datetime_unsubscribed']
  53.         db.delete_unique('resources_subscriptioninterval', ['content_type_id', 'object_id', 'datetime_subscribed', 'datetime_unsubscribed'])
  54.  
  55.         # Deleting model 'SubscriptionInterval'
  56.         db.delete_table('resources_subscriptioninterval')
  57.  
  58.         # Deleting model 'BaseReport'
  59.         db.delete_table('resources_basereport')
  60.  
  61.         # Deleting field 'ViewEntry.content_type'
  62.         db.delete_column('monitoringengine_ui_viewentry', 'content_type_id')
  63.  
  64.         # Deleting field 'ViewEntry.object_id'
  65.         db.delete_column('monitoringengine_ui_viewentry', 'object_id')
  66.  
  67.         # Adding field 'Resource.is_active'
  68.         db.add_column('monitoringengine_ui_resource', 'is_active',
  69.                       self.gf('django.db.models.fields.BooleanField')(default=False),
  70.                       keep_default=False)
  71.  
  72.         # Deleting field 'Resource.deactivation_date'
  73.         db.delete_column('monitoringengine_ui_resource', 'deactivation_date')
  74.  
  75.         # Removing M2M table for field google_regions on 'Resource'
  76.         db.delete_table('monitoringengine_ui_resource_google_regions')
  77.  
  78.  
  79.     models = {
  80.         'auth.permission': {
  81.             'Meta': {'ordering': "('content_type__app_label', 'content_type__model', 'codename')", 'unique_together': "(('content_type', 'codename'),)", 'object_name': 'Permission'},
  82.             'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
  83.             'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}),
  84.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  85.             'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
  86.         },
  87.         'contenttypes.contenttype': {
  88.             'Meta': {'ordering': "('name',)", 'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"},
  89.             'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
  90.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  91.             'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
  92.             'name': ('django.db.models.fields.CharField', [], {'max_length': '100'})
  93.         },
  94.         'monitoringengine_ui.objectpermission': {
  95.             'Meta': {'unique_together': "(('perm_type', 'content_type', 'object_id'),)", 'object_name': 'ObjectPermission'},
  96.             'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}),
  97.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  98.             'object_id': ('django.db.models.fields.PositiveIntegerField', [], {}),
  99.             'perm_type': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
  100.             'permission': ('django.db.models.fields.related.OneToOneField', [], {'related_name': "'object_permission'", 'unique': 'True', 'to': "orm['auth.Permission']"})
  101.         },
  102.         'queries.basesubscription': {
  103.             'Meta': {'object_name': 'BaseSubscription'},
  104.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  105.             'query': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'subscriptions'", 'to': "orm['queries.Query']"}),
  106.             'region': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'subscriptions'", 'db_column': "'yandex_region_id'", 'to': "orm['queries.YandexRegion']"})
  107.         },
  108.         'queries.googleregion': {
  109.             'Meta': {'object_name': 'GoogleRegion', 'db_table': "'google_regions'", 'managed': 'False'},
  110.             'gname': ('django.db.models.fields.IntegerField', [], {}),
  111.             'gurl': ('django.db.models.fields.CharField', [], {'max_length': '250'}),
  112.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  113.             'name': ('django.db.models.fields.CharField', [], {'max_length': '250'})
  114.         },
  115.         'queries.googlesubscription': {
  116.             'Meta': {'managed': 'False', 'object_name': 'GoogleSubscription', 'db_table': "'google_subscriptions'", '_ormbases': ['queries.BaseSubscription']},
  117.             'basesubscription_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['queries.BaseSubscription']", 'unique': 'True', 'primary_key': 'True'})
  118.         },
  119.         'queries.query': {
  120.             'Meta': {'object_name': 'Query', 'db_table': "'queries'", 'managed': 'False'},
  121.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  122.             'querystring': ('django.db.models.fields.CharField', [], {'max_length': '250'})
  123.         },
  124.         'queries.yandexregion': {
  125.             'Meta': {'object_name': 'YandexRegion', 'db_table': "'yandex_regions'", 'managed': 'False'},
  126.             'code': ('django.db.models.fields.IntegerField', [], {}),
  127.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  128.             'name': ('django.db.models.fields.CharField', [], {'max_length': '250'})
  129.         },
  130.         'queries.yandexsubscription': {
  131.             'Meta': {'managed': 'False', 'object_name': 'YandexSubscription', 'db_table': "'yandex_subscriptions'", '_ormbases': ['queries.BaseSubscription']},
  132.             'basesubscription_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['queries.BaseSubscription']", 'unique': 'True', 'primary_key': 'True'})
  133.         },
  134.         'resources.account': {
  135.             'Meta': {'object_name': 'Account', 'db_table': "'monitoringengine_ui_account'"},
  136.             'account_type': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
  137.             'address': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
  138.             'email': ('django.db.models.fields.EmailField', [], {'max_length': '75'}),
  139.             'fio': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
  140.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  141.             'inn': ('django.db.models.fields.CharField', [], {'max_length': '12', 'null': 'True'}),
  142.             'kpp': ('django.db.models.fields.CharField', [], {'max_length': '9', 'null': 'True'}),
  143.             'max_subscriptions_number': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
  144.             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
  145.             'org_full_title': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
  146.             'org_short_title': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
  147.             'phone': ('django.db.models.fields.CharField', [], {'max_length': '15'})
  148.         },
  149.         'resources.basereport': {
  150.             'Meta': {'ordering': "['datestamp']", 'object_name': 'BaseReport'},
  151.             'datestamp': ('django.db.models.fields.DateField', [], {}),
  152.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  153.             'position': ('django.db.models.fields.IntegerField', [], {}),
  154.             'resource_subscription': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'reports'", 'db_column': "'yandex_account_subscription_id'", 'to': "orm['resources.ResourceSubscription']"}),
  155.             'search_depth': ('django.db.models.fields.IntegerField', [], {})
  156.         },
  157.         'resources.fixeddate': {
  158.             'Meta': {'object_name': 'FixedDate', 'db_table': "'monitoringengine_ui_fixeddate'"},
  159.             'date': ('django.db.models.fields.DateField', [], {}),
  160.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  161.             'view': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'fixed_dates'", 'symmetrical': 'False', 'to': "orm['resources.View']"})
  162.         },
  163.         'resources.googlereport': {
  164.             'Meta': {'ordering': "['datestamp']", 'managed': 'False', 'object_name': 'GoogleReport', 'db_table': "'google_reports'", '_ormbases': ['resources.BaseReport']},
  165.             'basereport_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['resources.BaseReport']", 'unique': 'True', 'primary_key': 'True'})
  166.         },
  167.         'resources.googleresourcesubscription': {
  168.             'Meta': {'object_name': 'GoogleResourceSubscription', 'db_table': "'google_accounts_subscriptions'", 'managed': 'False'},
  169.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  170.             'resource': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'google_resource_subscriptions'", 'to': "orm['resources.Resource']"}),
  171.             'search_depth': ('django.db.models.fields.IntegerField', [], {}),
  172.             'subdomain_include': ('resources.models.SubdomainIncludeField', [], {}),
  173.             'subscription': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'resource_subscriptions'", 'db_column': "'yandex_subscription_id'", 'to': "orm['queries.GoogleSubscription']"}),
  174.             'visible': ('django.db.models.fields.BooleanField', [], {'default': 'False'})
  175.         },
  176.         'resources.report': {
  177.             'Meta': {'ordering': "['datestamp']", 'managed': 'False', 'object_name': 'Report', 'db_table': "'yandex_reports'", '_ormbases': ['resources.BaseReport']},
  178.             'basereport_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['resources.BaseReport']", 'unique': 'True', 'primary_key': 'True'})
  179.         },
  180.         'resources.resource': {
  181.             'Meta': {'object_name': 'Resource', 'db_table': "'monitoringengine_ui_resource'"},
  182.             'account': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'resources'", 'to': "orm['resources.Account']"}),
  183.             'bing': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
  184.             'deactivation_date': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
  185.             'google': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
  186.             'google_regions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['queries.GoogleRegion']", 'symmetrical': 'False'}),
  187.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  188.             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
  189.             'note': ('django.db.models.fields.CharField', [], {'max_length': '250'}),
  190.             'regions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['queries.YandexRegion']", 'symmetrical': 'False'}),
  191.             'search_depth': ('django.db.models.fields.IntegerField', [], {'default': '200'}),
  192.             'subdomain_include': ('resources.models.SubdomainIncludeField', [], {}),
  193.             'time_zone': ('django.db.models.fields.IntegerField', [], {}),
  194.             'website': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'resources'", 'to': "orm['resources.Website']"}),
  195.             'yandex': ('django.db.models.fields.BooleanField', [], {'default': 'False'})
  196.         },
  197.         'resources.resourcesubscription': {
  198.             'Meta': {'object_name': 'ResourceSubscription', 'db_table': "'yandex_accounts_subscriptions'", 'managed': 'False'},
  199.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  200.             'resource': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'resource_subscriptions'", 'to': "orm['resources.Resource']"}),
  201.             'search_depth': ('django.db.models.fields.IntegerField', [], {}),
  202.             'subdomain_include': ('resources.models.SubdomainIncludeField', [], {}),
  203.             'subscription': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'resource_subscriptions'", 'db_column': "'yandex_subscription_id'", 'to': "orm['queries.YandexSubscription']"}),
  204.             'visible': ('django.db.models.fields.BooleanField', [], {'default': 'False'})
  205.         },
  206.         'resources.subscriptioninterval': {
  207.             'Meta': {'unique_together': "(('content_type', 'object_id', 'datetime_subscribed', 'datetime_unsubscribed'),)", 'object_name': 'SubscriptionInterval'},
  208.             'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}),
  209.             'datetime_subscribed': ('django.db.models.fields.DateTimeField', [], {}),
  210.             'datetime_unsubscribed': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
  211.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  212.             'object_id': ('django.db.models.fields.PositiveIntegerField', [], {}),
  213.             'resource_subscription': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'subscription_intervals'", 'to': "orm['resources.ResourceSubscription']"})
  214.         },
  215.         'resources.view': {
  216.             'Meta': {'object_name': 'View', 'db_table': "'monitoringengine_ui_view'"},
  217.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  218.             'last_changed': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
  219.             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
  220.             'resource': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'views'", 'to': "orm['resources.Resource']"})
  221.         },
  222.         'resources.viewentry': {
  223.             'Meta': {'ordering': "['sorting_order']", 'object_name': 'ViewEntry', 'db_table': "'monitoringengine_ui_viewentry'"},
  224.             'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}),
  225.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  226.             'object_id': ('django.db.models.fields.PositiveIntegerField', [], {}),
  227.             'sorting_order': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
  228.             'subscription': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['resources.ResourceSubscription']"}),
  229.             'view': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'entries'", 'to': "orm['resources.View']"})
  230.         },
  231.         'resources.website': {
  232.             'Meta': {'object_name': 'Website', 'db_table': "'websites'", 'managed': 'False'},
  233.             'hostname': ('django.db.models.fields.CharField', [], {'max_length': '250'}),
  234.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
  235.         }
  236.     }
  237.  
  238.     complete_apps = ['resources']
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!