search

ctsit / redcapcustodian

Simplified, automated data management on REDCap systems
Other
12 stars 6 forks source link

Add project and instance fields to rcc job log #160

Closed ljwoodley closed 2 weeks ago

ljwoodley commented 3 weeks ago

Closes issue #159.

Here's the alter table statement to update rcc_job_log

ALTER TABLE `rcc_job_log`
ADD COLUMN `project` VARCHAR(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL AFTER `log_date`,
ADD COLUMN `instance` VARCHAR(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL AFTER `project`;

ALTER TABLE `rcc_job_log`
ADD INDEX `project` (`project`),
ADD INDEX `instance` (`instance`);

note there was one unrelated error when testing the build. This will be resolved in another PR.

pbchase commented 2 weeks ago

This looks good the documentation and templates need a little updating, but the functionality is great. The code is robust in sloppy deployments.