household_objects_database: database_scaled

Go to the documentation of this file.
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