NAME

Bif::SQLite::func_update_task - update a task topic

VERSION

0.1.0 (yyyy-mm-dd)

SYNOPSIS

#!sqlite
BEGIN;

INSERT INTO updates(...);

INSERT INTO func_update_task(
    update_id,  -- integer NOT NULL DEFAULT (currval('updates')),
    id,         -- integer NOT NULL DEFAULT (nextval('topics')),
    status_id,  -- integer
    title       -- varchar
) VALUES (...);

INSERT INTO func_merge_updates DEFAULT VALUES;

COMMIT;

DESCRIPTION

func_update_task() adds a task update to an in-progress update, by inserting a row into task_updates. As it just passes the values straight through this function is possibly a candidate for deletion.

AFFECTED TABLES

A successful call to func_update_task directly affects the following tables:

• task_updates

SEE ALSO

Bif::SQLite::table::updates, Bif::SQLite::table::tasks, Bif::SQLite::func_merge_updates

AUTHOR

Mark Lawrence <nomad@null.net>

COPYRIGHT AND LICENSE

Copyright 2013 Mark Lawrence <nomad@null.net>

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 3 of the License, or (at your option) any later version.