Fakultas Ilmu Komputer UI

tests.py 98.9 KB
Newer Older
1
import json, tempfile, os, mock
2
import pandas as pd
3
from io import StringIO
4
import time
5

6
7
from bs4 import BeautifulSoup
from datetime import datetime
8
from django.conf import settings
9
from django.contrib import messages as dj_messages
10
from django.contrib.auth import get_user_model
11
from django.core import serializers
12
from django.core.files import File
13
from django.core.exceptions import PermissionDenied, ValidationError
14
from django.core.files.uploadedfile import SimpleUploadedFile
15
from django.core.management import call_command
16
from django.test import Client, TestCase, TransactionTestCase
17
from django.urls import resolve, reverse
18
from django.db.utils import IntegrityError
19
20
21
from django.test import Client, RequestFactory, TestCase, TransactionTestCase
from pytz import timezone
from time import sleep
22
import datetime as dt
23

24
from administration.models import VerificationSetting, VerificationReport
25
from administration.utils import id_generator
26
from app.views import UploadMateriHTML, add_rating_materi
27
from authentication.models import User
28
from digipus.settings import TIME_ZONE
29
30
31
from .models import (
    Category,
    Comment,
32
    DislikeComment,
33
34
35
    DownloadStatistics,
    Materi,
    Like,
36
    LikeComment,
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
    Rating,
    ReqMaterial,
    RatingContributor,
    ViewStatistics,
)

from .views import (
    DaftarKatalog,
    DashboardKontributorView,
    DetailMateri,
    ProfilKontributorView,
    SuksesLoginAdminView,
    SuksesLoginKontributorView,
    SuntingProfilView,
    ProfilAdminView,
    PostsView,
    SuntingProfilAdminView,
    RevisiMateriView,
    ReqMateriView,
    KatalogPerKontributorView,
    UploadMateriView,
    UploadMateriExcelView,
Yaumi's avatar
Yaumi committed
59
    PasswordChangeViews,
Yaumi's avatar
Yaumi committed
60
    password_success,
61
    MateriFavorite,
62
)
63
from app.forms import SuntingProfilForm, year_choices
64
from app.utils.fileManagementUtil import get_random_filename, remove_image_exifdata
65

66
ERROR_403_MESSAGE = "Kamu harus login untuk mengakses halaman ini"
Saul Andre's avatar
Saul Andre committed
67

68
69
70
71
72
73
74
75
from django.test import LiveServerTestCase
from selenium import webdriver
from selenium.webdriver.chrome.options import Options
from selenium.webdriver.common.keys import Keys
from webdriver_manager.chrome import ChromeDriverManager
from selenium.common.exceptions import NoSuchElementException


76

77
78
79
class DaftarKatalogTest(TestCase):
    def test_daftar_katalog_url_exist(self):
        url = "/"
80
81
        response = Client().get(f"{url}")
        self.assertEqual(response.status_code, 200)
82
83

    def test_daftar_katalog_using_daftar_katalog_template(self):
84
85
86
        response = Client().get("/")
        self.assertTemplateUsed(response, "app/katalog_materi.html")

87
    def test_daftar_katalog_using_daftar_katalog_func(self):
88
        found = resolve("/")
89
90
91
92
        self.assertEqual(found.func.__name__, DaftarKatalog.as_view().__name__)

    def test_fields(self):
        materi = Materi()
93
94
95
        materi.title = "tes"
        materi.cover = "https://cache.umusic.com/_sites/billieeilish/v2/images/pic-red.jpg"
        materi.author = "input"
96
97
        materi.save()

98
99
100
        resp = Materi.objects.get(id=materi.id)
        self.assertEqual(resp, materi)

101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
    def test_materi_model_generate_search_vector_after_save(self):
        Materi(title="Eating book").save()

        search_vector_new_materi = list(Materi.objects.values_list("_search_vector", flat=True))
        expected_search_vector = ["'book':2A 'eat':1A"]

        self.assertSequenceEqual(search_vector_new_materi, expected_search_vector)

    def test_search_text_on_empty_database(self):
        search_query = "test"

        search_result = list(Materi.objects.search(search_query))
        expected_search_result = []

        self.assertSequenceEqual(search_result, expected_search_result)

    def test_search_text_on_unmatched_data(self):
        Materi(title="test satu sekarang").save()
        Materi(title="test dua nanti").save()

        search_query = "besok"

        search_result = list(Materi.objects.search(search_query))
        expected_search_result = []

        self.assertSequenceEqual(search_result, expected_search_result)

    def test_search_text_return_list_matched_by_rank(self):
        materi_2 = Materi(title="ini lumayan cocok lumayan cocok")
        materi_2.save()

        materi_1 = Materi(title="ini sangat cocok sangat cocok sangat cocok")
        materi_1.save()

        materi_4 = Materi(title="ini tidak")
        materi_4.save()

        materi_3 = Materi(title="ini sedikit cocok")
        materi_3.save()

        search_query = "ini cocok"

        search_result = list(Materi.objects.search(search_query))
        expected_search_result = [materi_1, materi_2, materi_3]

        self.assertSequenceEqual(search_result, expected_search_result)

