<commit_before>INSERT INTO schema_version(key, extra) values ('003', 'schema version');

-- Add a request rspec for a single node.
INSERT INTO rspec(name, schema, schema_version, description, rspec)
  VALUES
  ('One compute node', 'GENI', '3',
   'Any one compute node.',
   '<?xml version="1.0" encoding="UTF-8"?>
<rspec xmlns="http://www.geni.net/resources/rspec/3"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.geni.net/resources/rspec/3 http://www.geni.net/resources/rspec/3/request.xsd"
       type="request">
  <node client_id="foo"/>
</rspec>'
);
INSERT INTO rspec(name, schema, schema_version, description, rspec)
  VALUES
  ('Two compute nodes', 'GENI', '3',
   'Any two compute nodes.',
   '<?xml version="1.0" encoding="UTF-8"?>
<rspec xmlns="http://www.geni.net/resources/rspec/3"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.geni.net/resources/rspec/3 http://www.geni.net/resources/rspec/3/request.xsd"
       type="request">
  <node client_id="foo"/>
</rspec>'
);
INSERT INTO rspec(name, schema, schema_version, description, rspec)
  VALUES
  ('Two nodes, one link', 'GENI', '3',
   'Two nodes with a link between them.',
   '<?xml version="1.0" encoding="UTF-8"?>
<rspec xmlns="http://www.geni.net/resources/rspec/3"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.geni.net/resources/rspec/3 http://www.geni.net/resources/rspec/3/request.xsd"
       type="request">
  <node client_id="foo"/>
</rspec>'
);
INSERT INTO rspec(name, schema, schema_version, description, rspec)
  VALUES
  ('Three nodes, triangle topology', 'GENI', '3',
   'Three nodes in a triangle topology.',
   '<?xml version="1.0" encoding="UTF-8"?>
<rspec xmlns="http://www.geni.net/resources/rspec/3"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.geni.net/resources/rspec/3 http://www.geni.net/resources/rspec/3/request.xsd"
       type="request">
  <node client_id="foo"/>
</rspec>'
);<commit_msg>add a bunch of canned rspecs. In particular, 2 nodes 1 link is real and works<commit_after>INSERT INTO schema_version(key, extra) values ('003', 'schema version');

