X-Git-Url: https://git.creatis.insa-lyon.fr/pubgit/?a=blobdiff_plain;f=src2%2FcreaImageIOSQLiteTreeHandler.cpp;h=17025b4604cbc4161236d0ae94dfa61701212380;hb=1f46782fbd6a0b396516b58546e66b407fd7aa2a;hp=aec51554f68406d87bd679cebf989b9770b542cf;hpb=57608b6038aaf31b21948e6244aeb814f0bb7cbd;p=creaImageIO.git diff --git a/src2/creaImageIOSQLiteTreeHandler.cpp b/src2/creaImageIOSQLiteTreeHandler.cpp index aec5155..17025b4 100644 --- a/src2/creaImageIOSQLiteTreeHandler.cpp +++ b/src2/creaImageIOSQLiteTreeHandler.cpp @@ -132,14 +132,6 @@ namespace creaImageIO { tree::Node* parent = DBGetParent(attr); DBGraftToParent(parent,attr); - if(parent->GetLevel()GetLevel()>0) - { - int nC=GetNumberOfChildren(parent); - nC=nC+1; - std::stringstream out; - out <GetLevel()+1); } @@ -163,7 +155,7 @@ namespace creaImageIO { std::stringstream out; out <SetChildrenLoaded(true); - // std::cout<<"Number of children "<GetNumberOfChildren()<1) + { + int nc = GetNumberOfChildren(parent)+1; + + // std::cout<<"Number of children "<GetNumberOfChildren()<GetLevel()>0 ) @@ -891,33 +890,38 @@ namespace creaImageIO //===================================================================== unsigned int SQLiteTreeHandler::GetNumberOfChildren(tree::Node* n) { - // Query DB - int nb=0; + // Query DB + int nb=0; int level = n->GetLevel(); - - if(level0) - { - std::string query = "SELECT D1111_0011 FROM "; - query += GetTree().GetLevelDescriptor(level).GetName(); - if (level>0) + + if(level0) { - query += " WHERE ID='" + n->UnsafeGetAttribute("ID") - + "'"; - } - CppSQLite3Query q; - QUERYDB(query,q); + std::string query = "SELECT NumberOfChildren FROM "; + query += GetTree().GetLevelDescriptor(level).GetName(); + if (level>0) + { + query += " WHERE ID='" + n->UnsafeGetAttribute("ID") + + "'"; + } + CppSQLite3Query q; + QUERYDB(query,q); - - while (!q.eof()) - { - for (int fld = 0; fld < q.numFields(); fld++) - { - nb=q.getIntField(fld); - } - q.nextRow(); - } - } - if(nb==0){nb=1;} + + while (!q.eof()) + { + for (int fld = 0; fld < q.numFields(); fld++) + { + nb=q.getIntField(fld); + } + q.nextRow(); + } + } + /* + if(nb==0) + { + nb=1; + } + */ return nb; }