Skip to content
Snippets Groups Projects
Select Git revision
  • 51d15bc04924a5e02d81fa03c72871f5b1ae1e2e
  • master default
  • v0.0.1
3 results

05-data.sql

Blame
  • 05-data.sql 3.39 KiB
    /*
       Initialization test for storage table
    */
    
    INSERT INTO storage (storage_type, base_path, base_url, hostname) VALUES ('cold', '/ia2_tape_generic_rw_01/users', NULL, 'tape-fe.ia2.inaf.it');
    INSERT INTO storage (storage_type, base_path, base_url, hostname) VALUES ('hot', '/mnt/hot_storage/users', NULL, 'server');
    INSERT INTO storage (storage_type, base_path, base_url, hostname) VALUES ('local', '/home', NULL, 'localhost');
    INSERT INTO storage (storage_type, base_path, base_url, hostname) VALUES ('local', '/home/vospace/upload', NULL, 'localhost');
    INSERT INTO storage (storage_type, base_path, base_url, hostname) VALUES ('portal', NULL, '/files/new/lbt', 'archive.lbto.org');
    
    
    /*
       Initialization test for location table
    */
    
    INSERT INTO location (location_type, storage_src_id, storage_dest_id) VALUES ('async', 1, 3);
    INSERT INTO location (location_type, storage_src_id, storage_dest_id) VALUES ('async', 2, 3);
    INSERT INTO location (location_type, storage_src_id, storage_dest_id) VALUES ('user', 4, 4);
    INSERT INTO location (location_type, storage_src_id, storage_dest_id) VALUES ('portal', 5, 5);
    
    
    /*
       Initialization test for vospace node table
    */
    
    
    -- parent_path = parent_relative_path
    INSERT INTO node (parent_path, parent_relative_path, name, type, creator_id, is_public, sticky) VALUES (NULL, NULL, '', 'container', '0', true, true);                                                                                -- /
    INSERT INTO node (parent_path, parent_relative_path, name, type, creator_id, sticky) VALUES ('', NULL, 'cristiano.urban', 'container', '3354', true);                                                                        -- /curban
    INSERT INTO node (parent_path, parent_relative_path, name, type, creator_id, sticky) VALUES ('', NULL, 'sara.bertocco', 'container', '2048', true);                                                                     -- /sbertocco
    INSERT INTO node (parent_path, parent_relative_path, name, type, creator_id, sticky) VALUES ('', NULL, 'sonia.zorba', 'container', '2386', true);                                                                        -- /szorba
    -- parent_path <> parent_relative_path
    INSERT INTO node (parent_path, parent_relative_path, name, type, creator_id, group_read, group_write) VALUES ('', NULL, 'test', 'container', '2386', '{"VOSpace.test1"}','{"VOSpace.test1"}');      -- /test
    INSERT INTO node (parent_path, parent_relative_path, name, type, creator_id) VALUES ('5', '', 'f1', 'container', '2386');                                                                           -- /test/f1 (rel: /f1)
    INSERT INTO node (parent_path, parent_relative_path, name, os_name, type, creator_id, location_id) VALUES ('5.6', '6', 'f2_renamed', 'f2', 'container', '2386', 1);                                                 -- /test/f1/f2_renamed (rel: /f1/f2)
    INSERT INTO node (parent_path, parent_relative_path, name, type, creator_id, location_id) VALUES ('5.6.7', '6.7', 'f3', 'data', '2386', 1);                                                                         -- /test/f1/f2_renamed/f3 (rel: /f1/f2/f3)
    
    
    /*
       Initialization test for vospace users table
    */
    
    INSERT INTO Users (user_id, user_name, e_mail) VALUES ('3354', 'cristiano.urban', 'cristiano.urban@inaf.it');
    INSERT INTO Users (user_id, user_name, e_mail) VALUES ('2048', 'sara.bertocco', 'sara.bertocco@inaf.it');
    INSERT INTO Users (user_id, user_name, e_mail) VALUES ('2386', 'sonia.zorba', 'sonia.zorba@inaf.it');