Management Guide

contents

/info/catalogdiffs

/info/catalogdiffs — compares two catalogs and reports on the differences

Synopsis

/info/catalogdiffs

Methods

POST

When you specify the IDs for two existing catalog objects as arguments to this METHOD, VoltDB returns information about the difference between, including any tables or stored procedures that have been added, removed, or modified.

Arguments

You must specify the IDs of the two catalogs to compare in the attributes lhs_id and rhs_id. The complete JSON structure is returned in the results. The structure of the JSON object is as follows:

Argument NameTypeDescription
lhs_id*TextThe ID of one of the catalogs to compare
rhs_id*TextThe ID of the other catalog to compare
restartBoolean (read-only)Whether a database must be restarted to update from the one catalog to the other.
ProjectDiffsList (read-only)A collection of objects identifying changes to features within the catalog, such as enabling or disabling security
TableDiffsList (read-only)A collection of objects identifying changes to schema, one entry per table where tables have been added, removed, or modified.
ProcedureDiffsList (read-only)A collection of objects identifying changes to stored procedures in the catalog, one entry per procedure where procedures have been added, removed, or modified.

*Required

Examples

The following example compares two catalogs:

curl -d '{"Catalogdiff":{"lhs_id":16777280,"rhs_id":16777265}}'\
     http://voltdbmgr:9000/man/api/1.0/info/catalogdiffs
contents