Coverage for mindsdb / integrations / handlers / cloud_spanner_handler / tests / test_cloud_spanner_handler.py: 0%

1import unittest 

2from mindsdb.api.executor.data_types.response_type import ( 

3 RESPONSE_TYPE, 

4) 

5from mindsdb.integrations.handlers.cloud_spanner_handler.cloud_spanner_handler import ( 

6 CloudSpannerHandler, 

7) 

8 

9 

10class CloudSpannerHandlerTest(unittest.TestCase): 

11 @classmethod 

12 def setUpClass(cls): 

13 cls.kwargs = {'connection_data': {'database_id': 'example-db', 'instance_id': 'test-instance', 'project': 'your-project-id'}} 

14 cls.handler = CloudSpannerHandler('test_cloud_spanner_handler', **cls.kwargs) 

15 

16 def test_0_connect(self): 

17 self.handler.connect() 

18 

19 def test_1_check_connection(self): 

20 self.handler.check_connection() 

21 

22 def test_2_create_table(self): 

23 res = self.handler.query('CREATE TABLE integers(i INT64) PRIMARY KEY (i)') 

24 assert res.type is not RESPONSE_TYPE.ERROR 

25 

26 def test_3_insert_into_table(self): 

27 res = self.handler.query('INSERT INTO integers (i) VALUES (42)') 

28 assert res.type is not RESPONSE_TYPE.ERROR 

29 

30 def test_4_select(self): 

31 res = self.handler.query('SELECT * FROM integers') 

32 assert res.type is RESPONSE_TYPE.TABLE 

33 

34 def test_5_describe_table(self): 

35 res = self.handler.get_columns('integers') 

36 assert res.type is RESPONSE_TYPE.TABLE 

37 

38 def test_6_drop_table(self): 

39 res = self.handler.query('DROP TABLE integers') 

40 assert res.type is not RESPONSE_TYPE.ERROR 

41 

42 def test_7_get_tables(self): 

43 res = self.handler.get_tables() 

44 assert res.type is not RESPONSE_TYPE.ERROR 

45 

46 

47if __name__ == '__main__': 

48 unittest.main()