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
|
<?php
/**
* LtiConsumer - LTI consumer API for Stud.IP
*
* This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU General Public License as
* published by the Free Software Foundation; either version 2 of
* the License, or (at your option) any later version.
*
* @author Elmar Ludwig
* @license http://www.gnu.org/licenses/gpl-2.0.html GPL version 2
*/
class LtiConsumer extends Migration
{
public function description()
{
return 'initial database setup for LTI consumer API';
}
public function up()
{
$db = DBManager::get();
$sql = "CREATE TABLE lti_data (
id INT(11) NOT NULL AUTO_INCREMENT,
position INT(11) NOT NULL DEFAULT 0,
course_id CHAR(32) COLLATE latin1_bin NOT NULL,
title VARCHAR(255) NOT NULL DEFAULT '',
description TEXT NOT NULL DEFAULT '',
tool_id INT(11) NOT NULL DEFAULT 0,
launch_url VARCHAR(255) NOT NULL DEFAULT '',
mkdate INT(11) NOT NULL DEFAULT 0,
chdate INT(11) NOT NULL DEFAULT 0,
options TEXT NULL,
PRIMARY KEY (id),
KEY course_id (course_id)
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC";
$db->exec($sql);
$sql = "CREATE TABLE lti_tool (
id INT(11) NOT NULL AUTO_INCREMENT,
name VARCHAR(255) NOT NULL DEFAULT '',
launch_url VARCHAR(255) NOT NULL DEFAULT '',
consumer_key VARCHAR(255) NOT NULL DEFAULT '',
consumer_secret VARCHAR(255) NOT NULL DEFAULT '',
custom_parameters TEXT NOT NULL,
allow_custom_url TINYINT(1) NOT NULL DEFAULT 0,
deep_linking TINYINT(1) NOT NULL DEFAULT 0,
send_lis_person TINYINT(1) NOT NULL DEFAULT 0,
mkdate INT(11) NOT NULL DEFAULT 0,
chdate INT(11) NOT NULL DEFAULT 0,
PRIMARY KEY (id)
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC";
$db->exec($sql);
$sql = "CREATE TABLE lti_grade (
link_id INT(11) NOT NULL DEFAULT 0,
user_id CHAR(32) COLLATE latin1_bin NOT NULL,
score FLOAT NOT NULL DEFAULT 0,
mkdate INT(11) NOT NULL DEFAULT 0,
chdate INT(11) NOT NULL DEFAULT 0,
PRIMARY KEY (link_id, user_id)
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC";
$db->exec($sql);
// install as core plugin
$sql = "INSERT INTO plugins (pluginclassname, pluginname, plugintype, enabled, navigationpos)
VALUES ('LtiToolModule', 'LTI-Tool', 'StandardPlugin,SystemPlugin,PrivacyPlugin', 'yes', 1)";
$db->exec($sql);
$sql = "INSERT INTO roles_plugins (roleid, pluginid)
SELECT roleid, ? FROM roles WHERE `system` = 'y'";
$db->execute($sql, [$db->lastInsertId()]);
// install config settings
$stmt = $db->prepare('INSERT INTO config (field, value, type, `range`, mkdate, chdate, description)
VALUES (:name, :value, :type, :range, UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), :description)');
$stmt->execute([
'name' => 'LTI_TOOL_TITLE',
'description' => 'Voreinstellung für den Titel des Reiters "LTI-Tool" im Kurs.',
'range' => 'course',
'type' => 'string',
'value' => 'LTI-Tool'
]);
// migrate data from alija plugin
$result = $db->query("SHOW TABLES LIKE 'alija_grade'");
if ($result->rowCount() > 0) {
$db->exec("INSERT INTO lti_data
SELECT id, position, course_id, title, description, tool_id,
launch_url, mkdate, chdate, options FROM alija_data");
$db->exec('INSERT INTO lti_tool SELECT * FROM alija_tool');
$db->exec('INSERT INTO lti_grade SELECT * FROM alija_grade');
}
}
public function down()
{
$db = DBManager::get();
$db->exec("DELETE config, config_values FROM config
LEFT JOIN config_values USING (field)
WHERE field = 'LTI_TOOL_TITLE'");
$db->exec("DELETE plugins, roles_plugins FROM plugins
LEFT JOIN roles_plugins USING (pluginid)
WHERE pluginclassname = 'LtiToolModule'");
$db->exec('DROP table lti_grade, lti_tool, lti_data');
}
}
|
