sqlpage--sqlpage/examples/official-site/sqlpage/migrations/48_status_code.sql

-- Insert the status_code component into the component table
INSERT INTO
    component (name, description, icon)
VALUES
    (
        'status_code',
        'Sets the HTTP response code for the current page.

This is an advanced technical component.
You typically need it when building internet-facing APIs and websites,
but you may not need it for simple internal applications.

- Indicating operation results when using [SQLPage as an API](?component=json)
  - `200`: *OK*, for successful operations
  - `201`: *Created*, for successful record insertion
  - `404`: *Not Found*, for missing resources
  - `500`: *Internal Server Error*, for failed operations
- Handling data validation errors
  - `400`: *Bad Request*, for invalid data
- Enforcing access controls
  - `403`: *Forbidden*, for unauthorized access
  - `401`: *Unauthorized*, for unauthenticated access
- Tracking system health
  - `500`: *Internal Server Error*, for failed operations

For search engine optimization:
- Use `404` for deleted content to remove outdated URLs from search engines
- For redirection from one page to another, use 
  - `301` (moved permanently), or 
  - `302` (moved temporarily)
- Use `503` during maintenance',
        'error-404'
    );

-- Insert the parameters for the status_code component into the parameter table
INSERT INTO
    parameter (
        component,
        name,
        description,
        type,
        top_level,
        optional
    )
VALUES
    (
        'status_code',
        'status',
        'HTTP status code (e.g., 200 OK, 401 Unauthorized, 409 Conflict)',
        'INTEGER',
        TRUE,
        FALSE
    );

INSERT INTO example (component, description)
VALUES (
        'status_code',
        '
Set the HTTP status code to 404, indicating that the requested resource was not found.
Useful in combination with [`404.sql` files](/your-first-sql-website/custom_urls.sql):

```sql
SELECT ''status_code'' as component, 404 as status;
```
');