dbtutil.h

/* dbtutil.h */
/* $Id: dbtutil.h,v 1.8 2003/02/14 16:20:08 vlad Exp $ */

#ifndef __dbtutil_h

#define __dbtutil_h

#include <mix/Types.h>
#include <mix/ReportTools.h>
#include <ldb/dbtc.h>


#ifdef __cplusplus
extern "C" {
#endif


/*************************************************************
 *
 * Report tools.
 *
 *************************************************************/

/* For all columns. */

int dbComposedLen (dbHandle db);

void    dbComposeTitle (dbHandle db, char* szTitle);

void    dbComposeLine (dbHandle db, int iLineNo, char* szLine);

/* For selected columns. */

typedef struct
  {
    char    *column;    
    RtAtomField afpar;      
  } dbRtItem;


typedef struct
  {
    dbHandle    dbh;        
    dbRtItem    *items;     
    int     items_n;    
    int     length;     
  } dbRtParams;


void    dbRtComposedParams (dbRtParams* params, dbHandle db,
                dbRtItem* items, int items_n);

void    dbRtComposeTitle (dbRtParams* params, char* szTitle);

void    dbRtComposeLine (dbRtParams* params, DbIndex line,
             char* szLine);


/*************************************************************
 *
 * Search tools.
 *
 *************************************************************/

Logic   dbFFindFloat (dbHandle db, DbIndex* pStartIndex,
              const char* szColumnName, double value);
Logic   dbFFindInt (dbHandle db, DbIndex* pStartIndex,
            const char* szColumnName, int value);
Logic   dbFFindChar (dbHandle db, DbIndex* pStartIndex,
             const char* szColumnName, char value);
/* Compare is performed by strcmp() */
Logic   dbFFindString (dbHandle db, DbIndex* pStartIndex,
               const char* szColumnName, const char* pValue);

Logic   dbBFindFloat (dbHandle db, DbIndex* pStartIndex,
              const char* szColumnName, double value);
Logic   dbBFindInt (dbHandle db, DbIndex* pStartIndex,
            const char* szColumnName, int value);
Logic   dbBFindChar (dbHandle db, DbIndex* pStartIndex,
             const char* szColumnName, char value);
/* Compare is performed by strcmp() */
Logic   dbBFindString (dbHandle db, DbIndex* pStartIndex,
               const char* szColumnName, const char* pValue);

Logic   dbQFindFloat (dbHandle db, int* pResultIndex,
              const char* szColumnName, float value);


int dbQFindClosestFloat (dbHandle dbh,
                 const char* szColumnName,
                 float value);

float   dbInterpolation (dbHandle dbh, const char* szArgument,
             float fArgument, const char* szTarget);

/*************************************************************
 *
 * Determines MAX and MIN element in pointed column.
 * Works only with TV_INT or TV_FLOAT values.
 *
 *************************************************************/

float   dbFindMin (dbHandle dbh,
           const char* szColumnName);

float   dbFindMax (dbHandle dbh,
           const char* szColumnName);

float   dbFindLocalMin (dbHandle dbh,
            const char* szColumnName,
            int iLowIndex,
            int iHighIndex);

float   dbFindLocalMax (dbHandle dbh,
            const char* szColumnName,
            int iLowIndex,
            int iHighIndex);

int dbFirstFreeNumber (dbHandle dbh,
               const char* szColumnName);


#ifdef __cplusplus
};
#endif


#endif  /* dbtutil.h */