LibreOffice Module connectivity (master) 1
TTableHelper.hxx
Go to the documentation of this file.
1/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
2/*
3 * This file is part of the LibreOffice project.
4 *
5 * This Source Code Form is subject to the terms of the Mozilla Public
6 * License, v. 2.0. If a copy of the MPL was not distributed with this
7 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
8 *
9 * This file incorporates work covered by the following license notice:
10 *
11 * Licensed to the Apache Software Foundation (ASF) under one or more
12 * contributor license agreements. See the NOTICE file distributed
13 * with this work for additional information regarding copyright
14 * ownership. The ASF licenses this file to you under the Apache
15 * License, Version 2.0 (the "License"); you may not use this file
16 * except in compliance with the License. You may obtain a copy of
17 * the License at http://www.apache.org/licenses/LICENSE-2.0 .
18 */
19
20#ifndef INCLUDED_CONNECTIVITY_TTABLEHELPER_HXX
21#define INCLUDED_CONNECTIVITY_TTABLEHELPER_HXX
22
23#include <memory>
24#include <sal/config.h>
25
26#include <map>
27
30#include <utility>
31
32namespace com::sun::star::sdbc { class XConnection; }
33namespace com::sun::star::sdb::tools { class XIndexAlteration; }
34namespace com::sun::star::sdb::tools { class XKeyAlteration; }
35namespace com::sun::star::sdb::tools { class XTableAlteration; }
36namespace com::sun::star::sdb::tools { class XTableRename; }
37namespace connectivity::sdbcx { struct KeyProperties; }
38
39namespace connectivity
40{
41 typedef sal_Int32 OrdinalPosition;
43 {
44 OUString sName;
45 OUString aField6;
46 OUString sField12; // REMARKS
47 OUString sField13;
48 sal_Int32 nField5
52
54
55 ColumnDesc( OUString _sName
56 , sal_Int32 _nField5
57 , OUString _aField6
58 , sal_Int32 _nField7
59 , sal_Int32 _nField9
60 , sal_Int32 _nField11
61 , OUString _sField12
62 , OUString _sField13
63 ,OrdinalPosition _nPosition )
64 :sName(std::move( _sName ))
65 ,aField6(std::move(_aField6))
66 ,sField12(std::move(_sField12))
67 ,sField13(std::move(_sField13))
68 ,nField5(_nField5)
69 ,nField7(_nField7)
70 ,nField9(_nField9)
71 ,nField11(_nField11)
72 ,nOrdinalPosition( _nPosition )
73 {
74 }
75 };
77
78 typedef std::map<OUString, std::shared_ptr<sdbcx::KeyProperties>> TKeyMap;
79
80 struct OTableHelperImpl;
81
83 {
84 ::std::unique_ptr<OTableHelperImpl> m_pImpl;
85
86 void refreshPrimaryKeys(::std::vector< OUString>& _rKeys);
87 void refreshForeignKeys(::std::vector< OUString>& _rKeys);
88
89 protected:
94 virtual sdbcx::OCollection* createColumns(const ::std::vector< OUString>& _rNames) = 0;
95
100 virtual sdbcx::OCollection* createKeys(const ::std::vector< OUString>& _rNames) = 0;
101
106 virtual sdbcx::OCollection* createIndexes(const ::std::vector< OUString>& _rNames) = 0;
107
110 virtual void SAL_CALL disposing() override;
111
116 virtual OUString getRenameStart() const;
117
118 virtual ~OTableHelper() override;
119
120 public:
121 virtual void refreshColumns() override;
122 virtual void refreshKeys() override;
123 virtual void refreshIndexes() override;
124
125 const ColumnDesc* getColumnDescription(const OUString& _sName) const;
126
127 public:
129 const css::uno::Reference< css::sdbc::XConnection >& _xConnection,
130 bool _bCase);
132 const css::uno::Reference< css::sdbc::XConnection >& _xConnection,
133 bool _bCase,
134 const OUString& Name,
135 const OUString& Type,
136 const OUString& Description = OUString(),
137 const OUString& SchemaName = OUString(),
138 const OUString& CatalogName = OUString()
139 );
140
141 virtual css::uno::Reference< css::sdbc::XDatabaseMetaData> getMetaData() const override;
142 css::uno::Reference< css::sdbc::XConnection> const & getConnection() const;
143
144 // XRename
145 virtual void SAL_CALL rename( const OUString& newName ) override;
146
147 // XAlterTable
148 virtual void SAL_CALL alterColumnByIndex( sal_Int32 index, const css::uno::Reference< css::beans::XPropertySet >& descriptor ) override;
149 // XNamed
150 virtual OUString SAL_CALL getName() override;
151
152 // To retrieve the table name only without the schema
153 const OUString & getTableName();
154
155 // helper method to get key properties
156 std::shared_ptr<sdbcx::KeyProperties> getKeyProperties(const OUString& _sName) const;
157 void addKey(const OUString& _sName,const std::shared_ptr<sdbcx::KeyProperties>& _aKeyProperties);
158
159 virtual OUString getTypeCreatePattern() const;
160
161 css::uno::Reference< css::sdb::tools::XTableRename> const & getRenameService() const;
162 css::uno::Reference< css::sdb::tools::XTableAlteration> const & getAlterService() const;
163 css::uno::Reference< css::sdb::tools::XKeyAlteration> const & getKeyService() const;
164 css::uno::Reference< css::sdb::tools::XIndexAlteration> const & getIndexService() const;
165 };
166}
167#endif // INCLUDED_CONNECTIVITY_TTABLEHELPER_HXX
168
169/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
::std::unique_ptr< OTableHelperImpl > m_pImpl
OTableHelper(sdbcx::OCollection *_pTables, const css::uno::Reference< css::sdbc::XConnection > &_xConnection, bool _bCase, const OUString &Name, const OUString &Type, const OUString &Description=OUString(), const OUString &SchemaName=OUString(), const OUString &CatalogName=OUString())
virtual sdbcx::OCollection * createIndexes(const ::std::vector< OUString > &_rNames)=0
creates the index collection for the table
virtual sdbcx::OCollection * createKeys(const ::std::vector< OUString > &_rNames)=0
creates the key collection for the table
OTableHelper(sdbcx::OCollection *_pTables, const css::uno::Reference< css::sdbc::XConnection > &_xConnection, bool _bCase)
virtual sdbcx::OCollection * createColumns(const ::std::vector< OUString > &_rNames)=0
creates the column collection for the table
#define OOO_DLLPUBLIC_DBTOOLS
Type
sal_Int32 OrdinalPosition
std::map< OUString, std::shared_ptr< sdbcx::KeyProperties > > TKeyMap
connectivity::sdbcx::OTable OTable_TYPEDEF
Reference< XConnection > getConnection(const Reference< XRowSet > &_rxRowSet)
Definition: dbtools.cxx:348
ColumnDesc(OUString _sName, sal_Int32 _nField5, OUString _aField6, sal_Int32 _nField7, sal_Int32 _nField9, sal_Int32 _nField11, OUString _sField12, OUString _sField13, OrdinalPosition _nPosition)
OrdinalPosition nOrdinalPosition