kexicsvimportdialog.h

/* This file is part of the KDE project
   Copyright (C) 2005-2006 Jaroslaw Staniek <js@iidea.pl>
 
   This work is based on kspread/dialogs/kspread_dlg_csv.cpp
   and will be merged back with KOffice libraries.
 
   Copyright (C) 2002-2003 Norbert Andres <nandres@web.de>
   Copyright (C) 2002-2003 Ariya Hidayat <ariya@kde.org>
   Copyright (C) 2002 Laurent Montel <montel@kde.org>
   Copyright (C) 1999 David Faure <faure@kde.org>
 
   This library is free software; you can redistribute it and/or
   modify it under the terms of the GNU Library General Public
   License as published by the Free Software Foundation; either
   version 2 of the License, or (at your option) any later version.
 
   This library is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
   Library General Public License for more details.
 
   You should have received a copy of the GNU Library General Public License
   along with this library; see the file COPYING.LIB.  If not, write to
   the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
 * Boston, MA 02110-1301, USA.
*/
 
#ifndef KEXI_CSVDIALOG_H
#define KEXI_CSVDIALOG_H
 
#include <tqvaluevector.h>
#include <tqvaluelist.h>
#include <tqptrvector.h>
#include <tqregexp.h>
#include <tqbitarray.h>
 
#include <kdialogbase.h>
 
#include <kexiutils/tristate.h>
#include <kexidb/connection.h>
 
#include "kexicsvimportoptionsdlg.h"
 
class TQVBoxLayout;
class TQHBoxLayout;
class TQGridLayout;
class TQButtonGroup;
class TQCheckBox;
class TQLabel;
class TQLineEdit;
class TQPushButton;
class TQRadioButton;
class TQTable;
class TQFile;
class KComboBox;
class KIntSpinBox;
class KProgressDialog;
 
class KexiMainWindow;
class KexiCSVDelimiterWidget;
class KexiCSVTextQuoteComboBox;
class KexiCSVInfoLabel;

class KexiCSVImportDialog : public KDialogBase
{
    TQ_OBJECT
  
 
    public:
        enum Mode { Clipboard, File /*, Column*/ };
        enum Header { TEXT, NUMBER, DATE, CURRENCY };

        KexiCSVImportDialog( Mode mode, KexiMainWindow* mainWin, TQWidget * parent, 
          const char * name = 0/*, TQRect const & rect*/);
 
        virtual ~KexiCSVImportDialog();
 
        bool cancelled() const;
        virtual bool eventFilter ( TQObject * watched, TQEvent * e );
 
    protected:
        bool openData();
        virtual void accept();
 
    private:
        TQGridLayout* MyDialogLayout;
        TQHBoxLayout* Layout1;
        TQTable* m_table;
        KexiCSVDelimiterWidget* m_delimiterWidget;
        bool m_detectDelimiter; 
        TQString m_formatComboText;
        TQLabel* m_formatLabel;
        KComboBox* m_formatCombo;
        KIntSpinBox *m_startAtLineSpinBox;
        KexiCSVTextQuoteComboBox* m_comboQuote;
        TQLabel* m_startAtLineLabel;
        TQLabel* TextLabel2;
        TQCheckBox* m_ignoreDuplicates;
        TQCheckBox* m_1stRowForFieldNames;
        TQCheckBox* m_primaryKeyField;
 
        KexiMainWindow* m_mainWin;
 
        void detectTypeAndUniqueness(int row, int col, const TQString& text);
        void setText(int row, int col, const TQString& text, bool inGUI);

        bool parseDate(const TQString& text, TQDate& date);

        bool parseTime(const TQString& text, TQTime& time);

        void adjustRows(int iRows);
 
        int  getHeader(int col);
        TQString getText(int row, int col);
        void updateColumnText(int col);
        void updateRowCountInfo();
        tristate loadRows(TQString &field, int &row, int &columnm, int &maxColumn, bool inGUI);

        TQString detectDelimiterByLookingAtFirstBytesOfFile(TQTextStream& inputStream);

        bool saveRow(bool inGUI);
 
        bool m_cancelled;
        bool m_adjustRows;
        int m_startline;
        TQChar m_textquote;
        TQString m_clipboardData;
        TQByteArray m_fileArray;
        Mode m_mode;
        int m_prevSelectedCol;

        TQValueVector<int> m_detectedTypes;

        TQPtrVector< TQValueList<int> > m_uniquenessTest;
 
        TQRegExp m_dateRegExp, m_timeRegExp1, m_timeRegExp2, m_fpNumberRegExp;
        TQValueVector<TQString> m_typeNames, m_columnNames;
        TQBitArray m_changedColumnNames;
        bool m_columnsAdjusted : 1; 
        bool m_1stRowForFieldNamesDetected : 1; 
        bool m_firstFillTableCall : 1; 
        bool m_blockUserEvents : 1;
        int m_primaryKeyColumn; 
        int m_maximumRowsForPreview;
        int m_maximumBytesForPreview;
        TQPixmap m_pkIcon;
        TQString m_fname;
        TQFile* m_file;
        TQTextStream *m_inputStream; 
        KexiCSVImportOptions m_options;
        KProgressDialog *m_loadingProgressDlg, *m_importingProgressDlg;
        bool m_dialogCancelled;
        KexiCSVInfoLabel *m_infoLbl;
        KexiDB::Connection *m_conn; 
        KexiDB::TableSchema *m_destinationTableSchema;  
        KexiDB::PreparedStatement::Ptr m_importingStatement;
        TQValueList<TQVariant> m_dbRowBuffer; 
        bool m_implicitPrimaryKeyAdded; 
        bool m_allRowsLoadedInPreview; 
        bool m_stoppedAt_MAX_BYTES_TO_PREVIEW; 
 
    private slots:
        void fillTable();
        void fillTableLater();
        void initLater();
        void formatChanged(int id);
        void delimiterChanged(const TQString& delimiter);
        void startlineSelected(int line);
        void textquoteSelected(int);
        void currentCellChanged(int, int col);
        void ignoreDuplicatesChanged(int);
        void slot1stRowForFieldNamesChanged(int);
        void cellValueChanged(int row,int col);
        void optionsButtonClicked();
        void slotPrimaryKeyFieldToggled(bool on);
};
 
#endif