OSSP CVS Repository

ossp - Check-in [3431]
Not logged in 		[Honeypot]  [Browse]  [Home]  [Login]  [Reports] 
[Search]  [Ticket]  [Timeline] 
  [Patchset]  [Tagging/Branching] 

Check-in Number: 3431
Date: 2003-Jun-06 15:40:46 (local)
2003-Jun-06 13:40:46 (UTC)
User:rse
Branch:
Comment: greatly simplify creation of sample data by using the new as_hs_make() constructor
Tickets:
Inspections:
Files:
ossp-pkg/as/as-db/bres/bres-history.sql      1.8 -> 1.9     6 inserted, 23 deleted
ossp-pkg/as/as-db/bres/bres-history.sql 1.8 -> 1.9 

--- bres-history.sql     2003/06/06 13:33:43     1.8
+++ bres-history.sql     2003/06/06 13:40:46     1.9
@@ -426,29 +426,12 @@
 -- #  6th another new name "bar3" valid for usertime frame 200 upto n. i. 300
 
 -- whole test data injected
-INSERT INTO as_hs_st (st_oid,st_beg) VALUES (10, '2001-01-01');
-INSERT INTO as_hs_ut VALUES (10, '0100-01-01', '0200-01-01', currval('as_hs_st_seq'));
-INSERT INTO as_account VALUES (10, 'foo', currval('as_hs_st_seq'));
-
-INSERT INTO as_hs_st (st_oid,st_beg) VALUES (10, '2002-01-01');
-INSERT INTO as_hs_ut VALUES (10, '0200-01-01', '0300-01-01', currval('as_hs_st_seq'));
-INSERT INTO as_account VALUES (10, 'bar', currval('as_hs_st_seq'));
-
-INSERT INTO as_hs_st (st_oid,st_beg) VALUES (10, '2004-01-01');
-INSERT INTO as_hs_ut VALUES (10, '0100-01-01', 'infinity', currval('as_hs_st_seq'));
-INSERT INTO as_account VALUES (10, 'foo', currval('as_hs_st_seq'));
-
-INSERT INTO as_hs_st (st_oid,st_beg) VALUES (20, '2005-01-01');
-INSERT INTO as_hs_ut VALUES (20, '0100-01-01', 'infinity', currval('as_hs_st_seq'));
-INSERT INTO as_account VALUES (20, 'bar1', currval('as_hs_st_seq'));
-
-INSERT INTO as_hs_st (st_oid,st_beg) VALUES (20, '2006-01-01');
-INSERT INTO as_hs_ut VALUES (20, '0200-01-01', 'infinity', currval('as_hs_st_seq'));
-INSERT INTO as_account VALUES (20, 'bar2', currval('as_hs_st_seq'));
-
-INSERT INTO as_hs_st (st_oid,st_beg) VALUES (20, '2007-01-01');
-INSERT INTO as_hs_ut VALUES (20, '0200-01-01', '0300-01-01', currval('as_hs_st_seq'));
-INSERT INTO as_account VALUES (20, 'bar3', currval('as_hs_st_seq'));
+INSERT INTO as_account VALUES (10, 'foo',  as_hs_make(10, '0100-01-01', '0200-01-01', '2001-01-01'));
+INSERT INTO as_account VALUES (10, 'bar',  as_hs_make(10, '0200-01-01', '0300-01-01', '2002-01-01'));
+INSERT INTO as_account VALUES (10, 'foo',  as_hs_make(10, '0100-01-01', 'infinity',   '2004-01-01'));
+INSERT INTO as_account VALUES (20, 'bar1', as_hs_make(20, '0100-01-01', 'infinity',   '2005-01-01'));
+INSERT INTO as_account VALUES (20, 'bar2', as_hs_make(20, '0200-01-01', 'infinity',   '2006-01-01'));
+INSERT INTO as_account VALUES (20, 'bar3', as_hs_make(20, '0200-01-01', '0300-01-01', '2007-01-01'));
 
 -- ##
 -- ##  Data Dump

CVSTrac 2.0.1