+/*
+# ---------------------------------------------------------------------
+#
+# Copyright (c) CREATIS (Centre de Recherche en Acquisition et Traitement de l'Image
+# pour la Santé)
+# Authors : Eduardo Davila, Frederic Cervenansky, Claire Mouton
+# Previous Authors : Laurent Guigues, Jean-Pierre Roux
+# CreaTools website : www.creatis.insa-lyon.fr/site/fr/creatools_accueil
+#
+# This software is governed by the CeCILL-B license under French law and
+# abiding by the rules of distribution of free software. You can use,
+# modify and/ or redistribute the software under the terms of the CeCILL-B
+# license as circulated by CEA, CNRS and INRIA at the following URL
+# http://www.cecill.info/licences/Licence_CeCILL-B_V1-en.html
+# or in the file LICENSE.txt.
+#
+# As a counterpart to the access to the source code and rights to copy,
+# modify and redistribute granted by the license, users are provided only
+# with a limited warranty and the software's author, the holder of the
+# economic rights, and the successive licensors have only limited
+# liability.
+#
+# The fact that you are presently reading this means that you have had
+# knowledge of the CeCILL-B license and that you accept its terms.
+# ------------------------------------------------------------------------
+*/
+
#include <creaImageIOSynchron.h>
#include <creaImageIOSystem.h>
#include <boost/filesystem.hpp>
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+"');";
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);
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);
{
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)
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 ";
}
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();
+ }
}