[TestLink] 실행결과 가져와서 입력

자동화의 길은 멀고도 험하다.

executions 결과 입력 Php

<?php

# 

$build_id=$_GET['build_id'];

ECHO "Build ID:";

ECHO $_GET['build_id'];

ECHO "<BR>";

#2번으로 고정 되서 들어감. 

$tester_id = $_GET['tester_id'];

ECHO "Tester_id:";

ECHO $_GET['tester_id'];

ECHO "<BR>";

# 시간

$execution_ts = $_GET['execution_ts'];

ECHO "수행한 시간:";

ECHO $_GET['execution_ts'];

ECHO "<BR>";

# 결과

$status = $_GET['status'];

ECHO "결과:";

ECHO $_GET['status'];

ECHO "<BR>";

# 제품명

$testplan_id = $_GET['testplan_id'];

ECHO "제품ID:";

ECHO $_GET['testplan_id'];

ECHO "<BR>";

#수행한 TC 

$tcversion_id = $_GET['tcversion_id'];

ECHO "수행한 TC ID:";

ECHO $_GET['tcversion_id'];

ECHO "<BR>";

#수행한 TC 버전 

$tcversion_number = $_GET['tcversion_number'];

ECHO "수행한 TC Version:";

ECHO $_GET['tcversion_number'];

ECHO "<BR>";

# 실행형태

$execution_type = $_GET['execution_type'];

ECHO "실행형태:";

ECHO $_GET['execution_type'];

ECHO "<BR>";

#빌드서버에서 보내온 결과값

$notes =  $_GET['notes'];

ECHO "Notes:";

ECHO $_GET['notes'];

ECHO "<BR>";

$connect = mysql_connect("localhost","root","1234");

mysql_select_db("testlink",$connect);

$sql = "INSERT INTO `testlink`.`executions` (`id`, `build_id`, `tester_id`, `execution_ts`, `status`, `testplan_id`, `tcversion_id`, `tcversion_number`, `platform_id`, `execution_type`, `notes`) VALUES (NULL, '$build_id', '$tester_id', NULL, '$status', '$testplan_id', '$tcversion_id', '$tcversion_number', '0', '2', '$notes')";

mysql_query($sql, $connect);

mysql_close($connect);

?>