$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 #ifndef _DATABASE_SCALED_MODEL_H_ 00038 #define _DATABASE_SCALED_MODEL_H_ 00039 00040 #include <database_interface/db_class.h> 00041 00042 namespace household_objects_database { 00043 00044 class DatabaseScaledModel : public database_interface::DBClass 00045 { 00046 private: 00047 00048 public: 00049 //primary key 00050 database_interface::DBField<int> id_; 00051 //fields from the scaled_model table 00052 database_interface::DBField<double> scale_; 00053 database_interface::DBField<int> original_model_id_; 00054 00055 //fields from the original_model table 00056 //maybe at some point we'll inherit these directly 00057 database_interface::DBField<std::string> model_; 00058 database_interface::DBField<std::string> maker_; 00059 database_interface::DBField< std::vector<std::string> > tags_; 00060 database_interface::DBField<std::string> source_; 00061 database_interface::DBField<std::string> acquisition_method_; 00062 00063 DatabaseScaledModel() : 00064 id_(database_interface::DBFieldBase::TEXT, this, "scaled_model_id", "scaled_model", true), 00065 scale_(database_interface::DBFieldBase::TEXT, this, "scaled_model_scale", "scaled_model", true), 00066 original_model_id_(database_interface::DBFieldBase::TEXT, this, "original_model_id", "scaled_model", true), 00067 //fields "inherited" from the original model have no write access 00068 model_(database_interface::DBFieldBase::TEXT, this, "original_model_model" ,"original_model", false), 00069 maker_(database_interface::DBFieldBase::TEXT, this, "original_model_maker", "original_model", false), 00070 tags_(database_interface::DBFieldBase::TEXT, this, "original_model_tags", "original_model", false), 00071 source_(database_interface::DBFieldBase::TEXT, this, "original_model_source", "original_model", false), 00072 acquisition_method_(database_interface::DBFieldBase::TEXT, this, "acquisition_method_name", "original_model", false) 00073 { 00074 primary_key_field_ = &id_; 00075 fields_.push_back(&scale_); 00076 fields_.push_back(&original_model_id_); 00077 00078 fields_.push_back(&model_); 00079 fields_.push_back(&maker_); 00080 fields_.push_back(&tags_); 00081 fields_.push_back(&source_); 00082 fields_.push_back(&acquisition_method_); 00083 00084 setAllFieldsReadFromDatabase(true); 00085 setAllFieldsWriteToDatabase(false); 00086 scale_.setWriteToDatabase(true); 00087 original_model_id_.setWriteToDatabase(true); 00088 00089 id_.setSequenceName("model_model_id_seq"); 00090 id_.setWriteToDatabase(false); 00091 00092 foreign_keys_.insert( std::pair<std::string, database_interface::DBFieldBase*>("original_model", &original_model_id_) ); 00093 } 00094 }; 00095 00096 } //namespace model_database 00097 00098 #endif