/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
*/
#ifndef _CONNECTIVITY_DBASE_TABLE_HXX_
#define _CONNECTIVITY_DBASE_TABLE_HXX_
#include "file/FTable.hxx"
#include "connectivity/sdbcx/VColumn.hxx"
#include "connectivity/CommonTools.hxx"
#include <tools/urlobj.hxx>
namespace connectivity
{
namespace dbase
{
typedef file::OFileTable ODbaseTable_BASE;
class ODbaseConnection;
typedef ::std::map< OUString,
::com::sun::star::uno::Reference< ::com::sun::star::container::XNamed>, comphelper::UStringMixLess > OContainer;
class ODbaseTable : public ODbaseTable_BASE
{
// The first byte of a dBase file specifies its type
public:
enum DBFType { dBaseIII = 0x03,
dBaseIV = 0x04,
dBaseV = 0x05,
VisualFoxPro = 0x30,
VisualFoxProAuto = 0x31, // Visual FoxPro with AutoIncrement field
dBaseFS = 0x43,
dBaseFSMemo = 0xB3,
dBaseIIIMemo = 0x83,
dBaseIVMemo = 0x8B,
dBaseIVMemoSQL = 0x8E,
FoxProMemo = 0xF5
};
enum DBFMemoType { MemodBaseIII = 0,
MemodBaseIV,
MemoFoxPro
};
private:
struct DBFHeader { /* Header struct */
DBFType db_typ; /* File type */
sal_uInt8 db_aedat[3]; /* Date of last change */
/* YY MM DD */
sal_uInt32 db_anz; /* Data set count */
sal_uInt16 db_kopf; /* Header length */
sal_uInt16 db_slng; /* Data set length */
sal_uInt8 db_frei[20]; /* Reserved */
};
struct DBFColumn { /* Column descriptors */
sal_uInt8 db_fnm[11]; /* Field name */
sal_uInt8 db_typ; /* Field type */
sal_uInt32 db_adr; /* Field address */
sal_uInt8 db_flng; /* Field length */
sal_uInt8 db_dez; /* Decimal places for N */
sal_uInt8 db_frei2[14]; /* Reserved */
};
struct DBFMemoHeader
{
DBFMemoType db_typ; /* File type */
sal_uInt32 db_next; /* Next free block */
sal_uInt16 db_size; /* Block size: dBase 3 fixed */
};
::std::vector<sal_Int32> m_aTypes; // holds all types for columns just to avoid to ask the propertyset
::std::vector<sal_Int32> m_aPrecisions; // same as above
::std::vector<sal_Int32> m_aScales;
::std::vector<sal_Int32> m_aRealFieldLengths;
DBFHeader m_aHeader;
DBFMemoHeader m_aMemoHeader;
SvStream* m_pMemoStream;
rtl_TextEncoding m_eEncoding;
sal_Bool m_bWriteableMemo;
void alterColumn(sal_Int32 index,
const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet>& descriptor ,
const ::com::sun::star::uno::Reference< ::com::sun::star::sdbcx::XDataDescriptorFactory>& xOldColumn );
void readHeader();
void fillColumns();
OUString createTempFile();
void copyData(ODbaseTable* _pNewTable,sal_Int32 _nPos);
sal_Bool CreateFile(const INetURLObject& aFile, sal_Bool& bCreateMemo);
sal_Bool CreateMemoFile(const INetURLObject& aFile);
sal_Bool HasMemoFields() const { return m_aHeader.db_typ > dBaseIV;}
sal_Bool ReadMemoHeader();
sal_Bool ReadMemo(sal_uIntPtr nBlockNo, ORowSetValue& aVariable);
sal_Bool WriteMemo(const ORowSetValue& aVariable, sal_uIntPtr& rBlockNr);
sal_Bool WriteBuffer();
sal_Bool UpdateBuffer(OValueRefVector& rRow, OValueRefRow pOrgRow,const ::com::sun::star::uno::Reference< ::com::sun::star::container::XIndexAccess>& _xCols, bool bForceAllFields);
::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet> isUniqueByColumnName(sal_Int32 _nColumnPos);
void AllocBuffer();
void throwInvalidDbaseFormat();
void SAL_CALL renameImpl( const OUString& newName ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::container::ElementExistException, ::com::sun::star::uno::RuntimeException);
void throwInvalidColumnType(const sal_uInt16 _nErrorId,const OUString& _sColumnName);
protected:
virtual void FileClose();
// using ::connectivity::sdbcx::OTableDescriptor_BASE::rBHelper;
public:
virtual void refreshColumns();
virtual void refreshIndexes();
public:
ODbaseTable( sdbcx::OCollection* _pTables,ODbaseConnection* _pConnection);
ODbaseTable( sdbcx::OCollection* _pTables,ODbaseConnection* _pConnection,
const OUString& _Name,
const OUString& _Type,
const OUString& _Description = OUString(),
const OUString& _SchemaName = OUString(),
const OUString& _CatalogName = OUString()
);
void construct(); // can throw any exception
virtual sal_Int32 getCurrentLastPos() const;
virtual sal_Bool seekRow(IResultSetHelper::Movement eCursorPosition, sal_Int32 nOffset, sal_Int32& nCurPos);
virtual sal_Bool fetchRow(OValueRefRow& _rRow,const OSQLColumns& _rCols, sal_Bool _bUseTableDefs,sal_Bool bRetrieveData);
virtual ::com::sun::star::uno::Any SAL_CALL queryInterface( const ::com::sun::star::uno::Type & rType ) throw(::com::sun::star::uno::RuntimeException);
//XTypeProvider
virtual ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Type > SAL_CALL getTypes( ) throw(::com::sun::star::uno::RuntimeException);
virtual void SAL_CALL disposing(void);
// com::sun::star::lang::XUnoTunnel
virtual sal_Int64 SAL_CALL getSomething( const ::com::sun::star::uno::Sequence< sal_Int8 >& aIdentifier ) throw(::com::sun::star::uno::RuntimeException);
static ::com::sun::star::uno::Sequence< sal_Int8 > getUnoTunnelImplementationId();
// XAlterTable
virtual void SAL_CALL alterColumnByName( const OUString& colName, const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& descriptor ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::container::NoSuchElementException, ::com::sun::star::uno::RuntimeException);
virtual void SAL_CALL alterColumnByIndex( sal_Int32 index, const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& descriptor ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::lang::IndexOutOfBoundsException, ::com::sun::star::uno::RuntimeException);
// XRename
virtual void SAL_CALL rename( const OUString& newName ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::container::ElementExistException, ::com::sun::star::uno::RuntimeException);
sal_Bool DropImpl();
sal_Bool CreateImpl();
virtual sal_Bool InsertRow(OValueRefVector& rRow, sal_Bool bFlush,const ::com::sun::star::uno::Reference< ::com::sun::star::container::XIndexAccess>& _xCols);
virtual sal_Bool DeleteRow(const OSQLColumns& _rCols);
virtual sal_Bool UpdateRow(OValueRefVector& rRow, OValueRefRow& pOrgRow,const ::com::sun::star::uno::Reference< ::com::sun::star::container::XIndexAccess>& _xCols);
virtual void addColumn(const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet>& descriptor);
virtual void dropColumn(sal_Int32 _nPos);
static OUString getEntry(file::OConnection* _pConnection,const OUString& _sURL );
static sal_Bool Drop_Static(const OUString& _sUrl,sal_Bool _bHasMemoFields,sdbcx::OCollection* _pIndexes );
virtual void refreshHeader();
virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XDatabaseMetaData> getMetaData() const;
};
}
}
#endif // _CONNECTIVITY_DBASE_TABLE_HXX_
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */