24 exec($DB_COMMAND, $dbout, $rc);
25 preg_match(
"/(\d+)/", $dbout[0], $matches);
26 $test_name = $matches[1];
27 $DB_NAME =
"fosstest".$test_name;
28 $REPO_NAME =
"testDbRepo".$test_name;
29 $SYSCONF_DIR = $dbout[0];
30 $PG_CONN = pg_connect(
"host=localhost port=5432 dbname=$DB_NAME user=fossy password=fossy")
31 or die("Could not connect");
44 exec(
"$DB_COMMAND -d $DB_NAME");
54 function get_upload_id($upload_info)
57 preg_match(
"/UploadPk is: '(\d+)'/", $upload_info, $matches);
58 $upload_id = $matches[1];
74 function connect_to_DB($fossology_testconfig)
76 $test_pg_conn = FALSE;
78 $db_conf_file = $fossology_testconfig .
"/Db.conf";
80 $test_pg_conn = pg_connect(
81 str_replace(
";",
" ", file_get_contents($db_conf_file)));
83 if (empty($test_pg_conn)) {
84 print
"Error - could not connect to test db via $db_conf_file\n";
86 print
"Successfully connected to test db\n";
88 return ($test_pg_conn);
99 function check_agent_status($test_dbh, $agent_name, $upload_id)
102 $ars_table_name = $agent_name.
"_ars";
104 $sql =
"SELECT upload_fk FROM $ars_table_name where upload_fk = $upload_id and ars_success=true;";
106 #$result = pg_query($PG_CONN, $sql);
107 $result = pg_query($test_dbh, $sql);
108 $count = pg_num_rows($result);
109 pg_free_result($result);
125 function check_file_uploadtree($test_dbh, $file_name, $upload_id)
128 $sql =
"SELECT uploadtree_pk FROM uploadtree where upload_fk = $upload_id and ufile_name = '$file_name';";
130 $result = pg_query($test_dbh, $sql);
131 $count = pg_num_rows($result);
132 pg_free_result($result);
143 function add_user($user=
'fossy', $password=
'fossy')
147 $options = array(
'cost' => 10);
148 $Hash = password_hash($password, PASSWORD_DEFAULT, $options);
149 $sql =
"SELECT * FROM users WHERE user_name = '$user';";
151 $row0 = pg_fetch_assoc($result);
152 pg_free_result($result);
153 if (empty($row0[
'user_name'])) {
155 $SQL =
"INSERT INTO users (user_name,user_desc,user_seed,user_pass," .
156 "user_perm,user_email,email_notify,root_folder_fk)
157 VALUES ('$user','Default Administrator','Seed','$Hash',10,'$password','y',1);";
160 pg_free_result($result);
167 function preparations()
172 if (is_dir(
"/srv/fossology/$REPO_NAME")) {
173 exec(
"sudo chmod 2770 /srv/fossology/$REPO_NAME");
174 exec(
"sudo chown fossy /srv/fossology/$REPO_NAME -R");
175 exec(
"sudo chgrp fossy /srv/fossology/$REPO_NAME -R");
177 if (is_dir($SYSCONF_DIR)) {
178 exec(
"sudo chown fossy $SYSCONF_DIR -R");
179 exec(
"sudo chgrp fossy $SYSCONF_DIR -R");
186 function stop_scheduler()
190 $scheduler_path =
"$SYSCONF_DIR/mods-enabled/scheduler/agent/fo_scheduler";
191 exec(
"sudo $scheduler_path -k");
197 function scheduler_operation()
200 $scheduler_path =
"/usr/local/share/fossology/scheduler/agent/fo_scheduler";
201 exec(
"sudo $scheduler_path -k");
202 $scheduler_path =
"$SYSCONF_DIR/mods-enabled/scheduler/agent/fo_scheduler";
203 exec(
"sudo $scheduler_path -k");
204 exec(
"sudo $scheduler_path --daemon --reset --verbose=952 -c $SYSCONF_DIR");
210 function add_proxy($proxy_type=
'http_proxy', $porxy=
'web-proxy.cce.hp.com:8088')
214 $foss_conf = $SYSCONF_DIR.
"/fossology.conf";
215 exec(
"sudo sed 's/.$proxy_type.*=.*/$proxy_type=$porxy/' $foss_conf >/tmp/fossology.conf");
216 exec(
"sudo mv /tmp/fossology.conf $foss_conf");
227 function get_uploadtree_id($test_dbh, $upload_id)
229 $sql =
"SELECT uploadtree_pk from uploadtree where upload_fk =$upload_id order by uploadtree_pk limit 1;";
230 $result = pg_query($test_dbh, $sql);
231 $row = pg_fetch_assoc($result);
232 $uploadtree_id = $row[
'uploadtree_pk'];
233 pg_free_result($result);
234 return $uploadtree_id;
add_user($User, $Desc, $Hash, $Perm, $Email, $Email_notify, $Upload_visibility, $agentList, $Folder, $default_bucketpool_fk='')
Add a user.
foreach($Options as $Option=> $OptVal) if(0==$reference_flag &&0==$nomos_flag) $PG_CONN