函数库怎么连接sqlserver数据库呢,不是mysql是ms的sqlserver,有连接的教程和方案嘛?3Q
首先需要在容器中安装依赖库,后续在函数库中使用依赖库连接数据库即可,具体连接脚本如何写可以咨询AI。
参考脚本:
import pymssql
def execute_sql_query():
# 定义连接信息
server = 'xx.xx.xx.xx'
port = '1433'
database = 'xxx'
username = 'xxx'
password = 'Password123@xxx'
# 建立连接
cnxn = pymssql.connect(server=server, port=port, user=username, password=password, database=database)
# 创建游标对象
cursor = cnxn.cursor()
# 执行SQL查询
cursor.execute("SELECT * FROM Customers")
# 获取查询结果并格式化输出
result = "success:\n"
rows = cursor.fetchall()
for row in rows:
result += str(row) + "\n"
return result
感谢大佬,经过旧版组件+AI推理,成功了
我这边报错 libodbc.so.2: cannot open shared object file: No such file or directory
用了这个脚本报了这个错是什么原因 我把py脚本放到容器里面 用命令行跑都能出结果 但是用函数调试就出不来结果
Traceback (most recent call last):
File “/opt/py3/lib/python3.11/site-packages/rest_framework/views.py”, line 506, in dispatch
response = handler(request, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/opt/maxkb/app/apps/common/auth/authentication.py”, line 93, in run
return func(view, request, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/opt/maxkb/app/apps/function_lib/views/function_lib_views.py”, line 59, in post
request.data))
^^^^^^^^^^^^
File “/opt/py3/lib/python3.11/site-packages/rest_framework/request.py”, line 220, in data
self._load_data_and_files()
File “/opt/py3/lib/python3.11/site-packages/rest_framework/request.py”, line 283, in _load_data_and_files
self._data, self._files = self._parse()
^^^^^^^^^^^^^
File “/opt/py3/lib/python3.11/site-packages/rest_framework/request.py”, line 358, in _parse
parsed = parser.parse(stream, media_type, self.parser_context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/opt/py3/lib/python3.11/site-packages/rest_framework/parsers.py”, line 66, in parse
return json.load(decoded_stream, parse_constant=parse_constant)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/opt/py3/lib/python3.11/site-packages/rest_framework/utils/json.py”, line 31, in load
return json.load(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/usr/local/lib/python3.11/json/init.py”, line 293, in load
return loads(fp.read(),
^^^^^^^^^
File “”, line 499, in read
File “/opt/py3/lib/python3.11/site-packages/django/http/request.py”, line 410, in read
raise UnreadablePostError(*e.args) from e
django.http.request.UnreadablePostError: [Errno 104] Connection reset by peer