Coverage for mindsdb / integrations / handlers / vertica_handler / tests / test_vertica_handler.py: 0%

1import unittest 

2from mindsdb.integrations.handlers.vertica_handler.vertica_handler import VerticaHandler 

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

4 

5 

6class VerticaHandlerTest(unittest.TestCase): 

7 @classmethod 

8 def setUpClass(cls): 

9 cls.kwargs = { 

10 "connection_data": { 

11 "host": '127.0.0.1', 

12 "port": 5433, 

13 "user": 'dbadmin', 

14 "password": '', 

15 "database": 'VMart', 

16 "schema_name": 'public' 

17 } 

18 

19 } 

20 cls.handler = VerticaHandler('test_vertica_handler', cls.kwargs) 

21 

22 def test_0_check_connection(self): 

23 assert self.handler.check_connection() 

24 

25 def test_1_connect(self): 

26 assert self.handler.connect() 

27 

28 def test_2_create_table(self): 

29 query = "CREATE Table TEST(id Number(1),Name Varchar(33))" 

30 result = self.handler.query(query) 

31 assert result.type is not RESPONSE_TYPE.ERROR 

32 

33 def test_3_insert(self): 

34 query = "INSERT INTO TEST (1,'lOVe yOU)" 

35 result = self.handler.query(query) 

36 assert result.type is not RESPONSE_TYPE.ERROR 

37 

38 def test_4_native_query_select(self): 

39 query = "SELECT * FROM TEST;" 

40 result = self.handler.query(query) 

41 assert result.type is RESPONSE_TYPE.TABLE 

42 

43 def test_5_get_tables(self): 

44 tables = self.handler.get_tables() 

45 assert tables.type is not RESPONSE_TYPE.TABLE 

46 

47 def test_6_get_columns(self): 

48 columns = self.handler.get_columns('TEMP') 

49 assert columns.type is not RESPONSE_TYPE.ERROR 

50 

51 

52if __name__ == '__main__': 

53 unittest.main()