Interface.pm.in 51.6 KB
Newer Older
1
2
#!/usr/bin/perl -wT
#
Leigh B Stoller's avatar
Leigh B Stoller committed
3
# Copyright (c) 2005-2017 University of Utah and the Flux Group.
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
# 
# {{{EMULAB-LICENSE
# 
# This file is part of the Emulab network testbed software.
# 
# This file is free software: you can redistribute it and/or modify it
# under the terms of the GNU Affero General Public License as published by
# the Free Software Foundation, either version 3 of the License, or (at
# your option) any later version.
# 
# This file is distributed in the hope that it will be useful, but WITHOUT
# ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
# FITNESS FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public
# License for more details.
# 
# You should have received a copy of the GNU Affero General Public License
# along with this file.  If not, see <http://www.gnu.org/licenses/>.
# 
# }}}
23
24
25
26
27
28
29
30
31
32
33
34
#
package Interface;

use strict;
use Exporter;
use vars qw(@ISA @EXPORT);

@ISA    = "Exporter";
@EXPORT = qw ( );

use libdb;
use libtestbed;
35
use emutil qw(GenFakeMac);
36
use English;
37
use Carp qw(cluck);
38
39
40
41
42
43
44
45
46
47
use Data::Dumper;
use overload ('""' => 'Stringify');

# Configure variables
my $TB		= "@prefix@";
my $BOSSNODE    = "@BOSSNODE@";

# Cache of instances to avoid regenerating them.
my %all_interfaces   = ();
my %node_interfaces  = ();
48
49
50
BEGIN { use emutil;
	emutil::AddCache(\%all_interfaces); 
	emutil::AddCache(\%node_interfaces); }
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66

# Manual
my $debug = 0;

# Little helper and debug function.
sub mysystem($)
{
    my ($command) = @_;

    print STDERR "Running '$command'\n"
	if ($debug);
    return system($command);
}

#
# Lookup interfaces for a node and create a list of class instances to return.
67
68
# When using this interface we assume that this is the node side and
# the corresponding wire is node_id1.
69
#
70
sub LookupAll($$$)
71
{
72
    my ($class, $nodeid, $pref) = @_;
73
    my $node;
74

75
76
77
78
79
80
81
82
83
84
85
86
    if (ref($nodeid)) {
	$node   = $nodeid;
	$nodeid = $node->node_id();
    }
    else {
	require Node;
	$node = Node->Lookup($nodeid);
	if (!defined($node)) {
	    print STDERR "No such node in the DB: $nodeid\n";
	    return -1;
	}
    }
87
    # Look in cache first
88
89
90
91
92
    if (exists($node_interfaces{$nodeid})) {
	@$pref = @{ $node_interfaces{$nodeid} };
	return 0;
    }
    @$pref = ();
93

94
95
96
97
98
    #
    # Interfaces on dynamic virtnodes are marked with the logical flag.
    # We want those. But we want to ignore them on physical nodes, since
    # those refer to MLE interfaces.
    #
99
    my $logical_clause = ($node->isvirtnode() ? "" : "and i.logical=0");
100

101
    my $query_result =
102
103
104
105
	DBQueryWarn("select i.*,w.card1,w.port1 from interfaces as i ".
		    "left join wires as w on ".
		    "     w.node_id1=i.node_id and w.iface1=i.iface ".
		    "where i.node_id='$nodeid' $logical_clause");
106

107
    return -1
108
	if (!$query_result);
109
    return 0
110
111
112
113
114
115
	if (!$query_result->numrows);

    my $results = [];

    while (my $rowref = $query_result->fetchrow_hashref()) {
	my $iface = $rowref->{'iface'};
116
117
	my $card1 = $rowref->{'card1'};
	my $port1 = $rowref->{'port1'};
118
119
	my $interface;

120
121
122
123
	# Clean up the array, not part of the interface.
	delete($rowref->{'card1'});
	delete($rowref->{'port1'});

124
125
126
127
	#
	# If we already have this in the interface cache, lets not create
	# another one. Just use that one.
	#
128
129
130
131
132
133
	if (exists($all_interfaces{"$nodeid:$iface"})) {
	    $interface = $all_interfaces{"$nodeid:$iface"};
	}
        elsif (defined($card1) && defined($port1) &&
	       exists($all_interfaces{"$nodeid:$card1:$port1"})) {
	    $interface = $all_interfaces{"$nodeid:$card1:$port1"};
134
135
136
	}
	else {
	    $interface = {};
137
138
139
140
141
142
143
144
145

	    #
	    # Remove card,port in the results in preparation for removal
	    # from the table.
	    #
	    delete($rowref->{'card'})
		if (exists($rowref->{'card'}));
	    delete($rowref->{'port'})
		if (exists($rowref->{'port'}));
146
147
148
149
	
	    $interface->{"DBROW"}  = $rowref;
	    bless($interface, $class);

150
	    #
151
	    # Grab the wires table entry if there is one.
152
	    #
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
	    if (defined($card1) && defined($port1)) {
		my $wire = Interface::Wire->Lookup("$nodeid:$card1:$port1");
		if (!defined($wire)) {
		    print STDERR "*** Could not look up wire: ".
			"$nodeid:$card1:$port1\n";
		    return -1;
		}
		$interface->{'WIRE'} = $wire;

		#
		# Since we have a wire, we can set the card/port slots
		# for the interface. Basically, if an interface is not
		# wired up, then asking for its card/port is a nonsensical
		# thing to do and we will spit out a warning when that
		# happens so we can clean up the code.
		#
		$interface->{'CARD'} = $card1;
		$interface->{'PORT'} = $port1;
		
		# Cache
		$all_interfaces{"$nodeid:$card1:$port1"} = $interface;
	    }
	    else {
		$interface->{'WIRE'} = undef;
	    }
178

179
180
181
182
183
	    #
	    # And the interface_state table.
	    #
	    my $state_result =
		DBQueryWarn("select * from interface_state ".
184
			    "where node_id='$nodeid' and iface='$iface'");
185
186
187

	    return -1
		if (!$state_result);
188
189
190
	    if (!$state_result->numrows) {
		print STDERR
		    "*** Missing interface_state table entry for interface\n".
191
		    "    $nodeid:$iface.\n";
192
193
		return -1;
	    }
194
195
196
197
198
199
200
201
202
	    #
	    # Remove card,port in the results in preparation for removal
	    # from the table.
	    #
	    delete($state_result->{'card'})
		if (exists($state_result->{'card'}));
	    delete($state_result->{'port'})
		if (exists($state_result->{'port'}));
	    
203
204
	    $interface->{'STATE'} = $state_result->fetchrow_hashref();

205
206
	    # Cache.
	    $all_interfaces{"$nodeid:$iface"} = $interface;
207
208
209
210
211
212
	}
	push(@{ $results }, $interface);
    }
    # Add to cache of node interfaces
    $node_interfaces{$nodeid} = $results;
    
213
214
    @$pref = @{ $results };
    return 0;
215
216
217
218
219
220
221
222
223
}
# accessors
sub field($$)  { return ((! ref($_[0])) ? -1 : $_[0]->{'DBROW'}->{$_[1]}); }
sub node_id($) { return field($_[0], 'node_id'); }
sub iface($)   { return field($_[0], 'iface'); }
sub mac($)     { return field($_[0], 'mac'); }
sub IP($)      { return field($_[0], 'IP'); }
sub role($)    { return field($_[0], 'role'); }
sub type($)    { return field($_[0], 'interface_type'); }
224
sub logical($) { return field($_[0], 'logical'); }
Leigh B Stoller's avatar
Leigh B Stoller committed
225
sub speed($)   { return field($_[0], 'current_speed'); }
226
227
sub trunk_mode($) { return field($_[0], 'trunk_mode'); }
sub trunk($)   { return field($_[0], 'trunk'); }
228
sub whol($)    { return field($_[0], 'whol'); }
Leigh B Stoller's avatar
Leigh B Stoller committed
229
sub current_speed($) { return field($_[0], 'current_speed'); }
230
sub mask($)    { return field($_[0], 'mask'); }
231
sub uuid($)    { return field($_[0], 'uuid'); }
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
# These are special, now that interfaces no longer have card,port.
# There must be a wire to get that info.
sub card($)
{
    my ($self) = @_;

    if (!defined($self->{'CARD'})) {
	cluck("*** Wanted card, but no wire: $self");
	return undef;
    }
    return $self->{'CARD'};
}
sub port($)
{
    my ($self) = @_;

    if (!defined($self->{'PORT'})) {
	cluck("*** Wanted port, but no wire: $self");
	return undef;
    }
    return $self->{'PORT'};
}
254
# Wires table
255
256
257
258
259
sub wire($)    { return $_[0]->{'WIRE'}; }
sub wiredup($) { return (defined($_[0]->{'WIRE'}) ? 1 : 0); }
sub wirefield($$) {
    my ($self, $slot) = @_;
    if (!$self->wiredup()) {
260
	cluck("*** $self is not wired up, but asked for wire $slot!");
261
262
263
264
265
266
267
268
269
	return undef;
    }
    return $self->wire()->field($slot);
}
sub wire_type($)   { return $_[0]->wirefield('type'); }
sub wire_iface($)  { return $_[0]->wirefield('iface2'); }
sub switch_id($)   { return $_[0]->wirefield('node_id2'); }
sub switch_card($) { return $_[0]->wirefield('card2'); }
sub switch_port($) { return $_[0]->wirefield('port2'); }
270
sub wire_unused($) { return $_[0]->wire_type() eq "Unused" ? 1 : 0; }
271
# Interface State table
272
273
274
275
sub state($)       { return $_[0]->{'STATE'}; }
sub enabled($)     { return $_[0]->state()->{'enabled'}; }
sub tagged($)      { return $_[0]->state()->{'tagged'}; }
sub remaining_bandwidth { return $_[0]->state()->{'remaining_bandwidth'}; }
276
277
278
279
280
281
282

