---

dbexport.h

/* liblookdb: dbexport.h - Database export to flat file 
    Copyright (C) 1998-2001 LOOK Systems

    This library is free software; you can redistribute it and/or
    modify it under the terms of the GNU Lesser General Public
    License as published by the Free Software Foundation; either
    version 2.1 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
    Lesser General Public License for more details.

    You should have received a copy of the GNU Lesser General Public
    License along with this library; if not, write to the Free Software
    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
*/
#ifndef LIBLOOKDB_DBEXPORT_H
#define LIBLOOKDB_DBEXPORT_H

// $Id: dbexport.h,v 1.8 2001/07/05 16:25:22 clive Exp $

#include "lookdblibrary.h"
#include "dbdescribetable.h"
#include "lookstringlist.h"

namespace look {

class DbField;


class LOOKDBUTILITIES_DLL DbExport
{
public:


        enum SuppressionMode
        {
                SUPPRESS_NONE = 0, 
                SUPPRESS_TABLENAME = 1, 
                SUPPRESS_COLUMNNAMES = 2 
        };

        // this determines what happens with text with control chars in.
        // no_convert does nothing (preserves tab, etc)
        // convert_normal converts tab to \t, cr to \r, lf to \\n, \ to \\
        // qe wraps the entire string in "" (and doubles internal "
        // chars too) suitable for pasting into q&e

        enum TextConversionMode
        {
                NO_CONVERT = 0, 
                CONVERT_NORMAL, 
                CONVERT_TO_QE   
        };

        DbExport( const LookString& theTableName );

        ~DbExport();

        void AddOtherTable( const LookString& theTableName );
        void SetWhereClause( const LookString& theWhereClause );
        void SetOrderClause( const LookString& theOrderClause );
        void SetFloatPrecision( int thePrecision );

        void SetSuppressionMode( int theSuppressionMode )
        {
                itsHeaderSuppressionMode = theSuppressionMode;
        }
        
        void SetNULLString( const LookString& theString )
        {
                itsNULLString = theString;
        }

        void SetTextConversionMode( TextConversionMode theConversionMode )
        {
                itsTextConversionMode = theConversionMode;
        }

        void SetDOSLineEnds( bool useCRLF )
        {
                if( useCRLF )
                {
                        itsLFString = "\r\n";
                }
                else
                {
                        itsLFString = "\n";
                }
        }

        bool DoExport( const LookString& theFileName );

        long GetNRowsExported( void );

protected:

        LookString GenerateSelectString( void );

        LookString GetExportString( const DbField* theField );

        LookString itsTableName;
        LookStringList itsOtherTables;
        LookString itsWhereClause;
        LookString itsOrderClause;

        int itsFloatPrecision;
        bool itHasFloatPrecision;
        int itsHeaderSuppressionMode;
        TextConversionMode itsTextConversionMode;
        
        LookString itsNULLString;
        LookString itsLFString;
        
        DbDescribeTable::ColumnInfoList itsTableColumns;

        long itsNRowsExported;
};


} // end of "look" namespace
#endif

---