Prompting & Commands

# Understand the Task model's fields and relationships
gemini "@models.py Explain the Task model. What is the purpose of the task_tags table?"

# Understand schema validation rules
gemini "@schemas.py What fields are optional vs required in TaskCreate?"

# Understand the auth dependency
gemini "@auth.py What does get_current_user raise if the token is expired or invalid?"

# Understand database connection lifecycle
gemini "@database.py Why does get_db use yield instead of return?"

# Check model-schema alignment
gemini "@models.py @schemas.py Are all Task model fields represented in the Task response schema? List any that are missing."

# Trace auth dependencies across layers
gemini "@auth.py @routers/tasks.py Which task endpoints use get_current_user? How does it get injected?"

# Understand the full request cycle
gemini "@database.py @routers/tasks.py How does the database session get created and closed for a single POST /tasks/ request?"

# Find potential N+1 query issues
gemini "@models.py @routers/tasks.py When list_tasks returns results with tags, how many SQL queries are executed? Is there an N+1 risk?"

# Load all router files at once
gemini "@routers/ What authentication is required for each endpoint? Which ones are public?"

# Analyze all tests at once
gemini "@tests/ What test coverage exists? List any endpoints or functions that have no tests."

# Load entire project for architecture review
gemini "@routers/ @models.py @schemas.py @auth.py If I wanted to add a 'project' resource that tasks belong to, what changes would I need to make across all these files?"

# Pass an error message with context using here-string
$prompt = @'
I got this error when calling POST /tasks/:

sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: tasks.owner_id

Here is the create_task endpoint: @routers/tasks.py

What is causing the error and how do I fix it?
'@
gemini -p $prompt --no-interactive

# In the interactive session, type:
> Fix this function so it handles the case where tag_ids contains non-existent IDs:
```python
def create_task(task: schemas.TaskCreate, db: Session, current_user: models.User):
    tags = db.query(models.Tag).filter(models.Tag.id.in_(task.tag_ids)).all()
    db_task = models.Task(**task.dict(), owner_id=current_user.id, tags=tags)
    db.add(db_task)
    db.commit()
    return db_task
```