def test_distinct_values_of(self):
user, new = User.objects.get_or_create(name="Sergio Mena")
role_lst = []
with BlockSave(Role):
for i in range(1, 6, 1):
role = Role(name="Musician%s" % i, usr=user)
role.save()
role_lst.append(role)
user_dict_1 = Role.objects.filter(
name="Musician1").distinct_values_of("usr_id")
assert sum(user_dict_1.values()) == 1
user_dict_2 = Role.objects.filter(
usr_id=user.key).distinct_values_of("usr_id")
assert sum(user_dict_2.values()) == 5
Role.objects.filter(active=True).delete()
with BlockSave(Role, query_dict={'active': True}):
for i, r in enumerate(role_lst):
if i == 3:
pass
else:
r.active = True
r.save()
user_dict_3 = Role.objects.filter(
active=True).distinct_values_of("usr_id")
assert sum(user_dict_3.values()) == 4
new_user = User(name="Valnetin Hegg")
new_user.blocking_save()
role_lst[0].usr = new_user
role_lst[0].blocking_save(query_dict={'usr': new_user})
user_dict_4 = Role.objects.filter(
active=True, usr_id=user.key).distinct_values_of("usr_id")
assert sum(user_dict_4.values()) == 3
with BlockDelete(Role):
for r in role_lst:
r.delete()
def test_distinct_values_of(self):
user, new = User.objects.get_or_create(name="Sergio Mena")
role_lst = []
with BlockSave(Role):
for i in range(1, 6, 1):
role = Role(name="Musician%s" % i, usr=user)
role.save()
role_lst.append(role)
user_dict_1 = Role.objects.filter(name="Musician1").distinct_values_of("usr_id")
assert sum(user_dict_1.values()) == 1
user_dict_2 = Role.objects.filter(usr_id=user.key).distinct_values_of("usr_id")
assert sum(user_dict_2.values()) == 5
Role.objects.filter(active=True).delete()
with BlockSave(Role, query_dict={'active': True}):
for i, r in enumerate(role_lst):
if i == 3:
pass
else:
r.active = True
r.save()
user_dict_3 = Role.objects.filter(active=True).distinct_values_of("usr_id")
assert sum(user_dict_3.values()) == 4
new_user = User(name="Valnetin Hegg")
new_user.blocking_save()
role_lst[0].usr = new_user
role_lst[0].blocking_save(query_dict={'usr': new_user})
user_dict_4 = Role.objects.filter(active=True, usr_id=user.key).distinct_values_of("usr_id")
assert sum(user_dict_4.values()) == 3
with BlockDelete(Role):
for r in role_lst:
r.delete()
