instance_defs.php 24.3 KB
Newer Older
Leigh Stoller's avatar
Leigh Stoller committed
1 2
<?php
#
3
# Copyright (c) 2006-2016 University of Utah and the Flux Group.
Leigh Stoller's avatar
Leigh Stoller committed
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
# 
# {{{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/>.
# 
# }}}
#
#
25
include_once("aggregate_defs.php");
26

27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57
$geni_response_codes =
    array("Success",
          "Bad Arguments",
          "Error",
          "Forbidden",
          "Bad Version",
          "Server Error",
          "Too Big",
          "Refused",
          "Timed Out",
          "Database Error",
          "RPC Error",
          "Unavailable",
          "Search Failed",
          "Unsupported",
          "Busy",
          "Expired",
          "In Progress",
          "Already Exists",
          "Error 18",
          "Error 19",
          "Error 20",
          "Error 21",
          "Error 22",
          "Error 23",
          "Vlan Unavailable",
          "Insufficient Bandwidth",
          "Insufficient Nodes",
          "Insufficient Memory",
          "No Mapping Possible",
    );
58
define("GENIRESPONSE_BADARGS",   	       1);
59
define("GENIRESPONSE_REFUSED",                 7);
60
define("GENIRESPONSE_TIMEDOUT",                8);
61
define("GENIRESPONSE_SEARCHFAILED",            12);
62 63 64 65 66 67
define("GENIRESPONSE_VLAN_UNAVAILABLE",        24);
define("GENIRESPONSE_INSUFFICIENT_BANDWIDTH",  25);
define("GENIRESPONSE_INSUFFICIENT_NODES",      26);
define("GENIRESPONSE_INSUFFICIENT_MEMORY",     27);
define("GENIRESPONSE_NO_MAPPING",              28);
define("GENIRESPONSE_STITCHER_ERROR",          101);
68

Leigh Stoller's avatar
Leigh Stoller committed
69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86
class Instance
{
    var	$instance;
    
    #
    # Constructor by lookup on unique index.
    #
    function Instance($uuid) {
	$safe_uuid = addslashes($uuid);

	$query_result =
	    DBQueryWarn("select * from apt_instances ".
			"where uuid='$safe_uuid'");

	if (!$query_result || !mysql_num_rows($query_result)) {
	    $this->instance = null;
	    return;
	}
87 88 89 90 91 92
	$this->instance  = mysql_fetch_array($query_result);
        $this->slivers   = InstanceSliver::LookupForInstance($this);
        if (!count($this->slivers) && $this->aggregate_urn()) {
            $this->slivers =
                array(InstanceSliver::Lookup($this, $this->aggregate_urn()));
        }
Leigh Stoller's avatar
Leigh Stoller committed
93 94
    }
    # accessors
95
    function slivers()      { return $this->slivers; }
Leigh Stoller's avatar
Leigh Stoller committed
96 97 98 99
    function field($name) {
	return (is_null($this->instance) ? -1 : $this->instance[$name]);
    }
    function uuid()	    { return $this->field('uuid'); }
100
    function name()	    { return $this->field('name'); }
Leigh Stoller's avatar
Leigh Stoller committed
101 102 103 104 105
    function slice_uuid()   { return $this->field('slice_uuid'); }
    function creator()	    { return $this->field('creator'); }
    function creator_idx()  { return $this->field('creator_idx'); }
    function creator_uuid() { return $this->field('creator_uuid'); }
    function created()	    { return $this->field('created'); }
106 107
    function profile_id()   { return $this->field('profile_id'); }
    function profile_version() { return $this->field('profile_version'); }
Leigh Stoller's avatar
Leigh Stoller committed
108
    function status()	    { return $this->field('status'); }
109
    function canceled()	    { return $this->field('canceled'); }
110
    function paniced()	    { return $this->field('paniced'); }
111 112
    function pid()	    { return $this->field('pid'); }
    function pid_idx()	    { return $this->field('pid_idx'); }
Leigh Stoller's avatar
Leigh Stoller committed
113
    function public_url()   { return $this->field('public_url'); }
114
    function logfileid()    { return $this->field('logfileid'); }
Leigh Stoller's avatar
Leigh Stoller committed
115
    function manifest()	    { return $this->field('manifest'); }
116 117
    function admin_lockdown() { return $this->field('admin_lockdown'); }
    function user_lockdown(){ return $this->field('user_lockdown'); }
118 119
    function extension_count()   { return $this->field('extension_count'); }
    function extension_days()    { return $this->field('extension_days'); }
Leigh Stoller's avatar
Leigh Stoller committed
120
    function extension_reason()  { return $this->field('extension_reason'); }
121
    function extension_history() { return $this->field('extension_history'); }
Leigh Stoller's avatar
Leigh Stoller committed
122
    function extension_lockout() { return $this->field('extension_adminonly'); }
123
    function extension_requested(){return $this->field('extension_requested');}
124 125 126
    function extension_denied()  { return $this->field('extension_denied');}
    function extension_denied_reason(){
        return $this->field('extension_denied_reason');}
127 128
    function physnode_count()    { return $this->field('physnode_count'); }
    function virtnode_count()    { return $this->field('virtnode_count'); }
129
    function servername()   { return $this->field('servername'); }
Leigh Stoller's avatar
Leigh Stoller committed
130
    function aggregate_urn(){ return $this->field('aggregate_urn'); }
131
    function private_key()  { return $this->field('privkey'); }
132 133 134 135 136 137
    function IsAPT() {
	return preg_match('/aptlab/', $this->servername());
    }
    function IsCloud() {
	return preg_match('/cloudlab/', $this->servername());
    }
138 139 140
    function IsPNet() {
	return preg_match('/phantomnet/', $this->servername());
    }
141 142 143 144
    function aggregate_name() {
        global $urn_mapping;
        return $urn_mapping[$this->aggregate_urn()];
    }
Leigh Stoller's avatar
Leigh Stoller committed
145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173
    
