Update of /cvsroot/monetdb/sql/src/test/Via-m
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv25962
Added Files:
file.sql insert_file1.sql insert_file2.sql insert_file3.sql
insert_file4.sql insert_file5.sql insert_file6.sql
insert_file7.sql insert_file8.sql
Log Message:
Added new via-m tests for file table
--- NEW FILE: insert_file7.sql ---
declare return_id integer;
set return_id = -1;
set return_id = i_add_video_file('dummy description',
'fabchannel2007',
'identifier4',
'filename 3',
250,
250,
25,
125,
'codec 1',
2000);
select return_id;
--- NEW FILE: insert_file1.sql ---
select i_add_video_set(21, 'fabchannel2007');
--- NEW FILE: file.sql ---
select * from video_sets;
select * from video_set;
select * from file;
--- NEW FILE: insert_file5.sql ---
declare id_file1 integer;
declare id_media1 integer;
set id_media1 = (select media_id
from media
where identifier = 'identifier2');
set id_file1 = add_file(id_media1,
'fabchannel2007',
'filename 2',
'codec 1',
2000,
2,
'url 1',
'empty',
250,
250);
select id_file1;
--- NEW FILE: insert_file8.sql ---
declare return_id integer;
set return_id = i_add_video_file_event('fabchannel2007',
'event 4',
'dummy description',
4,
'filename 4',
250,
250,
25,
125,
'codec 1',
2000);
select return_id;
--- NEW FILE: insert_file2.sql ---
declare next_file_quid integer;
set next_file_quid = get_next_file_quid('fabchannel2007');
select next_file_quid;
--- NEW FILE: insert_file6.sql ---
declare id_file1 integer;
declare id_media1 integer;
set id_media1 = (select media_id
from media
where identifier = 'identifier1');
set id_file1 = add_file(id_media1,
'fabchannel2007',
'filename 3',
'codec 1',
2000,
1,
'url 1',
'empty',
250,
250);
select id_file1;
--- NEW FILE: insert_file3.sql ---
declare video_sets_id1 integer;
set video_sets_id1 = get_video_sets_id('fabchannel2007');
select video_sets_id1;
--- NEW FILE: insert_file4.sql ---
declare id_file1 integer;
declare id_media1 integer;
set id_media1 = (select media_id
from media
where identifier = 'identifier1');
set id_file1 = add_file(id_media1,
'fabchannel2007',
'filename 1',
'codec 1',
2000,
1,
'url 1',
'empty',
250,
250);
select id_file1;
------------------------------------------------------------------------------
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