148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
class DaftarKatalogSortingByJumlahUnduhTest(TestCase):
    def setUp(self):
        self.client = Client()

        self.contributor_credential = {
        "email": "kontributor@gov.id",
        "password": "passwordtest"
            }

        self.contributor_credential_2 = {
                "email": "kontributor2@gov.id",
                "password": "passwordtest"
            }

        self.contributor = get_user_model().objects.create_user(
            **self.contributor_credential, name="Kontributor 1", is_contributor=True)
        self.contributor2 = get_user_model().objects.create_user(
            **self.contributor_credential_2, name="Kontributor 2", is_contributor=True)

        self.cover = SimpleUploadedFile(
            "Cherprang_Areekul40_nJM9dGt.jpg", b"Test file")
        self.content = SimpleUploadedFile("Bahan_PA_RKK.pdf", b"Test file")

        Materi(title="Materi 1", author="Agas", uploader=self.contributor,
               publisher="Kelas SC", descriptions="Deskripsi Materi 1",
               status="APPROVE", cover=self.cover, content=self.content).save()
        time.sleep(1)
        Materi(title="Materi 2", author="Agas", uploader=self.contributor,
               publisher="Kelas SC", descriptions="Deskripsi Materi 2",
               status="APPROVE", cover=self.cover, content=self.content).save()

        self.last_uploaded_material = Materi.objects.last()

        material_unduh_url = f"/materi/{self.last_uploaded_material.id}/unduh"
        self.client.get(material_unduh_url)

    def test_sorting_by_jumlah_unduh(self):
        response = self.client.get("/?sort=jumlah_unduh")
        self.assertRegex(str(response.content), rf'.*Materi 2.*Materi 1.*')
187

188
189
190
class DaftarKatalogPerKontributorTest(TestCase):
    def setUp(self):
        self.client = Client()
Muhamad Lutfi Arif's avatar
Muhamad Lutfi Arif committed
191

192
193
194
195
        self.contributor_credential = {
                "email": "kontributor@gov.id",
                "password": "passwordtest"
            }
Muhamad Lutfi Arif's avatar
Muhamad Lutfi Arif committed
196

197
198
199
200
        self.contributor_credential_2 = {
                "email": "kontributor2@gov.id",
                "password": "passwordtest"
            }
201
202

        self.contributor = get_user_model().objects.create_user(
203
            **self.contributor_credential, name="Kontributor 1", is_contributor=True)
204
        self.contributor2 = get_user_model().objects.create_user(
205
            **self.contributor_credential_2, name="Kontributor 2", is_contributor=True)
Muhamad Lutfi Arif's avatar
Muhamad Lutfi Arif committed
206

207
208
        self.cover = SimpleUploadedFile(
            "Cherprang_Areekul40_nJM9dGt.jpg", b"Test file")
209
210
        self.content = SimpleUploadedFile("Bahan_PA_RKK.pdf", b"Test file")

211
212
213
214
215
216
217
218
219
        Materi(title="Materi 1", author="Agas", uploader=self.contributor,
               publisher="Kelas SC", descriptions="Deskripsi Materi 1",
               status="APPROVE", cover=self.cover, content=self.content).save()
        Materi(title="Materi 2", author="Agas", uploader=self.contributor,
               publisher="Kelas SC", descriptions="Deskripsi Materi 2",
               status="APPROVE", cover=self.cover, content=self.content).save()
        Materi(title="Materi 3", author="Agas", uploader=self.contributor2,
               publisher="Kelas SC", descriptions="Deskripsi Materi 3",
               status="APPROVE", cover=self.cover, content=self.content).save()
Muhamad Lutfi Arif's avatar
Muhamad Lutfi Arif committed
220

221
        self.url = f"/profil/{self.contributor.email}/"
Muhamad Lutfi Arif's avatar
Muhamad Lutfi Arif committed
222

223
224
225
226
227
228
    def test_katalog_per_kontributor_url_exist(self):
        response = self.client.get(self.url)
        self.assertEqual(response.status_code, 200)

    def test_katalog_per_kontributor_using_katalog_kontri_template(self):
        response = self.client.get(self.url)
Muhamad Lutfi Arif's avatar
Muhamad Lutfi Arif committed
229
        self.assertTemplateUsed(response, "app/katalog_kontri.html")
230
231
232
233
234
235
236

    def test_katalog_per_kontributor_using_katalog_per_kontributor_func(self):
        found = resolve(self.url)
        self.assertEqual(found.func.__name__, KatalogPerKontributorView.as_view().__name__)

    def test_katalog_per_kontributor_show_daftar_materi_kontributor(self):
        response = self.client.get(self.url)
Muhamad Lutfi Arif's avatar
Muhamad Lutfi Arif committed
237
238

        list_materi = Materi.objects.filter(uploader=self.contributor)
239
        data = response.context_data["materi_list"]
Muhamad Lutfi Arif's avatar
Muhamad Lutfi Arif committed
240
        self.assertEqual(len(list_materi), len(data))
241

242

Saul Andre's avatar
Saul Andre committed
243
class DetailMateriTest(TestCase):
244
    def setUp(self):
245
        self.client = Client()
