Copy_of_sCaseToSQL.m
311dc6245431Bashardoust_SystCoord

Copy_of_sCaseToSQL.m
View Options

			function sCaseToSQL(sCase, conn)
			%PCASETOSQL fill sCase structure array in mySQL
			% Detailed explanation goes here

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

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

			colnames = {'sCase_id','shoulder_id','folder_name'};

			% Loop on pCase structure array
			for i=1:numel(sCase)
			sCase_id = sCase(i).sCase_id;
			shoulder_id = sCase(i).shoulder_id;
			pathology_id = sCase(i).pathology_id;
			treatment_id = pCase(i).treatment_id;
			operation_date = pCase(i).operation_date;
			if ~isnat(operation_date)
			operation_date = datestr(pCase(i).operation_date,'yyyy-mm-dd');
			else
			operation_date = '';
			end
			folder_name = pCase(i).folder_name;

			exdata = {pCase_id,shoulder_id,pathology_id,treatment_id,operation_date,folder_name};
			% insert data in SQL
			datainsert(conn,'pCase',colnames,exdata);
			end

			fprintf('Done\n');

			end