/programs/{program_id}/frameworks/{framework_id}/compare_schemaCompare register schema
Compares the schema from the specified register with another framework's schema.
Quick start
curl "https://api.optitech.com/v1/programs/$PROGRAM_ID/frameworks/$FRAMEWORK_ID/compare_schema?db_name=$DB_NAME" \
-H "Authorization: Bearer $OPTITECH_API_KEY"Every field below is optional. An empty body works too.
import { createOptiTechClient, raw } from '@optitech/sdk';
const optitech = createOptiTechClient({ apiKey: process.env.OPTITECH_API_KEY });
const { data } = await raw.getProjectBranchSchemaComparison({
client: optitech.client,
path: {
program_id: process.env.PROGRAM_ID,
framework_id: process.env.FRAMEWORK_ID
},
query: {
db_name: process.env.DB_NAME,
timestamp: "2022-11-30T20:09:48Z",
base_timestamp: "2022-11-30T20:09:48Z"
}
});Parameters
program_idThe OptiTech program ID
framework_idThe framework ID
base_branch_idThe framework ID to compare the schema with
db_nameName of the register for which the schema is retrieved
lsnThe Log Sequence Number (LSN) for which the schema is retrieved
timestampThe point in time for which the schema is retrieved
base_lsnThe Log Sequence Number (LSN) for the base framework schema
base_timestampThe point in time for the base framework schema
Response
200Difference between the schemas
Errors
General error
This endpoint can return the standard OptiTech API error response.
Response fields
messageRequired. Human-readable error message.codeRequired. Machine-readable error code.request_idOptional. Request identifier for debugging. You can provide one with theX-Request-IDheader.
Retry guidance
If no response is returned, the request may still have reached the server. This is why retry safety depends on the method and status code.
Idempotent methods (GET, HEAD, OPTIONS) are generally safe to retry after a network error or timeout. Non-idempotent methods (POST, PATCH, DELETE, PUT) can change state, so avoid automatic retries unless your workflow can tolerate duplicate effects.
Responses with 423 Locked or 503 Service Unavailable are safe to retry. 423 Locked means the resource is temporarily locked, usually because another operation is in progress.