-- Add a request rspec for a single node.
INSERT INTO rspec(name, schema, schema_version, description, rspec)
  VALUES
  ('One compute node', 'GENI', '3',
   'Any one compute node.',
   '<?xml version="1.0" encoding="UTF-8"?>
<rspec xmlns="http://www.geni.net/resources/rspec/3"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.geni.net/resources/rspec/3 http://www.geni.net/resources/rspec/3/request.xsd"
       type="request">
  <node client_id="foo"/>
</rspec>'
);
INSERT INTO rspec(name, schema, schema_version, description, rspec)
  VALUES
  ('Two compute nodes', 'GENI', '3',
   'Any two compute nodes.',
   '<?xml version="1.0" encoding="UTF-8"?>
<rspec xmlns="http://www.geni.net/resources/rspec/3"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.geni.net/resources/rspec/3 http://www.geni.net/resources/rspec/3/request.xsd"
       type="request">
  <node client_id="foo"/>
  <node client_id="bar"/>
</rspec>'
);
INSERT INTO rspec(name, schema, schema_version, description, rspec)
  VALUES
  ('Two nodes, one link', 'GENI', '3',
   'Two nodes with a link between them.',
   '<rspec type="request" 
	xmlns="http://www.geni.net/resources/rspec/3" 
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
	xsi:schemaLocation="http://www.geni.net/resources/rspec/3 
	http://www.geni.net/resources/rspec/3/request.xsd">  
  <node client_id="VM-1" >
    <interface client_id="VM-1:if0"/>
  </node>
  <node client_id="VM-2">
    <interface client_id="VM-2:if0"/>
  </node>
  <link client_id="lan0">
    <interface_ref client_id="VM-1:if0"/>
    <interface_ref client_id="VM-2:if0"/>
    <property source_id="VM-1:if0" dest_id="VM-2:if0"/>
    <property source_id="VM-2:if0" dest_id="VM-1:if0"/>
    <link_type name="lan"/>
  </link>
</rspec>'
);
INSERT INTO rspec(name, schema, schema_version, description, rspec)
  VALUES
  ('Three nodes, triangle topology', 'GENI', '3',
   'Three nodes in a triangle topology.',
   '<?xml version="1.0" encoding="UTF-8"?>
<rspec xmlns="http://www.geni.net/resources/rspec/3"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.geni.net/resources/rspec/3 http://www.geni.net/resources/rspec/3/request.xsd"
       type="request">
  <node client_id="VM-1">
    <interface client_id="VM-1:if0"/>
    <interface client_id="VM-1:if1"/>
  </node>
  <node client_id="VM-2">
    <interface client_id="VM-2:if0"/>
    <interface client_id="VM-2:if1"/>
  </node>
  <node client_id="VM-3">
    <interface client_id="VM-3:if0"/>
    <interface client_id="VM-3:if1"/>
  </node>
  <link client_id="lan0">
    <interface_ref client_id="VM-1:if0"/>
    <interface_ref client_id="VM-2:if0"/>
    <property source_id="VM-1:if0" dest_id="VM-2:if0"/>
    <property source_id="VM-2:if0" dest_id="VM-1:if0"/>
    <link_type name="lan"/>
  </link>
  <link client_id="lan1">
    <interface_ref client_id="VM-2:if1"/>
    <interface_ref client_id="VM-3:if1"/>
    <property source_id="VM-2:if1" dest_id="VM-3:if1"/>
    <property source_id="VM-3:if1" dest_id="VM-2:if1"/>
    <link_type name="lan"/>
  </link>
  <link client_id="lan2">
    <interface_ref client_id="VM-1:if1"/>
    <interface_ref client_id="VM-3:if0"/>
    <property source_id="VM-1:if1" dest_id="VM-3:if0"/>
    <property source_id="VM-3:if0" dest_id="VM-1:if1"/>
    <link_type name="lan"/>
  </link>
</rspec>'
);
INSERT INTO rspec(name, schema, schema_version, description, rspec)
  VALUES
  ('Four nodes, diamond topology', 'GENI', '3',
   'Four nodes in a diamond topology.',
   '<?xml version="1.0" encoding="UTF-8"?>
<rspec xmlns="http://www.geni.net/resources/rspec/3"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.geni.net/resources/rspec/3 http://www.geni.net/resources/rspec/3/request.xsd"
       type="request">
  <node client_id="VM-1">
    <interface client_id="VM-1:if0"/>
    <interface client_id="VM-1:if1"/>
  </node>
  <node client_id="VM-2">
    <interface client_id="VM-2:if0"/>
    <interface client_id="VM-2:if1"/>
  </node>
  <node client_id="VM-3">
    <interface client_id="VM-3:if0"/>
    <interface client_id="VM-3:if1"/>
  </node>
  <node client_id="VM-4">
    <interface client_id="VM-4:if0"/>
    <interface client_id="VM-4:if1"/>
  </node>
  <link client_id="lan0">
    <interface_ref client_id="VM-1:if0"/>
    <interface_ref client_id="VM-2:if0"/>
    <property source_id="VM-1:if0" dest_id="VM-2:if0"/>
    <property source_id="VM-2:if0" dest_id="VM-1:if0"/>
    <link_type name="lan"/>
  </link>
  <link client_id="lan1">
    <interface_ref client_id="VM-2:if1"/>
    <interface_ref client_id="VM-3:if1"/>
    <property source_id="VM-2:if1" dest_id="VM-3:if1"/>
    <property source_id="VM-3:if1" dest_id="VM-2:if1"/>
    <link_type name="lan"/>
  </link>
  <link client_id="lan2">
    <interface_ref client_id="VM-4:if1"/>
    <interface_ref client_id="VM-3:if0"/>
    <property source_id="VM-4:if1" dest_id="VM-3:if0"/>
    <property source_id="VM-3:if0" dest_id="VM-4:if1"/>
    <link_type name="lan"/>
  </link>
  <link client_id="lan3">
    <interface_ref client_id="VM-1:if1"/>
    <interface_ref client_id="VM-4:if0"/>
    <property source_id="VM-1:if1" dest_id="VM-4:if0"/>
    <property source_id="VM-4:if0" dest_id="VM-1:if1"/>
    <link_type name="lan"/>
  </link>
</rspec>'
);
INSERT INTO rspec(name, schema, schema_version, description, rspec)
  VALUES
  ('Three nodes, linear topology', 'GENI', '3',
   'Three nodes in a linear topology.',
   '<?xml version="1.0" encoding="UTF-8"?>
<rspec xmlns="http://www.geni.net/resources/rspec/3"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.geni.net/resources/rspec/3 http://www.geni.net/resources/rspec/3/request.xsd"
       type="request">
  <node client_id="VM-1">
    <interface client_id="VM-1:if0"/>
  </node>
  <node client_id="VM-2">
    <interface client_id="VM-2:if0"/>
    <interface client_id="VM-2:if1"/>
  </node>
  <node client_id="VM-3">
    <interface client_id="VM-3:if0"/>
  </node>
  <link client_id="lan0">
    <interface_ref client_id="VM-1:if0"/>
    <interface_ref client_id="VM-2:if0"/>
    <property source_id="VM-1:if0" dest_id="VM-2:if0"/>
    <property source_id="VM-2:if0" dest_id="VM-1:if0"/>
    <link_type name="lan"/>
  </link>
  <link client_id="lan1">
    <interface_ref client_id="VM-2:if1"/>
    <interface_ref client_id="VM-3:if0"/>
    <property source_id="VM-2:if1" dest_id="VM-3:if0"/>
    <property source_id="VM-3:if0" dest_id="VM-2:if1"/>
    <link_type name="lan"/>
  </link>
</rspec>'
);
INSERT INTO rspec(name, schema, schema_version, description, rspec)
  VALUES
  ('Four nodes, star topology', 'GENI', '3',
   'Four nodes in a star topology.',
   '<?xml version="1.0" encoding="UTF-8"?>
<rspec xmlns="http://www.geni.net/resources/rspec/3"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.geni.net/resources/rspec/3 http://www.geni.net/resources/rspec/3/request.xsd"
       type="request">
  <node client_id="VM-1">
    <interface client_id="VM-1:if0"/>
  </node>
  <node client_id="VM-2">
    <interface client_id="VM-2:if0"/>
    <interface client_id="VM-2:if1"/>
    <interface client_id="VM-2:if2"/>
  </node>
  <node client_id="VM-3">
    <interface client_id="VM-3:if0"/>
  </node>
  <node client_id="VM-4">
    <interface client_id="VM-4:if0"/>
  </node>
  <link client_id="lan0">
    <interface_ref client_id="VM-1:if0"/>
    <interface_ref client_id="VM-2:if0"/>
    <property source_id="VM-1:if0" dest_id="VM-2:if0"/>
    <property source_id="VM-2:if0" dest_id="VM-1:if0"/>
    <link_type name="lan"/>
  </link>
  <link client_id="lan1">
    <interface_ref client_id="VM-2:if1"/>
    <interface_ref client_id="VM-3:if0"/>
    <property source_id="VM-2:if1" dest_id="VM-3:if0"/>
    <property source_id="VM-3:if0" dest_id="VM-2:if1"/>
    <link_type name="lan"/>
  </link>
  <link client_id="lan2">
    <interface_ref client_id="VM-2:if2"/>
    <interface_ref client_id="VM-4:if0"/>
    <property source_id="VM-2:if2" dest_id="VM-4:if0"/>
    <property source_id="VM-4:if0" dest_id="VM-2:if2"/>
    <link_type name="lan"/>
  </link>
</rspec>'
);
-- Need 3 nodes where middle is a delay node
-- Need the Click Router schema
{'fraction_non_alphanumeric': 0.20128156803618544, 'fraction_numerical': 0.035337353938937055, 'mean_word_length': 3.9179796107506952, 'pattern_counts': {'":': 0, '<': 191, '<?xml version=': 10, '>': 191, 'https://': 0, 'lorem ipsum': 0, 'www.': 44, 'xml': 32}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2620036', 'n_tokens_mistral': 4231, 'n_tokens_neox': 4128, 'n_words': 687}