sub IsExperimental($)
{
    my ($self) = @_;

    return $self->role() eq TBDB_IFACEROLE_EXPERIMENT();
}
Leigh B. Stoller's avatar
Leigh B. Stoller committed
283
284
285
286
287
288
sub IsControl($)
{
    my ($self) = @_;

    return $self->role() eq TBDB_IFACEROLE_CONTROL();
}
289

290
291
292
293
294
295
296
sub IsManagement($)
{
    my ($self) = @_;

    return $self->role() eq TBDB_IFACEROLE_MANAGEMENT();
}

297
#
298
299
300
301
# Lookup by card,port. When using this interface we assume that this
# is the node side and the corresponding wire is node_id1.
#
# This is a bit of a legacy interface.
302
#
303
sub Lookup($$$;$)
304
305
306
{
    my ($class, $nodeid, $card, $port) = @_;

307
308
309
    $nodeid = $nodeid->node_id()
	if (ref($nodeid));

310
311
312
313
    # XXX: the node side always uses port 1.
    $port = 1
	if (!defined($port));

314
315
    cluck("Legacy Interface->Lookup($nodeid,$card,$port)");

316
317
318
319
    # Look in cache first
    return $all_interfaces{"$nodeid:$card:$port"}
        if (exists($all_interfaces{"$nodeid:$card:$port"}));

320
    #
321
322
    # Look in the wires table, in preparation for removing card,port from
    # the interfaces table.
323
    #
324
325
    my $wire = Interface::Wire->Lookup("$nodeid:$card:$port");
	
326
    #
327
    # If no wires entry and a legacy lookup, warn.
328
    #
329
330
331
    if (!defined($wire)) {
	cluck("*** No wires entry for Interface->Lookup($nodeid,$card,$port)");
	return undef;
332
    }
333
    return Interface->LookupByIface($nodeid, $wire->iface1());
334
335
}

Leigh B Stoller's avatar
Leigh B Stoller committed
336
337
338
339
340
341
342
sub Flush($)
{
    my ($self) = @_;
    my $nodeid  = $self->node_id();
    my $iface   = $self->iface();

    delete($all_interfaces{"$nodeid:$iface"});
343
344
345
346
347
348
349
350
351

    #
    # Check for cache entry by wire card,port.
    #
    if ($self->wiredup()) {
	my $card    = $self->card();
	my $port    = $self->port();
	delete($all_interfaces{"$nodeid:$card:$port"});
    }
Leigh B Stoller's avatar
Leigh B Stoller committed
352
353
}

354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
#
# Refresh instance by reloading from the DB.
#
sub Refresh($)
{
    my ($self) = @_;

    return -1
	if (! ref($self));

    my $nodeid  = $self->node_id();
    my $iface   = $self->iface();

    my $query_result =
	DBQueryWarn("select * from interfaces ".
369
		    "where node_id='$nodeid' and iface='$iface'");
370
371
    return undef
	if (!$query_result || !$query_result->numrows);
372
373
    
    my $rowref = $query_result->fetchrow_hashref();    
374

375
376
377
378
379
380
381
382
383
384
385
    #
    # Remove card,port in the results in preparation for removal
    # from the table. If we have a wire, we do want card/port in
    # the interface.
    #
    delete($rowref->{'card'})
	if (exists($rowref->{'card'}));
    delete($rowref->{'port'})
	if (exists($rowref->{'port'}));

    $self->{"DBROW"} = $rowref;
386
387
388
389
    
    #
    # And the interface_state table.
    #
390
391
392
    if (defined($self->{'STATE'})) {
	$query_result =
	    DBQueryWarn("select * from interface_state ".
393
			"where node_id='$nodeid' and iface='$iface'");
394
395
	return undef
	    if (!$query_result || !$query_result->numrows);
396
397
398
399
400
401
402
403
404
405
406

	my $state_result = $query_result->fetchrow_hashref();

	#
	# Remove card,port in the results in preparation for removal
	# from the table.
	#
	delete($state_result->{'card'})
	    if (exists($state_result->{'card'}));
	delete($state_result->{'port'})
	    if (exists($state_result->{'port'}));
407
	
408
	$self->{'STATE'} = $state_result;
409
    }
410
411
412
    return 0;
}