246
247
248
249
250
251
252
253
254
255
256
257
258
259
        self.admin_credential = {
            "email": "admin@gov.id",
            "password": "passwordtest"
        }
        self.contributor_credential = {
            "email": "kontributor@gov.id",
            "password": "passwordtest"
        }
        self.anonymous_credential = {
            "email": "anonymous@gov.id",
            "password": "passwordtest"
        }
        self.admin = get_user_model().objects.create_user(
            **self.admin_credential, name="Admin", is_admin=True)
260
        self.contributor = get_user_model().objects.create_user(
261
262
263
            **self.contributor_credential, name="Kontributor", is_contributor=True)
        self.anonymous = get_user_model().objects.create_user(
            **self.anonymous_credential, name="Anonymous"
264
        )
265
266
        self.cover = SimpleUploadedFile(
            "ExampleCover921.jpg", b"Test file")
267
        self.content = SimpleUploadedFile("ExampleFile921.pdf", b"Test file")
268

269
270
271
        Materi(title="Materi 1", author="Agas", uploader=self.contributor,
               publisher="Kelas SC", descriptions="Deskripsi Materi 1",
               status="APPROVE", cover=self.cover, content=self.content).save()
272
        self.materi1 = Materi.objects.first()
273
        self.url = "/materi/" + str(self.materi1.id) + "/"
274

275
276
277
278
        self.materi_with_published_date = Materi.objects.create(title="Materi 1", author="Agas", uploader=self.contributor,
                                                 publisher="Kelas SC", descriptions="Deskripsi Materi 1",
                                                 status="APPROVE", cover=self.cover, content=self.content,
                                                 date_modified=datetime.now(), date_created=datetime.now())
279
        self.materi_with_published_date_url = "/materi/" + str(self.materi_with_published_date.id) + "/"
280
281
282
283
        VerificationReport.objects.create(report='{"feedback": "Something", "kriteria": [{"title": "Kriteria 1", "status": true},' + \
            ' {"title": "Kriteria 2", "status": true}, {"title": "Kriteria 3", "status": true}]}', \
            timestamp="2020-10-09 06:21:33", status="Diterima", materi= self.materi_with_published_date, \
            user=self.materi_with_published_date.uploader)
284

285
    def test_detail_materi_url_exist(self):
286
        response = Client().get(self.url)
287
        self.assertEqual(response.status_code, 200)
288
289
290
        self.assertNotEqual(response.status_code, 404)

    def test_detail_materi_using_detail_materi_template(self):
291
        response = Client().get(self.url)
292
        self.assertTemplateUsed(response, "app/detail_materi.html")
293

Saul Andre's avatar
Saul Andre committed
294
    def test_detail_materi_using_detail_materi_func(self):
295
        found = resolve(self.url)
Saul Andre's avatar
Saul Andre committed
296
        self.assertEqual(found.func.__name__, DetailMateri.as_view().__name__)
297

Saul Andre's avatar
Saul Andre committed
298
    def test_category_models_can_create_new_object(self):
299
300
        test = Category.objects.create(
            id="1", name="medis", description="kategori medis")
Saul Andre's avatar
Saul Andre committed
301
302
303
304
305
        countData = Category.objects.all().count()
        self.assertEqual(1, countData)
        self.assertNotEqual(0, countData)
        self.assertEqual(test.__str__(), "medis")
        self.assertNotEqual(test.__str__(), "saul")
Samuel Dimas's avatar
Samuel Dimas committed
306

Saul Andre's avatar
Saul Andre committed
307
    def test_comment_models_can_create_new_object(self):
308
309
        test = Comment.objects.create(
            username="saul", profile="121212", comment="232323")
Saul Andre's avatar
Saul Andre committed
310
311
312
313
314
        countData = Comment.objects.all().count()
        self.assertEqual(1, countData)
        self.assertNotEqual(0, countData)
        self.assertEqual(test.__str__(), "saul")
        self.assertNotEqual(test.__str__(), "userlain")
315

316
    def test_post_blank_comment(self):
317
318
319
320
        url = self.url
        self.client.login(**self.anonymous_credential)
        response = self.client.post(url, {"comment": ""})
        self.assertIn("error_message", response.context)
321
322
        self.assertIn("Anda belum menuliskan komentar",
                      response.context["error_message"])
323
324
325
326
327

    def test_comment_rendered_to_template(self):
        url = self.url
        self.client.login(**self.contributor_credential)
        self.client.post(url, {"comment": "This is my new comment"})
328
329
        response = Client().get(url)
        self.assertContains(response, "This is my new comment")
330

331
    def test_comment_by_admin(self):
332
333
334
335
        url = self.url
        self.client.login(**self.admin_credential)
        self.client.post(url, {"comment": "This is new comment by Admin"})
        response = self.client.get(url)
336
337
338
        self.assertContains(response, "Admin")

    def test_comment_by_kontributor(self):
339
340
        url = self.url
        self.client.login(**self.contributor_credential)
341
342
        self.client.post(
            url, {"comment": "This is new comment by Contributor"})
343
344
        response = self.client.get(url)
        self.assertContains(response, "Kontributor")
345
346

    def test_comment_by_anonymous(self):
