Coverage for mindsdb / integrations / handlers / sqreamdb_handler / tests / test_sqreamdb_handler.py: 0%

1import unittest 

2from mindsdb.integrations.handlers.sqreamdb_handler.sqreamdb_handler import SQreamDBHandler 

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

4 

5 

6class SQreamDBHandlerTest(unittest.TestCase): 

7 @classmethod 

8 def setUpClass(cls): 

9 cls.kwargs = { 

10 "connection_data": { 

11 "host": "127.0.0.1", 

12 "port": "5000", 

13 "user": "sqream", 

14 "password": "sqream", 

15 "database": "master" 

16 } 

17 } 

18 cls.handler = SQreamDBHandler('test_sqreamdb_handler', **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 LOVE") 

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 LOVE (LOVER varchar(20))") 

29 assert res.type is not RESPONSE_TYPE.ERROR 

30 

31 def test_3_get_tables(self): 

32 tables = self.handler.get_tables() 

33 assert tables.type is not RESPONSE_TYPE.ERROR 

34 

35 def test_4_select_query(self): 

36 query = "SELECT * FROM AUTHORS" 

37 result = self.handler.native_query(query) 

38 assert result.type is RESPONSE_TYPE.TABLE 

39 

40 def test_5_check_connection(self): 

41 self.handler.check_connection() 

42 

43 

44if __name__ == '__main__': 

45 unittest.main()