413
414
415
416
417
418
419
420
421
422
#
# Create a new interface record. This also handles the wires table entries.
#
sub Create($$$)
{
    my ($class, $node, $argref) = @_;

    return undef
	if (! (ref($node) && ref($argref)));

423
424
425
426
427
428
    if (exists($argref->{'switch_id'})) {
	print STDERR "*** Creating a wire in Interface->Create() is no ".
	    "longer supported!\n";
	return undef;
    }

429
430
    my $node_id = $node->node_id();

431
    my $MAC        = $argref->{'MAC'} || $argref->{'mac'};
432
433
434
435
    my $IP         = $argref->{'IP'};
    my $mask       = $argref->{'mask'};
    my $card       = $argref->{'card'};
    my $port       = $argref->{'port'};
Leigh B Stoller's avatar
Leigh B Stoller committed
436
    my $iftype     = $argref->{'type'} || $argref->{'interface_type'};
437
438
439
440
    my $ifrole     = $argref->{'role'};
    my $uuid       = $argref->{'uuid'};
    my $max_speed  = $argref->{'max_speed'};
    my $duplex     = $argref->{'duplex'};
441
    my $iface      = $argref->{'iface'};
442
    my $logical    = $argref->{'logical'};
443
    my $trunk      = $argref->{'trunk'};
444
    my $auto       = $argref->{'autocreated'};
445

446
447
    $iface = "eth$card"    
	if (!defined($iface));
448
449
450
451
452
453
454
455
456
457
    $port = 1
	if (!defined($port));
    $IP = ""
	if (!defined($IP));
    $mask = ""
	if (!defined($mask));
    $duplex = "full"
	if (!defined($duplex));
    $max_speed = 0
	if (!defined($max_speed));
458
459
    $logical = 0
	if (!defined($logical));
460
461
    $auto = 0
	if (!defined($auto));
462
463
    $trunk = 0
	if (!defined($trunk));
464
465
466
467
468
469
470
    if (!defined($uuid)) {
	$uuid = NewUUID();
	if (!defined($uuid)) {
	    print STDERR "Could not generate a UUID!\n";
	    return undef;
	}
    }
471
    if (! (defined($card) && defined($ifrole) && defined($MAC) &&
Leigh B Stoller's avatar
Leigh B Stoller committed
472
	   defined($IP) && defined($port) && 
473
474
475
476
477
478
	   defined($iftype) && defined($iface) && defined($max_speed) &&
	   defined($duplex) && defined($uuid))) {
	print STDERR "Interface::Create: Missing fields in arguments:\n";
	print STDERR Dumper($argref);
	return undef;
    }
479

480
481
482
483
484
    #
    # Lock the tables to prevent concurrent creation
    #
    DBQueryWarn("lock tables interfaces write, ".
		"            interface_state write, ".
485
486
		"            vinterfaces read, ".
		"            node_history read, ".
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
		"            wires write")
	or return undef;

    #
    # See if we have a record; if we do, we can stop now. This is
    # not actually correct, since creating a node is not atomic.
    #
    my $query_result =
	DBQueryWarn("select node_id from interfaces ".
		    "where node_id='$node_id' and ".
		    "      card='$card' and port='$port'");
    if ($query_result->numrows) {
	DBQueryWarn("unlock tables");
	return Interface->Lookup($node_id, $card, $port);
    }
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527

    #
    # Generate a fake mac if requested. 
    #
    if ($MAC eq "genfake") {
	while (1) {
	    $MAC = GenFakeMac();

	    # Check to make sure unique. If not, try again.
	    $query_result =
		DBQueryWarn("(select mac from interfaces ".
			    " where mac='$MAC') ".
			    "union ".
			    "(select mac from vinterfaces ".
			    " where mac='$MAC') ".
			    "union ".
			    "(select cnet_mac as mac from node_history ".
			    " where cnet_mac='$MAC')");
	    if (!$query_result) {
		DBQueryWarn("unlock tables");
		return undef;
	    }
	    last
		if (!$query_result->numrows);
	}
    }
528
529
    
    if (!DBQueryWarn("insert into interfaces set ".
530
		"  node_id='$node_id', logical='$logical', " .
531
		"  card=$card, port=$port, role='$ifrole', ".
532
		"  mac='$MAC', IP='$IP', autocreated='$auto', " .
Leigh B Stoller's avatar
Leigh B Stoller committed
533
		(defined($mask) ? "mask='$mask', " : "") .
534
		($trunk ? "trunk='1', " : "") .
535
536
		"  interface_type='$iftype', iface='$iface', " .
		"  current_speed='$max_speed', duplex='$duplex', ".
537
538
539
540
		"  uuid='$uuid'")) {
	DBQueryWarn("unlock tables");
	return undef;
    }
541

542
543
    if (!DBQueryWarn("insert into interface_state set ".
		     "  node_id='$node_id', " .
544
		     ($trunk ? "remaining_bandwidth='$max_speed', " : "") .
545
546
		     "  card=$card, port=$port, iface='$iface'")) {
	DBQueryWarn("delete from interfaces ".
547
		    "where node_id='$node_id' and iface='$iface' ");
548
	DBQueryWarn("unlock tables");
549
550
551
	return undef;
    }

552
    DBQueryWarn("unlock tables");
553
    return Interface->LookupByIface($node_id, $iface);
554
555
}

