diagnosisToSQL.m
311dc6245431master

diagnosisToSQL.m
View Options

			function diagnosisToSQL(diagnosis, conn)
			%diagnosisTOSQL Summary of this function goes here
			% Detailed explanation goes here

			fprintf('\ndiagnosis to mySQL...');

			% Empty diagnosis table and reset AUTO_INCREMENT
			sqlquery = 'TRUNCATE diagnosis';
			curs = exec(conn,sqlquery);
			if ~isempty(curs.Message)
			fprintf('\nMessage: %s\n', curs.Message);
			end

			colnames = {'diagnosis_id','sCase_id','diagnosisList_id','date','comment'};

			% Loop on pCase structure array
			for i=1:numel(diagnosis)
			diagnosis_id = diagnosis(i).diagnosis_id;
			sCase_id = diagnosis(i).sCase_id;
			diagnosisList_id = diagnosis(i).diagnosisList_id;
			date = diagnosis(i).date;
			comment = diagnosis(i).comment;

			exdata = {diagnosis_id,sCase_id,diagnosisList_id,date,comment};
			% insert data in SQL
			datainsert(conn,'diagnosis',colnames,exdata);
			end

			fprintf(' Done\n');

			end