Coverage for mindsdb / integrations / handlers / sheets_handler / tests / test_sheets_handler.py: 0%

1import unittest 

2from mindsdb.integrations.handlers.sheets_handler.sheets_handler import SheetsHandler 

3from mindsdb.api.executor.data_types.response_type import RESPONSE_TYPE 

4 

5 

6class SheetsHandlerTest(unittest.TestCase): 

7 @classmethod 

8 def setUpClass(cls): 

9 cls.kwargs = { 

10 "spreadsheet_id": "12wgS-1KJ9ymUM-6VYzQ0nJYGitONxay7cMKLnEE2_d0", 

11 "sheet_name": "iris" 

12 } 

13 cls.handler = SheetsHandler('test_sheets_handler', cls.kwargs) 

14 

15 def test_0_check_connection(self): 

16 assert self.handler.check_connection() 

17 

18 def test_1_native_query_select(self): 

19 query = "SELECT * FROM iris" 

20 result = self.handler.native_query(query) 

21 assert result.type is RESPONSE_TYPE.TABLE 

22 

23 def test_2_get_tables(self): 

24 tables = self.handler.get_tables() 

25 assert tables.type is not RESPONSE_TYPE.ERROR 

26 

27 def test_3_get_columns(self): 

28 columns = self.handler.get_columns() 

29 assert columns.type is not RESPONSE_TYPE.ERROR 

30 

31 

32if __name__ == '__main__': 

33 unittest.main()