Software & Coding Prompts

You are an expert QA and software testing engineer. Analyze the TypeScript function provided below and write a comprehensive unit test suite using Jest/Vitest.

Ensure that the tests cover:
1. Happy Path: Core functionality with expected inputs and outputs.
2. Edge Cases: Handling null, undefined, empty strings, negative numbers, overflow limits, or empty arrays.
3. Error Handling: Verifying that the function throws the correct error types when invalid inputs are provided.
4. Type Safety: Adhering to and validating TS types.

Here is the function code:
```typescript
[Paste Function Code Here]
```

You are a backend software engineer. Write a complete TypeScript Next.js App Router route handler (route.ts) based on the database schema and request requirements provided below.

The output must include:
1. Zod Schema: A validation schema for request payload or query parameters.
2. Error Handling: Return 400 Bad Request if validation fails, 500 for internal errors.
3. Safe DB query: Simulating database operations using Prisma/Mongoose query formatting.
4. Correct Types: Return typed NextResponses with appropriate HTTP status codes.

Endpoint details:
- Route URL/Method: [e.g., POST /api/user]
- Request Body Schema: [Describe fields and types]
- Database Action: [Create user, fetch data, etc.]

You are a database administrator and SQL optimization expert. Analyze the slow SQL query and schema provided below and provide optimization recommendations.

Deliver:
1. Refactored Query: Write the optimized version of the SQL query.
2. Indexing Strategy: Identify which columns should be indexed (composite or single) and explain why.
3. Query Execution Plan analysis: Explain why the original query was slow (e.g., table scan, bad join logic).

SQL Query & Details:
```sql
[Insert SQL Query Here]
```
Database Schema & Row Counts:
[Provide schema details and table sizes]

You are an API technical writer. Convert the raw code or request/response payload details below into a standardized OpenAPI 3.0 specification in YAML format.

Ensure:
- Valid YAML syntax.
- All request parameters (header, query, path, body) are detailed with types.
- Success responses (200 OK, 201 Created) and error responses (400, 401, 404, 500) are fully defined.

Raw API Details:
[Paste API endpoint code, controller, or JSON payloads here]

Act as a senior UI/UX auditor and mobile accessibility expert. Analyze the provided screenshot of the user interface:
- Layout Grid: [LAYOUT_GRID]
- Main Goal: [UX_MAIN_GOAL]

Please provide a detailed review highlighting:
1. Usability roadblocks and user friction points.
2. Visual hierarchy problems and contrast issues.
3. 3 concrete layout or styling changes to improve the overall conversion rate.

Act as a senior Next.js architect. Help me design and write code for:
- Component Goal: [NEXT_GOAL]
- State Requirements: [NEXT_STATE]
- Data Fetching Pattern: [NEXT_FETCHING]

Ensure strict compliance with React Server Components (RSC), proper client/server component boundaries ('use client' placement), and optimized Next.js metadata configs.

Act as a senior python data engineer. Write an ethical web scraping script targeting:
- Source Website URL: [SCRAPING_URL]
- Elements to Extract: [TARGET_ELEMENTS]
- Data Export Format: [EXPORT_FORMAT]

Include polite header configuration (user-agent), robust error exceptions (try/except), and a basic Pandas pipeline to clean up and structure the output data.

// Act as a QA automation engineer using GitHub Copilot inline chat. 
// Write a comprehensive Jest integration test suite for the controller below.

// Requirements:
// 1. Setup mock services and databases.
// 2. Test successful requests (status 200/201).
// 3. Test validation errors (status 400 with invalid inputs).
// 4. Test authorization failure (status 401/403 with invalid tokens).
// 5. Test edge cases (not found exceptions, database crash simulations).

// Controller Code to test:
[Insert Controller Code Here]

// Act as a senior software architect. Analyze and refactor the legacy function provided below to follow clean code standards.

// Refactoring Targets:
// 1. Single Responsibility Principle (SRP): Split massive routines into small utility functions.
// 2. DRY (Don't Repeat Yourself): Consolidate duplicate structures.
// 3. Type Safety: Ensure strict TypeScript typings, interfaces, and guards.
// 4. Performance: Improve loop processing, search complexity, and async actions.

// Legacy Code:
[Paste Legacy Code Here]

Act as a senior frontend engineer. Design a beautiful, dark-themed SaaS analytics dashboard using React, Tailwind CSS, and lucide-react icons for v0.dev.

UI Requirements:
1. **Sidebar Navigation**: Collapsible menu containing Dashboard, Users, Campaigns, Settings with subtle active states.
2. **Header Bar**: Global search bar, notification center bell icon, and a profile avatar dropdown.
3. **KPI Cards Grid**: 4 cards showing Revenue, Conversions, Active Users, Bounce Rate. Each card needs progress lines or mini trend sparklines.
4. **Main Chart Section**: Interactive dashboard container placeholder for weekly charts and recent transactions table.
5. **Aesthetics**: Premium deep slate bg (#09090b), glassmorphic card borders (border-white/10), clean typography (Inter), and neon purple accents.

Act as a senior UI engineer. Create a fully responsive step-by-step e-commerce checkout page layout for v0.dev.

Sections to include:
1. **Stepper Progress Bar**: "Cart -> Shipping -> Payment -> Confirmation" visual indicators.
2. **Shipping Form**: Interactive input fields for Name, Address, City, Zip Code, and Phone Number.
3. **Payment Form**: Visa/Mastercard credit card input wrapper layout showing placeholder formatting, expiry, and security CVV fields.
4. **Order Summary Side Card**: List of purchased items, prices, tax calculation, discount voucher inputs, and a glowing green "Pay Now" checkout button.
5. **Responsive Behavior**: 2-column layout on desktop, stacking into a single column on tablet/mobile views.

Act as a Senior Technical Writer and API Architect. Generate production-grade OpenAPI 3.0 documentation for the provided backend endpoint logic.

Deliverables:
1. OpenAPI 3.0 YAML Specification: Complete request/response schemas, path parameters, and JWT Bearer security schemes.
2. HTTP Status Code Catalog: Concrete JSON payload examples for 200 OK, 400 Bad Request, 401 Unauthorized, and 500 Internal Error scenarios.
3. Executable Code Snippets: Terminal cURL calls alongside Node.js fetch and Python requests examples.

Backend Service Endpoints:
[PASTE ENDPOINT OR CONTROLLER CODE HERE]

Act as a Lead Data Engineer and SQL Performance Tuning Specialist. Architect optimized SQL queries for complex business intelligence requirements.

Engineering Guidelines:
1. CTE & Window Functions: Replace nested subqueries with readable Common Table Expressions and OVER (PARTITION BY ...) analytical functions.
2. Indexing Strategy: Propose composite or partial B-Tree index definitions to minimize full table scans.
3. Expected Payload: Display sample query output rows with computed aggregation columns.

Database Schema & Metric Requirements:
[PASTE SCHEMA & ANALYTICS NEED HERE]

Act as a Lead Data Scientist and Senior Python Developer. Generate an end-to-end Python Pandas ETL and Seaborn data visualization script for the described dataset.

Script Features:
1. Data Cleaning & Outlier Removal: Impute null entries and isolate anomalies via Z-score / IQR algorithms.
2. Feature Engineering: Derive meaningful polynomial or bucketed categorical variables.
3. Publication-Grade Plots: Generate 3 distinct Seaborn correlation heatmaps and distribution boxplots.

Dataset Schema & Goal:
[PASTE DATASET COLUMNS AND GOAL HERE]