Changeset 23 for trunk/epic/test/test_globals.sql

Timestamp:

09/07/08 23:57:57 (4 years ago)

Author:

fumanchu

Message:

Lots of changes:

1. Changed global to return the TEMP tablename instead of a record. Use the new test.get function to obtain a record.
   
2. Added a 'name' arg to global to re-use the TEMP table.
   
3. New test.get(call, rownum).
   
4. Moved the few public functions into the test schema.
   
5. Moved the under-under attributes to new functions: constructor, len, iter.
   
6. Made run_test prepend the test schema to search_path.
   

Files:

• trunk/epic/test/test_globals.sql (modified) (2 diffs)

trunk/epic/test/test_globals.sql

@@ -4 +4 @@
 CREATE OR REPLACE FUNCTION test._test_global() RETURNS VOID AS $$
 DECLARE
+  g      text;
+  g2     text;
   rec    record;
   trec   record;
 BEGIN
-  rec := global('pg_namespace WHERE nspname = ''test'';');
+  g := global('pg_namespace WHERE nspname = ''test'';');
   
-  -- The result of global() should be a normal record.
+  -- The returned string MUST be the name of the TEMP table.
+  PERFORM test.assert(g LIKE E'\_global\_%', g || ' not like _global');
+  
+  rec := get(g);
+  
+  -- The result of get() should be a normal record.
   PERFORM test.assert_equal(rec.nspname, 'test');
   
@@ -15 +22 @@
   PERFORM test.assert(rec.__name__ LIKE E'\_global\_%', rec.__name__ || ' not like _global');
   
-  -- The .__name__ MUST reference a temporary table with the same fields.
-  EXECUTE 'SELECT * FROM ' || rec.__name__ INTO trec;
+  -- The global MUST reference a temporary table with the same fields.
+  EXECUTE 'SELECT * FROM ' || g INTO trec;
   PERFORM test.assert_equal(trec.nspname, 'test');
   PERFORM test.assert_equal(trec.nspowner, rec.nspowner);
   PERFORM test.assert_equal(trec.nspacl, rec.nspacl);
   
-  -- The returned record MUST possess a .__create__ attribute.
-  PERFORM test.assert_equal(rec.__create__, 'SELECT * FROM pg_namespace WHERE nspname = ''test''');
+  -- The TEMP table MUST possess its own constructor SQL string in a COMMENT
+  PERFORM test.assert_equal(constructor(g), 'SELECT * FROM pg_namespace WHERE nspname = ''test''');
   
-  -- The returned record MUST possess a .__record__ attribute.
-  PERFORM test.assert_equal(rec.__record__,
-    'SELECT * FROM _global_record(''' || rec.__name__ || ''', ''' || rec.__create__ || ''')');
+  -- Test the iter() function.
+  g2 := global('iter(''' || g || ''')');
+  PERFORM test.assert_not_empty(g2);
   
-  -- The returned record MUST possess an .__iter__ attribute.
-  PERFORM test.assert_equal(rec.__iter__, 'SELECT * FROM ' || rec.__name__);
-  PERFORM test.assert_not_empty(rec.__iter__);
+  -- Test the attributes() function.
+  PERFORM test.assert_column('SELECT attname FROM attributes(''' || g || ''')',
+                             ARRAY['nspname', 'nspowner', 'nspacl']);
   
-  -- The returned record MUST possess an .__attributes__ attribute.
-  PERFORM test.assert_equal(rec.__attributes__, 'SELECT attname FROM test.attributes(''' || rec.__name__ || ''')');
-  PERFORM test.assert_column(rec.__attributes__, ARRAY['nspname', 'nspowner', 'nspacl']);
-  
-  -- The returned record MUST possess a .__len__ attribute.
-  PERFORM test.assert_equal(rec.__len__, 1);
+  -- Test the len() function.
+  PERFORM test.assert_equal(len(g), 1);
   
   -- Raise an exception to test deletion of the TEMP table ON COMMIT
-  RAISE EXCEPTION '%', rec.__name__;
+  RAISE EXCEPTION '%', g;
 END;
 $$ LANGUAGE plpgsql;