347
348
349
350
351
        url = self.url
        self.client.get("/logout/")
        self.client.login(**self.anonymous_credential)
        self.client.post(url, {"comment": "This is new comment by Anonymous"})
        response = self.client.get(url)
352
        self.assertContains(response, "Anonymous")
353

354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
    def test_comment_disliked_by_anonymous(self):
        url_materi = self.url
        self.client.get("/logout/")
        self.client.login(**self.anonymous_credential)

        self.client.post(url_materi, {"comment": "This is new comment by Anonymous"})
        comment = Comment.objects.get(comment="This is new comment by Anonymous").id
        response = self.client.get(url_materi)
        session_id = response.context["session_id"]

        payload = {"comment": comment, "session_id": session_id}
        ajax_response = self.client.post("/comment/dislike/", payload)
        num_of_comment_dislikes = DislikeComment.objects.filter(comment=comment).count()
        self.assertEqual(num_of_comment_dislikes, 0)

    def test_comment_liked_by_anonymous(self):
        url_materi = self.url
        self.client.get("/logout/")
        self.client.login(**self.anonymous_credential)

        self.client.post(url_materi, {"comment": "This is new comment by Anonymous"})
        comment = Comment.objects.get(comment="This is new comment by Anonymous").id
        response = self.client.get(url_materi)
        session_id = response.context["session_id"]

        payload = {"comment": comment, "session_id": session_id}
        ajax_response = self.client.post("/comment/like/", payload)
        num_of_comment_likes = LikeComment.objects.filter(comment=comment).count()
        self.assertEqual(num_of_comment_likes, 0)

    def test_comment_undisliked_by_anonymous(self):
        url_materi = self.url
        self.client.get("/logout/")
        self.client.login(**self.anonymous_credential)

        self.client.post(url_materi, {"comment": "This is new comment by Anonymous"})
        comment = Comment.objects.get(comment="This is new comment by Anonymous")
        response = self.client.get(url_materi)
        session_id = response.context["session_id"]
        
        payload = {"comment": comment, "session_id": session_id}
        ajax_response = self.client.post("/comment/dislike/", payload)
        
        ajax_response = self.client.post("/comment/dislike/", payload)
        num_of_comment_dislikes = DislikeComment.objects.filter(comment=comment, session_id=session_id).count()
        self.assertEqual(num_of_comment_dislikes, 0)

    def test_comment_unliked_by_anonymous(self):
        url_materi = self.url
        self.client.get("/logout/")
        self.client.login(**self.anonymous_credential)

        self.client.post(url_materi, {"comment": "This is new comment by Anonymous"})
        comment = Comment.objects.get(comment="This is new comment by Anonymous")
        response = self.client.get(url_materi)
        session_id = response.context["session_id"]
        
        payload = {"comment": comment, "session_id": session_id}
        ajax_response = self.client.post("/comment/like/", payload)
        
        ajax_response = self.client.post("/comment/like/", payload)
        num_of_comment_likes = LikeComment.objects.filter(comment=comment, session_id=session_id).count()
        self.assertEqual(num_of_comment_likes, 0)

    def test_comment_new_does_not_have_dislike(self):
        url_materi = self.url
        self.client.get("/logout/")
        self.client.login(**self.anonymous_credential)

        response = self.client.get(url_materi)
        session_id = response.context["session_id"]
        self.client.post(url_materi, {"comment": "This is new comment by Anonymous"})

        comment = Comment.objects.get(comment="This is new comment by Anonymous")
        comment_dislike_counter = DislikeComment.objects.filter(comment=comment, session_id=session_id).count()
        self.assertEqual(comment_dislike_counter, 0)

    def test_comment_new_does_not_have_like(self):
        url_materi = self.url
        self.client.get("/logout/")
        self.client.login(**self.anonymous_credential)

        response = self.client.get(url_materi)
        session_id = response.context["session_id"]
        self.client.post(url_materi, {"comment": "This is new comment by Anonymous"})

        comment = Comment.objects.get(comment="This is new comment by Anonymous")
        comment_like_counter = LikeComment.objects.filter(comment=comment, session_id=session_id).count()
        self.assertEqual(comment_like_counter, 0)

444
    def test_detail_materi_contains_form_comment(self):
445
        self.client.login(**self.contributor_credential)
446
        response = self.client.get(self.url)
447
        self.assertContains(response, "Beri komentar...")
448

449
450
451
452
453
    def test_detail_materi_not_contains_form_comment(self):
        response = self.client.get(self.url)
        self.assertNotContains(response, "Beri komentar...")
        self.assertContains(response, "Login terlebih dahulu untuk berkomentar")

454
    def create_and_delete_comment(self, is_admin=False, is_contributor=False):
455
        url = self.url
456
        self.client.login(**self.admin_credential)
