Coverage for mindsdb / integrations / handlers / mssql_handler / connection_args.py: 100%

1from collections import OrderedDict 

2 

3from mindsdb.integrations.libs.const import HANDLER_CONNECTION_ARG_TYPE as ARG_TYPE 

4 

5 

6connection_args = OrderedDict( 

7 user={ 

8 "type": ARG_TYPE.STR, 

9 "description": "The user name used to authenticate with the Microsoft SQL Server.", 

10 "required": True, 

11 "label": "User", 

12 }, 

13 password={ 

14 "type": ARG_TYPE.PWD, 

15 "description": "The password to authenticate the user with the Microsoft SQL Server.", 

16 "required": True, 

17 "label": "Password", 

18 "secret": True, 

19 }, 

20 database={ 

21 "type": ARG_TYPE.STR, 

22 "description": "The database name to use when connecting with the Microsoft SQL Server.", 

23 "required": True, 

24 "label": "Database", 

25 }, 

26 host={ 

27 "type": ARG_TYPE.STR, 

28 "description": "The host name or IP address of the Microsoft SQL Server.", 

29 "required": True, 

30 "label": "Host", 

31 }, 

32 port={ 

33 "type": ARG_TYPE.INT, 

34 "description": "The TCP/IP port of the Microsoft SQL Server. Must be an integer.", 

35 "required": False, 

36 "label": "Port", 

37 }, 

38 server={ 

39 "type": ARG_TYPE.STR, 

40 "description": "The server name of the Microsoft SQL Server. Typically only used with named instances or Azure SQL Database.", 

41 "required": False, 

42 "label": "Server", 

43 }, 

44 schema={ 

45 "type": ARG_TYPE.STR, 

46 "description": "The schema in which objects are searched first. If not provided, all schemas will be queried.", 

47 "required": False, 

48 "label": "Schema", 

49 }, 

50) 

51 

52connection_args_example = OrderedDict( 

53 host="127.0.0.1", port=1433, user="sa", password="password", database="master", schema="dbo" 

54)