anonymityToSQL.m
311dc6245431master

anonymityToSQL.m
View Options

			function anonymity(patient, conn)
			%PATIENDBUPDATE fill patient structure array in mySQL
			% Detailed explanation goes here

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

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

			colnames = {'ipp','initials'};

			% Loop on patient structure array
			for i=1:numel(patient)
			ipp = patient(i).IPP;
			initials = patient(i).initials;

			exdata = {ipp,initials};
			% insert data in SQL
			datainsert(conn,'anonymity',colnames,exdata);
			end

			fprintf('Done\n');

			end