457
        self.client.post(url, {"comment": "This is new comment by Anonymous"})
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
        deleteURL = "/delete/" + str(self.materi1.id) + "/" + str(
            Comment.objects.get(comment="This is new comment by Anonymous").id)
        if is_admin:
            self.client.login(**self.admin_credential)
        if is_contributor:
            self.client.login(**self.contributor_credential)
        if not is_admin and not is_contributor:
            self.client.login(**self.anonymous_credential)
        response = self.client.get(deleteURL)
        return response

    def test_delete_comments_by_admin(self):
        self.create_and_delete_comment(is_admin=True)
        count = Comment.objects.all().filter(comment="This is new comment by Anonymous").count()
        self.assertEqual(count, 0)

    def test_delete_comments_by_contributor(self):
        response = self.create_and_delete_comment(is_contributor=True)

        self.assertRaises(PermissionDenied)
        self.assertEqual(response.status_code, 403)

        count = Comment.objects.all().filter(comment="This is new comment by Anonymous").count()
        self.assertEqual(count, 1)

    def test_delete_comments_by_anonymous(self):
        response = self.create_and_delete_comment()

        self.assertRaises(PermissionDenied)
        self.assertEqual(response.status_code, 403)

        count = Comment.objects.all().filter(comment="This is new comment by Anonymous").count()
        self.assertEqual(count, 1)
491

492
    def test_tombol_citasiAPA(self):
493
        response = self.client.get(self.url)
494
        self.assertContains(response, "Citate APA")
495

496
    def test_hasil_citasi_APA_materi_has_no_published_date(self):
497
        response = self.client.get(self.url)
498
        expected = self.materi1.author + " . (n.d) . " + self.materi1.title + " . " + self.materi1.publisher	
499
        self.assertIn(expected, response.context["citationAPA"])
500
501
        self.assertIn(expected,
                      response.context["citationAPA"])
502

503
504
    def test_hasil_citasi_APA_materi_has_published_date(self):
        response = self.client.get(self.materi_with_published_date_url)
505
506
507
508
509
510
511
512
513
514
        published_date = self.materi_with_published_date.published_date.strftime("%Y-%m-%d %H:%M")	
        expected = (	
            self.materi_with_published_date.author	
            + " . ("	
            + published_date	
            + ") . "	
            + self.materi_with_published_date.title	
            + " . "	
            + self.materi_with_published_date.publisher	
        )	
515
        self.assertIn(expected, response.context["citationAPA"])
516
    
517
518
519
520
521
522
523
524
525
526
527
    def test_citation_IEEE_button(self):
        response = self.client.get(self.url)
        self.assertContains(response, "Citate IEEE")

    def test_citation_IEEE_materi_has_no_published_date(self):
        response = self.client.get(self.url)
        current_date = datetime.now()
        current_day = str(current_date.day)
        current_month = current_date.strftime("%b")
        current_year = str(current_date.year)

528
529
530
531
532
533
534
535
536
537
538
539
540
        expected = (	
            "Agas, "	
            + "Materi 1. "	
            + "Kelas SC, n.d. "	
            + "Accessed on: "	
            + current_month	
            + ". "	
            + current_day	
            + ", "	
            + current_year	
            + ". [Online]. "	
            + "Available: http://testserver"	
            + self.url	
541
        )
542
543
544
545
546
547
548
549
        self.assertIn(expected, response.context["citationIEEE"])

    def test_citation_IEEE_materi_has_published_date(self):
        response = self.client.get(self.materi_with_published_date_url)
        current_date = datetime.now()
        current_day = str(current_date.day)
        current_month = current_date.strftime("%b")
        current_year = str(current_date.year)
550
551
552
553
554
555
556
557
        published_date = self.materi_with_published_date.published_date.strftime('%Y')

        expected = "Agas, " + \
                   "Materi 1. " + \
                   "Kelas SC, " + published_date + ". " +\
                   "Accessed on: " + current_month + ". " + current_day + ", " + current_year + \
                   ". [Online]. " + \
                   "Available: http://testserver" + self.materi_with_published_date_url
558
        self.assertIn(expected, response.context["citationIEEE"])
559

560
561
    def test_tombol_bagikan_google_drive(self):
        response = Client().get(self.url)
562
        self.assertContains(response, 'Google Drive')
563

564
    @mock.patch("app.services.GoogleDriveUploadService.upload_to_gdrive")
565
    def test_save_to_gdrive_with_nonexistent_materi(self, mock_upload_to_gdrive):
566
        response = self.client.get('/materi/%s/save-to-gdrive/' % 0)
567
568
569
        mock_upload_to_gdrive.assert_not_called()
        self.assertEqual(response.status_code, 404)

570
    @mock.patch("app.services.GoogleDriveUploadService.upload_to_gdrive")
571
    def test_save_to_gdrive_with_valid_materi(self, mock_upload_to_gdrive):
572
573
        response = self.client.get(
            '/materi/%s/save-to-gdrive/' % self.materi1.id, follow=True)
574
575
        last_url, status_code = response.redirect_chain[-1]
        mock_upload_to_gdrive.assert_called_once()
576
        self.assertEqual(last_url, '/materi/%d/' % self.materi1.id)
577
578
        self.assertEqual(status_code, 302)

579
class PostsViewTest(TestCase):
580

581
582
583
584
    @classmethod
    def generate_posts_data(cls, user):
        POST_COUNT = 3
        COMMENTS_COUNT_PER_POST = [1, 0, 3]
585
        LIKES_COUNT_PER_POST = [5, 4, 2]
586
587
588
589
590
591
592

        assert POST_COUNT == len(COMMENTS_COUNT_PER_POST)

        sample_file = SimpleUploadedFile("Test.jpg", b"Test file")
        sample_category = Category.objects.create(name="Test Category")

        post_comment_group_dict = {}
