patientToSQL.m
7c9e17a5edb9pezhman_excelExport

patientToSQL.m
View Options

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

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

			testquery= 'SET FOREIGN_KEY_CHECKS = 0';
			exec(conn,testquery);

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

			testquery= 'SET FOREIGN_KEY_CHECKS = 1';
			exec(conn,testquery);

			colnames = {'gender','birth_date','height','weight','comment'};

			% Loop on patient structure array
			for i=1:numel(patient)
			gender = patient(i).gender;
			birth_date = datestr(patient(i).birth_date,'yyyy-mm-dd');
			height = patient(i).height;
			comment = patient(i).comment;

			if isnan(height)
			height = '';
			end
			weight = patient(i).weight;
			if isnan(weight)
			weight = '';
			end

			exdata = {gender,birth_date,height,weight,comment};
			% insert data in SQL
			datainsert(conn,'patient',colnames,exdata);
			end

			fprintf('Done\n');

			end