forked from deepakbhimavarapu/WP_Mentor_training_2020
-
Notifications
You must be signed in to change notification settings - Fork 0
/
test_search.py
55 lines (44 loc) · 2.02 KB
/
test_search.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
import os
import unittest
from search import *
from application import app
from sqlalchemy.orm import scoped_session, sessionmaker
from sqlalchemy import create_engine, or_
from models import Base, User, Book
class BasicTests(unittest.TestCase):
def setUp(self):
app.config['TESTING'] = True
app.config['WTF_CSRF_ENABLED'] = False
app.config['DEBUG'] = False
# Check for environment variable
if not os.getenv("DATABASE_URL"):
raise RuntimeError("DATABASE_URL is not set")
Base.query = db_session.query_property()
self.app = app.test_client()
# Disable sending emails during unit testing
self.assertEqual(app.debug, False)
# executed after each test
def tearDown(self):
pass
def test_search_book_by_type_ISBN(self):
query = "0399"
books1 = search_book_by_type("ISBN", "0399")
books2 = db_session.query(Book).filter(or_(Book.isbn.like(f'%{query}'),Book.isbn.like(f'%{query}%'),Book.isbn.like(f'{query}%'), Book.isbn==query))
self.assertEqual(books1[0], books2[0])
def test_search_book_by_type_Name(self):
query = "The"
books1 = search_book_by_type('Name', "The")
books2 = db_session.query(Book).filter(or_(Book.name.like(f'%{query}'),Book.name.like(f'%{query}%'),Book.name.like(f'{query}%'), Book.name==query))
self.assertEqual(books1[0], books2[0])
def test_search_book_by_type_author(self):
query = "David"
books1 = search_book_by_type('author', "David")
books2 = db_session.query(Book).filter(or_(Book.author.like(f'%{query}'),Book.author.like(f'%{query}%'),Book.author.like(f'{query}%'), Book.author==query))
self.assertEqual(books1[0], books2[0])
def test_search_book_by_type_year(self):
query = "1996"
books1 = search_book_by_type('year', "1996")
books2 = db_session.query(Book).filter(Book.year==query)
self.assertEqual(books1[0], books2[0])
if __name__ == "__main__":
unittest.main()