Zum Inhalt
HALOWERK

Technische Prüfungen & Formate

F TD2000 DOCUMENTS 11 / sqlite346 integer foreign key actions deferred transaction reconstruction

Replay foreign-key actions and deferred transaction commit behavior. Reconstruct the fully typed result and compare its complete canonical SHA256 claim.

POST https://detect.halowerk.com/v1/F-TD2000-DOCUMENTS-11/sqlite346-integer-foreign-key-actions-deferred-transaction-reconstruction

Eingaben

Felder des veröffentlichten Eingabeschemas
FeldTypPflichtBeschreibung
artifactobjectJa
Vollständiges Eingabeschema anzeigen
{
  "type": "object",
  "additionalProperties": false,
  "required": [
    "artifact"
  ],
  "properties": {
    "artifact": {
      "type": "object",
      "additionalProperties": false,
      "required": [
        "sqliteForeignKeys"
      ],
      "properties": {
        "sqliteForeignKeys": {
          "type": "object",
          "additionalProperties": false,
          "required": [
            "data",
            "claim"
          ],
          "properties": {
            "data": {
              "type": "object",
              "additionalProperties": false,
              "required": [
                "parents",
                "children",
                "deferred",
                "on_delete",
                "on_update",
                "default_parent",
                "events"
              ],
              "properties": {
                "parents": {
                  "type": "array",
                  "items": {
                    "type": "integer",
                    "minimum": -1000000,
                    "maximum": 1000000
                  },
                  "minItems": 0,
                  "maxItems": 40
                },
                "children": {
                  "type": "array",
                  "items": {
                    "type": "object",
                    "additionalProperties": false,
                    "required": [
                      "id",
                      "parent"
                    ],
                    "properties": {
                      "id": {
                        "type": "integer",
                        "minimum": 0,
                        "maximum": 1000000
                      },
                      "parent": {
                        "$ref": "#/properties/artifact/%24defs/s0"
                      }
                    }
                  },
                  "minItems": 0,
                  "maxItems": 40
                },
                "deferred": {
                  "type": "boolean"
                },
                "on_delete": {
                  "enum": [
                    "NO ACTION",
                    "RESTRICT",
                    "SET NULL",
                    "SET DEFAULT",
                    "CASCADE"
                  ]
                },
                "on_update": {
                  "enum": [
                    "NO ACTION",
                    "RESTRICT",
                    "SET NULL",
                    "SET DEFAULT",
                    "CASCADE"
                  ]
                },
                "default_parent": {
                  "$ref": "#/properties/artifact/%24defs/s0"
                },
                "events": {
                  "type": "array",
                  "items": {
                    "anyOf": [
                      {
                        "type": "object",
                        "additionalProperties": false,
                        "required": [
                          "kind"
                        ],
                        "properties": {
                          "kind": {
                            "enum": [
                              "begin",
                              "commit",
                              "rollback"
                            ]
                          }
                        }
                      },
                      {
                        "type": "object",
                        "additionalProperties": false,
                        "required": [
                          "kind",
                          "key"
                        ],
                        "properties": {
                          "kind": {
                            "enum": [
                              "insert_parent",
                              "delete_parent"
                            ]
                          },
                          "key": {
                            "type": "integer",
                            "minimum": -1000000,
                            "maximum": 1000000
                          }
                        }
                      },
                      {
                        "type": "object",
                        "additionalProperties": false,
                        "required": [
                          "kind",
                          "key",
                          "new_key"
                        ],
                        "properties": {
                          "kind": {
                            "enum": [
                              "update_parent"
                            ]
                          },
                          "key": {
                            "type": "integer",
                            "minimum": -1000000,
                            "maximum": 1000000
                          },
                          "new_key": {
                            "type": "integer",
                            "minimum": -1000000,
                            "maximum": 1000000
                          }
                        }
                      },
                      {
                        "type": "object",
                        "additionalProperties": false,
                        "required": [
                          "kind",
                          "id",
                          "parent"
                        ],
                        "properties": {
                          "kind": {
                            "enum": [
                              "insert_child",
                              "update_child"
                            ]
                          },
                          "id": {
                            "type": "integer",
                            "minimum": 0,
                            "maximum": 1000000
                          },
                          "parent": {
                            "$ref": "#/properties/artifact/%24defs/s0"
                          }
                        }
                      },
                      {
                        "type": "object",
                        "additionalProperties": false,
                        "required": [
                          "kind",
                          "id"
                        ],
                        "properties": {
                          "kind": {
                            "enum": [
                              "delete_child"
                            ]
                          },
                          "id": {
                            "type": "integer",
                            "minimum": 0,
                            "maximum": 1000000
                          }
                        }
                      }
                    ]
                  },
                  "minItems": 0,
                  "maxItems": 48
                }
              }
            },
            "claim": {
              "anyOf": [
                {
                  "type": "null"
                },
                {
                  "type": "string",
                  "minLength": 64,
                  "maxLength": 64,
                  "pattern": "^[0-9a-f]{64}$"
                }
              ]
            }
          }
        }
      },
      "$defs": {
        "s0": {
          "anyOf": [
            {
              "type": "null"
            },
            {
              "type": "integer",
              "minimum": -1000000,
              "maximum": 1000000
            }
          ]
        }
      }
    }
  }
}

Originalschema öffnen

Ergebnis & Dokumentation

Maschinenlesbare Dokumentation dieses Hubs

Quelle dieser Seite: der veröffentlichte HALOWERK-Katalog. Stand: 2026-11-01, 15:19 UTC.

Weitere Endpunkte dieses Hubs

Alle Endpunkte dieses Hubs →