summaryrefslogtreecommitdiff
path: root/sql/modules/test/Business_type.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/modules/test/Business_type.sql')
-rw-r--r--sql/modules/test/Business_type.sql17
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;