database_utils/of_ports_pci_correspondence.sql

   1 ##
   2 # Copyright 2015 Telefónica Investigación y Desarrollo, S.A.U.
   3 # This file is part of openmano
   4 # All Rights Reserved.
   5 #
   6 # Licensed under the Apache License, Version 2.0 (the "License"); you may
   7 # not use this file except in compliance with the License. You may obtain
   8 # a copy of the License at
   9 #
  10 #         http://www.apache.org/licenses/LICENSE-2.0
  11 #
  12 # Unless required by applicable law or agreed to in writing, software
  13 # distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
  14 # WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
  15 # License for the specific language governing permissions and limitations
  16 # under the License.
  17 #
  18 # For those usages not covered by the Apache License, Version 2.0 please
  19 # contact with: nfvlabs@tid.es
  20 ##
  21
  22 /*
  23    READ THIS please:
  24    This table contains the matching between dataplane host ports
  25    and openflow switch ports.
  26    The two first column identifies the host and the pci bus
  27        command ethtool -i provides the pci bus port (at host)
  28        command ethtool -p makes this port blinking (at host)
  29    Last column identifies the switch port name
  30        openvim prints at starting the openflow ports naming
  31    NOTE: if a host has already been inserted, you must execute
  32    UpdateSwitchPort database procedure to associate ports with
  33    the switch connection
  34 */
  35
  36 LOCK TABLES `of_ports_pci_correspondence` WRITE;
  37
  38 /* DATA for fakehost examples*/
  39 INSERT INTO `of_ports_pci_correspondence`
  40     (ip_name, pci, switch_port)
  41 VALUES
  42     ('fake-host-0', '0000:06:00.0', 'port0/0'),
  43     ('fake-host-0', '0000:06:00.1', 'port0/1'),
  44     ('fake-host-0', '0000:08:00.0', 'port0/2'),
  45     ('fake-host-0', '0000:08:00.1', 'port0/3'),
  46
  47     ('fake-host-1', '0000:44:00.0', 'port0/4'),
  48     ('fake-host-1', '0000:44:00.1', 'port0/5'),
  49     ('fake-host-1', '0000:43:00.0', 'port0/6'),
  50     ('fake-host-1', '0000:43:00.1', 'port0/7'),
  51     ('fake-host-1', '0000:04:00.0', 'port0/8'),
  52     ('fake-host-1', '0000:04:00.1', 'port0/9'),
  53     ('fake-host-1', '0000:06:00.0', 'port0/10'),
  54     ('fake-host-1', '0000:06:00.1', 'port0/11'),
  55
  56     ('fake-host-2', '0000:44:00.0', 'port0/12'),
  57     ('fake-host-2', '0000:44:00.1', 'port0/13'),
  58     ('fake-host-2', '0000:43:00.0', 'port0/14'),
  59     ('fake-host-2', '0000:43:00.1', 'port0/15'),
  60     ('fake-host-2', '0000:04:00.0', 'port0/16'),
  61     ('fake-host-2', '0000:04:00.1', 'port0/17'),
  62     ('fake-host-2', '0000:06:00.0', 'port0/18'),
  63     ('fake-host-2', '0000:06:00.1', 'port0/19'),
  64
  65     ('fake-host-3', '0000:44:00.0', 'port1/0'),
  66     ('fake-host-3', '0000:44:00.1', 'port1/1'),
  67     ('fake-host-3', '0000:43:00.0', 'port1/2'),
  68     ('fake-host-3', '0000:43:00.1', 'port1/3'),
  69     ('fake-host-3', '0000:04:00.0', 'port1/4'),
  70     ('fake-host-3', '0000:04:00.1', 'port1/5'),
  71     ('fake-host-3', '0000:06:00.0', 'port1/6'),
  72     ('fake-host-3', '0000:06:00.1', 'port1/7')
  73 ;
  74
  75
  76 UNLOCK TABLES;