View source

''This page describes the temporary table that is created to hold the ids of the selected deliverables.''

== Description ==

To hold the selected deliverables, a ''temporary'' table is created in the database. Although this table only has to hold the ids of the selected deliverables, it is convenient to have this table since it can be used when [[Undoing actions|undoing the last edits]].

== Design ==

The ids of the selected deliverables are stored in a temporary table. These ids are references to the ids in the [[Deliverables database table|deliverables table]]. The usage will be entering and deleting a deliverable and deleting all elements.

== Implementation ==

=== Creating the table ===

<syntaxhighlight lang="sql">
CREATE TEMPORARY TABLE SelectedDeliverables
(
  Id INTEGER REFERENCES Deliverables(Id) ON DELETE CASCADE
)
</syntaxhighlight>

=== Add a deliverable ===

<syntaxhighlight lang="sql">
INSERT INTO SelectedDeliverables VALUE(%d)
</syntaxhighlight>

=== Delete a deliverable ===

<syntaxhighlight lang="sql">
DELETE FROM SelectedDeliverables WHERE Id=%d
</syntaxhighlight>

=== Clear table ===

<syntaxhighlight lang="sql">
DELETE FROM SelectedDeliverables
</syntaxhighlight>

----

* [[Database]]