RENCI / ctmd

MIT License
2 stars 0 forks source link

Add Data Synchronization Capability #64

Closed mbwatson closed 5 years ago

mbwatson commented 5 years ago
mbwatson commented 5 years ago

danger zone branch has sync button, along with backup and restore buttons

mbwatson commented 5 years ago

@xu-hao Hitting /data/sync returns "Method Not Allowed, The method is not allowed for the requested URL" error message.

The pipeline container stays up and running.

Docker logs:

[mwatson@stage-pmd dashboard]$ docker logs pmd-pipeline
 * Serving Flask app "reload" (lazy loading)
 * Environment: production
   WARNING: This is a development server. Do not use it in a production deployment.
   Use a production WSGI server instead.
 * Debug mode: off
INFO:werkzeug: * Running on http://0.0.0.0:5000/ (Press CTRL+C to quit)
executing create table "StudyPI" ("AreYouStudyPI" boolean, "userId" bigint);

executing create table "CTSA" ("CTSAhubPIFirstName" varchar, "CTSAhubPILastName" varchar, "ProposalID" bigint, "approvalfromCTSA" boolean);

executing create table "ProposalDetails" ("ProposalID" bigint, "therapeuticArea" varchar, "rareDisease" boolean, "numberSubjects" bigint, "studyPopulation" varchar, "numberSites" bigint, "numberNonUSsites" bigint, "listCountries" varchar, "numberCTSAprogHubSites" bigint);

executing create table "Submitter" ("userId" varchar, "ProposalID" bigint, "submitterFirstName" varchar, "submitterLastName" varchar, "submitterFacultyStatus" bigint, "submitterEmail" varchar, "submitterPhone" varchar, "submitterInstitution" varchar);

executing create table "ProtocolTimelines_estimated" ("ProposalID" bigint, "plannedFinalProtocol" date, "plannedFirstSiteActivated" date, "plannedSubmissionDate" date, "plannedGrantSubmissionDate" date, "actualGrantSubmissionDate" date, "plannedGrantAwardDate" date, "actualGrantAwardDate" date, "estimatedStartDateOfFunding" date);

executing create table "Proposal" ("ProposalID" bigint, "dateSubmitted" date, "proposalStatus" varchar, "HEALnetwork" boolean, "ShareThisInfo" boolean, "FullTitle" varchar, "ShortTitle" varchar, "PhaseOfStudy" varchar, "ShortDescription" varchar, "ProtocolDesign" varchar, "Objectives" varchar, "Endpoints" varchar, "StudyPopulation" varchar, "MainEntryCriteria" varchar, "PlannedSitesEnrollingParticipants" varchar, "DescriptionOfStudyIntervention" varchar, "StudyDuration" varchar, "ParticipantDuration" varchar, "DisclosureConflicts" varchar, "optStatisticalPlan" varchar, "optEnrollmentPlan" varchar);

executing create table "ProposalFunding" ("ProposalID" bigint, "submittedToNIH" boolean, "currentFunding" varchar, "newFundingStatus" varchar, "numberFundingSource" bigint, "fundingSource" varchar, "fundingMechanism" varchar, "identifyFundingMechanism" varchar, "instituteCenter" varchar, "grantApplicationNumber" varchar, "FOAnumber" varchar, "planningGrant" boolean, "largerThan500K" boolean, "amountAward" varchar, "totalBudget" varchar, "fundingPeriod" varchar, "fundingStart" date, "applicationToInstituteBusinessOfficeDate" date, "discussWithPO" boolean, "POsName" varchar, "NewOrExistingNetwork" boolean, "peerReviewDone" varchar);

executing create table "User" ("userId" varchar, "password" varchar, "loginStatus" varchar, "registerDate" date);

executing create table "Administrator" ("userId" varchar, "adminName" varchar, "adminEmail" varchar);

executing create table "TINuser" ("userId" varchar, "TINuser_fname" varchar, "TINuser_lname" varchar, "TINuser_email" varchar, "TINuserOrganization" varchar);

executing create table "AssignProposal" ("ProposalID" bigint, "assignToInstitution" varchar, "ticPOC" varchar, "ricPOC" varchar, "ncatsPOC" varchar);

executing create table "TIChealPOCs" ("ProposalID" bigint, "DukePOC" varchar, "UtahPOC" varchar, "jhuPOC" varchar);

executing create table "InitialConsultationDates" ("ProposalID" bigint, "FirstContact" date, "kickOffNeeded" boolean, "kickOffScheduled" date, "kickOffDateOccurs" date, "workComplete" date, "reportSentToPI" date);

executing create table "ConsultationRequest" ("consultationRequestID" bigint, "ProposalID" bigint, "serviceOrComprehensive" varchar);

executing create table "ServicesAdditionalInfo" ("consultationRequestID" bigint, "SAuseBefore" boolean, "CIRBfwaNumber" varchar);

executing create table "InitialConsultationSummary" ("ProposalID" bigint, "protocolReviewed" boolean, "budgetReviewed" boolean, "fundingReviewed" boolean, "CIRBdiscussed" boolean, "SAdiscussed" boolean, "EHRdiscussed" boolean, "CommunityEngagementDiscuss" boolean, "RecruitmentPlanDiscussed" boolean, "FeasibilityAssessmentDiscussed" boolean, "OtherComments" varchar);

executing create table "LettersAndSurvey" ("ProposalID" bigint, "decisionLetterSent" date, "satisfactionSurveySent" date, "LetterOfSupport" date);

