sqlrimport.h

// Copyright (c) 1999-2018 David Muse
// See the file COPYING for more information
 
#ifndef SQLRIMPORT_H
#define SQLRIMPORT_H
 
#include <sqlrelay/private/sqlrimportincludes.h>
 
class SQLRCLIENT_DLLSPEC sqlrimport {
        public:
                sqlrimport();
 
                virtual ~sqlrimport();
 
                void    setSqlrConnection(sqlrconnection *sqlrcon);
 
                void    setSqlrCursor(sqlrcursor *sqlrcur);
 
                sqlrconnection  *getSqlrConnection();
 
                sqlrcursor      *getSqlrCursor();
 
                void    insertPrimaryKey(const char *primarykeycolumnname,
                                                uint32_t primarykeycolumnindex,
                                                const char *primarykeysequence);
 
                void    removePrimaryKey();
 
                bool            getInsertPrimaryKey();
 
                const char      *getPrimaryKeyColumnName();
 
                uint32_t        getPrimaryKeyColumnIndex();
 
                const char      *getPrimaryKeySequence();
 
                void    insertStaticValue(const char *columnname,
                                                uint32_t columnindex,
                                                const char *value);
 
                void    removeStaticValue(uint32_t columnindex);
 
                const char      *getStaticValueColumnName(uint32_t index);
 
                const char      *getStaticValue(uint32_t index);
 
                uint32_t        getStaticValueCount();
 
                void    setDbType(const char *dbtype);
 
                const char      *getDbType();
 
                void    setObjectName(const char *objectname);
 
                const char      *getObjectName();
 
                void    setIgnoreColumns(bool ignorecolumns);
 
                bool    getIgnoreColumns();
 
                void    setIgnoreColumnsWithEmptyNames(
                                        bool ignorecolumnswithemptynames);
 
                bool    getIgnoreColumnsWithEmptyNames();
 
                void    setIgnoreEmptyRows(bool ignoreemptyrows);
 
                bool    getIgnoreEmptyRows();
 
                void    mapColumnName(const char *from, const char *to);
 
                const char      *getMappedColumnName(const char *from);
 
                void    setMixedCaseColumnNames();
 
                bool    getMixedCaseColumnNames();
 
                void    setLowerCaseColumnNames();
 
                bool    getLowerCaseColumnNames();
 
                void    setUpperCaseColumnNames();
 
                bool    getUpperCaseColumnNames();
 
                void    mapFieldValue(const char *from, const char *to);
 
                const char      *getMappedFieldValue(const char *from);
 
                void    setReformatDateTime(bool reformatdatetime);
 
                bool    getReformatDateTime();
 
                void    setDdMm(bool ddmm);
 
                bool    getDdMm();
 
                void    setYyyyDdMm(bool yyyyddmm);
 
                bool    getYyyyDdMm();
 
                void    setDateDelimiters(const char *datedelimiters);
 
                const char      *getDateDelimiters();
 
                void    setNoCenturyThreshold(uint16_t nocenturythreshold);
 
                uint16_t        getNoCenturyThreshold();
 
                void    setLastCenturyThreshold(uint16_t lastcenturythreshold);
 
                uint16_t        getLastCenturyThreshold();
 
                void    setDateTimeFormat(const char *datetimeformat);
 
                const char      *getDateTimeFormat();
 
                void    setCommitCount(uint64_t commitcount);
 
                uint64_t getCommitCount();
 
                void    setLogger(logger *lg);
 
                logger  *getLogger();
 
                void    setCoarseLogLevel(uint8_t coarseloglevel);
 
                uint8_t getCoarseLogLevel();
 
                void    setFineLogLevel(uint8_t fineloglevel);
 
                uint8_t getFineLogLevel();
 
                void    setLogIndent(uint32_t logindent);
 
                uint32_t        getLogIndent();
 
                void    setLogErrors(bool logerrors);
 
                bool    getLogErrors();
 
                virtual bool    importData();
 
                uint64_t        getImportedRowCount();
 
        protected:
                virtual bool    importStart();
 
                virtual bool    columnsStart();
 
                virtual bool    columnStart();
 
                virtual bool    columnEnd();
 
                virtual bool    columnsEnd();
 
                virtual bool    rowsStart();
 
                virtual bool    rowStart();
 
                virtual bool    fieldStart();
 
                virtual bool    fieldEnd();
 
                virtual bool    rowEnd();
 
                virtual bool    rowsEnd();
 
                virtual bool    beginStart();
 
                virtual bool    beginEnd();
 
                virtual bool    commitStart();
 
                virtual bool    commitEnd();
 
                virtual bool    error(int64_t errornumber,
                                        const char *errormessage);
 
                virtual bool    importEnd();
 
                void    setExcludeRow(bool excluderow);
 
                bool    getExcludeRow();
 
                void    setCurrentRow(uint64_t currentrow);
 
                uint64_t        getCurrentRow();
 
                void    setCurrentColumn(uint32_t currentcol);
 
                uint32_t        getCurrentColumn();
 
                void    setCurrentColumnName(char *currentcolname);
 
                char    *getCurrentColumnName();
 
                void    setCurrentField(char *currentfield);
 
                char    *getCurrentField();
 
                void    setIsNumericColumn(uint64_t index, bool numeric);
 
                bool    getIsNumericColumn(uint64_t index);
 
                void    clearAreNumericColumns();
 
                void    setIsDateTimeColumn(uint64_t index, bool datetime);
 
                bool    getIsDateTimeColumn(uint64_t index);
 
                void    clearAreDateTimeColumns();
 
                void setImportedRowCount(uint64_t importedrowcount);
 
        #include <sqlrelay/private/sqlrimport.h>
};
 
#endif