Coverage for mindsdb / integrations / handlers / ingres_handler / tests / test_ingres_handler.py: 0%

1import unittest 

2from mindsdb.integrations.handlers.ingres_handler.ingres_handler import IngresHandler 

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

4 

5 

6class IngresHandlerTest(unittest.TestCase): 

7 

8 @classmethod 

9 def setUpClass(cls): 

10 cls.kwargs = { 

11 "connection_data": { 

12 "user": "admin", 

13 "password": "password", 

14 "server": "(local)", 

15 "database": "test_db" 

16 } 

17 } 

18 cls.handler = IngresHandler('test_ingres_handler', **cls.kwargs) 

19 

20 def test_0_check_connection(self): 

21 assert self.handler.check_connection() 

22 

23 def test_1_get_tables(self): 

24 tables = self.handler.get_tables() 

25 assert tables.type is not RESPONSE_TYPE.ERROR 

26 

27 def test_2_select_query(self): 

28 query = "SELECT * FROM test_db.home_rentals" 

29 result = self.handler.native_query(query) 

30 assert result.type is RESPONSE_TYPE.TABLE 

31 

32 def test_3_get_columns(self): 

33 columns = self.handler.get_columns('test') 

34 assert columns.type is not RESPONSE_TYPE.ERROR 

35 

36 def test_4_drop_table(self): 

37 res = self.handler.native_query("DROP TABLE IF EXISTS test_db.test") 

38 assert res.type is not RESPONSE_TYPE.ERROR 

39 

40 def test_5_create_table(self): 

41 res = self.handler.native_query("CREATE TABLE IF NOT EXISTS test_db.test (id INT, name VARCHAR(255))") 

42 assert res.type is not RESPONSE_TYPE.ERROR 

43 

44 def test_6_insert(self): 

45 res = self.handler.native_query("INSERT INTO test VALUES (100,'ONE HUNDRED')") 

46 assert res.type is not RESPONSE_TYPE.ERROR 

47 

48 def test_7_disconnect(self): 

49 assert self.handler.disconnect() 

50 

51 

52if __name__ == '__main__': 

53 unittest.main()