class UserTest(TestCase):
    def test_create(self):
        user = User.objects.create(username='login1', password='haslo')

        self.assertEqual(user.pk, User.objects.get(password='haslo').pk)
        self.assertEqual(user.password, User.objects.get(pk=user.pk).password)

    def test_update(self):
        user = User.objects.create(username='login2', password='haslo2')

        User.objects.filter(pk=user.pk).update(password='haslo3')
        self.assertEqual(user.pk, User.objects.get(password='haslo3').pk)

        user_test = User.objects.get(pk=user.pk)

        self.assertEqual(user_test.password, 'haslo3')

    def test_read(self):
        user = User.objects.create(username='Olek', password='Olek12')
        user1 = User.objects.create(username='Adam', password='Olek12')
        user2 = User.objects.create(username='Jacek', password='Jacek12')

        lista = User.objects.get(pk=user.pk)
        self.assertEqual(lista.username, 'Olek')

        result = User.objects.all().order_by("username").reverse()
        self.assertEqual(result[0].username, 'Olek')
        self.assertEqual(result[1].username, 'Jacek')
        self.assertEqual(result[2].username, 'Adam')
        self.assertLess(result[1].username, result[0].username)
        self.assertLess(result[2].username, result[1].username)

        self.assertEqual(len(User.objects.filter(password='Olek12')), 2)

    def test_delete(self):
        user = User.objects.create(username='Olek', password='Olek12')
        user1 = User.objects.create(username='Adam', password='Adam12')

        User.objects.filter(pk=user.pk).delete()

        self.assertEqual(len(User.objects.filter(username='Olek')), 0)
        self.assertEqual(len(User.objects.filter(username='Adam')), 1)