ShopVN — E-commerce Website

// Postman Test Script — TC-API-ORDER-001: Create order with Stripe const body = pm.response.json(); pm.test("201 Created", () => pm.response.to.have.status(201)); pm.test("Response time < 3000ms", () => pm.expect(pm.response.responseTime).to.be.below(3000)); pm.test("Order ID format SVN-XXXXXX", () => { pm.expect(body.orderId).to.match(/^SVN-\d{6}$/); }); pm.test("Total amount matches cart", () => { pm.expect(body.totalAmount).to.equal(pm.environment.get('expectedTotal')); }); pm.test("Payment intent created", () => { pm.expect(body.stripePaymentIntentId).to.match(/^pi_/); }); pm.test("Cart cleared", () => { pm.expect(body.cartCleared).to.be.true; }); pm.environment.set('lastOrderId', body.orderId); pm.environment.set('paymentIntentId', body.stripePaymentIntentId);

-- TC-DB-001: Order data integrity sau checkout thành công SELECT o.id, o.status, o.total_amount, o.shipping_fee, o.discount_amount, o.coupon_code, o.stripe_payment_intent_id, o.created_at FROM orders o WHERE o.id = 'SVN-000142'; -- Expected: status='confirmed', amounts chính xác, payment_intent_id có prefix 'pi_' SELECT oi.product_id, oi.variant_id, oi.quantity, oi.unit_price, oi.product_name_snapshot FROM order_items oi WHERE oi.order_id = 'SVN-000142'; -- Expected: price snapshot đúng với giá tại thời điểm order (không bị ảnh hưởng nếu giá sau đó thay đổi) -- product_name_snapshot NOT NULL (de-normalized, bảo toàn lịch sử) -- TC-DB-002: Inventory decrement sau order confirmed SELECT stock_quantity, reserved_quantity FROM product_variants WHERE id = '<variantId>'; -- stock_quantity giảm đúng số lượng ordered -- reserved_quantity = 0 (không còn reserved sau khi confirmed) -- TC-DB-003: No card data stored SELECT column_name FROM information_schema.columns WHERE table_schema = 'public' AND column_name IN ('card_number', 'cvv', 'pan'); -- Expected: 0 rows — không có column nào lưu card data -- TC-DB-004: Coupon single-use enforcement SELECT times_used, max_uses, is_active FROM coupons WHERE code = 'SAVE100K'; -- times_used tăng +1 sau mỗi order dùng coupon này -- Nếu times_used >= max_uses → coupon không thể dùng thêm -- TC-DB-005: Race condition — flash sale stock -- Setup: stock = 1 cho variant ID X UPDATE product_variants SET stock_quantity = 1 WHERE id = 'flash-item-id'; -- Sau khi 2 concurrent orders gửi: -- Expected: chỉ 1 order confirmed, 1 order failed "Hết hàng" -- stock_quantity = 0 (không phải -1) -- Fix: dùng atomic UPDATE với RETURNING, check rows affected -- TC-DB-006: Elasticsearch sync check -- Sau khi update product name trong DB: UPDATE products SET name = 'iPhone 15 Pro Max 512GB Black' WHERE id = 'prod-001'; -- Sau 10 giây, search API phải reflect tên mới -- Verify: GET /products/search?q=Pro+Max+512GB → phải tìm thấy sản phẩm này

// k6 — tests/performance/sprint5-ecommerce.js import http from 'k6/http'; import { check, sleep, group } from 'k6'; export const options = { scenarios: { browse_and_search: { executor: 'ramping-vus', stages: [ { duration: '2m', target: 100 }, // Ramp up { duration: '5m', target: 500 }, // Flash sale simulation { duration: '2m', target: 0 }, // Ramp down ], }, }, thresholds: { 'http_req_duration{scenario:browse}': ['p(90)<2000'], 'http_req_duration{scenario:search}': ['p(90)<500'], // Elasticsearch fast 'http_req_failed': ['rate<0.005'], // < 0.5% errors }, }; export default function() { group('Product Browse', () => { const res = http.get('https://staging.shopvn.vn/api/v1/products?category=dien-thoai&limit=20'); check(res, { 'status 200': r => r.status === 200 }); sleep(2); }); group('Search', () => { const queries = ['iphone', 'samsung', 'laptop dell', 'tai nghe bluetooth']; const q = queries[Math.floor(Math.random() * queries.length)]; const res = http.get(`https://staging.shopvn.vn/api/v1/products/search?q=${q}&limit=20`); check(res, { 'search 200': r => r.status === 200 }); sleep(1); }); group('Add to Cart', () => { const res = http.post( 'https://staging.shopvn.vn/api/v1/cart/items', JSON.stringify({ productId: 'prod-001', variantId: 'var-001', quantity: 1 }), { headers: { 'Content-Type': 'application/json', 'Authorization': `Bearer ${__ENV.TEST_TOKEN}` } } ); check(res, { 'cart 200': r => r.status === 200 || r.status === 201 }); sleep(1); }); }

// tests/e2e/checkout/stripe-checkout.spec.ts import { test, expect } from '@playwright/test'; import { CartPage } from '../pages/CartPage'; import { CheckoutPage } from '../pages/CheckoutPage'; import { ProductPage } from '../pages/ProductPage'; test.describe('Stripe Checkout Flow', () => { test.beforeEach(async ({ page }) => { // Login với test user từ storageState await page.goto('/'); }); test('TC-CHK-001: Complete checkout with Stripe', async ({ page }) => { const productPage = new ProductPage(page); const cartPage = new CartPage(page); const checkoutPage = new CheckoutPage(page); // Add product to cart await productPage.navigate('iphone-15-pro-256gb'); await productPage.addToCart(); await productPage.miniCart.expectVisible(); // Proceed to checkout await cartPage.navigate(); await cartPage.proceedToCheckout(); // Fill shipping address await checkoutPage.fillShippingAddress({ fullName: 'Nguyễn Văn Test', phone: '0901234567', province: 'Hồ Chí Minh', district: 'Quận 1', ward: 'Phường Bến Nghé', street: '123 Nguyễn Huệ', }); // Select shipping method await checkoutPage.selectShippingMethod('GHN Express'); await checkoutPage.continueToPayment(); // Fill Stripe card (inside iframe) const stripeFrame = page.frameLocator('[name="cardNumber"]'); await stripeFrame.locator('input[name="cardnumber"]').fill('4242424242424242'); await page.frameLocator('[name="cardExpiry"]').locator('input').fill('12/28'); await page.frameLocator('[name="cardCvc"]').locator('input').fill('123'); // Submit order await checkoutPage.placeOrder(); // Verify confirmation await expect(page).toHaveURL(/\/order-confirmation\/SVN-\d{6}/); await expect(page.getByRole('heading', { name: /Đặt hàng thành công/ })).toBeVisible(); await expect(page.getByTestId('order-id')).toHaveText(/SVN-\d{6}/); }); test('TC-CHK-006: Card declined shows error', async ({ page }) => { const checkoutPage = new CheckoutPage(page); await checkoutPage.navigateWithCartPrefilled(); await checkoutPage.fillAllFieldsExceptCard(); // Use declined card const stripeFrame = page.frameLocator('[name="cardNumber"]'); await stripeFrame.locator('input').fill('4000000000000002'); await checkoutPage.placeOrder(); await expect(page.getByTestId('payment-error')).toBeVisible(); await expect(page.getByTestId('payment-error')).toContainText('Thẻ bị từ chối'); await expect(page).toHaveURL(/checkout/); // Still on checkout page }); });