    # Hmm, how does one cause an error in a php constructor?
    function IsValid() {
	return !is_null($this->instance);
    }

    # Lookup up an instance by idx. 
    function Lookup($idx) {
	$foo = new Instance($idx);

	if ($foo->IsValid()) {
            # Insert into cache.
	    return $foo;
	}	
	return null;
    }

    function LookupByCreator($token) {
	$safe_token = addslashes($token);

	$query_result =
	    DBQueryFatal("select uuid from apt_instances ".
			 "where creator_uuid='$safe_token'");

	if (! ($query_result && mysql_num_rows($query_result))) {
	    return null;
	}
	$row = mysql_fetch_row($query_result);
	$uuid = $row[0];
174 175 176
 	return Instance::Lookup($uuid);
    }

177 178 179 180 181 182 183 184 185 186 187 188 189 190 191
    function LookupBySlice($token) {
	$safe_token = addslashes($token);

	$query_result =
	    DBQueryFatal("select uuid from apt_instances ".
			 "where slice_uuid='$safe_token'");

	if (! ($query_result && mysql_num_rows($query_result))) {
	    return null;
	}
	$row = mysql_fetch_row($query_result);
	$uuid = $row[0];
 	return Instance::Lookup($uuid);
    }

192 193 194 195 196 197 198 199 200 201 202 203 204
    function LookupByName($project, $token) {
	$safe_token = addslashes($token);
        $pid_idx    = $project->pid_idx();

	$query_result =
	    DBQueryFatal("select uuid from apt_instances ".
			 "where pid_idx='$pid_idx' and name='$safe_token'");

	if (! ($query_result && mysql_num_rows($query_result))) {
	    return null;
	}
	$row = mysql_fetch_row($query_result);
	$uuid = $row[0];
Leigh Stoller's avatar
Leigh Stoller committed
205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226
 	return Instance::Lookup($uuid);
    }

