Aider Stock Verification System Configuration
This skill configures Aider for the Stock Verification System project with proper model settings, file handling, linting, testing, and critical architecture rules.
Architecture Overview
**Backend**: FastAPI (Python 3.10+) on port 8001**Frontend**: React Native + Expo (TypeScript)**Primary DB**: MongoDB (Motor async driver)**ERP Source**: SQL Server (pyodbc, read-only)Critical Rules
1. **SQL Server is READ-ONLY** - All writes go to MongoDB
2. **Use parameterized queries (?)** for SQL - never string concatenation
3. **JWT auth required** for all /api/* endpoints
4. **Follow patterns** in existing code
5. **Run tests** before suggesting changes
Configuration Instructions
When setting up Aider for this project, apply these settings:
Model Configuration
**Main model**: `claude-sonnet-4-20250514`**Edit format**: `diff`**Weak model**: `claude-sonnet-4-20250514`Git & Commit Settings
Auto-commits: **disabled**Dirty commits: **disabled**Attribute author: **enabled**Attribute committer: **enabled**Attribute commit message author: **enabled**Attribute commit message committer: **enabled**Git integration: **enabled**Respect .gitignore: **enabled**Read-Only Reference Files
Never modify these files (reference only):
README.mdARCHITECTURE.mdAPI_CONTRACTS.mdAPI_REFERENCE.md.cursorrules.github/copilot-instructions.mdFiles to Ignore
Respect exclusions from:
.gitignore.aiderignoreLinting Commands
**Python**: `cd backend && ruff check --fix {fname}`**TypeScript**: `cd frontend && npm run lint -- --fix`Testing Commands
**Backend tests**: `cd backend && pytest tests/ -v`**Frontend tests**: `cd frontend && npm test`**Full CI**: `make test` or `make ci`Code Map Settings
Map tokens: 2048Map refresh: autoSafety Settings
Suggest shell commands: **enabled**Show diffs: **enabled**Check for updates: **enabled**Environment
Load environment from: `.env`Voice Settings
Voice language: `en` (English)System Prompt
When working on this project, always remember:
**SQL Server is READ-ONLY. All writes go to MongoDB.**
Use parameterized queries (?) for SQL - never string concatenationJWT auth required for all /api/* endpointsFollow patterns in existing codeRun tests before suggesting changesExample Usage
1. Start Aider in the project root with configuration loaded
2. Reference architecture docs (README.md, ARCHITECTURE.md, etc.) without modifying them
3. Make changes following the diff format
4. Lint Python with ruff, TypeScript with npm lint
5. Run tests before committing: `make test`
6. Ensure MongoDB writes and SQL Server reads are properly separated
Test Workflow
Before committing changes:
```bash
Backend tests
cd backend && pytest tests/ -v
Frontend tests
cd frontend && npm test
Full CI pipeline
make ci
```
Constraints
**Never modify** the read-only reference files listed above**Never write** to SQL Server (read-only constraint)**Always use** parameterized queries for SQL**Always require** JWT auth for API endpoints**Always run** tests before suggesting code changes