outcomeToSQL.m
4b5355e68791pezhman_excelExport

outcomeToSQL.m
View Options

			function outcomeToSQL( outcome, conn )
			%OUTCOMETOSQL Summary of this function goes here
			% Detailed explanation goes here

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

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

			colnames = {'outcome_id','sCase_id','date','comment','loosening'};

			% Loop on pCase structure array
			for i=1:numel(outcome)

			outcome_id = outcome(i).outcome_id;
			sCase_id = outcome(i).sCase_id;
			date = outcome(i).date;
			comment = outcome(i).comment;
			loosening = outcome(i).loosening;

			exdata = {outcome_id, sCase_id, date, comment, loosening};
			% insert data in SQL
			datainsert(conn,'outcome',colnames,exdata);
			end

			fprintf(' Done\n');

			end