diff options
Diffstat (limited to 'sql/modules/test/Business_type.sql')
-rw-r--r-- | sql/modules/test/Business_type.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/modules/test/Business_type.sql b/sql/modules/test/Business_type.sql new file mode 100644 index 00000000..461537a3 --- /dev/null +++ b/sql/modules/test/Business_type.sql @@ -0,0 +1,17 @@ +BEGIN; +\i Base.sql + +INSERT INTO business (description) values ('testing'); + +INSERT INTO test_result (test_name, success) +SELECT 'Business Class Inserted', count(*) > 0 from business_type__list() +WHERE description = 'testing'; + +SELECT * FROM test_result; + +SELECT (select count(*) from test_result where success is true) +|| ' tests passed and ' +|| (select count(*) from test_result where success is not true) +|| ' failed' as message; + +ROLLBACK; |