UgliDbiTableDescr.cxx

Go to the documentation of this file.

// $Id: UgliDbiTableDescr.cxx,v 1.4 2005/04/29 04:49:06 minoscvs Exp $
//
// UgliDbiTableDescr
//
// Package: UgliGeometry
//
// R. Hatcher  2001-08-08
//
// Concept:
//   
// Purpose:
//

#include "UgliGeometry/UgliDbiTableDescr.h"
#include "Util/UtilString.h"

//rwh: ClassImp(UgliDbiTableDescr)

//   Definition of static data members
//   *********************************

#include "MessageService/MsgService.h"
CVSID("$Id: UgliDbiTableDescr.cxx,v 1.4 2005/04/29 04:49:06 minoscvs Exp $");

// Definition of member functions (alphabetical order)
// ***************************************************


//.....................................................................

vector<pair<string,string> > 
UgliDbiTableDescr::ParseTableDescr(string tabledescr)
{
//
//  Purpose:  Break down tabledescr into a vector of column names and types
//
//  Arguments: "( ColName0 ColType0, ColName1 ColType1, ... )"
//
//  Return:    vector of pair<"ColNameN","ColTypeN">
//
//  Contact:   R. Hatcher
//
//  Specification:-
//  =============
//
//  Program Notes:-
//  =============

//  None.

   // trim the input string
   string trimmed = TrimToParentheses(tabledescr);
   // remove lead and trailing parentheses
   trimmed = trimmed.substr(1,trimmed.size()-2);

   vector<pair<string,string> > components;

   string::size_type start = 0;
   string::size_type end   = trimmed.size();
   string::size_type comma;
   while (start < end) {
      comma = trimmed.find_first_of(",",start);
      // cout << " start " << start << " comma " << comma << endl;

      // handle case of no delimiters before end-of-string;
      if ( string::npos == comma ) comma = end;

      string onepair = trimmed.substr(start,comma-start);

      // trim lead/trail blanks
      onepair = TrimWhiteSpace(onepair,true,true);
      // cout << " onepair '" << onepair << "'" << endl;

      string::size_type first_blank = onepair.find_first_of(" ");
      string::size_type last_blank  = onepair.find_last_of(" ");
      // cout << " first " << first_blank << " last " << last_blank << endl;

      string colName = onepair.substr(0,first_blank);
      string colType = onepair.substr(last_blank+1,onepair.size()-last_blank);
      // cout << "  colName '" << colName 
      //      << "' colType '" << colType << "'" << endl;

      pair<string,string> colPair(colName,colType);
      components.push_back(colPair);

      // move past comma
      start = comma + 1;
   }

#ifdef DUMPRESUL
   MSG("Ugli",Msg::kInfo)
        << "UgliDbiTableDescr::ParseTableDescr starts with '" 
        << tabledescr << "'" << endl;
   int n = components.size();
   MSG("Ugli",Msg::kInfo)
        << " result was " << n << " components" << endl;
   for (int i=0; i<n; i++) {
      pair<string,string> colPair = components[i];
      MSG("Ugli",Msg::kInfo)
           << " i=" << i << " '" 
           << colPair.first << "' : '"
           << colPair.second << "'" << endl;
   }
#endif

   return components;
}
//.....................................................................

string UgliDbiTableDescr::TrimWhiteSpace(string input, 
                                         bool fromFront, bool fromBack)
{
//
//  Purpose:  Trim away leading/trailing blanks, tabs, newlines
//
//  Arguments: "  xyzyz "
//
//  Return:    "xyzzy"
//
//  Contact:   R. Hatcher
//
//  Specification:-
//  =============
//

//  Program Notes:-
//  =============

//  None.

   if (!fromFront && !fromBack) return input;

   string::size_type start = 0;
   string::size_type end   = input.size()-1;

   string delim = " \t\n\r\b\f\v";

   if (fromFront) start = input.find_first_not_of(delim);
   if (fromBack)  end   = input.find_last_not_of(delim);

   return input.substr(start,end+1-start);

}

//.....................................................................

string UgliDbiTableDescr::TrimToParentheses(string full_create,
                                            bool remove_paren)
{
//
//  Purpose:  Trim string down to just parenthesized comma separated list
//
//  Arguments: "create table if not exists UgliDbiGeometry ( ... ) ;"
//
//  Return:    "( ... )"
//
//  Contact:   R. Hatcher
//
//  Specification:-
//  =============
//

//  Program Notes:-
//  =============

//  None.

   string::size_type start = full_create.find("(");
   string::size_type end   = full_create.rfind(")");

   if (start == string::npos || end == string::npos) {
      MSG("Ugli",Msg::kInfo)
           << "UgliDbiTableDescr found unmatched parentheses in:" << endl
           << full_create << endl;
      return "";
   }

   if ( ! remove_paren ) return full_create.substr(start,end+1-start);
   else                  return full_create.substr(start+1,end+1-start-2);
}

//.....................................................................

string UgliDbiTableDescr::TextTableDescrLine(string tabledescr)
{
//
//  Purpose:  Reformat string for use in ASCII table usage including
//            no SQL command (ie. just fields and types), 
//            comma separation, minimal spaces, trimming,
//
//  Arguments: "create table if not exists UgliDbiGeometry ( ... ) ;"
//
//  Return:    "..."
//
//  Contact:   R. Hatcher
//
//  Specification:-
//  =============
//

//  Program Notes:-
//  =============

//  None.

    tabledescr = UgliDbiTableDescr::TrimToParentheses(tabledescr,true);

    size_t pos;
    //pos = tabledescr.find("(");
    //tabledescr.erase(pos,1);
    //pos = tabledescr.find(")");
    //tabledescr.erase(pos,1);

    // remove double spaces
    if ( true ) {
      pos = tabledescr.rfind("  ");
      while ( pos != string::npos && pos > 0 ) {
        tabledescr.erase(pos,1);  // erase one-of-two spaces
        pos = tabledescr.rfind("  ");
      }
    }
    tabledescr = TrimWhiteSpace(tabledescr);
    tabledescr = UtilString::ToUpper(tabledescr);

    return tabledescr;
}

//.....................................................................

/*    Template for New Member Function

//.....................................................................

UgliDbiTableDescr:: {
//
//
//  Purpose:  
//
//  Arguments: 
//    xxxxxxxxx    in    yyyyyy
//
//  Return:    
//
//  Contact:   R. Hatcher
//
//  Specification:-
//  =============
//
//  o 

//  Program Notes:-
//  =============

//  None.


}

*/

---