    #
    # Refresh an instance by reloading from the DB.
    #
    function Refresh() {
	if (! $this->IsValid())
	    return -1;

	$uuid = $this->uuid();

	$query_result =
	    DBQueryWarn("select * from apt_instances where uuid='$uuid'");
    
	if (!$query_result || !mysql_num_rows($query_result)) {
	    $this->instance  = NULL;
	    return -1;
	}
	$this->instance = mysql_fetch_array($query_result);
	return 0;
    }
227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261
    #
    # Class function to create a new Instance
    #
    function Instantiate($creator, $options, $args, &$errors) {
	global $suexec_output, $suexec_output_array;

	# So we can look up the slice after the backend creates it.
	$uuid = NewUUID();

	#
        # Generate a temporary file and write in the XML goo. 
	#
	$xmlname = tempnam("/tmp", "quickvm");
	if (! $xmlname) {
	    TBERROR("Could not create temporary filename", 0);
	    $errors["error"] = "Transient error(1); please try again later.";
	    return null;
	}
	elseif (! ($fp = fopen($xmlname, "w"))) {
	    TBERROR("Could not open temp file $xmlname", 0);
	    $errors["error"] = "Transient error(2); please try again later.";
	    return null;
	}
	else {
	    fwrite($fp, "<quickvm>\n");
	    foreach ($args as $name => $value) {
		fwrite($fp, "<attribute name=\"$name\">");
		fwrite($fp, "  <value>" . htmlspecialchars($value) .
		       "</value>");
		fwrite($fp, "</attribute>\n");
	    }
	    fwrite($fp, "</quickvm>\n");
	    fclose($fp);
	    chmod($xmlname, 0666);
	}
262 263
	# 
	# With a real user, run as that user. 
264
	#
265
	$uid = ($creator ? $creator->uid() : "nobody");
Leigh Stoller's avatar
Leigh Stoller committed
266 267 268 269
	$pid = "nobody";
	if ($creator && $creator->FirstApprovedProject()) {
	    $pid = $creator->FirstApprovedProject()->pid();
	}
270 271 272
	if (isset($_SERVER['REMOTE_ADDR'])) { 
	    putenv("REMOTE_ADDR=" . $_SERVER['REMOTE_ADDR']);
	}
Leigh Stoller's avatar
Leigh Stoller committed
273 274 275
	if (isset($_SERVER['SERVER_NAME'])) { 
	    putenv("SERVER_NAME=" . $_SERVER['SERVER_NAME']);
	}
276
	$retval = SUEXEC($uid, $pid,
277
			 "webcreate_instance $options -u $uuid $xmlname",
278
			 SUEXEC_ACTION_IGNORE);
279
	unlink($xmlname);
280 281 282

	if ($retval != 0) {
	    if ($retval < 0) {
283
		SUEXECERROR(SUEXEC_ACTION_CONTINUE);
284 285 286 287 288 289 290 291 292
		$errors["error"] =
		    "Transient error(3); please try again later.";
	    }
	    else {
		if (count($suexec_output_array)) {
		    $line = $suexec_output_array[0];
		    $errors["error"] = $line;
		}
		else {
293
		    SUEXECERROR(SUEXEC_ACTION_CONTINUE);
294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313
		    $errors["error"] =
			"Transient error(4); please try again later.";
		}
	    }
	    return null;
	}
	$instance = Instance::Lookup($uuid);
	if (!$instance) {
	    $errors["error"] = "Transient error(5); please try again later.";
	    return null;
	}
	if (!$creator) {
	    $creator = GeniUser::Lookup("sa", $instance->creator_uuid());
	}
	if (!$creator) {
	    $errors["error"] = "Transient error(6); please try again later.";
	    return null;
	}
	return array($instance, $creator);
    }
314 315 316 317 318 319 320 321 322 323

    function UserHasInstances($user) {
	$uuid = $user->uuid();

	$query_result =
	    DBQueryFatal("select uuid from apt_instances ".
			 "where creator_uuid='$uuid'");

	return mysql_num_rows($query_result);
    }
324 325 326 327

    function SendEmail($to, $subject, $msg, $headers) {
	TBMAIL($to, $subject, $msg, $headers);
    }
328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343

