summaryrefslogtreecommitdiff
path: root/sql/modules/test/Business_type.sql
blob: 461537a36aa4b71fe03acbfffefd8956367560fc (plain)
  1. BEGIN;
  2. \i Base.sql
  3. INSERT INTO business (description) values ('testing');
  4. INSERT INTO test_result (test_name, success)
  5. SELECT 'Business Class Inserted', count(*) > 0 from business_type__list()
  6. WHERE description = 'testing';
  7. SELECT * FROM test_result;
  8. SELECT (select count(*) from test_result where success is true)
  9. || ' tests passed and '
  10. || (select count(*) from test_result where success is not true)
  11. || ' failed' as message;
  12. ROLLBACK;