测试工程师能力展示平台

# test_api.py - API 接口测试用例
import requests
import pytest

BASE_URL = "http://oywangzhan.cn/library/api.php"

class TestLibraryAPI:
    def test_get_books(self):
        """测试获取图书列表"""
        resp = requests.get(f"{BASE_URL}?action=get_books")
        assert resp.status_code == 200
        assert len(resp.json()["data"]) > 0

    def test_search_books(self):
        """测试搜索功能"""
        resp = requests.get(f"{BASE_URL}?action=search_books&keyword=算法")
        assert len(resp.json()["data"]) >= 1

    def test_get_stats(self):
        """测试统计数据"""
        resp = requests.get(f"{BASE_URL}?action=get_stats")
        data = resp.json()["data"]
        assert "total_books" in data

# test_database.py
import pymysql

class TestDatabase:
    def setup_class(self):
        self.conn = pymysql.connect(
            host="localhost", user="wpuser",
            password="WpPass2024!", database="library"
        )

    def test_tables_exist(self):
        """验证所有表都存在"""
        cursor = self.conn.cursor()
        cursor.execute("SHOW TABLES")
        tables = [t[0] for t in cursor.fetchall()]
        assert "books" in tables
        assert "users" in tables

# test_ui.py - Selenium UI 测试
from selenium import webdriver
from selenium.webdriver.common.by import By

class TestLibraryUI:
    def setup_method(self):
        self.driver = webdriver.Chrome()
        self.driver.get("http://oywangzhan.cn/library/")

    def test_login_success(self):
        self.driver.find_element(By.ID, "loginUsername").send_keys("admin")
        self.driver.find_element(By.ID, "loginPassword").send_keys("password")
        self.driver.find_element(By.CLASS_NAME, "btn-primary").click()

    def test_book_search(self):
        search = self.driver.find_element(By.ID, "searchInput")
        search.send_keys("算法")

# Jenkinsfile
pipeline {
    agent any
    stages {
        stage('Checkout') { steps { git '...' } }
        stage('Install') { steps { sh 'pip install -r requirements.txt' } }
        stage('Test') { steps { sh 'pytest tests/ --junitxml=report.xml' } }
        stage('Build') { steps { sh 'docker build -t app .' } }
        stage('Deploy') { steps { sh 'docker-compose up -d' } }
    }
}