Leigh B Stoller's avatar
Leigh B Stoller committed
556
557
558
#
# Delete a logical interface.
#
559
sub Delete($;$)
Leigh B Stoller's avatar
Leigh B Stoller committed
560
{
561
562
    my ($self, $real) = @_;
    my $logical = ($real ? 0 : 1);
Leigh B Stoller's avatar
Leigh B Stoller committed
563

564
    if ($logical && !$self->logical()) {
Leigh B Stoller's avatar
Leigh B Stoller committed
565
566
567
568
	print STDERR "Refusing to delete real $self\n";
	return -1;
    }
    my $node_id = $self->node_id();
569
    my $iface   = $self->iface();
Leigh B Stoller's avatar
Leigh B Stoller committed
570
571
572

    return -1
	if (!DBQueryWarn("delete from interface_state ".
573
			 "where node_id='$node_id' iface='$iface'"));
574
575
    return -1
	if (!DBQueryWarn("delete from port_counters ".
576
			 "where node_id='$node_id' and iface='$iface'"));
Leigh B Stoller's avatar
Leigh B Stoller committed
577
578
    return -1
	if (!DBQueryWarn("delete from interfaces ".
579
			 "where logical=$logical and ".
580
			 "      node_id='$node_id' and iface='$iface'"));
Leigh B Stoller's avatar
Leigh B Stoller committed
581
582
583
    return 0;
}

584
585
586
587
588
589
#
# Delete this interface's wire entry.
#
sub DeleteWire($)
{
    my ($self) = @_;
590
591
592
593

    return 0
	if (!$self->wiredup());
    
594
595
596
597
598
599
600
601
602
603
604
    my $node_id = $self->node_id();
    my $card    = $self->card();
    my $port    = $self->port();

    return -1
	if (!DBQueryWarn("delete from wires ".
			 "where node_id1='$node_id' and card1='$card' and ".
			 "      port1='$port'"));
    return 0;
}

605
606
#
# Create a fake object, as for the mapper (assign_wrapper) during debugging.
607
# Port library uses this too.
608
609
610
611
#
sub MakeFake($$$)
{
    my ($class, $node, $argref) = @_;
612
    my ($card,$port);
613

614
615
616
617
618
619
620
621
622
623
    my $query_result =
	DBQueryWarn("show columns from interfaces");
    return undef
	if (!$query_result);
    
    while (my ($slot) = $query_result->fetchrow_array()) {
	if (!exists($argref->{$slot})) {
	    $argref->{$slot} = "";
	}
    }
624
    my $self            = {};
625
    my $nodeid = ref($node) ? $node->node_id() : $node;
626
    $argref->{'node_id'} = $nodeid;
627
628
629
630
631
632
633
634
635
    
    if (exists($argref->{'card'})) {
	$card = $argref->{'card'};
	$port = $argref->{'port'};
	delete($argref->{'card'});
	delete($argref->{'port'});
	$self->{'CARD'} = $card;
	$self->{'PORT'} = $port;
    }
636
    $self->{"DBROW"}    = $argref;
637
    $self->{"WIRE"}     = undef;
638
639
640
641
642
643
    $self->{"STATE"}    = {
	"node_id"  => $nodeid,
	"iface"    => $argref->{'iface'},
	"tagged"   => 0,
	"enabled"  => 1,
    };
644
645
646
647
648
    bless($self, $class);

    # Cache by card,port and by iface
    my $iface = $argref->{'iface'};
    $all_interfaces{"$nodeid:$iface"}      = $self;
649
650
651
652

    if (defined($card)) {
	$all_interfaces{"$nodeid:$card:$port"} = $self;
    }
653
654
655
    return $self;
}

656
657
658
659
660
661
#
# Lookup by iface
#
sub LookupByIface($$$)
{
    my ($class, $nodeid, $iface) = @_;
662
    my $state_row;
663

664
665
666
    $nodeid = $nodeid->node_id()
	if (ref($nodeid));

667
668
    # Look in cache first
    return $all_interfaces{"$nodeid:$iface"}
669
    if (exists($all_interfaces{"$nodeid:$iface"}));
670

671
    # Used from Protogeni code, so be careful.
672
673
    return undef
	if (! ($nodeid =~ /^[-\w]+$/ && $iface =~ /^[-\w\/\.:]+$/));
674

675
    my $query_result =
676
677
	DBQueryWarn("select * from interfaces ".
		    "where node_id='$nodeid' and iface='$iface'");
678
679
    return undef
	if (!$query_result);
680
681
682
683
684

    #
    # If no interfaces entry, this is bad.
    #
    if (!$query_result->numrows) {
685
686
687
688
689
690
691
692
	#
	# See if there is a wire and it is a Trunk link; we can ignore those
	# for now since it was not possible to autocreate the entries.
	#
	my $wire = Interface::Wire->LookupAnyByIface($nodeid, $iface);
	if (defined($wire) && $wire->type() eq "Trunk") {
	    return undef;
	}
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
	cluck("*** No interface entry for Interface->Lookup($nodeid,$iface)");
	return undef;
    }
    my $rowref = $query_result->fetchrow_hashref();

    #
    # Remove card,port in the results in preparation for removal
    # from the table.
    #
    delete($rowref->{'card'})
	if (exists($rowref->{'card'}));
    delete($rowref->{'port'})
	if (exists($rowref->{'port'}));

    #
    # And the interface_state table.
    #
    $query_result =
	DBQueryWarn("select * from interface_state ".
		    "where node_id='$nodeid' and iface='$iface'");
713
    return undef
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
	if (!$query_result);

    #
    # If a management interface or a switch, the lack of an interface_state
    # record is not a big deal, so let it slide. If it is a real node, then
    # whine about it but keep going. 
    #
    if (!$query_result->numrows) {
	require Node;
	my $node = Node->Lookup($nodeid);
	if (! ($rowref->{'role'} eq TBDB_IFACEROLE_MANAGEMENT() ||
	       (defined($node) && $node->role() ne "testnode"))) {
	    print STDERR "*** Missing missing interface_state ".
		"for $nodeid:$iface\n";
	}
    }
    else {
	$state_row = $query_result->fetchrow_hashref();
732

733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
	#
	# Remove card,port in the results in preparation for removal
	# from the table.
	#
	delete($state_row->{'card'})
	    if (exists($state_row->{'card'}));
	delete($state_row->{'port'})
	    if (exists($state_row->{'port'}));
    }
    # Does not have to exist.
    my $wire = Interface::Wire->LookupAnyByIface($nodeid, $iface);
    
    my $interface = {};
    $interface->{"DBROW"} = $rowref;
    $interface->{'STATE'} = $state_row;
    $interface->{'WIRE'}  = undef;
    bless($interface, $class);
    
    # Cache by card,port and by iface
    $all_interfaces{"$nodeid:$iface"} = $interface;

    if (defined($wire)) {
	my ($card,$port);
	
	#
	# We still have to assume that the node is the node_id1 side of
	# the wire, at least for now. So if the interface corresponds
	# to the node_id2 side, get the card/port, but do not stash the
	# wire (wireup() is false). Need to come back to this later.
	#
	if ($wire->node_id1() eq $nodeid) {
	    $card = $wire->card1();
	    $port = $wire->port1();
	    $interface->{'WIRE'} = $wire;
	}
	else {
	    $card = $wire->card2();
	    $port = $wire->port2();
	}
	$all_interfaces{"$nodeid:$card:$port"} = $interface;
773

774
775
776
777
	$interface->{'CARD'} = $card;
	$interface->{'PORT'} = $port;
    }
    return $interface;
778
779
}

