1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
|
/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4; fill-column: 100 -*- */
/*
* 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/.
*/
#include "mysqlc_columns.hxx"
#include "mysqlc_indexes.hxx"
#include "mysqlc_keys.hxx"
#include "mysqlc_table.hxx"
#include <TConnection.hxx>
#include <comphelper/types.hxx>
#include <connectivity/dbtools.hxx>
#include <com/sun/star/sdbcx/Privilege.hpp>
#include <com/sun/star/beans/PropertyAttribute.hpp>
connectivity::mysqlc::Table::Table(
Tables* pTables, osl::Mutex& rMutex,
const css::uno::Reference<OMetaConnection::XConnection>& rConnection)
: OTableHelper(pTables, rConnection, true)
, m_rMutex(rMutex)
, m_nPrivileges(0)
{
construct();
}
connectivity::mysqlc::Table::Table(
Tables* pTables, osl::Mutex& rMutex,
const css::uno::Reference<OMetaConnection::XConnection>& rConnection, const OUString& rCatalog,
const OUString& rSchema, const OUString& rName, const OUString& rType,
const OUString& rDescription)
: OTableHelper(pTables, rConnection, true, rName, rType, rDescription, rSchema, rCatalog)
, m_rMutex(rMutex)
, m_nPrivileges(0)
{
construct();
}
void connectivity::mysqlc::Table::construct()
{
OTableHelper::construct();
if (isNew())
return;
// TODO: get privileges when in non-embedded mode.
m_nPrivileges = css::sdbcx::Privilege::DROP | css::sdbcx::Privilege::REFERENCE
| css::sdbcx::Privilege::ALTER | css::sdbcx::Privilege::CREATE
| css::sdbcx::Privilege::READ | css::sdbcx::Privilege::DELETE
| css::sdbcx::Privilege::UPDATE | css::sdbcx::Privilege::INSERT
| css::sdbcx::Privilege::SELECT;
registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_PRIVILEGES),
PROPERTY_ID_PRIVILEGES, css::beans::PropertyAttribute::READONLY,
&m_nPrivileges, cppu::UnoType<decltype(m_nPrivileges)>::get());
}
//----- OTableHelper ---------------------------------------------------------
connectivity::sdbcx::OCollection*
connectivity::mysqlc::Table::createColumns(const ::std::vector<OUString>& rNames)
{
return new Columns(*this, m_rMutex, rNames);
}
connectivity::sdbcx::OCollection*
connectivity::mysqlc::Table::createKeys(const ::std::vector<OUString>& rNames)
{
return new Keys(this, m_rMutex, rNames);
}
connectivity::sdbcx::OCollection*
connectivity::mysqlc::Table::createIndexes(const ::std::vector<OUString>& rNames)
{
return new Indexes(this, m_rMutex, rNames);
}
//----- XAlterTable -----------------------------------------------------------
void SAL_CALL connectivity::mysqlc::Table::alterColumnByName(
const OUString& rColName, const css::uno::Reference<XPropertySet>& rDescriptor)
{
osl::MutexGuard aGuard(m_rMutex);
checkDisposed(WeakComponentImplHelperBase::rBHelper.bDisposed);
css::uno::Reference<XPropertySet> xColumn(m_xColumns->getByName(rColName), css::uno::UNO_QUERY);
// sdbcx::Descriptor
const bool bNameChanged
= xColumn->getPropertyValue("Name") != rDescriptor->getPropertyValue("Name");
// sdbcx::ColumnDescriptor
const bool bTypeChanged
= xColumn->getPropertyValue("Type") != rDescriptor->getPropertyValue("Type");
const bool bTypeNameChanged = !comphelper::getString(xColumn->getPropertyValue("TypeName"))
.equalsIgnoreAsciiCase(comphelper::getString(
rDescriptor->getPropertyValue("TypeName")));
const bool bPrecisionChanged
= xColumn->getPropertyValue("Precision") != rDescriptor->getPropertyValue("Precision");
const bool bScaleChanged
= xColumn->getPropertyValue("Scale") != rDescriptor->getPropertyValue("Scale");
const bool bIsNullableChanged
= xColumn->getPropertyValue("IsNullable") != rDescriptor->getPropertyValue("IsNullable");
const bool bIsAutoIncrementChanged = xColumn->getPropertyValue("IsAutoIncrement")
!= rDescriptor->getPropertyValue("IsAutoIncrement");
// there's also DefaultValue but not related to database directly, it seems completely internal to LO
// so no need to test it
// TODO: remainder -- these are all "optional" so have to detect presence and change.
if (bTypeChanged || bTypeNameChanged || bPrecisionChanged || bScaleChanged || bIsNullableChanged
|| bIsAutoIncrementChanged)
{
// If bPrecisionChanged this will only succeed if we have increased the
// precision, otherwise an exception is thrown -- however the base
// gui then offers to delete and recreate the column.
OUStringBuffer sSql(300);
sSql.append("ALTER TABLE `" + getTableName() + "` MODIFY COLUMN `" + rColName + "` "
+ ::dbtools::createStandardTypePart(rDescriptor, getConnection()));
if (comphelper::getBOOL(rDescriptor->getPropertyValue("IsAutoIncrement")))
sSql.append(" auto_increment");
// see ColumnValue: NO_NULLS = 0, NULLABLE = 1, NULLABLE_UNKNOWN
// so entry required = yes corresponds to NO_NULLS = 0 and only in this case
// NOT NULL
if (comphelper::getINT32(rDescriptor->getPropertyValue("IsNullable")) == 0)
sSql.append(" NOT NULL");
getConnection()->createStatement()->execute(sSql.makeStringAndClear());
}
if (bNameChanged)
{
OUString sNewColName;
rDescriptor->getPropertyValue("Name") >>= sNewColName;
OUString sSql("ALTER TABLE `" + getName() + "` RENAME COLUMN `" + rColName + "` TO `"
+ sNewColName + "`");
getConnection()->createStatement()->execute(sSql);
}
m_xColumns->refresh();
}
void SAL_CALL connectivity::mysqlc::Table::alterColumnByIndex(
sal_Int32 index, const css::uno::Reference<css::beans::XPropertySet>& descriptor)
{
osl::MutexGuard aGuard(m_rMutex);
css::uno::Reference<XPropertySet> xColumn(m_xColumns->getByIndex(index),
css::uno::UNO_QUERY_THROW);
alterColumnByName(comphelper::getString(xColumn->getPropertyValue(
OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_NAME))),
descriptor);
}
OUString connectivity::mysqlc::Table::getRenameStart() const { return "RENAME TABLE "; }
/* vim:set shiftwidth=4 softtabstop=4 expandtab cinoptions=b1,g0,N-s cinkeys+=0=break: */
|
