--------------------------------------------------------------------------------
-- postgresql-table_version - PostgreSQL table versioning extension
--
-- Copyright 2016 Crown copyright (c)
-- Land Information New Zealand and the New Zealand Government.
-- All rights reserved
--
-- This software is released under the terms of the new BSD license. See the 
-- LICENSE file for more information.
--
--------------------------------------------------------------------------------
-- Provide unit testing for table versioning system using pgTAP
--------------------------------------------------------------------------------
\set ECHO none
1..59
ok 1 - Schema table_version should exist
ok 2 - Should have revision table
ok 3 - Should have tables_changed table
ok 4 - Should have versioned_tables table
ok 5 - Function table_version.ver_complete_revision() should exist
ok 6 - Function table_version.ver_create_revision(text, timestamp without time zone, boolean) should exist
ok 7 - Function table_version.ver_create_table_functions(name, name, name) should exist
ok 8 - Function table_version.ver_create_version_trigger(name, name, name) should exist
ok 9 - Function table_version.ver_delete_revision(integer) should exist
ok 10 - Function table_version.ver_enable_versioning(name, name) should exist
ok 11 - Function table_version.ver_disable_versioning(name, name) should exist
ok 12 - Function table_version.ver_expandtemplate(text, text[]) should exist
ok 13 - Function table_version.ver_get_last_revision() should exist
ok 14 - Function table_version.ver_get_modified_tables(integer) should exist
ok 15 - Function table_version.ver_get_modified_tables(integer, integer) should exist
ok 16 - Function table_version.ver_get_revision(timestamp without time zone) should exist
ok 17 - Function table_version.ver_get_revision(integer) should exist
ok 18 - Function table_version.ver_get_revisions(integer[]) should exist
ok 19 - Function table_version.ver_get_revisions(timestamp without time zone, timestamp without time zone) should exist
ok 20 - Function table_version.ver_get_table_base_revision(name, name) should exist
ok 21 - Function table_version.ver_get_table_last_revision(name, name) should exist
ok 22 - Function table_version.ver_get_version_table(name, name) should exist
ok 23 - Function table_version.ver_get_version_table_full(name, name) should exist
ok 24 - Function table_version.ver_get_versioned_table_key(name, name) should exist
ok 25 - Function table_version.ver_get_versioned_tables() should exist
ok 26 - Function table_version.ver_is_table_versioned(name, name) should exist
ok 27 - Function table_version.ver_versioned_table_change_column_type(name, name, name, text) should exist
ok 28 - Function table_version.ver_versioned_table_add_column(name, name, name, text) should exist
ok 29 - Enable versioning on foo.bar
ok 30 - Check table is revisioned versioning on foo.bar
ok 31 - Check table foo.bar table key
ok 32 - Check table base revision
ok 33 - Function table_version.ver_get_foo_bar_revision(integer) should exist
ok 34 - Function table_version.ver_get_foo_bar_diff(integer, integer) should exist
ok 35 - Check get table revision function API
ok 36 - Foo bar diff for table creation
ok 37 - Create edit 1 revision
ok 38 - Complete edit 1 revision
ok 39 - Foo bar diff for edit 1
ok 40 - Create edit 2 revision
ok 41 - Complete edit 2 revision
ok 42 - Foo bar diff for edit 1 (recheck)
ok 43 - Foo bar diff range for edit 1-2
ok 44 - Foo bar diff for edit 2
ok 45 - Foo bar diff for edit 2 (larger range parameter)
ok 46 - Create edit 3 revision
ok 47 - Complete edit 3 revision
ok 48 - Foo bar diff check to ensure a row created and deleted in between revisions is not returned
ok 49 - Create edit 4 revision
ok 50 - Complete edit 4 revision
ok 51 - Foo bar diff for edit 4
ok 52 - Foo bar diff check to ensure a feature created and delete in between revision does not show (delete does not occur in last revision)
ok 53 - Create edit 4 revision
ok 54 - Complete edit 4 revision
ok 55 - Foo bar diff check re-insert a prevoiusly deleted row #1
ok 56 - Foo bar diff check re-insert a prevoiusly deleted row #2
ok 57 - Change column datatype
ok 58 - Add column datatype
ok 59 - Disable versioning on foo.bar