780
781
782
783
784
785
#
# Lookup by mac
#
sub LookupByMAC($$)
{
    my ($class, $mac) = @_;
786
    my $safe_mac = DBQuoteSpecial($mac);
787
788

    my $query_result =
789
790
	DBQueryWarn("select node_id,iface from interfaces ".
		    "where mac=$safe_mac");
791
792
793
794
795
796

    return undef
	if (!$query_result);
    return undef
	if (!$query_result->numrows);
    
797
    my ($nodeid, $iface) = $query_result->fetchrow_array();
798

799
    return Interface->LookupByIface($nodeid, $iface);
800
801
802
803
804
805
806
807
808
}

#
# Lookup by IP, but only on control or management interfaces.
# Makes no sense for experimental.
#
sub LookupByIP($$)
{
    my ($class, $ip) = @_;
809
    my $safe_ip = DBQuoteSpecial($ip);
810
811

    my $query_result =
812
813
	DBQueryWarn("select node_id,iface from interfaces ".
		    "where ip=$safe_ip and ".
814
815
816
817
818
819
820
821
		    "      (role='" . TBDB_IFACEROLE_CONTROL()  . "' or ".
		    "       role='" . TBDB_IFACEROLE_MANAGEMENT()  . "')");

    return undef
	if (!$query_result);
    return undef
	if (!$query_result->numrows);
    
822
    my ($nodeid, $iface) = $query_result->fetchrow_array();
823

824
    return Interface->LookupByIface($nodeid, $iface);
825
826
}

827
828
829
830
831
832
833
834
835
836
837
838
#
# Lookup by uuid
#
sub LookupByUUID($$)
{
    my ($class, $uuid) = @_;

    if (! ($uuid =~ /^\w+\-\w+\-\w+\-\w+\-\w+$/)) {
	return undef;
    }
    
    my $query_result =
839
	DBQueryWarn("select node_id,iface from interfaces ".
840
841
842
843
844
845
846
		    "where uuid='$uuid'");

    return undef
	if (!$query_result);
    return undef
	if (!$query_result->numrows);
    
847
    my ($nodeid, $iface) = $query_result->fetchrow_array();
848

849
    return Interface->LookupByIface($nodeid, $iface);
850
851
}

852
853
854
855
856
857
858
#
# Lookup the control interface for a node, which is something we do a lot.
#
sub LookupControl($)
{
    my ($class, $nodeid) = @_;

859
860
861
    $nodeid = $nodeid->node_id()
	if (ref($nodeid));

862
    my $query_result =
863
	DBQueryWarn("select iface from interfaces ".
864
865
866
867
868
869
870
871
		    "where node_id='$nodeid' and ".
		    "      role='" . TBDB_IFACEROLE_CONTROL()  . "'");

    return undef
	if (!$query_result);
    return undef
	if (!$query_result->numrows);

872
    my ($iface) = $query_result->fetchrow_array();
873

874
    return Interface->LookupByIface($nodeid, $iface);
875
876
}

877
878
879
880
881
882
883
884
885
886
887
#
# Lookup the management interface for a node.
#
sub LookupManagement($)
{
    my ($class, $nodeid) = @_;

    $nodeid = $nodeid->node_id()
	if (ref($nodeid));

    my $query_result =
888
	DBQueryWarn("select iface from interfaces ".
889
890
891
892
893
894
895
896
		    "where node_id='$nodeid' and ".
		    "      role='" . TBDB_IFACEROLE_MANAGEMENT()  . "'");

    return undef
	if (!$query_result);
    return undef
	if (!$query_result->numrows);

897
    my ($iface) = $query_result->fetchrow_array();
898

899
    return Interface->LookupByIface($nodeid, $iface);
900
901
}

902
903
904
905
906
907
908
909
910
911
912
913
914
#
# Stringify for output.
#
sub Stringify($)
{
    my ($self) = @_;
    
    my $nodeid = $self->node_id();
    my $iface  = $self->iface();

    return "[Interface: $nodeid:$iface]";
}

915
916
917
918
919
920
921
922
923
#
# Dump for debugging.
#
sub Dump($)
{
    my ($self) = @_;

    print "Node:      " . $self->node_id() . "\n";
    print "Iface:     " . $self->iface() . "\n";
924
925
926
927
    if ($self->wiredup()) {
	print "Card:      " . $self->card() . "\n";
	print "Port:      " . $self->port() . "\n";
    }
928
929
930
    print "Type:      " . $self->type() . "\n";
    print "Role:      " . $self->role() . "\n";
    print "Trunk:     " . $self->trunk() . "\n";
Leigh B Stoller's avatar
Leigh B Stoller committed
931
    print "IP:        " . ($self->IP() || "") . "\n";
932
933
934
935
    print "MAC:       " . $self->mac() . "\n";
    return 0;
}

936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
#
# Temporary cruft for geni widearea switches.
#
sub LookUpWideAreaSwitch($$)
{
    my ($class, $hrn) = @_;
    my $safe_hrn = DBQuoteSpecial($hrn);

    my $query_result =
	DBQueryWarn("select node_id from widearea_switches ".
		    "where hrn=$safe_hrn");
    return undef
	if (!$query_result);
    if ($query_result->numrows) {
	my ($switch_id) = $query_result->fetchrow_array();
	return $switch_id;
    }
    my $next_id   = TBGetUniqueIndex('next_switch', 1);
    my $switch_id = "widearea_switch$next_id";

    return $switch_id
	if (DBQueryWarn("insert into widearea_switches set ".
			" hrn=$safe_hrn, node_id='$switch_id'"));
    return undef;
}

962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
#
# Perform some updates ...
#
sub Update($$)
{
    my ($self, $argref) = @_;

    # Must be a real reference. 
    return -1
	if (! ref($self));

    my $nodeid  = $self->node_id();
    my $iface   = $self->iface();
    my @sets    = ();

    foreach my $key (keys(%{$argref})) {
	my $val = $argref->{$key};

	# Treat NULL special.
	push (@sets, "${key}=" . ($val eq "NULL" ?
				  "NULL" : DBQuoteSpecial($val)));
    }

    my $query = "update interfaces set " . join(",", @sets) .
	" where node_id='$nodeid' and iface='$iface'";

    return -1
	if (! DBQueryWarn($query));

    return Refresh($self);
}