593
        for i in range(POST_COUNT):
594
595
596
597
598
            post = Materi.objects.create(
                uploader=user,
                cover=sample_file,
                content=sample_file,
            )
599
600
601
602
603
604
605
            post.categories.add(sample_category)

            post_comment_group_dict[post.id] = {
                "data": post,
                "comments": [],
            }

606
            for j in range (LIKES_COUNT_PER_POST[i]):
607
                Like.objects.create(
608
609
610
                    timestamp=datetime.now(), 
                    materi=post, 
                    session_id=("dummysession-" + str(i) + '-' + str(j))
611
                )
612
            
613
614
615
616
617
618
619
620
621
622
623
624
625
626
        for i, post_id in enumerate(post_comment_group_dict):
            post = post_comment_group_dict[post_id]["data"]

            for _ in range(COMMENTS_COUNT_PER_POST[i]):
                comment = Comment.objects.create(materi=post)
                post_comment_group_dict[post_id]["comments"].append(comment)

            # order by latest (-timestamp)
            post_comment_group_dict[post_id]["comments"].reverse()

        return post_comment_group_dict

    @classmethod
    def setUpTestData(cls):
627
628
629
630
631
        cls.url = '/posts/'
        cls.user_credentials = {
            "email": "user@email.com",
            "password": "justpass"
        }
632
633
634
635
636
637
638
639
        cls.user = User.objects.create_user(**cls.user_credentials, is_contributor=True)
        cls.data = cls.generate_posts_data(cls.user)

    def _request_as_user(self):
        self.client.login(**self.user_credentials)
        return self.client.get(self.url)

    def test_url_resolves_to_posts_view(self):
640
        found = resolve(self.url)
641
        self.assertEqual(found.func.__name__, PostsView.as_view().__name__)
642

643
644
645
    def test_returns_200_on_authenticated_access(self):
        response = self._request_as_user()
        self.assertEqual(response.status_code, 200)
646

647
    def test_returns_403_on_unauthenticated_access(self):
648
        response = self.client.get(self.url)
649
        self.assertRaises(PermissionDenied)
650
        self.assertEqual(response.status_code, 403)
651

652
653
654
        html = response.content.decode("utf-8")
        self.assertIn(ERROR_403_MESSAGE, html)

655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
    def test_returns_correct_template(self):
        response = self._request_as_user()
        self.assertTemplateUsed(response, "user_uploaded_posts.html")

    def test_success_returns_correct_comment_post_groupings_by_context(self):
        post_comment_group_dict = self.data

        response = self._request_as_user()

        response_user = response.context_data["user"]
        self.assertEqual(response_user, self.user)

        response_data = response.context_data["posts"]
        actual_data = post_comment_group_dict
        self.assertDictEqual(response_data, actual_data)

    def test_html_contains_grouped_posts_and_comments(self):
        response = self._request_as_user()

        posts = list(self.data.keys())
675
676
677
678
        comments = {
            i: [comment.id for comment in self.data[post_id]["comments"]]
            for i, post_id in enumerate(posts)
        }
679
680

        self.assertRegex(
681
            str(response.content),
682
683
684
685
686
687
688
            rf'.*(<div id="post-{posts[2]}">)' + \
            rf'.*(<div id="post-{posts[2]}-comment-{comments[2][0]}">)' + \
            rf'.*(<div id="post-{posts[2]}-comment-{comments[2][1]}">)' + \
            rf'.*(<div id="post-{posts[2]}-comment-{comments[2][2]}">)' + \
            rf'.*(<div id="post-{posts[1]}">)' + \
            rf'.*(<div id="post-{posts[0]}">)' + \
            rf'.*(<div id="post-{posts[0]}-comment-{comments[0][0]}">)'
689
690
        )

691
692
693
694
695
696
697
    def test_like_count_written_correctly_on_template(self):
        response = self._request_as_user()

        for _, post_id in enumerate(self.data):
            post = self.data[post_id]["data"]

            self.assertContains(
698
699
                response,
                '<span id="post-like-count-' + str(post.id) + '">' +  str(post.like_count) + '</span>',
700
            )
701

702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
class TemplateLoaderTest(TestCase):
    def test_template_loader_url_exist(self):
        url = "/test-page.html"
        response = Client().get(url)
        self.assertEqual(response.status_code, 200)

    def test_template_loader_using_template_loader_template(self):
        url = "/test-page.html"
        response = Client().get(url)
        expected_template_name = "test-page.html"
        self.assertTemplateUsed(response, expected_template_name)

    def test_template_loader_using_template_loader_func(self):
        url = "/test-page.html"
        found = resolve(url)
        expected_view_name = "pages"
        self.assertEqual(found.func.__name__, expected_view_name)

    def test_template_loader_handle_non_existent_html(self):
        url = "/test.html"
        expected_template_name = "error-404.html"
        response = Client().get(url)
724
        self.assertEqual(response.status_code, 200)
725
        self.assertTemplateUsed(response, expected_template_name)
726

727

728
729
class UploadPageTest(TestCase):
    def setUp(self):
