xbio.h

/*
    gSAFE - LIB
    general Sql dAtabase FrontEnd

   (C) 2011 Peter Deak  (hyper80@gmail.com)

    License: GPLv2  http://www.gnu.org/licenses/gpl-2.0.html

        XBase Import/Export lib
    xbio.h
*/

/* This module is not depends from gSAFE
 * Can be used separatedly (Just add xbio.h/xbio.cpp to your project)
 *
 * WARNING: This file's .cpp is depends on XBase library (http://linux.techass.com/projects/xdb/)
 * If you don't want to use the XBase support just remove
 * the xbio* files from your project, or undefine (remove) the ENABLE_XBASE_SUPPORT macro!
 */

#ifdef ENABLE_XBASE_SUPPORT

#ifndef GSAFE_XBASE_IO_H
#define GSAFE_XBASE_IO_H

#include <QtCore>

/* @{ */

#define CPCONV_BUFFERLENGTH     256
#define XBASESCHEMA_MAXFIELD    64

class xbXBase;
class xbDbf;
class xbSchema;

enum HXBaseFieldType    {
                           Error,
                           Numeric,
                           Char,
                           Date,
                           Float,
                           Logical,
                           Memo
                        };

class HCodepageConvert
{

public:
    HCodepageConvert(void) {}

    virtual QString conv_from(char * from) = 0;
    virtual void    conv_to(QString from,char * buffer,int bufflen) = 0;
};

class HCodepage852 : public HCodepageConvert
{

public:
    HCodepage852(void) {}

    virtual QString conv_from(char * from);
    virtual void    conv_to(QString from,char * buffer,int bufflen);
};

class HCodepage850 : public HCodepageConvert
{

public:
    HCodepage850(void) {}

    virtual QString conv_from(char * from);
    virtual void    conv_to(QString from,char * buffer,int bufflen);
};

class HXBaseFileHandler : public QObject
{
    Q_OBJECT

protected:
    HCodepageConvert *c;
    char *buffer;
    xbXBase *xbase;
    xbDbf   *dbf;
    bool opened;
    bool deleteconvertobject;

public:
    HXBaseFileHandler(HCodepageConvert *conv,bool deletecobj=false);
    ~HXBaseFileHandler(void);

    int  fieldCount(void);
    QString fieldName(int n);
    HXBaseFieldType fieldType(int n);
    long recordCount(void);

signals:
    void errorSignal(QString error);
};

class HXBaseFileReader : public HXBaseFileHandler
{
    Q_OBJECT

public:
    HXBaseFileReader(HCodepageConvert *conv,bool deletecobj=false);
    ~HXBaseFileReader(void);

    int open(QString name);
    int close(void);

    int toRecord(long idx);
    int firstRecord(void);
    int lastRecord(void);
    int nextRecord(void);
    int prevRecord(void);
    long getCurrentRecordIdx(void);

    QString getFieldStr    (QString fname);
    long    getFieldDecimal(QString fname);
    double  getFieldFloat  (QString fname);
    bool    getFieldBool   (QString fname);
    QDate   getFieldDate   (QString fname);


    QString getCellStr    (long rec,QString fname);
    long    getCellDecimal(long rec,QString fname);
    double  getCellFloat  (long rec,QString fname);
    bool    getCellBool   (long rec,QString fname);
    QDate   getCellDate   (long rec,QString fname);

};

class HXBaseFileWriter : public HXBaseFileHandler
{
    Q_OBJECT

protected:
    xbSchema *schema;
    int       defined_fnum;

    void setLastDefinedField(int idx);

public:
    HXBaseFileWriter(HCodepageConvert *conv,bool deletecobj=false);
    ~HXBaseFileWriter(void);

public:
    void defineField(QString name,HXBaseFieldType type,int length=0,int nofdecimals=0);

    int create(QString name,int version);
    int open(QString name);
    int close(void);

    int resetRecord(void);
    int appendRecord(void);

    int setFieldStr    (QString fname,QString str);
    int setFieldDecimal(QString fname,long decimal);
    int setFieldFloat  (QString fname,double val);
    int setFieldBool   (QString fname,bool logical);
    int setFieldDate   (QString fname,QDate date);

};

/* @} */

#endif // GSAFE_XBASE_IO_H

#endif // ENABLE_XBASE_SUPPORT