994
995
996
997
998
999
1000
1001
1002
1003
#
# Lookup a specific attribute in the type capabilities table. 
#
sub TypeCapability($$$)
{
    my ($self, $capkey, $pcapval) = @_;
    
    return -1
	if (!ref($self));

1004
    my $itype = $self->type();
1005
1006
1007

    my $query_result =
	DBQueryWarn("select capval from interface_capabilities ".
1008
		    "where type='$itype' and capkey='$capkey'");
1009
1010
1011
1012

    return -1
	if (!$query_result || !$query_result->numrows());
    my ($capval) = $query_result->fetchrow_array();
1013
    $$pcapval = $capval;
1014
1015
1016
    return 0;
}

1017
##############################################################################
1018
1019
1020
package Interface::VInterface;
use libdb;
use libtestbed;
1021
use emutil qw(GenFakeMac);
1022
use English;
1023
use Carp;
1024
use overload ('""' => 'Stringify');
1025
use vars qw($AUTOLOAD);
1026
1027
1028
1029
1030
1031

my $nextfake = 0;

#
# Lookup by node_id,unit
#
1032
sub Lookup($$$)
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
{
    my ($class, $nodeid, $unit) = @_;

    $nodeid = $nodeid->node_id()
	if (ref($nodeid));

    my $query_result =
	DBQueryWarn("select * from vinterfaces ".
		    "where node_id='$nodeid' and unit='$unit'");

    return undef
	if (!$query_result);
    return undef
	if (!$query_result->numrows);

    my $vinterface = {};
	
    $vinterface->{"DBROW"} = $query_result->fetchrow_hashref();
1051
    $vinterface->{"HASH"}  = {};
1052
1053
    bless($vinterface, $class);
}
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084

AUTOLOAD {
    my $self  = $_[0];
    my $type  = ref($self) or croak "$self is not an object";
    my $name  = $AUTOLOAD;
    $name =~ s/.*://;   # strip fully-qualified portion

    # A DB row proxy method call.
    if (exists($self->{'DBROW'}->{$name})) {
	return $self->{'DBROW'}->{$name};
    }
    # Or it is for a local storage slot.
    if ($name =~ /^_.*$/) {
	if (scalar(@_) == 2) {
	    return $self->{'HASH'}->{$name} = $_[1];
	}
	elsif (exists($self->{'HASH'}->{$name})) {
	    return $self->{'HASH'}->{$name};
	}
    }
    carp("No such slot '$name' field in class $type");
    return undef;
}

# Break circular reference someplace to avoid exit errors.
sub DESTROY {
    my $self = shift;

    $self->{'DBROW'} = undef;
    $self->{'HASH'}  = undef;
}
1085
1086
1087

# The virtual iface name is $type$unit
sub viface($)     { return $_[0]->type() . $_[0]->unit(); }
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111

#
# Lookup by the experiment/virtlan/vnode
#
sub LookupByVirtLan($$$$)
{
    my ($class, $experiment, $virtlan, $vnode) = @_;
    my $exptidx = $experiment->idx();

    $virtlan = DBQuoteSpecial($virtlan);
    $vnode   = DBQuoteSpecial($vnode);

    my $query_result =
	DBQueryWarn("select node_id,unit from vinterfaces as vif ".
		    "left join virt_lans as vl on vl.exptidx=vif.exptidx and ".
		    "  vl.ip=vif.IP ".
		    "where vif.exptidx='$exptidx' and ".
		    "      vl.vname=$virtlan and vl.vnode=$vnode");
    return undef
	if (!defined($query_result) || !$query_result->numrows);

    my ($node_id,$unit) = $query_result->fetchrow_array();
    return Interface::VInterface->Lookup($node_id, $unit);
}
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
    
#
# Create a new vinterface
#
sub Create($$$)
{
    my ($class, $nodeid, $argref) = @_;

    $nodeid = $nodeid->node_id()
	if (ref($nodeid));
    $argref->{'node_id'} = $nodeid;

    # This is generated by the insert.
    delete($argref->{'unit'})
	if (exists($argref->{'unit'}));

1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
    DBQueryWarn("lock tables interfaces read, ".
		"            vinterfaces write, ".
		"            node_history read")
	or return undef;

    #
    # Generate a fake mac if requested. 
    #
    if (exists($argref->{'mac'}) && $argref->{'mac'} eq "genfake") {
	while (1) {
	    my $mac = GenFakeMac();

	    # Check to make sure unique. If not, try again.
	    my $query_result =
		DBQueryWarn("(select mac from interfaces ".
			    " where mac='$mac') ".
			    "union ".
			    "(select mac from vinterfaces ".
			    " where mac='$mac') ".
			    "union ".
			    "(select cnet_mac as mac from node_history ".
			    " where cnet_mac='$mac')");
	    if (!$query_result) {
		DBQueryWarn("unlock tables");
		return undef;
	    }
	    if (!$query_result->numrows) {
		$argref->{'mac'} = $mac;
		last;
	    }
	}
    }

1161
1162
1163
1164
    my $query = "insert into vinterfaces set ".
	join(",", map("$_='" . $argref->{$_} . "'", keys(%{$argref})));

    my $query_result = DBQueryWarn($query);
1165
    DBQueryWarn("unlock tables");
1166
1167
1168
    return undef
	if (!defined($query_result));

1169
    my $unit= $query_result->insertid;
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
    return Interface::VInterface->Lookup($nodeid, $unit);
}

#
# Create a fake object, as for the mapper (assign_wrapper) during debugging.
#
sub MakeFake($$$)
{
    my ($class, $nodeid, $argref) = @_;

    $nodeid = $nodeid->node_id()
	if (ref($nodeid));
1182
    $argref->{'node_id'}  = $nodeid;
1183
1184
1185
    foreach my $field (('vnode_id', 'iface', 'vlanid', 'bandwidth')) {
	$argref->{$field} = undef if (!exists($argref->{$field}));
    }
1186
1187

    # This is usually generated by the insert.
1188
    $argref->{'unit'}   = $nextfake++;
1189
1190
1191

    my $self            = {};
    $self->{"DBROW"}    = $argref;
1192
    $self->{"HASH"}     = {};
1193
    $self->{"FAKE"}     = 1;
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
1220
1221
1222
1223
1224
1225
1226
1227
1228
1229
    bless($self, $class);
    return $self;
}

#
# Stringify for output.
#
sub Stringify($)
{
    my ($self) = @_;
    
    my $nodeid  = $self->node_id();
    my $unit    = $self->unit();
    my $iface   = (defined($self->iface()) ? ":" . $self->iface() : "");
    my $vnodeid = (defined($self->vnode_id()) ? ":" . $self->vnode_id() : "");

    return "[VInterface: $nodeid:${unit}${iface}${vnodeid}]";
}

