# Codev

## Read records

> Retrieves records from the specified Codev table with optional filtering and field selection. Features:\
>     \- Select specific fields using comma-separated field names\
>     \- Filter results using JSON-formatted query conditions\
>     \- Returns all matching records as an array\
>     \
>     Common use cases:\
>     \- Get all commits for a specific repository\
>     \- Find deployments within a date range\
>     \- List issues assigned to a user\
>     \- Track file changes across branches\
>     \
>     Returns empty array if no records match the criteria.

```json
{"openapi":"3.0.0","info":{"title":"sfp server","version":"51.9.0"},"security":[{"access-token":[]}],"components":{"securitySchemes":{"access-token":{"scheme":"bearer","bearerFormat":"JWT","type":"http","in":"header"}}},"paths":{"/sfp/api/codev/{table}":{"get":{"operationId":"CodevCrudController_read","summary":"Read records","description":"Retrieves records from the specified Codev table with optional filtering and field selection. Features:\n    - Select specific fields using comma-separated field names\n    - Filter results using JSON-formatted query conditions\n    - Returns all matching records as an array\n    \n    Common use cases:\n    - Get all commits for a specific repository\n    - Find deployments within a date range\n    - List issues assigned to a user\n    - Track file changes across branches\n    \n    Returns empty array if no records match the criteria.","parameters":[{"name":"table","required":true,"in":"path","description":"The table to read from","schema":{"type":"string"}},{"name":"select","required":false,"in":"query","description":"Comma-separated list of fields to return (defaults to *)","schema":{"type":"string"}},{"name":"filter","required":false,"in":"query","description":"JSON string of filter conditions","schema":{"type":"string"}}],"responses":{"200":{"description":"Records retrieved successfully.","content":{"application/json":{}}},"403":{"description":"Forbidden - Requires role: member, application"}},"tags":["Codev"]}}}}
```

## Create a new record

> Creates a new record in the specified Codev table. Codev tables store various development lifecycle data including:\
>     \- codev\_commit\_stream: Git commit history and metadata\
>     \- codev\_deploy\_stream: Deployment events and status\
>     \- codev\_file\_stream: File change tracking\
>     \- codev\_user: Developer profiles and activity\
>     \- codev\_issue: Issue tracking and management\
>     \- codev\_review\_stream: Code review activity\
>     \- codev\_tasks: Task management and tracking\
>     \
>     The data structure varies by table type. See examples for each table's schema. Returns the created record with generated ID and timestamps.

```json
{"openapi":"3.0.0","info":{"title":"sfp server","version":"51.9.0"},"security":[{"access-token":[]}],"components":{"securitySchemes":{"access-token":{"scheme":"bearer","bearerFormat":"JWT","type":"http","in":"header"}},"schemas":{"CodevCreateDto":{"type":"object","properties":{"table":{"type":"string","description":"The table to create the record in"},"data":{"type":"object","description":"The data to create"},"fetchAll":{"type":"boolean","description":"When true, returns all created records. When false or omitted, returns only the first record","default":false}},"required":["table","data"]}}},"paths":{"/sfp/api/codev/{table}":{"post":{"operationId":"CodevCrudController_create","summary":"Create a new record","description":"Creates a new record in the specified Codev table. Codev tables store various development lifecycle data including:\n    - codev_commit_stream: Git commit history and metadata\n    - codev_deploy_stream: Deployment events and status\n    - codev_file_stream: File change tracking\n    - codev_user: Developer profiles and activity\n    - codev_issue: Issue tracking and management\n    - codev_review_stream: Code review activity\n    - codev_tasks: Task management and tracking\n    \n    The data structure varies by table type. See examples for each table's schema. Returns the created record with generated ID and timestamps.","parameters":[{"name":"table","required":true,"in":"path","description":"The table to create the record in","schema":{"type":"string"}}],"requestBody":{"required":true,"content":{"application/json":{"schema":{"$ref":"#/components/schemas/CodevCreateDto"}}}},"responses":{"201":{"description":"Record created successfully.","content":{"application/json":{"schema":{"$ref":"#/components/schemas/CodevCreateDto"}}}},"403":{"description":"Forbidden - Requires role: member, application"},"409":{"description":"Conflict error."}},"tags":["Codev"]}}}}
```

## Update records

> Updates existing records in the specified Codev table that match the filter conditions. This endpoint:\
>     \- Updates all records matching the filter criteria\
>     \- Supports partial updates (only specified fields are modified)\
>     \- Automatically updates the updated\_at timestamp\
>     \- Returns all updated records with their new values\
>     \
>     Common use cases:\
>     \- Update deployment status\
>     \- Mark issues as resolved\
>     \- Update task assignments\
>     \- Modify review states\
>     \
>     The filter parameter is required to prevent accidental bulk updates. Use specific filters to target intended records.

```json
{"openapi":"3.0.0","info":{"title":"sfp server","version":"51.9.0"},"security":[{"access-token":[]}],"components":{"securitySchemes":{"access-token":{"scheme":"bearer","bearerFormat":"JWT","type":"http","in":"header"}},"schemas":{"CodevUpdateDataDto":{"type":"object","properties":{"data":{"type":"object","description":"The data to update matched records with"}},"required":["data"]}}},"paths":{"/sfp/api/codev/{table}":{"put":{"operationId":"CodevCrudController_update","summary":"Update records","description":"Updates existing records in the specified Codev table that match the filter conditions. This endpoint:\n    - Updates all records matching the filter criteria\n    - Supports partial updates (only specified fields are modified)\n    - Automatically updates the updated_at timestamp\n    - Returns all updated records with their new values\n    \n    Common use cases:\n    - Update deployment status\n    - Mark issues as resolved\n    - Update task assignments\n    - Modify review states\n    \n    The filter parameter is required to prevent accidental bulk updates. Use specific filters to target intended records.","parameters":[{"name":"table","required":true,"in":"path","description":"The table to update records in","schema":{"type":"string"}},{"name":"filter","required":true,"in":"query","description":"JSON string of query conditions to match records to update","schema":{"type":"string"}}],"requestBody":{"required":true,"description":"The data to update matched records with","content":{"application/json":{"schema":{"$ref":"#/components/schemas/CodevUpdateDataDto"}}}},"responses":{"200":{"description":"Records updated successfully.","content":{"application/json":{"schema":{"type":"array","items":{"$ref":"#/components/schemas/CodevUpdateDataDto"}}}}},"403":{"description":"Forbidden - Requires role: member, application"}},"tags":["Codev"]}}}}
```

