Update of /cvsroot/monetdb/sql/src/test/Via-m
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv18228/Via-m
Added Files:
create-viam.sql event.sql insert_event1.sql insert_event2.sql
insert_event3.sql insert_event4.sql
Log Message:
First set of tests for via-m schema and queries
--- NEW FILE: create-viam.sql ---
START TRANSACTION;
CREATE SEQUENCE "sys"."seq_annotator_id" AS INTEGER;
CREATE SEQUENCE "sys"."seq_event_id" AS INTEGER;
CREATE SEQUENCE "sys"."seq_event_metadata_id" AS INTEGER;
CREATE SEQUENCE "sys"."seq_feature_id" AS INTEGER;
CREATE SEQUENCE "sys"."seq_keyword_id" AS INTEGER;
CREATE SEQUENCE "sys"."seq_media_description_id" AS INTEGER;
CREATE SEQUENCE "sys"."seq_model_sets_name_id" AS INTEGER;
CREATE SEQUENCE "sys"."seq_video_sets_id" AS INTEGER;
CREATE SEQUENCE "sys"."seq_annotation_sets_id" AS INTEGER;
CREATE SEQUENCE "sys"."seq_production_type_id" AS INTEGER;
CREATE SEQUENCE "sys"."seq_media_id" AS INTEGER;
CREATE SEQUENCE "sys"."seq_file_id" AS INTEGER;
CREATE SEQUENCE "sys"."seq_fragment_id" AS INTEGER;
CREATE SEQUENCE "sys"."seq_feature_vector_id" AS INTEGER;
CREATE SEQUENCE "sys"."seq_annotation_id" AS INTEGER;
CREATE SEQUENCE "sys"."seq_frame_image_id" AS INTEGER;
CREATE SEQUENCE "sys"."seq_keyword_sets_id" AS INTEGER;
CREATE SEQUENCE "sys"."seq_keyword_set_id" AS INTEGER;
[...1015 lines suppressed...]
ALTER SEQUENCE "sys"."seq_video_sets_id" RESTART WITH 1 MINVALUE 1 NO CYCLE;
ALTER SEQUENCE "sys"."seq_annotation_sets_id" RESTART WITH 1 MINVALUE 1 NO
CYCLE;
ALTER SEQUENCE "sys"."seq_production_type_id" RESTART WITH 1 MINVALUE 1 NO
CYCLE;
ALTER SEQUENCE "sys"."seq_media_id" RESTART WITH 1 MINVALUE 1 NO CYCLE;
ALTER SEQUENCE "sys"."seq_file_id" RESTART WITH 1 MINVALUE 1 NO CYCLE;
ALTER SEQUENCE "sys"."seq_fragment_id" RESTART WITH 1 MINVALUE 1 NO CYCLE;
ALTER SEQUENCE "sys"."seq_feature_vector_id" RESTART WITH 1 MINVALUE 1 NO CYCLE;
ALTER SEQUENCE "sys"."seq_annotation_id" RESTART WITH 1 MINVALUE 1 NO CYCLE;
ALTER SEQUENCE "sys"."seq_frame_image_id" RESTART WITH 1 MINVALUE 1 NO CYCLE;
ALTER SEQUENCE "sys"."seq_keyword_sets_id" RESTART WITH 1 MINVALUE 1 NO CYCLE;
ALTER SEQUENCE "sys"."seq_keyword_set_id" RESTART WITH 1 MINVALUE 1 NO CYCLE;
ALTER SEQUENCE "sys"."seq_model_ref_id" RESTART WITH 1 MINVALUE 1 NO CYCLE;
ALTER SEQUENCE "sys"."seq_model_id" RESTART WITH 1 MINVALUE 1 NO CYCLE;
ALTER SEQUENCE "sys"."seq_model_sets_id" RESTART WITH 1 MINVALUE 1 NO CYCLE;
ALTER SEQUENCE "sys"."seq_model_set_id" RESTART WITH 1 MINVALUE 1 NO CYCLE;
ALTER SEQUENCE "sys"."seq_annotation_set_id" RESTART WITH 1 MINVALUE 1 NO CYCLE;
ALTER SEQUENCE "sys"."seq_production_id" RESTART WITH 1 MINVALUE 1 NO CYCLE;
ALTER SEQUENCE "sys"."seq_score_id" RESTART WITH 1 MINVALUE 1 NO CYCLE;
ALTER SEQUENCE "sys"."seq_video_set_id" RESTART WITH 1 MINVALUE 1 NO CYCLE;
COMMIT;
--- NEW FILE: insert_event4.sql ---
declare id_event integer;
set id_event = -1;
set id_event = add_event('event 4', 123456, 'artist2', 'location3',
'description3');
select id_event;
set id_event = add_event('event 4', '2009-06-23', NULL, NULL, 'description3');
select id_event;
delete from event where event_name = 'event 2';
insert into event_metadata (
event_id,
metadata_name,
metadata_value )
values ( 1,
'artist',
'artist1' );
set id_event = add_event('event 4', '2009-06-24', 'artist4', 'location4',
'description4');
select id_event;
--- NEW FILE: insert_event2.sql ---
declare id_event integer;
set id_event = -1;
set id_event = add_event('event 2', '2009-06-23', 'artist2', 'location2',
'description2');
select id_event;
--- NEW FILE: insert_event1.sql ---
declare id_event integer;
set id_event = add_event('event 1', '2009-06-23', 'artist1', 'location1',
'description1');
select id_event;
--- NEW FILE: insert_event3.sql ---
declare id_event integer;
set id_event = add_event('event 3', '2009-06-23', 'artist2', 'location3',
'description3');
select id_event;
--- NEW FILE: event.sql ---
select * from event;
select * from event_metadata;
------------------------------------------------------------------------------
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
