15 function create_db() {
23 exec($DB_COMMAND, $dbout, $rc);
24 preg_match(
"/(\d+)/", $dbout[0], $matches);
25 $test_name = $matches[1];
26 $DB_NAME =
"fosstest".$test_name;
27 $REPO_NAME =
"testDbRepo".$test_name;
28 $SYSCONF_DIR = $dbout[0];
29 $PG_CONN = pg_connect(
"host=localhost port=5432 dbname=$DB_NAME user=fossy password=fossy")
30 or die("Could not connect");
42 exec(
"$DB_COMMAND -d $DB_NAME");
52 function get_upload_id($upload_info) {
54 preg_match(
"/UploadPk is: '(\d+)'/", $upload_info, $matches);
55 $upload_id = $matches[1];
56 if (!$upload_id)
return false;
57 else return $upload_id;
68 function connect_to_DB($fossology_testconfig) {
69 $test_pg_conn = FALSE;
71 $db_conf_file = $fossology_testconfig .
"/Db.conf";
73 $test_pg_conn = pg_connect(str_replace(
";",
" ", file_get_contents($db_conf_file)));
75 if (empty($test_pg_conn)) {
76 print
"Error - could not connect to test db via $db_conf_file\n";
79 print
"Successfully connected to test db\n";
81 return($test_pg_conn);
92 function check_agent_status($test_dbh, $agent_name, $upload_id) {
94 $ars_table_name = $agent_name.
"_ars";
96 $sql =
"SELECT upload_fk FROM $ars_table_name where upload_fk = $upload_id and ars_success=true;";
98 #$result = pg_query($PG_CONN, $sql);
99 $result = pg_query($test_dbh, $sql);
100 $count = pg_num_rows($result);
101 pg_free_result($result);
102 if(1 == $count)
return 1;
114 function check_file_uploadtree($test_dbh, $file_name, $upload_id) {
116 $sql =
"SELECT uploadtree_pk FROM uploadtree where upload_fk = $upload_id and ufile_name = '$file_name';";
118 $result = pg_query($test_dbh, $sql);
119 $count = pg_num_rows($result);
120 pg_free_result($result);
131 function add_user($user=
'fossy', $password=
'fossy') {
134 $options = array(
'cost' => 10);
135 $Hash = password_hash($password, PASSWORD_DEFAULT, $options);
136 $sql =
"SELECT * FROM users WHERE user_name = '$user';";
138 $row0 = pg_fetch_assoc($result);
139 pg_free_result($result);
140 if (empty($row0[
'user_name'])) {
142 $SQL =
"INSERT INTO users (user_name,user_desc,user_seed,user_pass," .
143 "user_perm,user_email,email_notify,root_folder_fk)
144 VALUES ('$user','Default Administrator','Seed','$Hash',10,'$password','y',1);";
147 pg_free_result($result);
154 function preparations() {
158 if (is_dir(
"/srv/fossologyTestRepo/$REPO_NAME")) {
159 exec(
"sudo chmod 2770 /srv/fossologyTestRepo/$REPO_NAME");
160 exec(
"sudo chown fossy /srv/fossologyTestRepo/$REPO_NAME -R");
161 exec(
"sudo chgrp fossy /srv/fossologyTestRepo/$REPO_NAME -R");
163 if (is_dir($SYSCONF_DIR)) {
164 exec(
"sudo chown fossy $SYSCONF_DIR -R");
165 exec(
"sudo chgrp fossy $SYSCONF_DIR -R");
172 function stop_scheduler() {
175 $scheduler_path =
"$SYSCONF_DIR/mods-enabled/scheduler/agent/fo_scheduler";
176 exec(
"sudo $scheduler_path -k");
182 function scheduler_operation() {
184 $scheduler_path =
"/usr/local/share/fossology/scheduler/agent/fo_scheduler";
185 exec(
"sudo $scheduler_path -k");
186 $scheduler_path =
"$SYSCONF_DIR/mods-enabled/scheduler/agent/fo_scheduler";
187 exec(
"sudo $scheduler_path -k");
188 exec(
"sudo $scheduler_path --daemon --reset --verbose=952 -c $SYSCONF_DIR");
194 function add_proxy($proxy_type=
'http_proxy', $porxy=
'web-proxy.cce.hp.com:8088') {
197 $foss_conf = $SYSCONF_DIR.
"/fossology.conf";
198 exec(
"sudo sed 's/.$proxy_type.*=.*/$proxy_type=$porxy/' $foss_conf >/tmp/fossology.conf");
199 exec(
"sudo mv /tmp/fossology.conf $foss_conf");
210 function get_uploadtree_id($test_dbh, $upload_id) {
211 $sql =
"SELECT uploadtree_pk from uploadtree where upload_fk =$upload_id order by uploadtree_pk limit 1;";
212 $result = pg_query($test_dbh, $sql);
213 $row = pg_fetch_assoc($result);
214 $uploadtree_id = $row[
'uploadtree_pk'];
215 pg_free_result($result);
216 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