Coverage for mindsdb / integrations / handlers / cockroach_handler / tests / test_cockroachdb_handler.py: 0%

1import unittest 

2from mindsdb.integrations.handlers.cockroach_handler.cockroach_handler import CockroachHandler 

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

4 

5 

6class CockroachHandlerTest(unittest.TestCase): 

7 @classmethod 

8 def setUpClass(cls): 

9 cls.kwargs = { 

10 "connection_data": { 

11 "host": "localhost", 

12 "port": "5432", 

13 "user": "mindsdb", 

14 "password": "mindsdb", 

15 "database": "postgres" 

16 } 

17 } 

18 cls.handler = CockroachHandler('test_cockroach_handler', **cls.kwargs) 

19 

20 def test_0_check_connection(self): 

21 assert self.handler.check_connection() 

22 

23 def test_1_describe_table(self): 

24 described = self.handler.describe_table("test_mdb") 

25 assert described['type'] is not RESPONSE_TYPE.ERROR 

26 

27 def test_2_get_tables(self): 

28 tables = self.handler.get_tables() 

29 assert tables['type'] is not RESPONSE_TYPE.ERROR 

30 

31 def test_4_select_query(self): 

32 query = "SELECT * FROM data.test_mdb WHERE 'id'='1'" 

33 result = self.handler.query(query) 

34 assert result['type'] is RESPONSE_TYPE.TABLE