/**
* @global moodle_database $DB
* @param int $oldversion
* @return bool
*/
function xmldb_plagiarism_turnitin_upgrade($oldversion)
{
global $DB, $CFG;
$dbman = $DB->get_manager();
$result = true;
if ($oldversion < 2013081202) {
$table = new xmldb_table('plagiarism_turnitin_files');
$field1 = new xmldb_field('transmatch', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, 0, 'legacyteacher');
$field2 = new xmldb_field('lastmodified', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, 0, 'transmatch');
$field3 = new xmldb_field('grade', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, 'lastmodified');
$field4 = new xmldb_field('submissiontype', XMLDB_TYPE_TEXT, 'medium', null, null, null, null, 'grade');
$field5 = new xmldb_field('similarityscore', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, 'statuscode');
if (!$dbman->field_exists($table, $field1)) {
$dbman->add_field($table, $field1);
}
if (!$dbman->field_exists($table, $field2)) {
$dbman->add_field($table, $field2);
}
if (!$dbman->field_exists($table, $field3)) {
$dbman->add_field($table, $field3);
}
if (!$dbman->field_exists($table, $field4)) {
$dbman->add_field($table, $field4);
}
if (!$dbman->field_exists($table, $field5)) {
$dbman->add_field($table, $field5);
} else {
$dbman->change_field_type($table, $field5);
$dbman->change_field_default($table, $field5);
}
upgrade_dm_successful_uploads();
upgrade_plugin_savepoint(true, 2013081202, 'plagiarism', 'turnitin');
}
if ($oldversion < 2014012403) {
$table = new xmldb_table('plagiarism_turnitin_files');
$field = new xmldb_field('orcapable', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, 'submissiontype');
if (!$dbman->field_exists($table, $field)) {
$dbman->add_field($table, $field);
} else {
$dbman->change_field_default($table, $field);
}
upgrade_plugin_savepoint(true, 2014012403, 'plagiarism', 'turnitin');
}
if ($oldversion < 2014012405) {
if ($turnitinsetting = $DB->get_record('config_plugins', array('name' => 'turnitin_use', 'plugin' => 'plagiarism'))) {
if ($turnitinsetting->value == 1) {
$supported_mods = array('assign', 'forum', 'workshop');
foreach ($supported_mods as $mod) {
$configfield = new object();
$configfield->value = 1;
$configfield->plugin = 'plagiarism';
$configfield->name = 'turnitin_use_mod_' . $mod;
if (!$DB->get_record('config_plugins', array('name' => 'turnitin_use_mod_' . $mod))) {
$DB->insert_record('config_plugins', $configfield);
}
}
}
}
upgrade_plugin_savepoint(true, 2014012405, 'plagiarism', 'turnitin');
}
if ($oldversion < 2014012406) {
$table = new xmldb_table('plagiarism_turnitin_files');
$field = new xmldb_field('errorcode', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, 'orcapable');
if (!$dbman->field_exists($table, $field)) {
$dbman->add_field($table, $field);
}
$field = new xmldb_field('errormsg', XMLDB_TYPE_TEXT, 'medium', null, null, null, null, 'errorcode');
if (!$dbman->field_exists($table, $field)) {
$dbman->add_field($table, $field);
}
upgrade_plugin_savepoint(true, 2014012406, 'plagiarism', 'turnitin');
}
if ($oldversion < 2014012413) {
// Add new indexes to tables
$table = new xmldb_table('plagiarism_turnitin_files');
$index = new xmldb_index('externalid', XMLDB_INDEX_NOTUNIQUE, array('externalid'));
if (!$dbman->index_exists($table, $index)) {
$dbman->add_index($table, $index);
}
// Alter certain datatypes incase install was made before install.xml was updated.
$field1 = new xmldb_field('transmatch', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, 0, 'legacyteacher');
$field2 = new xmldb_field('lastmodified', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, 0, 'transmatch');
$field3 = new xmldb_field('grade', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, 'lastmodified');
$field4 = new xmldb_field('submissiontype', XMLDB_TYPE_TEXT, 'medium', null, null, null, null, 'grade');
$field5 = new xmldb_field('similarityscore', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, 'statuscode');
if (!$dbman->field_exists($table, $field1)) {
$dbman->add_field($table, $field1);
} else {
$dbman->change_field_precision($table, $field1);
}
if (!$dbman->field_exists($table, $field2)) {
$dbman->add_field($table, $field2);
} else {
$dbman->change_field_precision($table, $field2);
}
if (!$dbman->field_exists($table, $field3)) {
$dbman->add_field($table, $field3);
} else {
$dbman->change_field_precision($table, $field3);
}
if (!$dbman->field_exists($table, $field4)) {
$dbman->add_field($table, $field4);
} else {
$dbman->change_field_precision($table, $field4);
}
if (!$dbman->field_exists($table, $field5)) {
$dbman->add_field($table, $field5);
} else {
$dbman->change_field_type($table, $field5);
$dbman->change_field_default($table, $field5);
$dbman->change_field_precision($table, $field5);
}
upgrade_plugin_savepoint(true, 2014012413, 'plagiarism', 'turnitin');
}
if ($oldversion < 2015040107) {
upgrade_dm_successful_uploads();
}
if ($oldversion < 2015040107) {
$table = new xmldb_table('plagiarism_turnitin_files');
$field = new xmldb_field('submitter', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, 'userid');
if (!$dbman->field_exists($table, $field)) {
$dbman->add_field($table, $field);
}
upgrade_plugin_savepoint(true, 2015040107, 'plagiarism', 'turnitin');
}
if ($oldversion < 2015040110) {
$table = new xmldb_table('plagiarism_turnitin_files');
$field = new xmldb_field('student_read', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, 'errormsg');
if (!$dbman->field_exists($table, $field)) {
$dbman->add_field($table, $field);
}
upgrade_plugin_savepoint(true, 2015040110, 'plagiarism', 'turnitin');
}
if ($oldversion < 2016011101) {
$table = new xmldb_table('plagiarism_turnitin_files');
$field = new xmldb_field('gm_feedback', XMLDB_TYPE_INTEGER, '1', XMLDB_UNSIGNED, true, false, 0, 'student_read');
if (!$dbman->field_exists($table, $field)) {
$dbman->add_field($table, $field);
}
}
if ($oldversion < 2016011104) {
$table = new xmldb_table('plagiarism_turnitin_files');
$field = new xmldb_field('duedate_report_refresh', XMLDB_TYPE_INTEGER, '1', XMLDB_UNSIGNED, true, false, 0, 'gm_feedback');
if (!$dbman->field_exists($table, $field)) {
$dbman->add_field($table, $field);
}
}
if ($oldversion < 2016011105) {
$table = new xmldb_table('plagiarism_turnitin_config');
// Drop cm key so that we can modify the field to allow null values.
$key = new xmldb_key('cm', XMLDB_KEY_FOREIGN, array('cm'), 'course_modules', array('id'));
$dbman->drop_key($table, $key);
// Alter cm to allow null values.
$field = new xmldb_field('cm', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, false, null, null, 'id');
$dbman->change_field_notnull($table, $field);
// Update 0 to null for defaults.
$DB->execute("UPDATE " . $CFG->prefix . "plagiarism_turnitin_config SET cm = NULL WHERE cm = 0");
// Re-add foreign key for cm field.
$dbman->add_key($table, $key);
upgrade_plugin_savepoint(true, 2016011105, 'plagiarism', 'turnitin');
}
return $result;
}
/**
* @global moodle_database $DB
* @param int $oldversion
* @return bool
*/
function xmldb_plagiarism_turnitin_upgrade($oldversion)
{
global $DB;
$dbman = $DB->get_manager();
$result = true;
if ($oldversion < 2013081202) {
$table = new xmldb_table('plagiarism_turnitin_files');
$field1 = new xmldb_field('transmatch', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, 0, 'legacyteacher');
$field2 = new xmldb_field('lastmodified', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, 0, 'transmatch');
$field3 = new xmldb_field('grade', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, 'lastmodified');
$field4 = new xmldb_field('submissiontype', XMLDB_TYPE_TEXT, 'medium', null, null, null, null, 'grade');
$field5 = new xmldb_field('similarityscore', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, 'statuscode');
if (!$dbman->field_exists($table, $field1)) {
$dbman->add_field($table, $field1);
}
if (!$dbman->field_exists($table, $field2)) {
$dbman->add_field($table, $field2);
}
if (!$dbman->field_exists($table, $field3)) {
$dbman->add_field($table, $field3);
}
if (!$dbman->field_exists($table, $field4)) {
$dbman->add_field($table, $field4);
}
if (!$dbman->field_exists($table, $field5)) {
$dbman->add_field($table, $field5);
} else {
$dbman->change_field_type($table, $field5);
$dbman->change_field_default($table, $field5);
}
upgrade_dm_successful_uploads();
upgrade_plugin_savepoint(true, 2013081202, 'plagiarism', 'turnitin');
}
if ($oldversion < 2014012403) {
$table = new xmldb_table('plagiarism_turnitin_files');
$field = new xmldb_field('orcapable', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, 'submissiontype');
if (!$dbman->field_exists($table, $field)) {
$dbman->add_field($table, $field);
} else {
$dbman->change_field_default($table, $field);
}
upgrade_plugin_savepoint(true, 2014012403, 'plagiarism', 'turnitin');
}
if ($oldversion < 2014012405) {
if ($turnitinsetting = $DB->get_record('config_plugins', array('name' => 'turnitin_use', 'plugin' => 'plagiarism'))) {
if ($turnitinsetting->value == 1) {
$supported_mods = array('assign', 'forum', 'workshop');
foreach ($supported_mods as $mod) {
$configfield = new object();
$configfield->value = 1;
$configfield->plugin = 'plagiarism';
$configfield->name = 'turnitin_use_mod_' . $mod;
if (!$DB->get_record('config_plugins', array('name' => 'turnitin_use_mod_' . $mod))) {
$DB->insert_record('config_plugins', $configfield);
}
}
}
}
upgrade_plugin_savepoint(true, 2014012405, 'plagiarism', 'turnitin');
}
if ($oldversion < 2014012406) {
$table = new xmldb_table('plagiarism_turnitin_files');
$field = new xmldb_field('errorcode', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, 'orcapable');
if (!$dbman->field_exists($table, $field)) {
$dbman->add_field($table, $field);
}
$field = new xmldb_field('errormsg', XMLDB_TYPE_TEXT, 'medium', null, null, null, null, 'errorcode');
if (!$dbman->field_exists($table, $field)) {
$dbman->add_field($table, $field);
}
upgrade_plugin_savepoint(true, 2014012406, 'plagiarism', 'turnitin');
}
if ($oldversion < 2014012413) {
// Add new indexes to tables
$table = new xmldb_table('plagiarism_turnitin_files');
$index = new xmldb_index('externalid', XMLDB_INDEX_NOTUNIQUE, array('externalid'));
if (!$dbman->index_exists($table, $index)) {
$dbman->add_index($table, $index);
}
// Alter certain datatypes incase install was made before install.xml was updated.
$field1 = new xmldb_field('transmatch', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, 0, 'legacyteacher');
$field2 = new xmldb_field('lastmodified', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, 0, 'transmatch');
$field3 = new xmldb_field('grade', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, 'lastmodified');
$field4 = new xmldb_field('submissiontype', XMLDB_TYPE_TEXT, 'medium', null, null, null, null, 'grade');
$field5 = new xmldb_field('similarityscore', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, null, 'statuscode');
if (!$dbman->field_exists($table, $field1)) {
$dbman->add_field($table, $field1);
} else {
$dbman->change_field_precision($table, $field1);
}
if (!$dbman->field_exists($table, $field2)) {
$dbman->add_field($table, $field2);
} else {
$dbman->change_field_precision($table, $field2);
}
if (!$dbman->field_exists($table, $field3)) {
$dbman->add_field($table, $field3);
} else {
$dbman->change_field_precision($table, $field3);
}
if (!$dbman->field_exists($table, $field4)) {
$dbman->add_field($table, $field4);
} else {
$dbman->change_field_precision($table, $field4);
}
if (!$dbman->field_exists($table, $field5)) {
$dbman->add_field($table, $field5);
} else {
$dbman->change_field_type($table, $field5);
$dbman->change_field_default($table, $field5);
$dbman->change_field_precision($table, $field5);
}
upgrade_plugin_savepoint(true, 2014012413, 'plagiarism', 'turnitin');
}
if ($oldversion < 2015040106) {
upgrade_dm_successful_uploads();
}
return $result;
}