| Ankush Menat | 62fc544 | 2021-09-10 12:46:35 +0530 | [diff] [blame] | 1 | import unittest |
| 2 | from functools import partial |
| 3 | |
| Ankush Menat | 33aad4b | 2022-01-11 17:06:31 +0530 | [diff] [blame] | 4 | import frappe |
| 5 | |
| Ankush Menat | 62fc544 | 2021-09-10 12:46:35 +0530 | [diff] [blame] | 6 | from erpnext.controllers import queries |
| 7 | |
| 8 | |
| 9 | def add_default_params(func, doctype): |
| 10 | return partial( |
| 11 | func, doctype=doctype, txt="", searchfield="name", start=0, page_len=20, filters=None |
| 12 | ) |
| 13 | |
| 14 | |
| 15 | class TestQueries(unittest.TestCase): |
| 16 | |
| 17 | # All tests are based on doctype/test_records.json |
| 18 | |
| 19 | def assert_nested_in(self, item, container): |
| 20 | self.assertIn(item, [vals for tuples in container for vals in tuples]) |
| 21 | |
| 22 | def test_employee_query(self): |
| 23 | query = add_default_params(queries.employee_query, "Employee") |
| 24 | |
| 25 | self.assertGreaterEqual(len(query(txt="_Test Employee")), 3) |
| 26 | self.assertGreaterEqual(len(query(txt="_Test Employee 1")), 1) |
| 27 | |
| 28 | def test_lead_query(self): |
| 29 | query = add_default_params(queries.lead_query, "Lead") |
| 30 | |
| 31 | self.assertGreaterEqual(len(query(txt="_Test Lead")), 4) |
| 32 | self.assertEqual(len(query(txt="_Test Lead 4")), 1) |
| 33 | |
| Ankush Menat | 62fc544 | 2021-09-10 12:46:35 +0530 | [diff] [blame] | 34 | def test_item_query(self): |
| 35 | query = add_default_params(queries.item_query, "Item") |
| 36 | |
| 37 | self.assertGreaterEqual(len(query(txt="_Test Item")), 7) |
| 38 | self.assertEqual(len(query(txt="_Test Item Home Desktop 100 3")), 1) |
| 39 | |
| 40 | fg_item = "_Test FG Item" |
| 41 | stock_items = query(txt=fg_item, filters={"is_stock_item": 1}) |
| 42 | self.assert_nested_in("_Test FG Item", stock_items) |
| 43 | |
| 44 | bundled_stock_items = query(txt="_test product bundle item 5", filters={"is_stock_item": 1}) |
| 45 | self.assertEqual(len(bundled_stock_items), 0) |
| 46 | |
| Ankush Menat | 41a95e5 | 2022-02-03 13:02:13 +0530 | [diff] [blame] | 47 | # empty customer/supplier should be stripped of instead of failure |
| 48 | query(txt="", filters={"customer": None}) |
| 49 | query(txt="", filters={"customer": ""}) |
| 50 | query(txt="", filters={"supplier": None}) |
| 51 | query(txt="", filters={"supplier": ""}) |
| 52 | |
| Ankush Menat | 62fc544 | 2021-09-10 12:46:35 +0530 | [diff] [blame] | 53 | def test_bom_qury(self): |
| 54 | query = add_default_params(queries.bom, "BOM") |
| 55 | |
| 56 | self.assertGreaterEqual(len(query(txt="_Test Item Home Desktop Manufactured")), 1) |
| 57 | |
| 58 | def test_project_query(self): |
| ruthra kumar | 3349dde | 2024-01-16 14:28:09 +0530 | [diff] [blame] | 59 | query = add_default_params(queries.get_project_name, "Project") |
| Ankush Menat | 62fc544 | 2021-09-10 12:46:35 +0530 | [diff] [blame] | 60 | |
| 61 | self.assertGreaterEqual(len(query(txt="_Test Project")), 1) |
| 62 | |
| 63 | def test_account_query(self): |
| 64 | query = add_default_params(queries.get_account_list, "Account") |
| 65 | |
| 66 | debtor_accounts = query(txt="Debtors", filters={"company": "_Test Company"}) |
| 67 | self.assert_nested_in("Debtors - _TC", debtor_accounts) |
| 68 | |
| 69 | def test_income_account_query(self): |
| 70 | query = add_default_params(queries.get_income_account, "Account") |
| 71 | |
| 72 | self.assertGreaterEqual(len(query(filters={"company": "_Test Company"})), 1) |
| 73 | |
| 74 | def test_expense_account_query(self): |
| 75 | query = add_default_params(queries.get_expense_account, "Account") |
| 76 | |
| 77 | self.assertGreaterEqual(len(query(filters={"company": "_Test Company"})), 1) |
| 78 | |
| 79 | def test_warehouse_query(self): |
| 80 | query = add_default_params(queries.warehouse_query, "Account") |
| 81 | |
| 82 | wh = query(filters=[["Bin", "item_code", "=", "_Test Item"]]) |
| 83 | self.assertGreaterEqual(len(wh), 1) |
| Ankush Menat | 33aad4b | 2022-01-11 17:06:31 +0530 | [diff] [blame] | 84 | |
| 85 | def test_default_uoms(self): |
| 86 | self.assertGreaterEqual(frappe.db.count("UOM", {"enabled": 1}), 10) |