Update of /cvsroot/monetdb/sql/src/test/Via-m
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv22954
Modified Files:
create-viam.sql
Added Files:
insert_media1.sql insert_media2.sql insert_media3.sql
insert_media4.sql insert_media5.sql insert_media6.sql
insert_media7.sql media.sql
Log Message:
Added new via-m tests for media table
--- NEW FILE: insert_media1.sql ---
declare id_event1 integer;
declare id_media1 integer;
declare id_media_description1 integer;
set id_event1 = (select max(event_id) from event);
set id_media_description1 = (select max(media_description_id) from
media_description);
set id_media1 = add_media(id_event1, id_media_description1, 'identifier1', 1,
25, 125);
select id_media1;
U create-viam.sql
Index: create-viam.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Via-m/create-viam.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- create-viam.sql 22 Sep 2009 07:47:37 -0000 1.1
+++ create-viam.sql 22 Sep 2009 08:42:10 -0000 1.2
@@ -69,7 +69,7 @@
CONSTRAINT "annotator_annotator_id_pkey" PRIMARY KEY ("annotator_id"),
CONSTRAINT "unq_annotator_name" UNIQUE ("annotator_name")
);
-COPY 1 RECORDS INTO "sys"."annotator" FROM stdin USING DELIMITERS '\t';
+COPY 1 RECORDS INTO "sys"."annotator" FROM stdin USING DELIMITERS
'\t','\n','"';
1 "fabchannel" "the boss" true
CREATE TABLE "sys"."event" (
"event_id" int NOT NULL DEFAULT next value for "sys"."seq_event_id",
@@ -105,7 +105,7 @@
CONSTRAINT "media_description_media_description_id_pkey" PRIMARY KEY
("media_description_id"),
CONSTRAINT "unq_media_description_description" UNIQUE ("description")
);
-COPY 1 RECORDS INTO "sys"."media_description" FROM stdin USING DELIMITERS '\t';
+COPY 1 RECORDS INTO "sys"."media_description" FROM stdin USING DELIMITERS
'\t','\n','"';
1 "dummy description"
CREATE TABLE "sys"."model_sets_name" (
"model_sets_name_id" int NOT NULL DEFAULT next value for
"sys"."seq_model_sets_name_id",
@@ -132,7 +132,7 @@
CONSTRAINT "production_type_production_type_id_pkey" PRIMARY KEY
("production_type_id"),
CONSTRAINT "unq_production_type_steps" UNIQUE ("production_steps")
);
-COPY 2 RECORDS INTO "sys"."production_type" FROM stdin USING DELIMITERS '\t';
+COPY 2 RECORDS INTO "sys"."production_type" FROM stdin USING DELIMITERS
'\t','\n','"';
1 "full"
2 "result"
CREATE TABLE "sys"."media" (
--- NEW FILE: insert_media7.sql ---
declare id_event1 integer;
declare id_media1 integer;
declare id_media_description1 integer;
set id_event1 = (select event_id from event where event_name = 'event 1');
set id_media_description1 = (select max(media_description_id) + 1 from
media_description);
set id_media1 = add_media(id_event1, id_media_description1, 'description 3', 1,
25, 125);
select id_media1;
--- NEW FILE: insert_media3.sql ---
declare id_media_description integer;
set id_media_description = add_media_description('description 1');
select id_media_description;
--- NEW FILE: media.sql ---
select * from media;
select * from media_description;
--- NEW FILE: insert_media4.sql ---
declare id_event1 integer;
declare id_media1 integer;
declare id_media_description1 integer;
set id_event1 = (select event_id from event where event_name = 'event 1');
set id_media_description1 = (select max(media_description_id) from
media_description);
set id_media1 = add_media(id_event1, id_media_description1, 'identifier3', 1,
25, 125);
select id_media1;
--- NEW FILE: insert_media6.sql ---
declare id_event1 integer;
declare id_media1 integer;
declare id_media_description1 integer;
set id_event1 = (select max(event_id) + 1 from event);
set id_media_description1 = (select max(media_description_id) from
media_description);
set id_media1 = add_media(id_event1, id_media_description1, 'description 3', 1,
25, 125);
select id_media1;
--- NEW FILE: insert_media5.sql ---
declare id_event1 integer;
set id_event1 = -1;
declare id_media1 integer;
set id_media1 = -1;
declare id_media_description1 integer;
set id_event1 = (select event_id from event where event_name = 'event 1');
set id_media_description1 = (select max(media_description_id) from
media_description);
set id_media1 = add_media(id_event1, id_media_description1, NULL, 1, 25, 125);
select id_media1;
--- NEW FILE: insert_media2.sql ---
declare id_event1 integer;
declare id_media1 integer;
declare id_media_description1 integer;
set id_event1 = (select event_id from event where event_name = 'event 2');
set id_media_description1 = (select max(media_description_id) from
media_description);
set id_media1 = add_media(id_event1, id_media_description1, 'identifier2', 1,
25, 125);
select id_media1;
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
