Branch data Line data Source code
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 : : #include "connectivity/TKey.hxx"
21 : : #include "connectivity/TKeyColumns.hxx"
22 : : #include <com/sun/star/sdbc/XRow.hpp>
23 : : #include <com/sun/star/sdbc/XResultSet.hpp>
24 : : #include "TConnection.hxx"
25 : : #include "connectivity/TTableHelper.hxx"
26 : :
27 : : using namespace connectivity;
28 : : using namespace ::com::sun::star::uno;
29 : : using namespace ::com::sun::star::beans;
30 : : using namespace ::com::sun::star::sdbc;
31 : : using namespace ::com::sun::star::container;
32 : : using namespace ::com::sun::star::lang;
33 : : // -------------------------------------------------------------------------
34 : 0 : OTableKeyHelper::OTableKeyHelper(OTableHelper* _pTable) : connectivity::sdbcx::OKey(sal_True)
35 : 0 : ,m_pTable(_pTable)
36 : : {
37 [ # # ]: 0 : construct();
38 : 0 : }
39 : : // -------------------------------------------------------------------------
40 : 0 : OTableKeyHelper::OTableKeyHelper( OTableHelper* _pTable
41 : : ,const ::rtl::OUString& _Name
42 : : ,const sdbcx::TKeyProperties& _rProps
43 : : ) : connectivity::sdbcx::OKey(_Name,_rProps,sal_True)
44 : 0 : ,m_pTable(_pTable)
45 : : {
46 [ # # ]: 0 : construct();
47 [ # # ]: 0 : refreshColumns();
48 : 0 : }
49 : : // -------------------------------------------------------------------------
50 : 0 : void OTableKeyHelper::refreshColumns()
51 : : {
52 [ # # ]: 0 : if ( !m_pTable )
53 : 0 : return;
54 : :
55 [ # # ]: 0 : ::std::vector< ::rtl::OUString> aVector;
56 [ # # ]: 0 : if ( !isNew() )
57 : : {
58 [ # # ]: 0 : aVector = m_aProps->m_aKeyColumnNames;
59 [ # # ]: 0 : if ( aVector.empty() )
60 : : {
61 [ # # ]: 0 : ::dbtools::OPropertyMap& rPropMap = OMetaConnection::getPropMap();
62 : 0 : ::rtl::OUString aSchema,aTable;
63 [ # # ][ # # ]: 0 : m_pTable->getPropertyValue(rPropMap.getNameByIndex(PROPERTY_ID_SCHEMANAME)) >>= aSchema;
64 [ # # ][ # # ]: 0 : m_pTable->getPropertyValue(rPropMap.getNameByIndex(PROPERTY_ID_NAME)) >>= aTable;
65 : :
66 [ # # ]: 0 : if ( !m_Name.isEmpty() ) // foreign key
67 : : {
68 : :
69 [ # # ][ # # ]: 0 : Reference< XResultSet > xResult = m_pTable->getMetaData()->getImportedKeys(m_pTable->getPropertyValue(rPropMap.getNameByIndex(PROPERTY_ID_CATALOGNAME)),
70 [ # # ][ # # ]: 0 : aSchema,aTable);
[ # # ]
71 : :
72 [ # # ]: 0 : if ( xResult.is() )
73 : : {
74 [ # # ]: 0 : Reference< XRow > xRow(xResult,UNO_QUERY);
75 [ # # ][ # # ]: 0 : while( xResult->next() )
[ # # ]
76 : : {
77 [ # # ][ # # ]: 0 : ::rtl::OUString aForeignKeyColumn = xRow->getString(8);
78 [ # # ][ # # ]: 0 : if(xRow->getString(12) == m_Name)
[ # # ]
79 [ # # ]: 0 : aVector.push_back(aForeignKeyColumn);
80 : 0 : }
81 : 0 : }
82 : : }
83 : :
84 [ # # ]: 0 : if ( aVector.empty() )
85 : : {
86 [ # # ][ # # ]: 0 : const Reference< XResultSet > xResult = m_pTable->getMetaData()->getPrimaryKeys(m_pTable->getPropertyValue(rPropMap.getNameByIndex(PROPERTY_ID_CATALOGNAME)),
87 [ # # ][ # # ]: 0 : aSchema,aTable);
[ # # ]
88 : :
89 [ # # ]: 0 : if ( xResult.is() )
90 : : {
91 [ # # ]: 0 : const Reference< XRow > xRow(xResult,UNO_QUERY);
92 [ # # ][ # # ]: 0 : while( xResult->next() )
[ # # ]
93 [ # # ][ # # ]: 0 : aVector.push_back(xRow->getString(4));
[ # # ]
94 : 0 : } // if ( xResult.is() )
95 : 0 : }
96 : : }
97 : : }
98 : :
99 : :
100 [ # # ]: 0 : if ( m_pColumns )
101 [ # # ]: 0 : m_pColumns ->reFill(aVector);
102 : : else
103 [ # # ][ # # ]: 0 : m_pColumns = new OKeyColumnsHelper(this,m_aMutex,aVector);
104 : : }
105 : : // -----------------------------------------------------------------------------
106 : :
107 : : /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|