Coverage for mindsdb / integrations / handlers / google_analytics_handler / tests / test_google_analytics_handler.py: 0%

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

2from mindsdb.integrations.handlers.google_analytics_handler.google_analytics_handler import GoogleAnalyticsHandler 

3 

4import unittest 

5 

6 

7class GoogleAnalyticsTest(unittest.TestCase): 

8 @classmethod 

9 def setUpClass(cls): 

10 cls.kwargs = { 

11 "connection_data": { 

12 "credentials_file": '/home/talaat/Downloads/credentials.json', 

13 "property_id": '<YOUR_PROPERTY_ID>' 

14 } 

15 } 

16 

17 cls.handler = GoogleAnalyticsHandler('test_google_analytics_handler', **cls.kwargs) 

18 

19 def test_0_check_connection(self): 

20 assert self.handler.check_connection() 

21 

22 def test_1_get_tables(self): 

23 tables = self.handler.get_tables() 

24 assert tables.type is RESPONSE_TYPE.TABLE 

25 

26 def test_2_native_query_select(self): 

27 query = 'SELECT * FROM conversion_events' 

28 result = self.handler.native_query(query) 

29 assert result.type is RESPONSE_TYPE.TABLE 

30 

31 def test_3_native_query_update(self): 

32 query = 'UPDATE conversion_events SET countingMethod = 1 WHERE name = "properties/371809744/conversionEvents/6637248600"' 

33 result = self.handler.native_query(query) 

34 assert result.type is RESPONSE_TYPE.OK 

35 

36 def test_4_native_query_delete(self): 

37 query = 'DELETE FROM conversion_events WHERE name = "properties/371809744/conversionEvents/6622916665"' 

38 result = self.handler.native_query(query) 

39 assert result.type is RESPONSE_TYPE.OK 

40 

41 def test_5_native_query_insert(self): 

42 query = "INSERT INTO conversion_events (event_name, countingMethod) VALUES ('event_4', 2)" 

43 result = self.handler.native_query(query) 

44 assert result.type is RESPONSE_TYPE.OK 

45 

46 

47if __name__ == '__main__': 

48 unittest.main()