用 Oracle 云预算直接调用 OpenAI 模型与 Codex——企业级 AI 通道实践

# 在 OCI 控制台 Identity > Policies 中创建
# 假设 OpenAI 服务在 OCI 中以 ai-openai 命名空间注册

allow group AiDevelopers to use ai-openai-family in compartment ai-workspace
allow group AiDevelopers to manage ai-openai-keys in compartment ai-workspace

# 创建 API key（示意命令，实际子命令以 OCI 文档为准）
oci ai-openai key create \
  --compartment-id ocid1.compartment.oc1..example \
  --display-name "team-alpha-openai-key" \
  --query 'data."api-key"' \
  --raw-output

"""
依赖安装：
  pip install openai python-dotenv

运行前：
  1. 将 API key 保存到 .env 文件（见下方）
  2. 确认 OCI 侧策略和密钥已就绪
  3. endpoint 请替换为 OCI 文档提供的实际地址
"""

import os
from dotenv import load_dotenv
from openai import OpenAI

load_dotenv()

# OCI 通道的 OpenAI 端点（替换为实际值）
OCI_OPENAI_ENDPOINT = os.getenv(
    "OCI_OPENAI_ENDPOINT",
    "https://openai.ai.oraclecloud.com/v1"  # 示意地址，请替换
)

client = OpenAI(
    api_key=os.getenv("OCI_OPENAI_API_KEY"),
    base_url=OCI_OPENAI_ENDPOINT,
)

# ---- GPT-4o：文本分析任务 ----
def analyze_log(log_text: str) -> str:
    response = client.chat.completions.create(
        model="gpt-4o",
        messages=[
            {
                "role": "system",
                "content": "你是运维日志分析专家，用中文输出关键异常和建议。"
            },
            {
                "role": "user",
                "content": f"分析以下日志，提取异常模式并给出修复建议：\n{log_text}"
            },
        ],
        temperature=0.2,
        max_tokens=500,
    )
    return response.choices[0].message.content


# ---- Codex：代码补全任务 ----
def complete_code(prompt: str, language: str = "python") -> str:
    response = client.chat.completions.create(
        model="codex-mini-latest",  # Codex 模型标识，以 OCI 文档为准
        messages=[
            {
                "role": "user",
                "content": f"用 {language} 完成以下代码：\n{prompt}"
            },
        ],
        temperature=0.0,
        max_tokens=300,
    )
    return response.choices[0].message.content


# ---- 演示 ----
if __name__ == "__main__":
    # 示例日志
    sample_log = """
    2024-03-15 08:12:03 ERROR db-pool exhausted, wait=3200ms
    2024-03-15 08:12:04 WARN retry attempt 3/5 for query SELECT * FROM orders
    2024-03-15 08:12:06 ERROR connection timeout to replica-db-2
    """

    print("=== 日志分析结果 ===")
    print(analyze_log(sample_log))

    # 示例代码补全
    code_prompt = "写一个函数，接收一个 URL 列表，并发请求每个 URL，返回状态码字典，超时设为 5 秒"
    print("\n=== Codex 代码补全 ===")
    print(complete_code(code_prompt))

OCI_OPENAI_API_KEY=sk-oci-your-key-here
OCI_OPENAI_ENDPOINT=https://openai.ai.oraclecloud.com/v1

# .gitlab-ci.yml
codex-review:
  stage: review
  image: python:3.12-slim
  before_script:
    - pip install openai python-dotenv
  script:
    - |
      python3 -c "
      from openai import OpenAI
      import os, glob

      client = OpenAI(
          api_key=os.environ['OCI_OPENAI_API_KEY'],
          base_url=os.environ['OCI_OPENAI_ENDPOINT'],
      )

      changed_files = glob.glob('src/**/*.py', recursive=True)
      for f in changed_files[:5]:  # 限制审查文件数，控制成本
          code = open(f).read()
          resp = client.chat.completions.create(
              model='codex-mini-latest',
              messages=[{'role':'user','content':f'审查以下 Python 代码，指出潜在 bug 和改进点，用中文回答：\n{code}'}],
              temperature=0.1,
              max_tokens=400,
          )
          print(f'--- {f} ---')
          print(resp.choices[0].message.content)
      "
  variables:
    OCI_OPENAI_API_KEY: $CI_OPENAI_KEY      # 在 CI/CD Variables 中配置
    OCI_OPENAI_ENDPOINT: $CI_OPENAI_ENDPOINT
  only:
    - merge_requests