msd_chem.cc

//--------------------------------
// msd_chem.cc
//
// Project: PDBe API Framework, EBI 
// Module: Scientific Layer Classes for PDBe API Framework 
//
// Chemistry Layer
// Last updated: 25 February 2004 10:17
// (C) Siamak Sobhany
//--------------------------------

#ifndef __MSD_CHEM_H__
#include "msd_chem.h"
#endif

#ifdef __WITH_XMMDB__

//Add method calls to the XMMDB library here

#endif

int getMSDEntryID(msdbConnect& db, char* acc_code) {
 int ne_ID;
 char select_stm[512];
 sprintf (select_stm, "select /*+ INDEX(ENTRY)*/ ENTRY_ID "  
  "from ENTRY where ACCESSION_CODE = '%s' and :ni<int> = 1", acc_code);
  try{
  msdbStream imsd (50, select_stm, db);
  imsd << 1;
  while (!imsd.eof()){
          imsd >> ne_ID;
  }
 } catch(msdbException& p){ // intercept OTL exceptions
  cerr<<p.msg<<endl; // print out error message
  cerr<<p.stm_text<<endl; // print out SQL that caused the error
  cerr<<p.var_info<<endl; // print out the variable that caused the error
 }
return ne_ID;
}

int getMSDAccessionCode(msdbConnect& db, int e_ID, char* acc_code) {
char buf[16];
 const char* select_stm= "select /*+ INDEX(ENTRY)*/ ACCESSION_CODE  "  
  "from ENTRY where ENTRY_ID = :neID <int>";
  try{
  msdbStream imsd (50, select_stm, db);
  imsd << e_ID;
  
  while (!imsd.eof()){
          imsd >> buf;
  }
 } catch(msdbException& p){ // intercept OTL exceptions
  cerr<<p.msg<<endl; // print out error message
  cerr<<p.stm_text<<endl; // print out SQL that caused the error
  cerr<<p.var_info<<endl; // print out the variable that caused the error
 }

 int index = 0;
 int len = strlen(buf);
        for(int i = 0; i < len; i++)
        {
                acc_code[index] = buf[i];
                index++;
        }
 acc_code[index] = '\0';
 
return 0;
}
  
  
  

---