SANTO/InsertPublication.php at master · ag-sc/SANTO · GitHub

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
114
<?php
require_once 'php/constants.php';

//$mysqli->query("SET FOREIGN_KEY_CHECKS = 0");
//$mysqli->query("TRUNCATE TABLE `Publication`");
//$mysqli->query("TRUNCATE TABLE `Token`");
//$mysqli->query("TRUNCATE TABLE `Annotation`");
//$mysqli->query("TRUNCATE TABLE `Data`");
//$mysqli->query("SET FOREIGN_KEY_CHECKS = 1");

$mysqli->query("START TRANSACTION");

//$publication = trim(file_get_contents($_FILES['publication']['tmp_name']));

//$file = basename($_FILES['publication']['name']);
//var_dump($_POST);
$name = $_POST['name'];
if ($name == "") {
    $filename = $_FILES['tokens']['name'];
    $name = substr($filename, 0, strrpos($filename, '.'));
}

var_dump($name);


if($stmt = $mysqli->prepare("INSERT INTO `Publication` (`FileName`, `Name`) VALUES(?, ?)")) {
    $stmt->bind_param("ss", $_FILES['tokens']['name'], $name);
    $stmt->execute() or die("ERROR(".__LINE__."): ".$mysqli->error);
    $stmt->close();
} else die("ERROR(".__LINE__."): ".$mysqli->error);
$publicationId = $mysqli->insert_id;
//
//foreach ($_POST["users"] as $user) {
//    if($stmt = $mysqli->prepare("INSERT INTO `User_Publication` (`UserId`, `PublicationId`) VALUES(?, ?)")) {
//        $stmt->bind_param("ii", $user, $publicationId);
//        $stmt->execute() or die("ERROR(".__LINE__."): ".$mysqli->error);
//        $stmt->close();
//    } else die("ERROR(".__LINE__."): ".$mysqli->error);
//}

$csvFile = file($_FILES['tokens']['tmp_name']);
foreach ($csvFile as $line) {
    if (trim($line)[0] == '#') continue;
    $token = array_combine(array("sentence", "number", "onset", "offset", "text"), str_getcsv($line, "\t"));

    if($stmt = $mysqli->prepare("INSERT INTO `Token` (`PublicationId`, `Text`, `Onset`, `Offset`, `Sentence`, `Number`) VALUES(?, ?, ?, ?, ?, ?);")) {
        $stmt->bind_param("isiiii", $publicationId, $token["text"], $token["onset"], $token["offset"], $token["sentence"], $token["number"]);
        $stmt->execute() or die("ERROR(".__LINE__."): ".$mysqli->error);
        $stmt->close();
    } else die("ERROR(".__LINE__."): ".$mysqli->error);
}

//$csvFile = file($_FILES['annotations']['tmp_name']);
//
//$annotationIndices = array();
//
//foreach ($csvFile as $line) {
//    if (trim($line)[0] == '#') continue;
//    $annotation = array_combine(array("index", "class", "onset", "offset", "text"), str_getcsv($line, "\t"));
//    $annotationIndices[$annotation["index"]][] = $annotation;
//}
//
//if ($stmt = $mysqli->prepare("SELECT `AUTO_INCREMENT` FROM  INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'anno' AND TABLE_NAME = 'Annotation';")) {
//    $stmt->execute() or die("ERROR: ".$mysqli->error);
//    $result = $stmt->get_result();
//    $arr = $result->fetch_row();
//    $nextIndex = intval($arr[0]);
//    $stmt->close();
//} else die($mysqli->error);
//
//foreach ($annotationIndices as $index => $annotations) {
//    foreach ($annotations as $i => $annotation) {
//        if ($stmt = $mysqli->prepare("SELECT `Id` FROM `Class` WHERE `Name` = ?;")) {
//            $stmt->bind_param("s", $annotation["class"]);
//            $stmt->execute() or die("ERROR(" . __LINE__ . "): " . $mysqli->error);
//            $stmt->bind_result($annotationIndices[$index][$i]["classId"]);
//            $stmt->fetch();
//            $stmt->close();
//        } else die("ERROR(" . __LINE__ . "): " . $mysqli->error);
//
//        if ($stmt = $mysqli->prepare("SELECT `Number`, `Sentence` FROM `Token` WHERE `Onset` = ? AND `PublicationId` = ?;")) {
//            $stmt->bind_param("ii", $annotation["onset"], $publicationId);
//            $stmt->execute() or die("ERROR(" . __LINE__ . "): " . $mysqli->error);
//            $stmt->bind_result($annotationIndices[$index][$i]["tokenOnset"], $annotationIndices[$index][$i]["sentenceA"]);
//            $stmt->fetch();
//            $stmt->close();
//        } else die("ERROR(" . __LINE__ . "): " . $mysqli->error);
//
//        if ($stmt = $mysqli->prepare("SELECT `Number` FROM `Token` WHERE `Offset` = ? AND `PublicationId` = ?;")) {
//            $stmt->bind_param("ii", $annotation["offset"], $publicationId);
//            $stmt->execute() or die("ERROR(" . __LINE__ . "): " . $mysqli->error);
//            $stmt->bind_result($annotationIndices[$index][$i]["tokenOffset"]);
//            $stmt->fetch();
//            $stmt->close();
//        } else die("ERROR(" . __LINE__ . "): " . $mysqli->error);
//    }
//
//}
//
//foreach ($_POST["users"] as $user) {
//    foreach ($annotationIndices as $index => $annotations) {
//        foreach ($annotations as $annotation) {
//            echo "INSERT INTO Annotation ($publicationId, $nextIndex, {$annotation["classId"]}, {$annotation["sentenceA"]}, {$annotation["tokenOnset"]}, {$annotation["tokenOffset"]}, {$annotation["text"]}, $user<br>";
//            if ($stmt = $mysqli->prepare("INSERT INTO `Annotation` (`PublicationId`, `Index`, `Class`, `Sentence`, `Onset`, `Offset`, `Text`, `User`) VALUES(?, ?, ?, ?, ?, ?, ?, ?);")) {
//                $stmt->bind_param("iiiiiisi", $publicationId, $nextIndex, $annotation["classId"], $annotation["sentenceA"], $annotation["tokenOnset"], $annotation["tokenOffset"], $annotation["text"], $user);
//                $stmt->execute() or die("ERROR(".__LINE__."): ".$mysqli->error.": ".$annotation["class"]);
//                $stmt->close();
//            } else die("ERROR(" . __LINE__ . "): " . $mysqli->error);
//        }
//        ++$nextIndex;
//    }
//}

$mysqli->query("COMMIT");