$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 00036 00037 #ifndef _DATABASE_GRASP_ANALYSIS_H_ 00038 #define _DATABASE_GRASP_ANALYSIS_H_ 00039 00040 #include <vector> 00041 00042 #include <database_interface/db_class.h> 00043 00044 namespace household_objects_database { 00045 00047 class DatabasePerturbation : public database_interface::DBClass 00048 { 00049 private: 00050 const std::string table_name_; 00051 public: 00053 database_interface::DBField<int> perturbation_id_; 00054 00056 database_interface::DBField<int> grasp_id_; 00057 00059 database_interface::DBField<int> energy_function_id_; 00060 00062 database_interface::DBField<std::vector<double> > deltas_; 00063 00065 database_interface::DBField<double> score_; 00066 00068 database_interface::DBField<DatabasePose> final_pose_; 00070 DatabasePerturbation() : 00071 table_name_("grasp_analysis"), 00072 perturbation_id_(database_interface::DBFieldBase::TEXT, this, "perturbation_id", table_name_, true), 00073 grasp_id_(database_interface::DBFieldBase::TEXT, this, "grasp_id", table_name_, true), 00074 energy_function_id_(database_interface::DBFieldBase::TEXT, this, "energy_function_id", table_name_, true), 00075 deltas_(database_interface::DBFieldBase::TEXT, this, "deltas", table_name_, true), 00076 score_(database_interface::DBFieldBase::TEXT, this, "score", table_name_, true), 00077 final_pose_(database_interface::DBFieldBase::TEXT, this, "final_position", table_name_, true) 00078 { 00079 //primary key field 00080 primary_key_field_ = &perturbation_id_; 00081 00082 //all the other fields 00083 fields_.push_back(&grasp_id_); 00084 fields_.push_back(&energy_function_id_); 00085 fields_.push_back(&deltas_); 00086 fields_.push_back(&score_); 00087 fields_.push_back(&final_pose_); 00088 //by default, all fields here are used, and many of then not-null, so sync both ways 00089 setAllFieldsReadFromDatabase(true); 00090 setAllFieldsWriteToDatabase(true); 00091 00092 //sequences 00093 perturbation_id_.setSequenceName("grasp_analysis_perturbation_id_seq"); 00094 00095 //primary key only syncs from database; it has a sequence which is used by default on insertions 00096 perturbation_id_.setWriteToDatabase(false); 00097 } 00098 00100 ~DatabasePerturbation(){} 00101 }; 00102 00103 typedef boost::shared_ptr<DatabasePerturbation> DatabasePerturbationPtr; 00104 00105 } //namespace 00106 00107 #endif