    #
    # How many experiments has a guest user created
    #
    function GuestInstanceCount($geniuser) {
        $uid = $geniuser->uid();
        
        $query_result =
            DBQueryFatal("select count(h.uuid) from apt_instance_history as h ".
                         "left join geni.geni_users as u on ".
                         "     u.uuid=h.creator_uuid ".
                         "where h.creator='$uid' and u.email is not null");
        
	$row = mysql_fetch_row($query_result);
	return $row[0];
    }
344 345 346 347 348

    #
    # Return aggregate based on the current user.
    #
    function DefaultAggregateList() {
349
        return Aggregate::DefaultAggregateList();
350
    }
351

Leigh Stoller's avatar
Leigh Stoller committed
352 353 354 355 356 357 358 359
    # helper
    function ParseURN($urn)
    {
        if (preg_match("/^[^+]*\+([^+]+)\+([^+]+)\+(.+)$/", $urn, $matches)) {
            return array($matches[1], $matches[2], $matches[3]);
        }
        return array();
    }
360 361 362 363 364 365 366
    function ValidURN($urn)
    {
        if (preg_match("/^[^+]*\+([^+]+)\+([^+]+)\+(.+)$/", $urn)) {
            return true;
        }
        return false;
    }
367 368 369 370 371 372 373 374 375

    function SetExtensionReason($reason)
    {
	$uuid = $this->uuid();
        $safe_reason = mysql_escape_string($reason);

        DBQueryWarn("update apt_instances set ".
                    "  extension_reason='$safe_reason' ".
                    "where uuid='$uuid'");
376 377
    }

378 379 380 381 382 383 384 385 386
    function SetExtensionRequested($value)
    {
	$uuid = $this->uuid();

        DBQueryWarn("update apt_instances set ".
                    "  extension_requested='$value' ".
                    "where uuid='$uuid'");
    }

387 388 389 390 391 392 393 394 395
    function AddExtensionHistory($text)
    {
	$uuid = $this->uuid();
        $safe_text = mysql_escape_string($text);

        DBQueryWarn("update apt_instances set ".
                    "extension_history=CONCAT('$safe_text',".
                    "IFNULL(extension_history,'')) ".
                    "where uuid='$uuid'");
396
    }
397 398 399 400 401 402 403 404 405 406

    function BumpExtensionCount($granted)
    {
	$uuid = $this->uuid();

        DBQueryWarn("update apt_instances set ".
                    "  extension_count=extension_count+1, ".
                    "  extension_days=extension_days+${granted} ".
                    "where uuid='$uuid'");
    }
407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430
    #
    # Permission check; does user have permission to view instance.
    #
    function CanView($user) {
	if ($this->creator_idx() == $user->uid_idx()) {
	    return 1;
	}
	# Otherwise a project membership test.
	$project = Project::Lookup($this->pid_idx());
	if (!$project) {
	    return 0;
	}
	$isapproved = 0;
	if ($project->IsMember($user, $isapproved) && $isapproved) {
	    return 1;
	}
	return 0;
    }
    function CanModify($user) {
	if ($this->creator_idx() == $user->uid_idx()) {
	    return 1;
	}
        return 0;
    }
431 432 433 434 435
    function CanDoSSH($user) {
	if ($this->creator_idx() == $user->uid_idx()) {
	    return 1;
	}
        #
436
        # These are the guest projects.
437
        #
438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453
        $APT_HOLDINGPROJECT   = "aptguests";
        $CLOUD_HOLDINGPROJECT = "CloudLab";
        
        if ($this->pid() == $APT_HOLDINGPROJECT ||
            $this->pid() == $CLOUD_HOLDINGPROJECT) {
            return 0;
        }
        
        # Otherwise a project membership test.
        $project = Project::Lookup($this->pid_idx());
        if (!$project) {
            return 0;
        }
        $isapproved = 0;
        if ($project->IsMember($user, $isapproved) && $isapproved) {
            return 1;
454 455 456
        }
        return 0;
    }
457 458 459 460

