System documentation of the GNU Image-Finding Tool

CAcIFMySQL.h

/* -*- mode: c++ -*- 
*/
#ifdef __GIFT_WITH_MYSQL__
/* 

    GIFT, a flexible content based image retrieval system.
    Copyright (C) 1998, 1999, 2000, 2001, 2002, CUI University of Geneva

    This program is free software; you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation; either version 2 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with this program; if not, write to the Free Software
    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

*/
// -*- mode: c++ -*-


class CXMLElement;

#ifndef _CACIFMYSQL
#define _CACIFMYSQL
#include "libGIFTAcInvertedFile/include/uses-declarations.h"
class CXMLElement;

#include "libGIFTAcInvertedFile/include/CAcInvertedFile.h"
#include "libGIFTAcURL2FTS/include/CAcURL2FTS.h"
#include <string>
#include "libMRML/include/TID.h"
#include "libMRML/include/CSelfDestroyPointer.h"
#include "libMRML/include/CArraySelfDestroyPointer.h"
#include "libGIFTAcInvertedFile/include/CDocumentFrequencyList.h"

#include "libGIFTAcInvertedFile/include/CADIHash.h"
#include <iostream>
#include <fstream>
#include <map>
#include <vector>
#ifdef HAS_HASH_MAP
#include <hash_map>
#else
#define hash_map map
#endif
#include <functional>
#include <algorithm>

#include <sqlplus.hh>
#include <custom.hh>
#include "libMRML/include/CMagic.h"


typedef TID TFeatureID ;

class documentFeatureConnection;

class CAcIFMySQL:public CAccessor{  
  CSelfDestroyPointer<CAcURL2FTS> mURL2FTS;
  documentFeatureConnection* mConnection;

  string GdbName;
  string GdbUser;
  string GdbHost;
  string GdbPassword;

  bool connection2dbOK;

  Connection *cnx;

  //vector <documentFeatureConnection> queryReturn;
  vector <documentFeatureConnection>::iterator It;
  CDocumentFrequencyList* featureList2docList(CDocumentFrequencyList inFeatureList);
  void showDocFreqList(CDocumentFrequencyList docFreqList);
  /* neither this */
  CDocumentFrequencyList* blob2docFreqList(string inBlobFile)const;

protected:
  int CAcIFMySQL::recordCount(string ltableName)const;
  bool CAcIFMySQL::selectDB( string);
  bool CAcIFMySQL::createDB( string);
  bool CAcIFMySQL::dropDB( string);
  void CAcIFMySQL::initialiseGIFTTables(bool, bool,string);


public:
  virtual bool operator()()const;

  CAcIFMySQL(const CXMLElement& inCollectionElement);
  ~CAcIFMySQL();

  virtual string IDToURL(TID inID)const;

  virtual pair<bool,TID> URLToID(const string& inURL)const;
  
  virtual CDocumentFrequencyList* FeatureToList(TFeatureID inFID)const;

  virtual CDocumentFrequencyList* URLToFeatureList(string inURL)const;

  virtual CDocumentFrequencyList* DIDToFeatureList(TID inDID)const;



  virtual double FeatureToCollectionFrequency(TFeatureID)const;

  virtual unsigned int getFeatureDescription(TID inFeatureID)const;

  virtual double DIDToMaxDocumentFrequency(TID)const;

  virtual double DIDToDFSquareSum(TID)const;

  virtual double DIDToSquareDFLogICFSum(TID)const;

  /*@name Inverted File Generation and Consistency Checking*/


  void CAcIFMySQL::getAllIDs( list<TID > &) const;
  void CAcIFMySQL::getAllAccessorElements( list<CAccessorElement> &) const;
  void CAcIFMySQL::getRandomIDs(list<TID > &, size_t) const;
  void CAcIFMySQL::getRandomAccessorElements(list<CAccessorElement > &, size_t) const;
  virtual list<TID>* getAllFeatureIDs()const;
  virtual pair<bool,CAccessorElement> IDToAccessorElement(TID inID)const;

  int CAcIFMySQL::size() const;
  CAcIFMySQL::operator bool()const;

};


#endif
#endif

---

Need for discussion? Want to contribute? Contact