executing create table "PATMeeting" ("ProposalID" bigint, "meetingDate" date, "meetingNumber" bigint, "approvedFor" varchar, "comments" varchar);

executing create table "Voter" ("userId" varchar, "ProposalID" bigint, "Role" varchar);

executing create table "PATReviewForVote" ("ProposalID" bigint, "requireVote" boolean, "vote" varchar);

executing create table "BudgetBreakOut" ("ProposalID" bigint, "siteBudget" varchar, "recruitmentBudget" varchar, "overallBudget" varchar, "budgetNotes" varchar);

executing create table "RecommendationsForPI" ("ProposalID" bigint, "protocolRecommendation" varchar, "budgetRecommendation" boolean, "fundingAssessment" varchar, "CIRBrecommendation" varchar, "SArecommendation" varchar);

executing create table "TIC_RICAssessment" ("ProposalID" bigint, "Issues" varchar, "BudgetFeasible" varchar, "TICcapacity" boolean, "undertakeAtCurrentState" varchar, "opportunityToCollaborate" varchar, "operationHypothesis" varchar);

executing create table "FinalRecommendation" ("ProposalID" bigint, "recommendation" varchar, "serviceRecommended" varchar, "IsServiceFeasible" boolean, "hoursToOperationalizeService" varchar, "howOperationalizeService" varchar);

executing create table "SiteInformation" ("ProposalID" bigint, "siteNumber" bigint, "siteName" varchar, "principleInvestigator" varchar, "studyCoordinator" varchar, "ctsaName" varchar, "ctsaPOC" varchar, "activeProtocolDate" date, "protocolVersion" varchar, "projectedEnrollmentPerMonth" bigint, "IRBOriginalApproval" date, "CTA_FE" date, "enrollmentStatus" varchar, "onHoldDate" date, "onHoldDays" bigint, "siteActivatedDate" date, "dateOfFirstConsent" date, "dateOfFirstPtEnrolled" date, "mostRecentConsent" date, "mostRecentEnrolled" date, "noOfPtsSignedConsent" bigint, "noOfPtsEnrolled_site" bigint, "noOfPtsActive_site" bigint, "noOfPtsComplete_site" bigint, "noOfPtsWithdrawn_site" bigint, "noOfCRFsCompleted_site" bigint, "percentCRFsReviewed_site" bigint, "percentCRFsIncomplete_site" bigint, "noOfUnresolvedQueries_site" bigint, "noOfSAEs_site" bigint, "noOfSignificantProtocolDeviations_site" bigint, "CTAsentdate" date, "regPacksentdate" date, "siteSelectDate" date, "notesToSite" varchar);

executing create table "StudyInformation" ("ProposalID" bigint, "studyStartDate" date, "plannedCompleteEnrollment" date, "noOfSitesActive" bigint, "noOfPtsEnrolled" bigint, "noOfPtsActive" bigint, "noOfPtsComplete" bigint, "noOfPtsWithdrawn" bigint, "noOfCRFsEnteredForStudy" bigint, "percentCRFsReviewed" bigint, "percentCRFsIncomplete" bigint, "noOfUnresolvedQueries" bigint, "noOfSignificantProtocolDeviations" bigint, "noOfSAEs" bigint, "mostRecentPatientEnrolled" date);

executing create table "SuggestedChanges" ("changeID" bigint, "ShortTitle" varchar, "plannedDateToChange" date, "changeComplete" boolean);

executing create table "UtahRecommendation" ("ProposalID" bigint, "network" varchar, "tic" varchar, "ric" varchar, "collaborativeTIC" varchar, "collaborativeTIC_roleExplain" varchar, "DCCinstitution" varchar, "CCCinstitution" varchar, "primaryStudyType" varchar, "sub_ancillaryStudy" boolean, "mainStudy" varchar, "hasSubAncillaryStudy" boolean, "sub_ancillaryStudyName" varchar, "linkedData" varchar, "studyDesign" varchar, "randomized" boolean, "randomizationUnit" varchar, "randomizationFeature" varchar, "ascertainment" varchar, "observations" varchar, "pilot_demoStudy" boolean, "pilot_or_demo" varchar, "registry" boolean, "EHRdataTransfer" boolean, "EHRdataTransfer_option" varchar, "consent" boolean, "EFIC" boolean, "IRBtype" varchar, "regulatoryClassification" varchar, "clinicalTrialsIdentifier" varchar, "dsmb_dmcUsed" boolean, "initialPlannedNumberOfSites" bigint, "finalPlannedNumberOfSites" bigint, "enrollmentGoal" varchar, "initialProjectedEnrollmentDuration" bigint, "actualEnrollment" bigint);

executing create table "Proposal_NewServiceSelection" ("ProposalID" bigint, "serviceSelection" varchar);

executing create table "Proposal_ServicesApproved" ("ProposalID" bigint, "servicesApproved" varchar);

executing create table "reviewer_organization" ("reviewer" varchar, "organization" varchar);

executing create table "name" ("table" varchar, "column" varchar, "index" varchar, "id" varchar, "description" varchar);
INFO:werkzeug:192.168.240.6 - - [21/Jun/2019 03:05:01] "GET /sync HTTP/1.0" 405 -
INFO:werkzeug:192.168.240.6 - - [21/Jun/2019 03:05:05] "GET /sync HTTP/1.0" 405 -
INFO:werkzeug:192.168.240.6 - - [21/Jun/2019 03:05:06] "GET /sync HTTP/1.0" 405 -