    #
    # Determine user current usage.
    #
461
    function CurrentUsage($target) {
462 463 464
        $pcount = 0;
        $phours = 0;

465 466 467 468 469
        if (get_class($target) == "User") {
            $user_idx = $target->idx();
            
            $query_result =
                DBQueryFatal("select sum(physnode_count), ".
470
                         " truncate(sum(physnode_count * ".
471
                         "  ((UNIX_TIMESTAMP(now()) - ".
472
                         "    UNIX_TIMESTAMP(created)) / 3600.0)),2) as phours ".
473 474
                         "  from apt_instances ".
                         "where creator_idx='$user_idx' and physnode_count>0");
475 476 477 478 479 480 481 482 483 484 485 486
        }
        else {
            $pid_idx = $target->pid_idx();

            $query_result =
                DBQueryFatal("select sum(physnode_count), ".
                         " truncate(sum(physnode_count * ".
                         "  ((UNIX_TIMESTAMP(now()) - ".
                         "    UNIX_TIMESTAMP(created)) / 3600.0)),2) as phours ".
                         "  from apt_instances ".
                         "where pid_idx='$pid_idx' and physnode_count>0");
        }
487

488 489 490
        $row = mysql_fetch_array($query_result);
        $pcount = $row[0] ? $row[0] : 0;
        $phours = $row[1] ? $row[1] : 0;
491 492
        return array($pcount, $phours);
    }
493

494 495 496
    #
    # Usage over the last week. Just phours, cause pcount is not very useful.
    #
497
    function WeeksUsage($target) {
498 499
        $weekago  = time() - (3600 * 24 * 7);
        $phours   = 0;
500 501 502 503 504 505 506 507 508 509 510
        $pcount   = 0;
        $clause   = "";

        if (get_class($target) == "User") {
            $user_idx = $target->idx();
            $clause = "creator_idx='$user_idx'";
        }
        else {
            $pid_idx = $target->pid_idx();
            $clause = "pid_idx='$pid_idx'";
        }
511 512 513 514 515 516 517

        #
        # This gets existing experiments back one week.
        #
        $query_result =
            DBQueryFatal("select physnode_count,UNIX_TIMESTAMP(created) ".
                         "  from apt_instances ".
518
                         "where $clause and physnode_count>0");
519 520 521 522 523 524 525 526 527 528

	while ($row = mysql_fetch_array($query_result)) {
            $pnodes   = $row[0];
            $created  = $row[1];

            if ($created < $weekago)
                $diff = (3600 * 24 * 7);
            else
                $diff = time() - $created;

529
            $pcount += $pnodes;
530 531 532 533 534 535 536 537 538 539
            $phours += $pnodes * ($diff / 3600.0);
        }

        #
        # This gets experiments terminated in the last week.
        #
        $query_result =
            DBQueryFatal("select physnode_count,UNIX_TIMESTAMP(created), ".
                         "       UNIX_TIMESTAMP(destroyed) ".
                         "  from apt_instance_history ".
540
                         "where $clause and physnode_count>0 and " .
541 542 543 544 545 546 547 548 549 550 551 552
                         "      destroyed>DATE_SUB(curdate(), INTERVAL 1 WEEK)");

	while ($row = mysql_fetch_array($query_result)) {
            $pnodes    = $row[0];
            $created   = $row[1];
            $destroyed = $row[2];

            if ($created < $weekago)
                $diff = $destroyed - $weekago;
            else
                $diff = $destroyed - $created;

Leigh Stoller's avatar
Leigh Stoller committed
553 554 555
            if ($diff < 0)
                $diff = 0;

556
            $pcount += $pnodes;
557 558
            $phours += $pnodes * ($diff / 3600.0);
        }
559
        return array ($pcount, $phours);
560 561 562 563 564
    }

