$search
00001 /********************************************************************* 00002 * Software License Agreement (BSD License) 00003 * 00004 * Copyright (c) 2009, Willow Garage, Inc. 00005 * All rights reserved. 00006 * 00007 * Redistribution and use in source and binary forms, with or without 00008 * modification, are permitted provided that the following conditions 00009 * are met: 00010 * 00011 * * Redistributions of source code must retain the above copyright 00012 * notice, this list of conditions and the following disclaimer. 00013 * * Redistributions in binary form must reproduce the above 00014 * copyright notice, this list of conditions and the following 00015 * disclaimer in the documentation and/or other materials provided 00016 * with the distribution. 00017 * * Neither the name of the Willow Garage nor the names of its 00018 * contributors may be used to endorse or promote products derived 00019 * from this software without specific prior written permission. 00020 * 00021 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS 00022 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT 00023 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS 00024 * FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE 00025 * COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, 00026 * INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, 00027 * BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; 00028 * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER 00029 * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT 00030 * LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN 00031 * ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE 00032 * POSSIBILITY OF SUCH DAMAGE. 00033 *********************************************************************/ 00034 00035 // Author(s): Matei Ciocarlie 00036 00037 #include "household_objects_database/objects_database.h" 00038 00039 #include <database_interface/db_filters.h> 00040 00041 #include "household_objects_database/database_task.h" 00042 00043 using namespace database_interface; 00044 00045 namespace household_objects_database { 00046 00047 bool ObjectsDatabase::acquireNextTask(std::vector< boost::shared_ptr<DatabaseTask> > &task, 00048 std::vector<std::string> accepted_types) 00049 { 00050 //first get and mark (atomically) the task id 00051 int id; 00052 if (accepted_types.empty()) 00053 { 00054 std::vector< boost::shared_ptr<DatabaseTaskID> > id_vec; 00055 DatabaseTaskID id_example; 00056 if ( !getList<DatabaseTaskID>(id_vec, id_example, "") ) 00057 { 00058 ROS_ERROR("Failed to get the id of the next task to be run"); 00059 return false; 00060 } 00061 if (id_vec.empty()) 00062 { 00063 //no task to be run 00064 return true; 00065 } 00066 if (id_vec.size() != 1) 00067 { 00068 ROS_ERROR("Next task acquisition returned more than one result"); 00069 return false; 00070 } 00071 //get the actual task id 00072 id = id_vec[0]->id_.get(); 00073 } 00074 else 00075 { 00076 std::string function = "get_mark_next_dbase_task_of_type(ARRAY["; 00077 for(size_t i=0; i<accepted_types.size(); i++) 00078 { 00079 if (i != 0 ) function += ","; 00080 function += "'" + accepted_types[i] + "'"; 00081 } 00082 function += "])"; 00083 std::vector< boost::shared_ptr<DatabaseTaskIDTyped> > id_vec; 00084 DatabaseTaskIDTyped id_example(function); 00085 ROS_INFO_STREAM("Function call: " << function); 00086 if ( !getList<DatabaseTaskIDTyped>(id_vec, id_example, "") ) 00087 { 00088 ROS_ERROR("Failed to get the id of the next task of given type to be run"); 00089 ROS_ERROR_STREAM("Function call: " << function); 00090 return false; 00091 } 00092 if (id_vec.empty()) 00093 { 00094 //no task to be run 00095 return true; 00096 } 00097 if (id_vec.size() != 1) 00098 { 00099 ROS_ERROR("Next task acquisition returned more than one result"); 00100 return false; 00101 } 00102 //get the actual task id 00103 id = id_vec[0]->id_.get(); 00104 } 00105 00106 std::stringstream idstr; 00107 idstr << id; 00108 std::string where_clause("dbase_task_id=" + idstr.str()); 00109 //fill in the rest 00110 if (!getList<DatabaseTask>(task, where_clause) || task.size() != 1 ) 00111 { 00112 ROS_ERROR("Acquire next task: failed to populate entry"); 00113 return false; 00114 } 00115 return true; 00116 } 00117 00118 }//namespace