Coverage for mindsdb / integrations / handlers / supabase_handler / tests / test_supabase_handler.py: 0%

1import unittest 

2from mindsdb.integrations.handlers.supabase_handler.supabase_handler import SupabaseHandler 

3 

4 

5class SupabaseHandlerTest(unittest.TestCase): 

6 @classmethod 

7 def setUpClass(cls): 

8 cls.kwargs = { 

9 "connection_data": { 

10 "host": "localhost", 

11 "port": "3306", 

12 "user": "root", 

13 "password": "root", 

14 "database": "test", 

15 "ssl": False 

16 } 

17 } 

18 cls.handler = SupabaseHandler('test_supabase_handler', **cls.kwargs) 

19 

20 def test_0_connect(self): 

21 self.handler.connect() 

22 

23 def test_1_check_connection(self): 

24 assert self.handler.check_connection() 

25 

26 def test_2_native_query_show_dbs(self): 

27 dbs = self.handler.native_query("SHOW DATABASES;") 

28 assert isinstance(dbs, list) 

29 

30 def test_3_get_tables(self): 

31 tbls = self.handler.get_tables() 

32 assert isinstance(tbls, list) 

33 

34 def test_5_create_table(self): 

35 try: 

36 self.handler.native_query("CREATE TABLE test_mdb (test_col INT)") 

37 except Exception: 

38 pass 

39 

40 def test_6_describe_table(self): 

41 described = self.handler.get_columns("dt_test") 

42 assert isinstance(described, list) 

43 

44 def test_7_select_query(self): 

45 query = "SELECT * FROM dt_test WHERE 'id'='a'" 

46 self.handler.native_query(query)