    #
    # Usage over the last months Just phours, cause pcount is not very useful.
    #
565
    function MonthsUsage($target) {
566
        $monthago = time() - (3600 * 24 * 28);
567
        $pcount   = 0;
568
        $phours   = 0;
569 570 571 572 573 574 575 576 577 578
        $clause   = "";

        if (get_class($target) == "User") {
            $user_idx = $target->idx();
            $clause = "creator_idx='$user_idx'";
        }
        else {
            $pid_idx = $target->pid_idx();
            $clause = "pid_idx='$pid_idx'";
        }
579 580 581 582 583 584 585

        #
        # This gets existing experiments back one week.
        #
        $query_result =
            DBQueryFatal("select physnode_count,UNIX_TIMESTAMP(created) ".
                         "  from apt_instances ".
586
                         "where $clause and physnode_count>0");
587 588 589 590 591 592 593 594 595 596

	while ($row = mysql_fetch_array($query_result)) {
            $pnodes   = $row[0];
            $created  = $row[1];

            if ($created < $monthago)
                $diff = (3600 * 24 * 28);
            else
                $diff = time() - $created;

597
            $pcount += $pnodes;
598 599 600 601 602 603 604 605 606 607
            $phours += $pnodes * ($diff / 3600.0);
        }

        #
        # This gets experiments terminated in the last week.
        #
        $query_result =
            DBQueryFatal("select physnode_count,UNIX_TIMESTAMP(created), ".
                         "       UNIX_TIMESTAMP(destroyed) ".
                         "  from apt_instance_history ".
608
                         "where $clause and physnode_count>0 and " .
609 610 611 612 613 614 615 616 617 618 619 620
                         "      destroyed>DATE_SUB(curdate(), INTERVAL 1 MONTH)");

	while ($row = mysql_fetch_array($query_result)) {
            $pnodes    = $row[0];
            $created   = $row[1];
            $destroyed = $row[2];

            if ($created < $monthago)
                $diff = $destroyed - $monthago;
            else
                $diff = $destroyed - $created;

Leigh Stoller's avatar
Leigh Stoller committed
621 622 623
            if ($diff < 0)
                $diff = 0;

624
            $pcount += $pnodes;
625 626
            $phours += $pnodes * ($diff / 3600.0);
        }
627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679
        return array($pcount, $phours);
    }

    #
    # Ranking of usage over the last N days. Just by phours, cause pcount
    # is not very useful.
    #
    function Ranking($target, $days) {
        $daysago  = time() - (3600 * 24 * days);
        $rank     = null;
        $ranktotal= 0;

        if (get_class($target) == "User") {
            $which = "creator_idx";
            $who   = $target->uid_idx();
        }
        else {
            $which = "pid_idx";
            $who   = $target->pid_idx();
        }
        $query_result =
            DBQueryFatal("select $which,SUM(physnode_count) as physnode_count,".
                         "   SUM(phours) as phours from ".
                         " ((select $which,physnode_count,created,NULL, ".
                         "   physnode_count * (TIMESTAMPDIFF(HOUR, ".
                         "    IF(created > DATE_SUB(now(), INTERVAL 30 DAY), ".
                         "       created, DATE_SUB(now(), INTERVAL 30 DAY)), now())) ".
                         "    as phours ".
                         "   from apt_instances ".
                         "   where physnode_count>0) ".
                         "  union ".
                         "  (select $which,physnode_count,created,destroyed, ".
                         "   physnode_count * (TIMESTAMPDIFF(HOUR, ".
                         "    IF(created > DATE_SUB(now(), INTERVAL 30 DAY), ".
                         "       created, DATE_SUB(now(), INTERVAL 30 DAY)), destroyed)) ".
                         "    as phours ".
                         "   from apt_instance_history ".
                         "   where physnode_count>0 and ".
                         "         destroyed>DATE_SUB(now(),INTERVAL 30 DAY)))".
                         "   as combined ".
                         "group by $which ".
                         "order by phours desc");

        $ranktotal = mysql_num_rows($query_result);
        $count = 1;
	while ($row = mysql_fetch_array($query_result)) {
            if ($who == $row[0]) {
                $rank = $count;
                break;
            }
            $count++;
        }
        return array($rank, $ranktotal);
680 681
    }

682
    #
683 684
    # Return Caching Token, either the latest commit hash
    # or the current time for development trees.
685
    #
686 687 688 689 690 691 692
    function CacheToken() {
      if (preg_match("/\/dev\//", $_SERVER["SCRIPT_NAME"]))
      {
        return date('Y-m-d-H:i:s');
      }
      else
      {
693 694 695 696 697 698 699 700 701
          $query_result =
              DBQueryFatal("select value from version_info ".
                           "where name='commithash'");
          
          if (!$query_result || !mysql_num_rows($query_result)) {
              return date('Y-m-d-H:i:s');
          }
          $row = mysql_fetch_array($query_result);
          return $row[0];
702
      }
703
    }
Leigh Stoller's avatar
Leigh Stoller committed
704
}
705 706 707 708 709 710 711 712 713

