00001 /* 00002 * IMPORTANT: READ BEFORE DOWNLOADING, COPYING, INSTALLING OR USING. By 00003 * downloading, copying, installing or using the software you agree to 00004 * this license. If you do not agree to this license, do not download, 00005 * install, copy or use the software. 00006 * 00007 * Intel Open Source License 00008 * 00009 * Copyright (c) 2004 Intel Corporation. All rights reserved. 00010 * 00011 * Redistribution and use in source and binary forms, with or without 00012 * modification, are permitted provided that the following conditions are 00013 * met: 00014 * 00015 * Redistributions of source code must retain the above copyright 00016 * notice, this list of conditions and the following disclaimer. 00017 * 00018 * Redistributions in binary form must reproduce the above copyright 00019 * notice, this list of conditions and the following disclaimer in the 00020 * documentation and/or other materials provided with the distribution. 00021 * 00022 * Neither the name of the Intel Corporation nor the names of its 00023 * contributors may be used to endorse or promote products derived from 00024 * this software without specific prior written permission. 00025 * 00026 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS 00027 * ``AS IS'' AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT 00028 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR 00029 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE INTEL OR 00030 * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, 00031 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT 00032 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, 00033 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY 00034 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT 00035 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE 00036 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. 00037 */ 00038 00039 #include "config.h" 00040 00041 #if SQL_ENABLED 00042 00043 #include "SQLBundleStore.h" 00044 #include "SQLStore.h" 00045 #include "StorageConfig.h" 00046 #include "bundling/Bundle.h" 00047 00048 namespace dtn { 00049 00050 /****************************************************************************** 00051 * 00052 * SQLBundleStore 00053 * 00054 *****************************************************************************/ 00055 00060 SQLBundleStore::SQLBundleStore(oasys::SQLImplementation* db, const char* table_name) 00061 : BundleStore() 00062 { 00063 Bundle tmpobj(this); 00064 00065 store_ = new SQLStore(table_name, db); 00066 store_->create_table(&tmpobj); 00067 store_->set_key_name("bundleid"); 00068 } 00069 00076 Bundle* 00077 SQLBundleStore::get(int bundle_id) 00078 { 00079 Bundle* bundle = new Bundle(); 00080 if (store_->get(bundle, bundle_id) != 0) { 00081 delete bundle; 00082 return NULL; 00083 } 00084 00085 return bundle; 00086 } 00087 00091 bool 00092 SQLBundleStore::insert(Bundle* bundle) 00093 { 00094 return store_->insert(bundle) == 0; 00095 } 00096 00100 bool 00101 SQLBundleStore::update(Bundle* bundle) 00102 { 00103 return store_->update(bundle, bundle->bundleid_) == 0; 00104 } 00105 00109 bool 00110 SQLBundleStore::del(int bundle_id) 00111 { 00112 return store_->del(bundle_id) == 0; 00113 } 00114 00115 00116 00117 int 00118 SQLBundleStore::delete_expired(const time_t now) 00119 { 00120 const char* field = "expiration"; 00121 oasys::StringBuffer query ; 00122 query.appendf("DELETE FROM %s WHERE %s > %lu", store_->table_name(), field, now); 00123 00124 int retval = store_->exec_query(query.c_str()); 00125 return retval; 00126 } 00127 00128 00129 00130 bool 00131 SQLBundleStore::is_custodian(int bundle_id) 00132 { 00133 NOTIMPLEMENTED ; 00134 00142 } 00143 00144 } // namespace dtn 00145 00146 #endif /* SQL_ENABLED */