730
        self.client = Client()
731
732
733
734
        self.user = User.objects._create_user(email="kontributor@gov.id",
                                              password="kontributor", is_contributor=True)
        self.admin = User.objects.create_admin(email="admin@gov.id",
                                               password="admin")
735
736
737

    def test_upload_page_using_login_func(self):
        found = resolve("/unggah/")
738
739
        self.assertEqual(found.func.__name__,
                         UploadMateriView.as_view().__name__)
740

Steven Kusuman's avatar
Steven Kusuman committed
741
    def test_upload_page_url_is_exist(self):
742
        # Positive test
743
744
        self.client.login(email="kontributor@gov.id",
                          password="kontributor")
745
        response = self.client.get("/unggah/")
746
        self.assertEqual(response.status_code, 200)
747
748

        # Negative tests
749
750
        self.client.login(email="kontributor@gov.id",
                          password="kontributor")
751
752
753
        response = Client().get("/fake/")
        self.assertEqual(response.status_code, 404)

754
755
756
    def test_upload_page_url_admin_doesnt_exist(self):        
        self.client.login(email="admin@gov.id",
                          password="admin")
Steven Kusuman's avatar
Steven Kusuman committed
757
758
759
        response = self.client.get("/unggah/")
        self.assertEqual(response.status_code, 403)

760
761
762
    def test_upload_page_url_admin_cant_upload(self):        
        self.client.login(email="admin@gov.id",
                          password="admin")
Steven Kusuman's avatar
Steven Kusuman committed
763
764
765
        response = self.client.post("/unggah/")
        self.assertEqual(response.status_code, 403)

766
767
    def test_upload_page_template(self):
        url = "/unggah/"
768
769
        self.client.login(email="kontributor@gov.id",
                          password="kontributor")
770
771
        response = self.client.get(url)
        expected_template_name = "unggah.html"
772
        self.assertTemplateUsed(response, expected_template_name)
773
774

    def test_upload_page_title(self):
775
776
        self.client.login(email="kontributor@gov.id",
                          password="kontributor")
777
778
779
780
781
782
783
784
785
        response = self.client.get("/unggah/")

        # Positive tests
        self.assertContains(response, "Unggah Materi")

        # Negative tests
        self.assertNotContains(response, "Anything")

    def test_upload_page_form_field(self):
786
787
        self.client.login(email="kontributor@gov.id",
                          password="kontributor")
788
789
790
791
792
793
794
        response = self.client.get("/unggah/")

        # Positive tests
        self.assertContains(response, "title")

        # Negative tests
        self.assertNotContains(response, "anything")
795

796

797
798
799
class UploadExcelPageTest(TestCase):
    def setUp(self):
        self.client = Client()
800
801
        self.user = User.objects._create_user(email="kontributor@gov.id",
                                              password="kontributor", is_contributor=True)
802
803
804

    def test_upload_excel_page_using_login_func(self):
        found = resolve("/unggah_excel/")
805
806
        self.assertEqual(found.func.__name__,
                         UploadMateriExcelView.as_view().__name__)
807
808
809

    def test_uplaod_excel_page_url_is_exist(self):
        # Positive test
810
811
        self.client.login(email="kontributor@gov.id",
                          password="kontributor")
812
813
814
815
        response = self.client.get("/unggah_excel/")
        self.assertEqual(response.status_code, 200)

        # Negative tests
816
817
        self.client.login(email="kontributor@gov.id",
                          password="kontributor")
818
819
820
821
822
        response = Client().get("/fake/")
        self.assertEqual(response.status_code, 404)

    def test_upload_excel_page_template(self):
        url = "/unggah_excel/"
823
824
        self.client.login(email="kontributor@gov.id",
                          password="kontributor")
825
826
827
828
829
        response = self.client.get(url)
        expected_template_name = "unggah_excel.html"
        self.assertTemplateUsed(response, expected_template_name)

    def test_upload_excel_page_title(self):
830
831
        self.client.login(email="kontributor@gov.id",
                          password="kontributor")
832
833
834
835
836
837
838
839
840
        response = self.client.get("/unggah_excel/")

        # Positive tests
        self.assertContains(response, "Unggah Materi dari Excel")

        # Negative tests
        self.assertNotContains(response, "Anything")

    def test_upload_excel_page_form_field(self):
841
842
        self.client.login(email="kontributor@gov.id",
                          password="kontributor")
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
        response = self.client.get("/unggah_excel/")

        # Positive tests
        self.assertContains(response, "File (*.xlsx)")

        # Negative tests
        self.assertNotContains(response, "anything")

    def create_dummy_excel(self, field_lengths={}, categories=[]):
        title1 = "Hands-On Machine Learning with Scikit-Learn and TensorFlow: Concepts, Tools, and Techniques to Build Intelligent Systems"
        author1 = "Aurelien Geron, Aurelien Geron, Aurelien Geron"
        publisher1 = "O'Reilly Media, O'Reilly Media, O'Reilly Media"
        categories1 = "Machine Learning,Deep Learning,Computer Science"
        description1 = "A series of Deep Learning breakthroughs have boosted the whole field of machine learning over the last decade. Now that machine learning is thriving, even programmers who know close to nothing about this technology can use simple, efficient tools to implement programs capable of learning from data. This practical book shows you how."

