Coverage for mindsdb / integrations / handlers / sqlite_handler / tests / test_sqlite_handler.py: 0%

1import unittest 

2from mindsdb.integrations.handlers.sqlite_handler.sqlite_handler import SQLiteHandler 

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

4 

5 

6class SQLiteHandlerTest(unittest.TestCase): 

7 @classmethod 

8 def setUpClass(cls): 

9 cls.kwargs = { 

10 "db_file": "chinook.db", 

11 } 

12 cls.handler = SQLiteHandler('test_sqlite_handler', cls.kwargs) 

13 

14 def test_0_check_connection(self): 

15 assert self.handler.check_connection() 

16 

17 def test_1_native_query_select(self): 

18 query = "SELECT * FROM customers" 

19 result = self.handler.native_query(query) 

20 assert result.type is RESPONSE_TYPE.TABLE 

21 

22 def test_2_get_tables(self): 

23 tables = self.handler.get_tables() 

24 assert tables.type is not RESPONSE_TYPE.ERROR 

25 

26 def test_4_get_columns(self): 

27 columns = self.handler.get_columns('customers') 

28 assert columns.type is not RESPONSE_TYPE.ERROR 

29 

30 

31if __name__ == '__main__': 

32 unittest.main()