class InstanceSliver
{
    var	$sliver;
    
    #
    # Constructor by lookup on unique index.
    #
    function InstanceSliver($instance, $urn) {
714 715 716 717 718
        if (!$instance) {
            TBMAIL("stoller", "undefined instance", $urn);
	    $this->sliver = null;
	    return;
        }
719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741
	$uuid = $instance->uuid();

	$query_result =
	    DBQueryWarn("select * from apt_instance_aggregates ".
			"where uuid='$uuid' and aggregate_urn='$urn'");

	if (!$query_result || !mysql_num_rows($query_result)) {
	    $this->sliver = null;
	    return;
	}
	$this->sliver = mysql_fetch_array($query_result);
    }
    # accessors
    function field($name) {
	return (is_null($this->sliver) ? -1 : $this->sliver[$name]);
    }
    function uuid()	    { return $this->field('uuid'); }
    function name()	    { return $this->field('name'); }
    function aggregate_urn(){ return $this->field('aggregate_urn'); }
    function status()	    { return $this->field('status'); }
    function public_url()   { return $this->field('public_url'); }
    function webtask_id()   { return $this->field('webtask_id'); }
    function manifest()	    { return $this->field('manifest'); }
742 743
    function physnode_count() { return $this->field('physnode_count'); }
    function virtnode_count() { return $this->field('virtnode_count'); }
744 745 746 747
    function aggregate_name() {
        global $urn_mapping;
        return $urn_mapping[$this->aggregate_urn()];
    }
748 749 750 751 752 753 754 755 756 757 758 759 760 761 762

    # Hmm, how does one cause an error in a php constructor?
    function IsValid() {
	return !is_null($this->sliver);
    }

    function Lookup($instance, $urn) {
	$foo = new InstanceSliver($instance, $urn);

	if ($foo->IsValid()) {
            return $foo;
        }
        #
        # Backwards compat for a while, create a fake one. 
        #
763
        $webtask_id = null;
764
        $webtask = WebTask::LookupByObject($instance->uuid());
765 766 767
        if ($webtask) {
            $webtask_id = $webtask->task_id();
        }
768 769 770 771 772 773 774
        $foo->sliver = array(
            "uuid" => $instance->uuid(),
            "name" => $instance->name(),
            "aggregate_urn" => $instance->aggregate_urn(),
            "status" => $instance->status(),
            "public_url" => $instance->public_url(),
            "manifest" => $instance->manifest(),
775
            "webtask_id" => $webtask_id,
776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800
        );
        return $foo;
    }

    #
    # Lookup all slivers for an instance
    #
    function LookupForInstance($instance) {
        $result = array();
        $uuid   = $instance->uuid();

        $query_result =
            DBQueryFatal("select aggregate_urn from apt_instance_aggregates ".
                         "where uuid='$uuid'");

	while ($row = mysql_fetch_array($query_result)) {
            $sliver = InstanceSliver::Lookup($instance, $row['aggregate_urn']);
            if ($sliver) {
                $result[] = $sliver;
            }
        }
        return $result;
    }
}

Leigh Stoller's avatar
Leigh Stoller committed
801
?>