treatmentToSQL.m
8c4c3a6fc16bAvoidMainExcelUpdate

treatmentToSQL.m
View Options

			function treatmentToSQL(treatment, conn)
			%TREATMENTTOSQL Summary of this function goes here
			% Detailed explanation goes here

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

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

			colnames = {'treatment_id','sCase_id','treatmentList_id','date','comment'};

			% Loop on pCase structure array
			for i=1:numel(treatment)
			treatment_id = treatment(i).treatment_id;
			sCase_id = treatment(i).sCase_id;
			treatmentList_id = treatment(i).treatmentList_id;
			date = treatment(i).date;
			comment = treatment(i).comment;


			exdata = {treatment_id,sCase_id,treatmentList_id,date,comment};
			% insert data in SQL
			datainsert(conn,'treatment',colnames,exdata);
			end

			fprintf(' Done\n');

			end