## Delete records

> Permanently deletes records from the specified Codev table that match the query conditions. This operation:\
>     \- Removes all records matching the query criteria\
>     \- Cannot be undone - deleted data is permanently lost\
>     \- Returns no content on successful deletion\
>     \
>     Safety considerations:\
>     \- Always use specific query conditions to avoid mass deletion\
>     \- Consider archiving data instead of deletion for audit trails\
>     \- Some tables may have referential integrity constraints\
>     \
>     Common use cases:\
>     \- Remove outdated deployment records\
>     \- Clean up resolved issues\
>     \- Delete test data

```json
{"openapi":"3.0.0","info":{"title":"sfp server","version":"51.9.0"},"security":[{"access-token":[]}],"components":{"securitySchemes":{"access-token":{"scheme":"bearer","bearerFormat":"JWT","type":"http","in":"header"}},"schemas":{"CodevDeleteDto":{"type":"object","properties":{"key":{"type":"string","description":"The field name to filter by"},"value":{"type":"object","description":"The value to match for deletion"}},"required":["key","value"]}}},"paths":{"/sfp/api/codev/{table}":{"delete":{"operationId":"CodevCrudController_delete","summary":"Delete records","description":"Permanently deletes records from the specified Codev table that match the query conditions. This operation:\n    - Removes all records matching the query criteria\n    - Cannot be undone - deleted data is permanently lost\n    - Returns no content on successful deletion\n    \n    Safety considerations:\n    - Always use specific query conditions to avoid mass deletion\n    - Consider archiving data instead of deletion for audit trails\n    - Some tables may have referential integrity constraints\n    \n    Common use cases:\n    - Remove outdated deployment records\n    - Clean up resolved issues\n    - Delete test data","parameters":[{"name":"table","required":true,"in":"path","description":"The table to delete records from","schema":{"type":"string"}}],"requestBody":{"required":true,"description":"The key and value to identify which records to delete.","content":{"application/json":{"schema":{"$ref":"#/components/schemas/CodevDeleteDto"}}}},"responses":{"200":{"description":"Records deleted successfully."},"403":{"description":"Forbidden - Requires role: member, application"}},"tags":["Codev"]}}}}
```

## Insert or update records

> Performs an upsert operation (insert or update) on the specified Codev table. This endpoint:\
>     \- Attempts to insert the provided data as a new record\
>     \- If a conflict occurs on specified columns, updates the existing record instead\
>     \- Useful for idempotent operations and syncing external data\
>     \
>     The onConflict parameter specifies which columns to check for uniqueness:\
>     \- For commits: typically \['commit'] (commit hash)\
>     \- For deployments: \['deployment\_id'] or \['repo', 'environment', 'timestamp']\
>     \- For users: \['email'] or \['username']\
>     \
>     Returns the inserted or updated record(s). This is the preferred method for syncing data from external systems where you're unsure if the record already exists.

```json
{"openapi":"3.0.0","info":{"title":"sfp server","version":"51.9.0"},"security":[{"access-token":[]}],"components":{"securitySchemes":{"access-token":{"scheme":"bearer","bearerFormat":"JWT","type":"http","in":"header"}},"schemas":{"CodevUpsertDto":{"type":"object","properties":{"data":{"type":"object","description":"The data to insert. If a record with matching onConflict columns exists, this data will update that record instead."},"onConflict":{"description":"The columns to check for conflicts. If a record exists with the same values for these columns, it will be updated instead of inserted.","type":"array","items":{"type":"string"}}},"required":["data"]}}},"paths":{"/sfp/api/codev/{table}/upsert":{"put":{"operationId":"CodevCrudController_upsert","summary":"Insert or update records","description":"Performs an upsert operation (insert or update) on the specified Codev table. This endpoint:\n    - Attempts to insert the provided data as a new record\n    - If a conflict occurs on specified columns, updates the existing record instead\n    - Useful for idempotent operations and syncing external data\n    \n    The onConflict parameter specifies which columns to check for uniqueness:\n    - For commits: typically ['commit'] (commit hash)\n    - For deployments: ['deployment_id'] or ['repo', 'environment', 'timestamp']\n    - For users: ['email'] or ['username']\n    \n    Returns the inserted or updated record(s). This is the preferred method for syncing data from external systems where you're unsure if the record already exists.","parameters":[{"name":"table","required":true,"in":"path","description":"The table to insert/update records in","schema":{"type":"string"}}],"requestBody":{"required":true,"description":"The data to insert/update and optional conflict columns. If onConflict is specified and a record matches those columns, it will be updated instead of inserted.","content":{"application/json":{"schema":{"$ref":"#/components/schemas/CodevUpsertDto"}}}},"responses":{"200":{"description":"Record inserted or updated successfully."},"403":{"description":"Forbidden - Requires role: member, application"}},"tags":["Codev"]}}}}
```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.flxbl.io/flxbl/sfp-server/api-reference/codev.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.