#
# On a shared node, we have to "reserve" the required bandwidth on
# the physical interface.
#
sub ReserveSharedBandwidth($$)
{
    my ($self, $bandwidth) = @_;

    my $nodeid  = $self->node_id();
    my $unit    = $self->unit();
    my $iface   = $self->iface();

    # Must be a trivial link.
    return 0
	if (!defined($iface));

    #
1230
1231
    # Set the bw to the negative value; this is the bw that we need
    # to reserve later. Negative indicates we have not done it yet.
1232
    #
1233
1234
    DBQueryWarn("update vinterfaces set bandwidth=0-${bandwidth} ".
		"where node_id='$nodeid' and unit='$unit'")
1235
	or return -1;
1236
1237
	
    $self->{'DBROW'}->{'bandwidth'} = $bandwidth;
1238
1239
1240
    return 0;
}

1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
1260
1261
1262
1263
1264
1265
1266
1267
1268
1269
1270
1271
1272
1273
1274
1275
#
# Refresh instance by reloading from the DB.
#
sub Refresh($)
{
    my ($self) = @_;

    return -1
	if (! ref($self));

    my $nodeid  = $self->node_id();
    my $unit    = $self->unit();

    my $query_result =
	DBQueryWarn("select * from vinterfaces ".
		    "where node_id='$nodeid' and unit='$unit'");
    return undef
	if (!$query_result || !$query_result->numrows);

    $self->{"DBROW"} = $query_result->fetchrow_hashref();
    
    return 0;
}

#
# Perform some updates ...
#
sub Update($$)
{
    my ($self, $argref) = @_;

    # Must be a real reference. 
    return -1
	if (! ref($self));

1276
1277
1278
1279
1280
1281
    if (exists($self->{'FAKE'})) {
	foreach my $key (keys(%{$argref})) {
	    $self->{"DBROW"}->{$key} = $argref->{$key};
	}
	return 0;
    }
1282

1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
1301
1302
1303
    my $nodeid  = $self->node_id();
    my $unit    = $self->unit();
    my @sets    = ();

    foreach my $key (keys(%{$argref})) {
	my $val = $argref->{$key};

	# Treat NULL special.
	push (@sets, "${key}=" . ($val eq "NULL" ?
				  "NULL" : DBQuoteSpecial($val)));
    }

    my $query = "update vinterfaces set " . join(",", @sets) .
	" where node_id='$nodeid' and unit='$unit'";

    return -1
	if (! DBQueryWarn($query));

    return Refresh($self);
}

1304
1305
##############################################################################
#
Leigh B Stoller's avatar
Leigh B Stoller committed
1306
1307
1308
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
1321
# A wrapper class for a wire. 
#
package Interface::Wire;
use libdb;
use Node;
use libtestbed;
use English;
use overload ('""' => 'Stringify');

#
# Lookup a wire, using the interface of the "pc" side.
#
sub Lookup($$)
{
    my ($class, $interface) = @_;

1322
1323
1324
1325
1326
1327
1328
    my $query_result;
    if (!ref($interface) && $interface =~ /^urn:publicid:IDN+/) {
	# Allow lookup by remote interface URN
	$query_result =
	    DBQueryWarn("select * from wires ".
			"where external_interface='$interface'");
    } else {
1329
1330
	my ($node_id1,$card1,$port1);
	
1331
1332
1333
	if (!ref($interface)) {
	    # Allow "nodeid:card:port" argument.
	    if ($interface =~ /^([-\w]*):(\w+):(\w+)$/) {
1334
1335
1336
		$node_id1 = $1;
		$card1    = $2;
		$port1    = $3;
1337
1338
1339
1340
	    }
	    else {
		return undef;
	    }
Leigh B Stoller's avatar
Leigh B Stoller committed
1341
	}
1342
1343
1344
1345
1346
	else {
	    $node_id1 = $interface->node_id();
	    $card1    = $interface->card();
	    $port1    = $interface->port();
	}
1347
1348
1349
1350
	$query_result =
	    DBQueryWarn("select * from wires ".
			"where node_id1='$node_id1' and ".
			"      card1='$card1' and port1='$port1'");
Leigh B Stoller's avatar
Leigh B Stoller committed
1351
1352
1353
1354
1355
1356
1357
1358
1359
1360
1361
1362
1363
1364
1365
1366
1367
    }

    return undef
	if (!$query_result || !$query_result->numrows);

    my $wire = {};
    $wire->{"DBROW"}  = $query_result->fetchrow_hashref();
    bless($wire, $class);
    return $wire;
}
sub field($$)	       { return $_[0]->{'DBROW'}->{$_[1]}; }
sub node_id1($)        { return $_[0]->field('node_id1'); }
sub node_id2($)        { return $_[0]->field('node_id2'); }
sub card1($)           { return $_[0]->field('card1'); }
sub card2($)           { return $_[0]->field('card2'); }
sub port1($)           { return $_[0]->field('port1'); }
sub port2($)           { return $_[0]->field('port2'); }
1368
1369
sub iface1($)          { return $_[0]->field('iface1'); }
sub iface2($)          { return $_[0]->field('iface2'); }
Leigh B Stoller's avatar
Leigh B Stoller committed
1370
sub type($)            { return $_[0]->field('type'); }
1371
1372
sub cable($)           { return $_[0]->field('cable'); }
sub len($)             { return $_[0]->field('len'); }
Leigh B Stoller's avatar
Leigh B Stoller committed
1373
sub logical($)         { return $_[0]->field('logical'); }
1374
sub trunkid($)         { return $_[0]->field('trunkid'); }
Leigh B Stoller's avatar
Leigh B Stoller committed
1375
1376
sub IsActive($)        { return ($_[0]->type() eq "Unused" ? 0 : 1); }

