X-Git-Url: https://git.creatis.insa-lyon.fr/pubgit/?a=blobdiff_plain;f=src%2FcreaImageIOSynchron.cpp;h=4c832dd2a8ba9f20ede5b423a59ad88ed2960bf1;hb=1d55c1cf210e95a6dc12fb8af67b2d21e48fb408;hp=0955ffaee260161d386f73b4391d220c5e3c314d;hpb=f2ae64f4abd9dc5eacdc778cdd89d194f191c301;p=creaImageIO.git

diff --git a/src/creaImageIOSynchron.cpp b/src/creaImageIOSynchron.cpp
index 0955ffa..4c832dd 100644
--- a/src/creaImageIOSynchron.cpp
+++ b/src/creaImageIOSynchron.cpp
@@ -213,7 +213,7 @@ namespace creaImageIO
 		std::string pat=path.c_str();
 		CleanName(pat);
 		insert="INSERT INTO ADD_OPS (PATH,RECURSIVE,FILES_ADDED,REFERENCEDDB) VALUES('";
-		insert+=pat+"','";
+		insert+=convert(pat)+"','";
 		insert+=recursive+"',";
 		insert+=nChildren+",'";
 		insert+=refdb+"');";
@@ -239,7 +239,7 @@ namespace creaImageIO
 			std::string insert;
 			insert="INSERT INTO IGNORED_FILES (ADD_KEY,PATH,REMOVE,TIME) VALUES('";
 			insert+=addKey+"','";
-			insert+=pat+"','";
+			insert+=convert(pat)+"','";
 			insert+=remove+"',";
 			insert+=time+");";
 			UPDATESYNCDB(insert);
@@ -256,7 +256,7 @@ namespace creaImageIO
 				std::string insert;
 				insert="INSERT INTO IGNORED_FILES (ADD_KEY,PATH,REMOVE,TIME) VALUES('";
 				insert+=addKey+"','";
-				insert+=pat+"','";
+				insert+=convert(pat)+"','";
 				insert+=remove+"',";
 				insert+=time+");";
 				UPDATESYNCDB(insert);
@@ -320,7 +320,7 @@ namespace creaImageIO
     {
         std::stringstream query;
 	std::string result;
-	std::string sVal=searchValue.c_str();
+	std::string sVal=convert(searchValue.c_str());
 	CleanName(sVal);
 	query<<"SELECT "<<attribute<<" FROM "<<table<<" WHERE "<<searchParam<<" = '"<<sVal;
 	if(table.compare("ADD_OPS")==0)
@@ -358,7 +358,7 @@ namespace creaImageIO
 				const std::string& refdb)
     {
 	std::string val=value.c_str();
-	std::string sVal=searchValue.c_str();
+	std::string sVal=convert(searchValue.c_str());
 	CleanName(val);
 	CleanName(sVal);
 	std::string sql = "UPDATE ";
@@ -446,6 +446,13 @@ namespace creaImageIO
 		}
 		return valid;
 	}
+	  const std::string Synchronizer::convert(const std::string &i_word)
+	  {
+		  std::string temp = i_word;
+		  boost::algorithm::replace_all(temp,"'","''");
+
+	  return temp.c_str();
+  }
 }