scapulaToSQL.m
233813c10a01Bashardoust_SystCoord

scapulaToSQL.m
View Options

			function scapulaToSQL(scapula, conn)
			% fill scapula structure array in mySQL
			% Detailed explanation goes here

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

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

			colnames = {'CT_id','CT_angle'};

			% Loop on glenoid structure array
			for i=1:numel(scapula)

			CT_id = scapula(i).CT_id;
			CT_angle = scapula(i).CTangle;


			exdata = {CT_id,CT_angle};
			% insert data in SQL

			datainsert(conn,'scapula',colnames,exdata);
			end

			fprintf('Done\n');

			end