Coverage for mindsdb / integrations / handlers / d0lt_handler / tests / test_d0lt_handler.py: 0%

1import unittest 

2 

3from mindsdb.integrations.handlers.d0lt_handler.d0lt_handler import D0ltHandler 

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

5 

6 

7class D0ltHandlerTest(unittest.TestCase): 

8 @classmethod 

9 def setUpClass(cls): 

10 cls.kwargs = { 

11 "host": "localhost", 

12 "port": 3306, 

13 "user": "root", 

14 "password": "", 

15 "database": "getting_started", 

16 "ssl": False, 

17 } 

18 cls.handler = D0ltHandler("test_mysql_handler", connection_data=cls.kwargs) 

19 

20 def test_0_connect(self): 

21 self.handler.connect() 

22 

23 def test_1_drop_table(self): 

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

25 assert res.type is not RESPONSE_TYPE.ERROR 

26 

27 def test_2_create_table(self): 

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

29 assert res.type is not RESPONSE_TYPE.ERROR 

30 

31 def test_3_insert_table(self): 

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

33 assert res.type is not RESPONSE_TYPE.ERROR 

34 

35 def test_4_get_tables(self): 

36 tables = self.handler.get_tables() 

37 assert tables.type is not RESPONSE_TYPE.ERROR 

38 

39 def test_5_select_query(self): 

40 query = "SELECT * FROM PREM;" 

41 result = self.handler.native_query(query) 

42 assert result.type is not RESPONSE_TYPE.ERROR 

43 

44 def test_6_get_columns(self): 

45 result = self.handler.get_columns("PREM") 

46 assert result.type is not RESPONSE_TYPE.ERROR 

47 

48 def test_7_check_connection(self): 

49 self.handler.check_connection() 

50 

51 

52if __name__ == "__main__": 

53 unittest.main()