858
859
        if 'title' in field_lengths:
            title1 = title1[:field_lengths['title']]
860

861
862
        if 'author' in field_lengths:
            author1 = author1[:field_lengths['author']]
863

864
865
        if 'publisher' in field_lengths:
            publisher1 = publisher1[:field_lengths['publisher']]
866
867

        if len(categories) > 0:
868
869
870
871
872
873
874
875
876
            categories1 = ','.join(categories)

        data_frame = pd.DataFrame({
            'Title': [title1],
            'Author': [author1],
            'Publisher': [publisher1],
            'Categories': [categories1],
            'Description': [description1],
        })
877

878
        file_path = os.path.join(settings.MEDIA_ROOT, 'dummy.xlsx')
879

880
        writer = pd.ExcelWriter(file_path, engine='xlsxwriter') #pylint: disable=abstract-class-instantiated
881
882
883
884
885
886
        data_frame.to_excel(writer, index=0)
        writer.save()

        return file_path, data_frame

    def test_upload_excel_upload_file_title_error(self):
887
888
        self.client.login(email="kontributor@gov.id",
                          password="kontributor")
889
890

        field_lengths = {
891
892
            'author':30,
            'publisher':30,
893
894
895
        }
        file_name, data_frame = self.create_dummy_excel(field_lengths=field_lengths)

896
897
898
        with open(file_name, 'rb') as fp:
            response = self.client.post("/unggah_excel/", {'excel': fp})
        
899
900
901
        messages = list(dj_messages.get_messages(response.wsgi_request))
        msg_text = messages[0].message

902
        self.assertIn('Title', msg_text)
903
904

    def test_upload_excel_upload_file_author_error(self):
905
906
        self.client.login(email="kontributor@gov.id",
                          password="kontributor")
907
908

        field_lengths = {
909
910
            'title':50,
            'publisher':30,
911
912
913
        }
        file_name, data_frame = self.create_dummy_excel(field_lengths=field_lengths)

914
915
916
        with open(file_name, 'rb') as fp:
            response = self.client.post("/unggah_excel/", {'excel': fp})
        
917
918
919
        messages = list(dj_messages.get_messages(response.wsgi_request))
        msg_text = messages[0].message

920
921
        self.assertIn('Author', msg_text)

922
923

    def test_upload_excel_upload_file_publisher_error(self):
924
925
        self.client.login(email="kontributor@gov.id",
                          password="kontributor")
926
927

        field_lengths = {
928
929
            'title':50,
            'author':30,
930
931
932
        }
        file_name, data_frame = self.create_dummy_excel(field_lengths=field_lengths)

933
934
935
        with open(file_name, 'rb') as fp:
            response = self.client.post("/unggah_excel/", {'excel': fp})
        
936
937
938
        messages = list(dj_messages.get_messages(response.wsgi_request))
        msg_text = messages[0].message

939
        self.assertIn('Publisher', msg_text)
940
941

    def test_upload_excel_upload_file_categories_error(self):
942
943
        self.client.login(email="kontributor@gov.id",
                          password="kontributor")
944
945

        field_lengths = {
946
947
948
            'title':50,
            'author':30,
            'publisher':30,
949
950
951
        }
        file_name, data_frame = self.create_dummy_excel(field_lengths=field_lengths)

952
953
954
        with open(file_name, 'rb') as fp:
            response = self.client.post("/unggah_excel/", {'excel': fp})
        
955
956
957
        messages = list(dj_messages.get_messages(response.wsgi_request))
        msg_text = messages[0].message

958
        self.assertIn('Kategori', msg_text)
959
960

    def test_upload_excel_upload_file_success(self):
961
962
        self.client.login(email="kontributor@gov.id",
                          password="kontributor")
963

964
965
966
        Category(name='Computer Science').save()
        Category(name='Machine Learning').save()
        Category(name='Deep Learning').save()
967
968

        field_lengths = {
969
970
971
            'title':50,
            'author':30,
            'publisher':30,
972
973
        }

974
975
        categories = ['Computer Science','Machine Learning','Deep Learning']
        
976
977
        file_name, data_frame = self.create_dummy_excel(field_lengths=field_lengths, categories=categories)

978
979
980
981
        with open(file_name, 'rb') as fp:
            response = self.client.post("/unggah_excel/", {'excel': fp})
        
        title = data_frame['Title'][0]
982
983
984
        self.assertTrue(Materi.objects.get(title=title))

    def test_upload_excel_download_template(self):
985
986
        self.client.login(email="kontributor@gov.id",
                          password="kontributor")
987
988

        response = self.client.get("/unggah_excel/?template=1")
989
990
991
        
        self.assertEquals(response['Content-Type'],'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')
        self.assertEquals(response['Content-Disposition'],'attachment; filename=template.xlsx')
992
993
994



995
996
997
class DashboardKontributorViewTest(TestCase):
    def setUp(self):
        self.client = Client()
998
999
1000
        self.kontributor = User.objects.create_contributor(email="kontributor@gov.id",
                                                           password="kontributor")
        self.admin = User.objects.create_admin(email="admin@gov.id",