User: rt Date: 2008-01-30 08:48:38+0000 Modified: dba/dbaccess/source/ui/inc/WCopyTable.hxx
Log: INTEGRATION: CWS dba24d (1.22.28); FILE MERGED 2007/12/05 14:36:57 fs 1.22.28.9: #i81658# m_aColumnInfo should not be sorted by name 2007/12/05 13:41:48 fs 1.22.28.8: impl_ensureColumnInfo throws now 2007/12/01 13:41:08 fs 1.22.28.7: RESYNC: (1.22-1.23); FILE MERGED 2007/11/26 15:14:17 oj 1.22.28.6: #i49703# copy table settings 2007/11/19 09:48:30 fs 1.22.28.5: #i81658# +ICopyTableSourceObject::getPreparedSelectStatement, to re-use the statement already created by some implementations 2007/11/17 21:13:15 fs 1.22.28.4: #i81658# 2007/11/15 15:16:41 fs 1.22.28.3: #i81658# also allow to copy a table from an SDBC level connection 2007/11/15 10:04:51 fs 1.22.28.2: #i81658# removed m_xSourceObject, hide it behind some ICopyTableSourceObject, to allow copying tables at SDBC level where we cannot describe the source as object, but as table name only 2007/11/08 14:21:04 fs 1.22.28.1: #i81658# re-factoring of the Copy Table wizard File Changes: Directory: /dba/dbaccess/source/ui/inc/ ======================================= File [changed]: WCopyTable.hxx Url: http://dba.openoffice.org/source/browse/dba/dbaccess/source/ui/inc/WCopyTable.hxx?r1=1.23&r2=1.24 Delta lines: +175 -58 ---------------------- --- WCopyTable.hxx 2007-11-21 16:02:18+0000 1.23 +++ WCopyTable.hxx 2008-01-30 08:48:35+0000 1.24 @@ -128,6 +128,132 @@ ::std::bind2nd(m_aCase, _sColumnName)) != m_pVector->end(); } }; + + // ======================================================== + // ICopyTableSourceObject + // ======================================================== + /** interface to an object to copy to another DB, using the OCopyTableWizard + + when the wizard is used to copy an object to another DB, it usually requires + a sdbcx-level or sdb-level object (a css.sdbcx.Table or css.sdb.Query, that is). + + However, to also support copying tables from sdbc-level connections, we allow to + work with the object name only. This implies some less features (like copying the + UI settings of a table is not done), but still allows to copy definition and data. + */ + class ICopyTableSourceObject + { + public: + /// retrieves the fully qualified name of the object to copy + virtual ::rtl::OUString getQualifiedObjectName() const = 0; + /// determines whether the object is a view + virtual bool isView() const = 0; + /** copies the UI settings of the object to the given target object. Might be + ignored by implementations which do not have Ui settings. + */ + virtual void copyUISettingsTo( const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& _rxObject ) const = 0; + /// retrieves the column names of the to-be-copied object + virtual ::com::sun::star::uno::Sequence< ::rtl::OUString > + getColumnNames() const = 0; + /// retrieves the names of the primary keys of the to-be-copied object + virtual ::com::sun::star::uno::Sequence< ::rtl::OUString > + getPrimaryKeyColumnNames() const = 0; + /// creates a OFieldDescription for the given column of the to-be-copied object + virtual OFieldDescription* createFieldDescription( const ::rtl::OUString& _rColumnName ) const = 0; + /// returns the SELECT statement which can be used to retrieve the data of the to-be-copied object + virtual ::rtl::OUString getSelectStatement() const = 0; + + /** copies the filter and sorting + * + * \return + */ + virtual void copyFilterAndSortingTo(const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection >& _xConnection,const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& _rxObject ) const = 0; + + /** returns the prepared statement which can be used to retrieve the data of the to-be-copied object + + The default implementation of this method will simply prepare a statement with the return value + of ->getSelectStatement. + */ + virtual ::utl::SharedUNOComponent< ::com::sun::star::sdbc::XPreparedStatement > + getPreparedSelectStatement() const = 0; + + virtual ~ICopyTableSourceObject(); + }; + + // ======================================================== + // ObjectCopySource + // ======================================================== + class ObjectCopySource : public ICopyTableSourceObject + { + private: + ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection > m_xConnection; + ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XDatabaseMetaData > m_xMetaData; + ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet > m_xObject; + ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySetInfo > m_xObjectPSI; + ::com::sun::star::uno::Reference< ::com::sun::star::container::XNameAccess > m_xObjectColumns; + + public: + ObjectCopySource( + const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection >& _rxConnection, + const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& _rxObject + ); + + // ICopyTableSourceObject overridables + virtual ::rtl::OUString getQualifiedObjectName() const; + virtual bool isView() const; + virtual void copyUISettingsTo( const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& _rxObject ) const; + virtual void copyFilterAndSortingTo(const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection >& _xConnection, const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& _rxObject ) const; + virtual ::com::sun::star::uno::Sequence< ::rtl::OUString > + getColumnNames() const; + virtual ::com::sun::star::uno::Sequence< ::rtl::OUString > + getPrimaryKeyColumnNames() const; + virtual OFieldDescription* createFieldDescription( const ::rtl::OUString& _rColumnName ) const; + virtual ::rtl::OUString getSelectStatement() const; + virtual ::utl::SharedUNOComponent< ::com::sun::star::sdbc::XPreparedStatement > + getPreparedSelectStatement() const; + }; + + // ======================================================== + // NamedTableCopySource + // ======================================================== + class NamedTableCopySource : public ICopyTableSourceObject + { + private: + ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection > m_xConnection; + ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XDatabaseMetaData > m_xMetaData; + ::rtl::OUString m_sTableName; + ::rtl::OUString m_sTableCatalog; + ::rtl::OUString m_sTableSchema; + ::rtl::OUString m_sTableBareName; + ::std::vector< OFieldDescription > m_aColumnInfo; + ::utl::SharedUNOComponent< ::com::sun::star::sdbc::XPreparedStatement > m_xStatement; + + public: + NamedTableCopySource( + const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection >& _rxConnection, + const ::rtl::OUString& _rTableName + ); + + // ICopyTableSourceObject overridables + virtual ::rtl::OUString getQualifiedObjectName() const; + virtual bool isView() const; + virtual void copyUISettingsTo( const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& _rxObject ) const; + virtual void copyFilterAndSortingTo(const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection >& _xConnection,const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& _rxObject ) const; + virtual ::com::sun::star::uno::Sequence< ::rtl::OUString > + getColumnNames() const; + virtual ::com::sun::star::uno::Sequence< ::rtl::OUString > + getPrimaryKeyColumnNames() const; + virtual OFieldDescription* createFieldDescription( const ::rtl::OUString& _rColumnName ) const; + virtual ::rtl::OUString getSelectStatement() const; + virtual ::utl::SharedUNOComponent< ::com::sun::star::sdbc::XPreparedStatement > + getPreparedSelectStatement() const; + + private: + void impl_ensureColumnInfo_throw(); + ::utl::SharedUNOComponent< ::com::sun::star::sdbc::XPreparedStatement > + impl_ensureStatement_throw(); + }; + // ======================================================== // Wizard Dialog // ======================================================== @@ -142,14 +268,6 @@ public: DECLARE_STL_MAP(::rtl::OUString,::rtl::OUString,::comphelper::UStringMixLess,TNameMapping); - enum Wizard_Create_Style - { - WIZARD_APPEND_DATA = 0, - WIZARD_DEF_DATA, - WIZARD_DEF, - WIZARD_DEF_VIEW - }; - enum Wizard_Button_Style { WIZARD_NEXT, @@ -180,19 +298,17 @@ ODatabaseExport::TPositions m_vColumnPos; ::std::vector<sal_Int32> m_vColumnTypes; - ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet > m_xDestObject; // can be a query or a table - ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection > m_xConnection; // dest conn + ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection > m_xDestConnection; - ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet > m_xSourceObject; - ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection > m_xSourceConnection; // source conn + const ICopyTableSourceObject& m_rSourceObject; - ::com::sun::star::uno::Reference< ::com::sun::star::container::XNameAccess> m_xSourceColumns; // container ::com::sun::star::uno::Reference< ::com::sun::star::util::XNumberFormatter > m_xFormatter; ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory> m_xFactory; String m_sTypeNames; // these type names are the ones out of the resource file sal_uInt32 m_nPageCount; sal_Bool m_bDeleteSourceColumns; + bool m_bInterConnectionCopy; // are we copying between different connections? ::com::sun::star::lang::Locale m_aLocale; ::rtl::OUString m_sName; // for a table the name is composed @@ -200,9 +316,9 @@ ::rtl::OUString m_aKeyName; TOTypeInfoSP m_pTypeInfo; // default type sal_Bool m_bAddPKFirstTime; - Wizard_Create_Style m_eCreateStyle; + sal_Int16 m_nOperation; Wizard_Button_Style m_ePressed; - bool m_bCreatePrimaryColumn; + sal_Bool m_bCreatePrimaryKeyColumn; private: DECL_LINK( ImplPrevHdl , PushButton* ); @@ -210,34 +326,43 @@ DECL_LINK( ImplOKHdl , OKButton* ); DECL_LINK( ImplActivateHdl, WizardDialog* ); sal_Bool CheckColumns(sal_Int32& _rnBreakPos); - void loadData( const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& _xTable, + void loadData( const ICopyTableSourceObject& _rSourceObject, ODatabaseExport::TColumns& _rColumns, - ODatabaseExport::TColumnVector& _rColVector); + ODatabaseExport::TColumnVector& _rColVector ); void construct(); - ::com::sun::star::uno::Reference< ::com::sun::star::container::XNameAccess> getKeyColumns(const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& _xTable) const; // need for table creation - void appendColumns(::com::sun::star::uno::Reference< ::com::sun::star::sdbcx::XColumnsSupplier>& _rxColSup,const ODatabaseExport::TColumnVector* _pVec,sal_Bool _bKeyColumns=sal_False); - void appendKey(::com::sun::star::uno::Reference< ::com::sun::star::sdbcx::XKeysSupplier>& _rxSup,const ODatabaseExport::TColumnVector* _pVec); + void appendColumns( ::com::sun::star::uno::Reference< ::com::sun::star::sdbcx::XColumnsSupplier>& _rxColSup, const ODatabaseExport::TColumnVector* _pVec, sal_Bool _bKeyColumns = sal_False ) const; + void appendKey(::com::sun::star::uno::Reference< ::com::sun::star::sdbcx::XKeysSupplier>& _rxSup,const ODatabaseExport::TColumnVector* _pVec) const; // checks if the type is supported in the destination database sal_Bool supportsType(sal_Int32 _nDataType,sal_Int32& _rNewDataType); + void impl_loadSourceData(); + public: // used for copy tables or queries - OCopyTableWizard(Window * pParent, - const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& _xSourceObject, + OCopyTableWizard( + Window * pParent, + const ::rtl::OUString& _rDefaultName, + sal_Int16 _nOperation, + const ICopyTableSourceObject& _rSourceObject, const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection >& _xSourceConnection, const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection >& _xConnection, - const ::com::sun::star::uno::Reference< ::com::sun::star::util::XNumberFormatter >& _xFormatter, - const ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory >& _rM); + const ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory >& _rxORB + ); // used for importing rtf/html sources - OCopyTableWizard(Window * pParent, + OCopyTableWizard( + Window* pParent, const ::rtl::OUString& _rDefaultName, + sal_Int16 _nOperation, const ODatabaseExport::TColumns& _rDestColumns, const ODatabaseExport::TColumnVector& _rSourceColVec, const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection >& _xConnection, const ::com::sun::star::uno::Reference< ::com::sun::star::util::XNumberFormatter >& _xFormatter, - const ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory >& _rM); + TypeSelectionPageFactory _pTypeSelectionPageFactory, + SvStream& _rTypeSelectionPageArg, + const ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory >& _rM + ); virtual ~OCopyTableWizard(); @@ -249,16 +374,10 @@ void RemoveWizardPage(OWizardPage* pPage); // Page goes again to user void CheckButtons(); // checks which button can be disabled, enabled - void fillTypeInfo(); - /** has to be called after fillTypeInfo() and only when using the 1st ctor - */ - void loadData(); - // returns a vector where the position of a column and if the column is in the selection // when not the value is COLUMN_POSITION_NOT_FOUND == (sal_uInt32)-1 ODatabaseExport::TPositions GetColumnPositions() const { return m_vColumnPos; } ::std::vector<sal_Int32> GetColumnTypes() const { return m_vColumnTypes; } - const TNameMapping* GetNameMapping() const { return &m_mNameMapping; } void insertColumn(sal_Int32 _nPos,OFieldDescription* _pField); @@ -272,16 +391,20 @@ */ void replaceColumn(sal_Int32 _nPos,OFieldDescription* _pField,const ::rtl::OUString& _sOldName); - ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet > getDestObject() const { return m_xDestObject; } - /** - @return - <TRUE/> if I need to set the autoincrement value by myself otherwise <FALSE/> + /** returns whether a primary key should be created in the target database */ - bool isAutoincrementEnabled() const; + sal_Bool shouldCreatePrimaryKey() const; + void setCreatePrimaryKey( bool _bDoCreate, const ::rtl::OUString& _rSuggestedName ); + + static bool supportsPrimaryKey( const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection >& _rxConnection ); + bool supportsPrimaryKey() const { return supportsPrimaryKey( m_xDestConnection ); } + + static bool supportsViews( const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection >& _rxConnection ); + bool supportsViews() const { return supportsViews( m_xDestConnection ); } /** returns the name of the primary key @return - The name of teh primary key. + The name of the primary key. */ ::rtl::OUString getPrimaryKeyName() const { return m_aKeyName; } @@ -306,13 +429,11 @@ void clearDestColumns(); ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet > createTable(); - ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet > createView(); - // return true when the conenction supports primary keys - sal_Bool supportsPrimaryKey() const; + ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet > createView() const; sal_Int32 getMaxColumnNameLength() const; - void setCreateStyle(const Wizard_Create_Style& _eStyle); - Wizard_Create_Style getCreateStyle() const; + void setOperation( const sal_Int16 _nOperation ); + sal_Int16 getOperation() const; ::rtl::OUString convertColumnName( const TColumnFindFunctor& _rCmpFunctor, const ::rtl::OUString& _sColumnName, @@ -327,12 +448,8 @@ void removeColumnNameFromNameMap(const ::rtl::OUString& _sName); - //dyf add - void ResetsName(const ::rtl::OUString & _sName); - //dyf add end + void SetTableName( const ::rtl::OUString& _rName ); }; } #endif // DBAUI_WIZ_COPYTABLEDIALOG_HXX - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
