Coverage for mindsdb / integrations / handlers / vitess_handler / tests / test_vitess_handler.py: 0%

1import unittest 

2from mindsdb.integrations.handlers.vitess_handler.vitess_handler import VitessHandler 

3from mindsdb.integrations.libs.response import RESPONSE_TYPE 

4 

5 

6class VitessHandlerTest(unittest.TestCase): 

7 @classmethod 

8 def setUpClass(cls): 

9 cls.kwargs = { 

10 "connection_data": { 

11 "host": "localhost", 

12 "port": 33577, 

13 "user": "root", 

14 "password": "", 

15 "database": "vitess", 

16 } 

17 } 

18 cls.handler = VitessHandler('test_vitess_handler', **cls.kwargs) 

19 

20 def test_0_check_connection(self): 

21 assert self.handler.check_connection() 

22 

23 def test_1_connect(self): 

24 assert self.handler.connect() 

25 

26 def test_2_create_table(self): 

27 query = "CREATE Table IF NOT EXISTS Lover(name varchar(101));" 

28 result = self.handler.query(query) 

29 assert result.type is not RESPONSE_TYPE.ERROR 

30 

31 def test_3_insert(self): 

32 query = "INSERT INTO LOVER VALUES('Shiv Shakti');" 

33 result = self.handler.query(query) 

34 assert result.type is not RESPONSE_TYPE.ERROR 

35 

36 def test_4_native_query_select(self): 

37 query = "SELECT * FROM LOVER;" 

38 result = self.handler.query(query) 

39 assert result.type is RESPONSE_TYPE.TABLE 

40 

41 def test_5_get_tables(self): 

42 tables = self.handler.get_tables() 

43 assert tables.type is RESPONSE_TYPE.TABLE 

44 

45 def test_6_get_columns(self): 

46 columns = self.handler.get_columns('LOVER') 

47 

48 query = "DROP Table IF EXISTS Lover;" 

49 self.handler.query(query) 

50 assert columns.type is not RESPONSE_TYPE.ERROR 

51 

52 

53if __name__ == '__main__': 

54 unittest.main()