def test_switching_search_path(self): tenant1 = Tenant(domain_url='something.test.com', schema_name='tenant1') tenant1.save(verbosity=BaseTestCase.get_verbosity()) connection.set_schema_to_public() tenant2 = Tenant(domain_url='example.com', schema_name='tenant2') tenant2.save(verbosity=BaseTestCase.get_verbosity()) # go to tenant1's path connection.set_tenant(tenant1) # add some data, 2 DummyModels for tenant1 DummyModel(name="Schemas are").save() DummyModel(name="awesome!").save() # switch temporarily to tenant2's path with tenant_context(tenant2): # add some data, 3 DummyModels for tenant2 DummyModel(name="Man,").save() DummyModel(name="testing").save() DummyModel(name="is great!").save() # we should be back to tenant1's path, test what we have self.assertEqual(2, DummyModel.objects.count()) # switch back to tenant2's path with tenant_context(tenant2): self.assertEqual(3, DummyModel.objects.count())
def test_switching_search_path(self): tenant1 = Tenant(domain_url='something.test.com', schema_name='tenant1') tenant1.save(verbosity=BaseTestCase.get_verbosity()) connection.set_schema_to_public() tenant2 = Tenant(domain_url='example.com', schema_name='tenant2') tenant2.save(verbosity=BaseTestCase.get_verbosity()) # go to tenant1's path connection.set_tenant(tenant1) # add some data, 2 DummyModels for tenant1 DummyModel(name="Schemas are").save() DummyModel(name="awesome!").save() # switch temporarily to tenant2's path with tenant_context(tenant2): # add some data, 3 DummyModels for tenant2 DummyModel(name="Man,").save() DummyModel(name="testing").save() DummyModel(name="is great!").save() # we should be snello to tenant1's path, test what we have self.assertEqual(2, DummyModel.objects.count()) # switch snello to tenant2's path with tenant_context(tenant2): self.assertEqual(3, DummyModel.objects.count())
def test_command(self): """ Tests that tenant_command is capable of wrapping commands and its parameters. """ settings.SHARED_APPS = ( "tenant_schemas", "django.contrib.contenttypes", ) settings.TENANT_APPS = () settings.INSTALLED_APPS = settings.SHARED_APPS + settings.TENANT_APPS self.sync_shared() Tenant( domain_url="localhost", schema_name="public").save(verbosity=BaseTestCase.get_verbosity()) out = StringIO() tenant_command.Command().handle( "dumpdata", get_public_schema_name(), "tenant_schemas", natural_foreign=True, stdout=out, ) self.assertJSONEqual( out.getvalue(), [{ "fields": { "domain_url": "localhost", "schema_name": "public" }, "model": "tenant_schemas.tenant", "pk": 1, }], )
def test_auto_drop_schema_bulk_delete(self): """ When bulk deleting tenants, it should also drop the schemas of tenants that have auto_drop_schema set to True. """ Tenant.auto_drop_schema = True schemas = ['auto_drop_schema1', 'auto_drop_schema2'] for schema in schemas: self.assertFalse(schema_exists(schema)) tenant = Tenant(domain_url='%s.test.com' % schema, schema_name=schema) tenant.save(verbosity=BaseTestCase.get_verbosity()) self.assertTrue(schema_exists(tenant.schema_name)) # Force pending trigger events to be executed cursor = connection.cursor() cursor.execute('SET CONSTRAINTS ALL IMMEDIATE') # get a queryset of our 2 tenants and do a bulk delete Tenant.objects.filter(schema_name__in=schemas).delete() # verify that the schemas where deleted for schema in schemas: self.assertFalse(schema_exists(schema)) Tenant.auto_drop_schema = False
def test_auto_drop_schema_bulk_delete(self): """ When bulk deleting tenants, it should also drop the schemas of tenants that have auto_drop_schema set to True. """ Tenant.auto_drop_schema = True schemas = ['auto_drop_schema1', 'auto_drop_schema2'] for schema in schemas: self.assertFalse(schema_exists(schema)) tenant = Tenant( domain_url='%s.test.com' % schema, schema_name=schema ) tenant.save(verbosity=BaseTestCase.get_verbosity()) self.assertTrue(schema_exists(tenant.schema_name)) # Force pending trigger events to be executed cursor = connection.cursor() cursor.execute('SET CONSTRAINTS ALL IMMEDIATE') # get a queryset of our 2 tenants and do a bulk delete Tenant.objects.filter(schema_name__in=schemas).delete() # verify that the schemas where deleted for schema in schemas: self.assertFalse(schema_exists(schema)) Tenant.auto_drop_schema = False
def test_tenant_apps_and_shared_apps_can_have_the_same_apps(self): """ Tests that both SHARED_APPS and TENANT_APPS can have apps in common. In this case they should get synced to both tenant and public schemas. """ settings.SHARED_APPS = ( 'tenant_schemas', # 2 tables 'django.contrib.auth', # 6 tables 'django.contrib.contenttypes', # 1 table 'django.contrib.sessions', ) # 1 table settings.TENANT_APPS = ('django.contrib.sessions', ) # 1 table settings.INSTALLED_APPS = settings.SHARED_APPS + settings.TENANT_APPS self.sync_shared() tenant = Tenant(domain_url='arbitrary.test.com', schema_name='test') tenant.save(verbosity=BaseTestCase.get_verbosity()) shared_tables = self.get_tables_list_in_schema( get_public_schema_name()) tenant_tables = self.get_tables_list_in_schema(tenant.schema_name) self.assertEqual(2 + 6 + 1 + 1 + self.MIGRATION_TABLE_SIZE, len(shared_tables)) self.assertIn('django_session', shared_tables) self.assertEqual(1 + self.MIGRATION_TABLE_SIZE, len(tenant_tables)) self.assertIn('django_session', tenant_tables)
def test_command(self): """ Tests that tenant_command is capable of wrapping commands and its parameters. """ settings.SHARED_APPS = ( 'tenant_schemas', 'django.contrib.contenttypes', ) settings.TENANT_APPS = () settings.INSTALLED_APPS = settings.SHARED_APPS + settings.TENANT_APPS self.sync_shared() Tenant( domain_url='localhost', schema_name='public').save(verbosity=BaseTestCase.get_verbosity()) out = StringIO() call_command('tenant_command', args=('dumpdata', 'tenant_schemas'), natural_foreign=True, schema_name=get_public_schema_name(), stdout=out) self.assertEqual( json.loads( '[{"fields": {"domain_url": "localhost", "schema_name": "public"}, ' '"model": "tenant_schemas.tenant", "pk": 1}]'), json.loads(out.getvalue()))
def test_tenant_schema_is_created(self): """ When saving a tenant, it's schema should be created. """ tenant = Tenant(domain_url='something.test.com', schema_name='test') tenant.save(verbosity=BaseTestCase.get_verbosity()) self.assertTrue(schema_exists(tenant.schema_name))
def setUp(self): super(RoutesTestCase, self).setUp() self.factory = RequestFactory() self.tm = TenantMiddleware() self.tenant_domain = 'tenant.test.com' self.tenant = Tenant(domain_url=self.tenant_domain, schema_name='test') self.tenant.save(verbosity=BaseTestCase.get_verbosity())
def test_non_auto_sync_tenant(self): """ When saving a tenant that has the flag auto_create_schema as False, the schema should not be created when saving the tenant. """ self.assertFalse(schema_exists('non_auto_sync_tenant')) tenant = NonAutoSyncTenant(domain_url='something.test.com', schema_name='non_auto_sync_tenant') tenant.save(verbosity=BaseTestCase.get_verbosity()) self.assertFalse(schema_exists(tenant.schema_name))
def setUpClass(cls): super(RoutesTestCase, cls).setUpClass() settings.SHARED_APPS = ('tenant_schemas', ) settings.TENANT_APPS = ('dts_test_app', 'django.contrib.contenttypes', 'django.contrib.auth', ) settings.INSTALLED_APPS = settings.SHARED_APPS + settings.TENANT_APPS cls.sync_shared() cls.public_tenant = Tenant(domain_url='test.com', schema_name=get_public_schema_name()) cls.public_tenant.save(verbosity=BaseTestCase.get_verbosity())
def test_switching_tenant_without_previous_tenant(self): tenant = Tenant(domain_url='something.test.com', schema_name='test') tenant.save(verbosity=BaseTestCase.get_verbosity()) connection.tenant = None with tenant_context(tenant): DummyModel(name="No exception please").save() connection.tenant = None with schema_context(tenant.schema_name): DummyModel(name="Survived it!").save()
def test_throw_exception_if_db_not_specified(self): """ When saving a tenant without 'using' kwarg of save method throw MultiDBError """ tenant = Tenant(domain_url='something.test.com', schema_name='test') try: tenant.save( verbosity=BaseTestCase.get_verbosity()) except Exception as e: self.assertTrue(isinstance(e, MultipleDBError))
def setUp(self): super(RoutesTestCase, self).setUp() self.factory = RequestFactory() self.tm = TenantMiddleware() self.dtm = DefaultTenantMiddleware() self.tenant_domain = 'tenant.test.com' self.tenant = Tenant(domain_url=self.tenant_domain, schema_name='test') self.tenant.save(verbosity=BaseTestCase.get_verbosity()) self.non_existent_domain = 'no-tenant.test.com' self.non_existent_tenant = Tenant(domain_url=self.non_existent_domain, schema_name='no-tenant') self.url = '/any/path/'
def test_sync_tenant(self): """ When editing an existing tenant, all data should be kept. """ tenant = Tenant(domain_url='something.test.com', schema_name='test') tenant.save(verbosity=BaseTestCase.get_verbosity()) # go to tenant's path connection.set_tenant(tenant) # add some data DummyModel(name="Schemas are").save() DummyModel(name="awesome!").save() # edit tenant connection.set_schema_to_public() tenant.domain_url = 'example.com' tenant.save(verbosity=BaseTestCase.get_verbosity()) connection.set_tenant(tenant) # test if data is still there self.assertEqual(DummyModel.objects.count(), 2)
def test_sync_tenant(self): """ When editing an existing tenant, all data should be kept. """ tenant = Tenant(domain_url='something.test.com', schema_name='test') tenant.save(verbosity=BaseTestCase.get_verbosity()) # go to tenant's path connection.set_tenant(tenant) # add some data DummyModel(name="Schemas are").save() DummyModel(name="awesome!").save() # edit tenant connection.set_schema_to_public() tenant.domain_url = 'example.com' tenant.save(verbosity=BaseTestCase.get_verbosity()) connection.set_tenant(tenant) # test if data is still there self.assertEquals(DummyModel.objects.count(), 2)
def test_tenant_apps_does_not_sync_shared_apps(self): """ Tests that if an app is in TENANT_APPS, it does not get synced to the public schema. """ settings.SHARED_APPS = ('tenant_schemas', 'django.contrib.auth', 'django.contrib.contenttypes', ) settings.TENANT_APPS = ('django.contrib.sessions', ) # 1 table settings.INSTALLED_APPS = settings.SHARED_APPS + settings.TENANT_APPS self.sync_shared() tenant = Tenant(domain_url='arbitrary.test.com', schema_name='test') tenant.save(verbosity=BaseTestCase.get_verbosity()) tenant_tables = self.get_tables_list_in_schema(tenant.schema_name) self.assertEqual(1 + self.MIGRATION_TABLE_SIZE, len(tenant_tables)) self.assertIn('django_session', tenant_tables)
def test_command(self): """ Tests that tenant_command is capable of wrapping commands and its parameters. """ settings.SHARED_APPS = ('tenant_schemas', 'django.contrib.contenttypes', ) settings.TENANT_APPS = () settings.INSTALLED_APPS = settings.SHARED_APPS + settings.TENANT_APPS self.sync_shared() Tenant(domain_url='localhost', schema_name='public').save(verbosity=BaseTestCase.get_verbosity()) out = StringIO() call_command('tenant_command', 'dumpdata', 'tenant_schemas', natural_foreign=True, schema_name=get_public_schema_name(), stdout=out) self.assertItemsEqual( json.loads('[{"fields": {"domain_url": "localhost", "schema_name": "public"}, ' '"model": "tenant_schemas.tenant", "pk": 1}]'), json.loads(out.getvalue()))
def test_auto_drop_schema(self): """ When deleting a tenant with auto_drop_schema=True, it should delete the schema associated with the tenant. """ self.assertFalse(schema_exists('auto_drop_tenant')) Tenant.auto_drop_schema = True tenant = Tenant(domain_url='something.test.com', schema_name='auto_drop_tenant') tenant.save(verbosity=BaseTestCase.get_verbosity()) self.assertTrue(schema_exists(tenant.schema_name)) cursor = connection.cursor() # Force pending trigger events to be executed cursor.execute('SET CONSTRAINTS ALL IMMEDIATE') tenant.delete() self.assertFalse(schema_exists(tenant.schema_name)) Tenant.auto_drop_schema = False
def test_content_types_is_not_mandatory(self): """ Tests that even if content types is in SHARED_APPS, it's not required in TENANT_APPS. """ settings.SHARED_APPS = ('tenant_schemas', # 2 tables 'django.contrib.contenttypes', ) # 1 table settings.TENANT_APPS = ('django.contrib.sessions', ) # 1 table settings.INSTALLED_APPS = settings.SHARED_APPS + settings.TENANT_APPS self.sync_shared() tenant = Tenant(domain_url='something.test.com', schema_name='test') tenant.save(verbosity=BaseTestCase.get_verbosity()) shared_tables = self.get_tables_list_in_schema(get_public_schema_name()) tenant_tables = self.get_tables_list_in_schema(tenant.schema_name) self.assertEqual(2 + 1 + self.MIGRATION_TABLE_SIZE, len(shared_tables)) self.assertIn('django_session', tenant_tables) self.assertEqual(1 + self.MIGRATION_TABLE_SIZE, len(tenant_tables)) self.assertIn('django_session', tenant_tables)
def test_tenant_schema_creation_in_specified_db(self): """ When saving a tenant using a db, its schema should be created in that db """ db = random.choice(get_all_dbs()) tenant = Tenant(domain_url='something1.test.com', schema_name='test1') tenant.save( verbosity=BaseTestCase.get_verbosity(), using=db) for d in get_all_dbs(): if d == db: self.assertTrue(schema_exists( tenant.schema_name, db=d)) else: self.assertFalse(schema_exists( tenant.schema_name, db=d))
def test_tenant_apps_and_shared_apps_can_have_the_same_apps(self): """ Tests that both SHARED_APPS and TENANT_APPS can have apps in common. In this case they should get synced to both tenant and public schemas. """ settings.SHARED_APPS = ('tenant_schemas', # 2 tables 'django.contrib.auth', # 6 tables 'django.contrib.contenttypes', # 1 table 'django.contrib.sessions', ) # 1 table settings.TENANT_APPS = ('django.contrib.sessions', ) # 1 table settings.INSTALLED_APPS = settings.SHARED_APPS + settings.TENANT_APPS self.sync_shared() tenant = Tenant(domain_url='arbitrary.test.com', schema_name='test') tenant.save(verbosity=BaseTestCase.get_verbosity()) shared_tables = self.get_tables_list_in_schema(get_public_schema_name()) tenant_tables = self.get_tables_list_in_schema(tenant.schema_name) self.assertEqual(2 + 6 + 1 + 1 + self.MIGRATION_TABLE_SIZE, len(shared_tables)) self.assertIn('django_session', shared_tables) self.assertEqual(1 + self.MIGRATION_TABLE_SIZE, len(tenant_tables)) self.assertIn('django_session', tenant_tables)