Homec4science
Diffusion ShoulderDB_ImportSegmentMeasureAnalyze (master) Browse

R8218/XLS_MySQL_DB/MainExcel2SQL.m
e2d0fb93c2admaster

Last Change
Raw File

MainExcel2SQL.m
View Options

%% MainExcel2SQL
%
% This script reads the shoulder database Excel file and
% write in the mySQL database. The existing tables are overwritten and
% auto-counter are reset.
% Author: Alexandre Terrier, EPFL-LBO
% Date: 2016-09-29
%
%%
% Initialization
clearvars; % Clear all matlab variables
%%
%**************************************************************************
%
% Read data from Excel
%
excelRaw = rawFromExcel();
%%
% Read from Excel: pathology array
diagnosisList = diagnosisListFromExcel(excelRaw);
%%
% Read from Excel: treatement array
treatmentList = treatmentListFromExcel(excelRaw);
%%
% Read from Excel: patient structure array
patient = patientFromExcel(excelRaw);
%%
% Read from Excel: shoulder structure array
shoulder = shoulderFromExcel(patient, excelRaw);
%%
% Read from Excel: sCase struture array, and associated
[sCase, diagnosis, treatment, outcome, study] = sCaseFromExcel(...
shoulder, patient, diagnosisList, treatmentList, excelRaw);
%%
% Read from Excel: ct structure array, nd associated
[CT, scapula, glenoid, glenoid_density, humerus, muscle] = CTfromExcel(...
shoulder, patient, excelRaw);
%%
%**************************************************************************
%
% Write data to mySQL database
%%
% open mySQL connection
conn = openSQL();
%%
% Initialize tables of mySQL database
initializeSQL(conn);
%%
% Write in mySQL: patient table
patientToSQL(patient, conn);
%%
% Write in mySQL: anonymity table
anonymityToSQL(patient, conn);
%%
% Write in mySQL: shoulder table
shoulderToSQL(shoulder, conn);
%%
% Write in mySQL: sCase
sCaseToSQL(sCase, conn);
%%
% Write in mySQL: CT
CTtoSQL(CT, conn);
%%
% Write in mySQL: glenoid
scapulaToSQL(scapula, conn);
%%
% Write in mySQL: glenoid
glenoidToSQL(glenoid, conn);
%%
% Write in mySQL: diagnosisList
diagnosisListToSQL(diagnosisList, conn);
%%
% Write in mySQL: diagnosis
diagnosisToSQL(diagnosis, conn);
%%
% Write in mySQL: treatmentList
treatmentListToSQL(treatmentList, conn);
%%
% Write in mySQL: treatment
treatmentToSQL(treatment, conn);
%%
% Write in mySQL: outcome
outcomeToSQL(outcome, conn);
%%
% Close mySQL database
closeSQL(conn);
c4science · Help