-
Notifications
You must be signed in to change notification settings - Fork 0
/
runOnDatabase.php
113 lines (66 loc) · 5.16 KB
/
runOnDatabase.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
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
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
<!DOCTYPE html>
<html lang="en">
<head>
<?php
require_once "dbConn.php";
require_once "Factory.php";
?>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
<title>Run on All Images</title>
</head>
<body>
<div class="container">
<?php
$database_dir = "doubtForumImages/";
$objFactory = new Factory();
//Manager Object Created
$objManager = $objFactory->getManagerObj();
//Creating a Database connection for extracting the Mathpix API Latex
$files = array_slice(scandir($database_dir), 2);
for($i=0;$i<sizeof($files);$i++)
{
$doubt_image = $database_dir . $files[$i];
$conn = $objManager->objDB->objDBConnection->getDBConnection();
$Mathpix_API_response = $conn->query("SELECT Mathpix_API_Response FROM $table_name WHERE Image_Id = \"$doubt_image\" LIMIT 1")->fetch()["Mathpix_API_Response"];
$conn = null;
$responseArray = array();
//getSolrWorkDone() function prototype
//getSolrWorkDone($Mathpix_API_response,$do_delta_import)
$responseArray = $objManager->getSolrWorkDone($Mathpix_API_response,false);
$SolrResults = json_decode($responseArray["Solr's Results"]);
echo <<<END
<div class="row border border-dark m-4 p-4 overflow-auto">
<div class="col-sm-12">
<h3>Database Image $i </h3>
<img class="img-fluid" src = "$doubt_image"><br><br>
</div>
<div class="col-sm-12">
<h4>Solr's Responses</h4>
</div>
END;
for($j=0;$j<min(3,$SolrResults->{"response"}->{"numFound"});$j++)
{
$image_file = $SolrResults->{"response"}->{"docs"}[$j]->{"id"};
$score = $SolrResults->{"response"}->{"docs"}[$j]->{"score"};
echo <<<END
<div class="col-sm-12 border border-success overflow-auto p-4 mb-4">
<h5>Image:</h5>
<img class="img-fluid" src="$image_file"> <br>
<h5>Score: </h5>
$score
</div>
END;
}
echo "</div>";
}
?>
</div>
<!--Bootstrap Scripts -->
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js" integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script>
</body>
</html>