Contents

BEGIN;

SELECT PLAN(6);

--Verify PK and FK columns
SELECT col_is_fk('dummy_landable', 'pages', 'published_revision_id', 'pages have published_revision_id fk');
SELECT col_is_fk('dummy_landable', 'pages', 'theme_id', 'pages have theme_id fk');
SELECT col_is_fk('dummy_landable', 'pages', 'category_id', 'pages have category_id fk');
SELECT col_is_pk('dummy_landable', 'pages', 'page_id', 'page_id is PK');

--Verify unique index on path
SELECT index_is_unique('dummy_landable', 'pages', 'dummy_landable_pages__u_path', 'Path index is unique');

--Verify valid paths
SELECT throws_matching($$INSERT INTO dummy_landable.pages (is_publishable, path, status_code) VALUES ('true', 'good/page4', 200)$$, 'violates check', 'valid path');

SELECT * FROM finish()

ROLLBACK;

Version data entries

18 entries across 18 versions & 1 rubygems

Version	Path
landable-1.14.0	db/test/landable.pages.sql
landable-1.13.2	db/test/landable.pages.sql
landable-1.13.1	db/test/landable.pages.sql
landable-1.12.3	db/test/landable.pages.sql
landable-1.12.2	db/test/landable.pages.sql
landable-1.12.1	db/test/landable.pages.sql
landable-1.11.1	db/test/landable.pages.sql
landable-1.11.0	db/test/landable.pages.sql
landable-1.10.0.rc2	db/test/landable.pages.sql
landable-1.10.0.rc1	db/test/landable.pages.sql
landable-1.9.2	db/test/landable.pages.sql
landable-1.9.1	db/test/landable.pages.sql
landable-1.9.0	db/test/landable.pages.sql
landable-1.9.0.rc2	db/test/landable.pages.sql
landable-1.9.0.rc1	db/test/landable.pages.sql
landable-1.8.0	db/test/landable.pages.sql
landable-1.7.1.rc1	db/test/landable.pages.sql
landable-1.7.0	db/test/landable.pages.sql