Keep migration change "log"

[joente]

It would be useful to have a log with migration changes.

What is a migration change?

• must be a query (test query->with_tp for parseres)
• one of the following functions is called:
  • new_type
  • set_type
  • del_type
  • mod_type
  • rename_type
  • set_enum
  • mod_enum
  • del_enum
  • rename_enum
  • new_procedure
  • mod_procedure
  • del_procedure
  • rename_procedure

New functions

commit

If enabled, commit(..) must be called before one of the functions above can be called.

commit(message);

For example:

commit("Adds field `x` to type `Y`");

mod_type('Y', 'add', 'x', 'int');

set_history

(thingsdb scope only)

set_history(scope, state);

Argument:

• scope: must be a collection (of thingsdb?) scope
• state: boolean, on/off

Existing collections have history off. We need to decide what will be the setting for new collections.

history

(Collection (and thingsdb?) scope only)

history([options])

Where options may contain the following:

options = {
    id: int
    match: regex
    contains: str
    after: datetime
    before: datetime
    last: int
    first: int
    has_err: bool
    detail: bool  (true to include the query itself in the result)
}

Examples:

// list with the last 10 migration changes
history({
    last: 10
});

// list all migration changes with a whole word match to MyType and include the query in the result
history({
    match: /\bMyType\b/,
    detail: true,
});

// list all migrations with del_type in the last 10 days
history({
    contains: 'del_type',
    after: datetime().move('days', -10),
});

del_history

del_history(options)

Clears history data. options is equal to options from the history() function except
that here option is required and must be none empty.

// Clear all history
del_history({
    match: /.*/
});

Migration change type

typedef struct {
    uint64_t id;        /* equal to the change_id */
    time_t ts;          /* timestamp of the change */
    char * query;       /* original query string */
    char * info;        /* may be NULL */
    char * by;          /* may be NULL */
} ti_commit_t;

Tasks

• TI_TASK_SET_HISTORY (for ttask)
• TI_TASK_DEL_HISTORY (for ttask)
• TI_TASK_COMMIT (with ti_commit_t data)

[joente]

Implemented in v1.8.0