hk_importcsv.h

// ****************************************************************************
// copyright (c) 2000-2005 Horst Knorr <hk_classes@knoda.org>  
// This file is part of the hk_classes library.
// This file may be distributed and/or modified under the terms of the
// GNU Library Public License version 2 as published by the Free Software
// Foundation and appearing in the file COPYING included in the
// packaging of this file.
// This file is provided AS IS with NO WARRANTY OF ANY KIND, INCLUDING THE
// WARRANTY OF DESIGN, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
// ****************************************************************************
#ifndef HK_IMPORTCSV
#define HK_IMPORTCSV
#include <iostream>
#include <fstream>
#include "hk_class.h"
#include "hk_datasource.h"
#include "hk_dsvisible.h"
#include <vector>
using namespace std;

class hk_column;

typedef class colstruct
{
    public:
        colstruct(void){col=NULL;}
        hk_string colname;
        hk_column* col;
} colstruct;
class hk_importcsv:public hk_dsvisible
{
    public:
        hk_importcsv(void);
        virtual ~hk_importcsv(void);


        bool    execute(enum_interaction i=interactive);
        void    set_filedefinition(const hk_string& textdelimiter="\"",const hk_string& betweenfields=",", const hk_string& rowdelimiter="\n");
        void    set_filename(const hk_string& filename);
        void    set_firstrow_contains_fieldnames(bool f=true);
        void    set_append_rows(bool f=false);
        void    set_create_new_table(bool n=true);
        void    add_columnname(const hk_string& col);
        void    clear_columnlist(void);
        hk_string textdelimiter(void){return p_textdelimiter;}
        hk_string betweenfield(void) {return p_betweenfields;}
        hk_string rowdelimiter(void) {return p_rowdelimiter;}
        void set_overwrite_table(bool);
        bool overwrite_table(void);

    protected:

        void    set_columns(void);
        void    create_automatic_columns(void);
        bool    initialize_table(enum_interaction);
        virtual bool before_columns_deleted(void);
        virtual bool widget_specific_after_new_row(void);

    private:
        void    reset(void);
        void    create_valuelist( hk_string& row);
        void    get_line(ifstream&,hk_string&);
        bool        p_create_new_table;
/*
 * 0= hk_string
 * 1= float
 * 2= Integer
 * 3= boolean
 */
        int         interpret_columntype(hk_string&f);
        ifstream*   p_filestream;
        hk_string   p_filename;
        hk_string   p_textdelimiter;
        hk_string   p_rowdelimiter;
        hk_string   p_betweenfields;
        bool        p_firstrow_contains_fieldnames;
        vector<hk_string>  p_valuelist;
        vector<colstruct> p_columnlist;
        bool        p_datamode;
        bool        p_notcancelimport;
        bool        p_overwrite;
        hk_datasource::enum_accessmode p_accessmode;
};
#endif

---