1377
1378
1379
1380
1381
1382
1383
1384
1385
1386
1387
1388
1389
1390
1391
1392
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403
1404
1405
1406
1407
1408
1409
1410
1411
1412
1413
1414
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427
1428
1429
1430
1431
1432
1433
1434
1435
1436
1437
1438
#
# Create a wire by Interfaces.
#
sub Create($$$$$)
{
    my ($self, $interface1, $interface2, $type, $argref) = @_;

    my $node_id1  = $interface1->node_id();
    my $card1     = $interface1->card();
    my $port1     = $interface1->port();
    my $iface1    = $interface1->iface();
    my $node_id2  = $interface2->node_id();
    my $card2     = $interface2->card();
    my $port2     = $interface2->port();
    my $iface2    = $interface2->iface();

    my $command = "insert into wires set".
	"  type='$type', " .
	"  node_id1='$node_id1',card1=$card1,port1=$port1, " .
	"  iface1='$iface1', ".
	"  node_id2='$node_id2',card2=$card2,port2=$port2, ".
	"  iface2='$iface2'";
    $command .= ",cable=" . DBQuoteSpecial($argref->{'cable'})
	if (exists($argref->{'cable'}));
    $command .= ",len=" . DBQuoteSpecial($argref->{'cablelen'})
	if (exists($argref->{'cablelen'}));
    $command .= ",external_wire=" . DBQuoteSpecial($argref->{'external_wire'})
	if (exists($argref->{'external_wire'}));
    $command .= ",external_interface=" .
	DBQuoteSpecial($argref->{'external_interface'})
	if (exists($argref->{'external_interface'}));

    DBQueryWarn($command) or
	return undef;

    return Interface::Wire->Lookup($interface1);
}

#
# Create a fake object. Port library uses this too.
#
sub MakeFake($$)
{
    my ($class, $argref) = @_;

    my $query_result =
	DBQueryWarn("show columns from wires");
    return undef
	if (!$query_result);
    
    while (my ($slot) = $query_result->fetchrow_array()) {
	if (!exists($argref->{$slot})) {
	    $argref->{$slot} = "";
	}
    }
    my $self            = {};
    $self->{"DBROW"}    = $argref;
    bless($self, $class);

    return $self;
}

1439
1440
1441
#
# Find me a wire from either side using nodeid,card,port.
#
1442
sub LookupAny($$$;$)
1443
1444
1445
1446
1447
1448
1449
1450
1451
1452
1453
1454
1455
1456
1457
1458
1459
1460
{
    my ($class, $nodeid, $card, $port) = @_;

    my $query_result =
	DBQueryWarn("select * from wires ".
		    "where (node_id1='$nodeid' and ".
		    "       card1='$card' and port1='$port') or ".
		    "      (node_id2='$nodeid' and ".
		    "       card2='$card' and port2='$port')");

    return undef
	if (!$query_result || !$query_result->numrows);

    my $wire = {};
    $wire->{"DBROW"}  = $query_result->fetchrow_hashref();
    bless($wire, $class);
    return $wire;
}
1461
1462
1463
1464
1465
1466
1467
1468
1469
1470
1471
1472
1473
1474
1475
1476
1477
sub LookupAnyByIface($$$)
{
    my ($class, $nodeid, $iface) = @_;

    my $query_result =
	DBQueryWarn("select * from wires ".
		    "where (node_id1='$nodeid' and iface1='$iface') or ".
		    "      (node_id2='$nodeid' and iface2='$iface')");

    return undef
	if (!$query_result || !$query_result->numrows);

    my $wire = {};
    $wire->{"DBROW"}  = $query_result->fetchrow_hashref();
    bless($wire, $class);
    return $wire;
}
1478
1479
1480
1481
1482
1483
1484
1485
1486
1487
1488
1489
1490
1491
1492
1493
sub LookupByIface($$$)
{
    my ($class, $nodeid, $iface) = @_;

    my $query_result =
	DBQueryWarn("select * from wires ".
		    "where (node_id1='$nodeid' and iface1='$iface')");

    return undef
	if (!$query_result || !$query_result->numrows);

    my $wire = {};
    $wire->{"DBROW"}  = $query_result->fetchrow_hashref();
    bless($wire, $class);
    return $wire;
}
1494
1495
1496
1497
1498
1499
1500
1501
1502
1503
1504
1505
1506
1507
1508
1509
1510
1511
1512
1513

sub LookupAnyByIfaces($$$$$)
{
    my ($class, $nodeid1, $iface1, $nodeid2, $iface2) = @_;

    my $query_result =
	DBQueryWarn("select * from wires ".
		    "where ((node_id1='$nodeid1' and iface1='$iface1') and ".
		    "       (node_id2='$nodeid2' and iface2='$iface2')) or ".
		    "      ((node_id2='$nodeid1' and iface2='$iface1') and ".
		    "       (node_id1='$nodeid2' and iface1='$iface2'))");

    return undef
	if (!$query_result || !$query_result->numrows);

    my $wire = {};
    $wire->{"DBROW"}  = $query_result->fetchrow_hashref();
    bless($wire, $class);
    return $wire;
}
1514

Leigh B Stoller's avatar
Leigh B Stoller committed
1515
#
1516
# Delete a wire. For safety refuse to delete a real wire unless flag given.
Leigh B Stoller's avatar
Leigh B Stoller committed
1517
#
1518
sub Delete($;$)
Leigh B Stoller's avatar
Leigh B Stoller committed
1519
{
1520
1521
    my ($self, $real) = @_;
    my $logical = ($real ? 0 : 1);
Leigh B Stoller's avatar
Leigh B Stoller committed
1522

1523
    if ($logical && !$self->logical()) {
Leigh B Stoller's avatar
Leigh B Stoller committed
1524
1525
1526
1527
	print STDERR "Refusing to delete real $self\n";
	return -1;
    }
    my $node_id1 = $self->node_id1();
1528
1529
1530
    my $iface1   = $self->iface1();
    my $node_id2 = $self->node_id2();
    my $iface2   = $self->iface2();
Leigh B Stoller's avatar
Leigh B Stoller committed
1531
1532
1533

    return -1
	if (!DBQueryWarn("delete from wires ".
1534
1535
			 "where node_id1='$node_id1' and iface1='$iface1' and ".
			 "      node_id2='$node_id2' and iface2='$iface2'"));
Leigh B Stoller's avatar
Leigh B Stoller committed
1536
1537
    return 0;
}
Leigh B Stoller's avatar
Leigh B Stoller committed
1538
1539
1540
1541
1542
1543
1544
1545
1546
1547

#
# A wire has two interfaces, but we do not always create interface
# table entries for both sides; the switch side is generally not in
# the interfaces table. 
#
sub Interfaces($)
{
    my ($self) = @_;

1548
1549
    return (Interface->LookupByIface($self->node_id1(), $self->iface1()),
	    Interface->LookupByIface($self->node_id2(), $self->iface2()));
Leigh B Stoller's avatar
Leigh B Stoller committed
1550
1551
1552
1553
1554
1555
1556
1557
1558
1559
1560
1561
1562
1563
1564
}

#
# Stringify for output. 
#
sub Stringify($)
{
    my ($self) = @_;
    
    my $node1   = $self->node_id1();
    my $node2   = $self->node_id2();
    my $card1   = $self->card1();
    my $card2   = $self->card2();
    my $port1   = $self->port1();
    my $port2   = $self->port2();
Leigh B Stoller's avatar
Leigh B Stoller committed
1565