Coverage for mindsdb / integrations / handlers / crate_handler / tests / test_crate_handler.py: 0%

1import unittest 

2from mindsdb.integrations.handlers.crate_handler.crate_handler import CrateHandler 

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

4 

5 

6class CrateHandlerTest(unittest.TestCase): 

7 @classmethod 

8 def setUpClass(cls): 

9 cls.kwargs = { 

10 "host": "127.0.0.1", 

11 "port": 4200, 

12 "user": "crate", 

13 "password": "", 

14 } 

15 cls.handler = CrateHandler("test_crate_handler", cls.kwargs) 

16 

17 def test_0_connect(self): 

18 self.handler.connect() 

19 

20 def test_1_drop_table(self): 

21 res = self.handler.query("DROP TABLE IF EXISTS PREM;") 

22 assert res.type is not RESPONSE_TYPE.ERROR 

23 

24 def test_2_create_table(self): 

25 res = self.handler.query("CREATE TABLE IF NOT EXISTS PREM (Premi varchar(50));") 

26 assert res.type is not RESPONSE_TYPE.ERROR 

27 

28 def test_3_insert_table(self): 

29 res = self.handler.query("INSERT INTO PREM VALUES('Radha <3 Krishna');") 

30 assert res.type is not RESPONSE_TYPE.ERROR 

31 

32 def test_4_get_tables(self): 

33 tables = self.handler.get_tables() 

34 assert tables.type is not RESPONSE_TYPE.ERROR 

35 

36 def test_5_select_query(self): 

37 query = "SELECT * FROM PREM;" 

38 result = self.handler.native_query(query) 

39 assert result.type is RESPONSE_TYPE.TABLE or RESPONSE_TYPE.OK 

40 

41 def test_6_check_connection(self): 

42 self.handler.check_connection() 

43 

44 

45if __name__ == "__main__": 

46 unittest.main()