Branch data Line data Source code
1 : : /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
2 : : /*************************************************************************
3 : : *
4 : : * Effective License of whole file:
5 : : *
6 : : * This library is free software; you can redistribute it and/or
7 : : * modify it under the terms of the GNU Lesser General Public
8 : : * License version 2.1, as published by the Free Software Foundation.
9 : : *
10 : : * This library is distributed in the hope that it will be useful,
11 : : * but WITHOUT ANY WARRANTY; without even the implied warranty of
12 : : * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
13 : : * Lesser General Public License for more details.
14 : : *
15 : : * You should have received a copy of the GNU Lesser General Public
16 : : * License along with this library; if not, write to the Free Software
17 : : * Foundation, Inc., 59 Temple Place, Suite 330, Boston,
18 : : * MA 02111-1307 USA
19 : : *
20 : : * Parts "Copyright by Sun Microsystems, Inc" prior to August 2011:
21 : : *
22 : : * The Contents of this file are made available subject to the terms of
23 : : * the GNU Lesser General Public License Version 2.1
24 : : *
25 : : * Copyright: 200? by Sun Microsystems, Inc.
26 : : *
27 : : * Contributor(s): Joerg Budischewski
28 : : *
29 : : * All parts contributed on or after August 2011:
30 : : *
31 : : * Version: MPL 1.1 / GPLv3+ / LGPLv2.1+
32 : : *
33 : : * The contents of this file are subject to the Mozilla Public License Version
34 : : * 1.1 (the "License"); you may not use this file except in compliance with
35 : : * the License or as specified alternatively below. You may obtain a copy of
36 : : * the License at http://www.mozilla.org/MPL/
37 : : *
38 : : * Software distributed under the License is distributed on an "AS IS" basis,
39 : : * WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License
40 : : * for the specific language governing rights and limitations under the
41 : : * License.
42 : : *
43 : : * Major Contributor(s):
44 : : * [ Copyright (C) 2011 Lionel Elie Mamane <lionel@mamane.lu> ]
45 : : *
46 : : * All Rights Reserved.
47 : : *
48 : : * For minor contributions see the git repository.
49 : : *
50 : : * Alternatively, the contents of this file may be used under the terms of
51 : : * either the GNU General Public License Version 3 or later (the "GPLv3+"), or
52 : : * the GNU Lesser General Public License Version 2.1 or later (the "LGPLv2.1+"),
53 : : * in which case the provisions of the GPLv3+ or the LGPLv2.1+ are applicable
54 : : * instead of those above.
55 : : *
56 : : ************************************************************************/
57 : :
58 : : #include "pq_sequenceresultset.hxx"
59 : : #include "pq_resultsetmetadata.hxx"
60 : :
61 : : #include <com/sun/star/sdbc/FetchDirection.hpp>
62 : : #include <com/sun/star/sdbc/ResultSetConcurrency.hpp>
63 : : #include <com/sun/star/sdbc/ResultSetType.hpp>
64 : : #include <com/sun/star/sdbc/XResultSetUpdate.hpp>
65 : : #include <com/sun/star/sdbc/XRowUpdate.hpp>
66 : :
67 : : namespace pq_sdbc_driver
68 : : {
69 : :
70 : 0 : struct UpdateableField
71 : : {
72 : 0 : UpdateableField( )
73 : 0 : : isTouched(false)
74 : 0 : {}
75 : : com::sun::star::uno::Any value;
76 : : bool isTouched;
77 : : };
78 : :
79 : : typedef ::std::vector< UpdateableField , Allocator< UpdateableField > > UpdateableFieldVector;
80 : :
81 : 0 : class UpdateableResultSet :
82 : : public SequenceResultSet,
83 : : public com::sun::star::sdbc::XResultSetUpdate,
84 : : public com::sun::star::sdbc::XRowUpdate
85 : : {
86 : : ConnectionSettings **m_ppSettings;
87 : : rtl::OUString m_schema;
88 : : rtl::OUString m_table;
89 : : com::sun::star::uno::Sequence< rtl::OUString > m_primaryKey;
90 : : UpdateableFieldVector m_updateableField;
91 : : com::sun::star::uno::Reference< com::sun::star::sdbc::XResultSetMetaData > m_meta;
92 : : bool m_insertRow;
93 : :
94 : : protected:
95 : 0 : UpdateableResultSet(
96 : : const ::rtl::Reference< RefCountedMutex > & mutex,
97 : : const com::sun::star::uno::Reference< com::sun::star::uno::XInterface > &owner,
98 : : const com::sun::star::uno::Sequence< rtl::OUString > &colNames,
99 : : const com::sun::star::uno::Sequence< com::sun::star::uno::Sequence< com::sun::star::uno::Any > > &data,
100 : : ConnectionSettings **ppSettings,
101 : : const rtl::OUString &schema,
102 : : const rtl::OUString &table,
103 : : const com::sun::star::uno::Sequence< ::rtl::OUString > &primaryKey)
104 : : : SequenceResultSet( mutex, owner, colNames, data, (*ppSettings)->tc ),
105 : : m_ppSettings( ppSettings ),
106 : : m_schema( schema ),
107 : : m_table( table ),
108 : : m_primaryKey( primaryKey ),
109 : 0 : m_insertRow( false )
110 : : {
111 : : // LEM TODO: this duplicates code in pq_resultset.cxx, except for different value
112 : : // of ResultSetConcurrency. Baaad.
113 : : // Why is an updatable ResultSet a sequenceresultset in the first place?
114 : : // This seems to imply that the whole data is fetched once and kept in memory. BAAAAD.
115 : : // LEM TODO: shouldn't these things be inherited from the statement or something like that?
116 : 0 : sal_Bool b = sal_False;
117 : : // Positioned update/delete not supported, so no cursor name
118 : : // Fetch direction and size are cursor-specific things, so not used now.
119 : : // Fetch size not set
120 : : m_props[ BASERESULTSET_FETCH_DIRECTION ] = com::sun::star::uno::makeAny(
121 : 0 : com::sun::star::sdbc::FetchDirection::UNKNOWN);
122 : : // No escape processing for now
123 : 0 : m_props[ BASERESULTSET_ESCAPE_PROCESSING ] = com::sun::star::uno::Any( &b, getBooleanCppuType() );
124 : : // Bookmarks not implemented for now
125 : 0 : m_props[ BASERESULTSET_IS_BOOKMARKABLE ] = com::sun::star::uno::Any( &b, getBooleanCppuType() );
126 : : m_props[ BASERESULTSET_RESULT_SET_CONCURRENCY ] = com::sun::star::uno::makeAny(
127 : 0 : com::sun::star::sdbc::ResultSetConcurrency::UPDATABLE );
128 : : m_props[ BASERESULTSET_RESULT_SET_TYPE ] = com::sun::star::uno::makeAny(
129 : 0 : com::sun::star::sdbc::ResultSetType::SCROLL_INSENSITIVE );
130 : 0 : }
131 : :
132 : : rtl::OUString buildWhereClause();
133 : : void checkUpdate( sal_Int32 column );
134 : :
135 : : public:
136 : : static com::sun::star::uno::Reference< com::sun::star::sdbc::XCloseable > createFromPGResultSet(
137 : : const ::rtl::Reference< RefCountedMutex > & mutex,
138 : : const com::sun::star::uno::Reference< com::sun::star::uno::XInterface > &owner,
139 : : ConnectionSettings **ppSettings,
140 : : PGresult *result,
141 : : const rtl::OUString &schema,
142 : : const rtl::OUString &table,
143 : : const com::sun::star::uno::Sequence< ::rtl::OUString > &primaryKey );
144 : :
145 : : public: // XInterface
146 : 0 : virtual void SAL_CALL acquire() throw() { SequenceResultSet::acquire(); }
147 : 0 : virtual void SAL_CALL release() throw() { SequenceResultSet::release(); }
148 : : virtual com::sun::star::uno::Any SAL_CALL queryInterface(
149 : : const com::sun::star::uno::Type & reqType )
150 : : throw (com::sun::star::uno::RuntimeException);
151 : :
152 : : public: // XTypeProvider
153 : : virtual com::sun::star::uno::Sequence< com::sun::star::uno::Type > SAL_CALL getTypes()
154 : : throw( com::sun::star::uno::RuntimeException );
155 : : virtual com::sun::star::uno::Sequence< sal_Int8> SAL_CALL getImplementationId()
156 : : throw( com::sun::star::uno::RuntimeException );
157 : :
158 : : public: // XResultSetUpdate
159 : : virtual void SAL_CALL insertRow( ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
160 : : virtual void SAL_CALL updateRow( ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
161 : : virtual void SAL_CALL deleteRow( ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
162 : : virtual void SAL_CALL cancelRowUpdates( ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
163 : : virtual void SAL_CALL moveToInsertRow( ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
164 : : virtual void SAL_CALL moveToCurrentRow( ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
165 : :
166 : : public: // XRowUpdate
167 : : virtual void SAL_CALL updateNull( sal_Int32 columnIndex ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
168 : : virtual void SAL_CALL updateBoolean( sal_Int32 columnIndex, sal_Bool x ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
169 : : virtual void SAL_CALL updateByte( sal_Int32 columnIndex, sal_Int8 x ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
170 : : virtual void SAL_CALL updateShort( sal_Int32 columnIndex, sal_Int16 x ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
171 : : virtual void SAL_CALL updateInt( sal_Int32 columnIndex, sal_Int32 x ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
172 : : virtual void SAL_CALL updateLong( sal_Int32 columnIndex, sal_Int64 x ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
173 : : virtual void SAL_CALL updateFloat( sal_Int32 columnIndex, float x ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
174 : : virtual void SAL_CALL updateDouble( sal_Int32 columnIndex, double x ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
175 : : virtual void SAL_CALL updateString( sal_Int32 columnIndex, const ::rtl::OUString& x ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
176 : : virtual void SAL_CALL updateBytes( sal_Int32 columnIndex, const ::com::sun::star::uno::Sequence< sal_Int8 >& x ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
177 : : virtual void SAL_CALL updateDate( sal_Int32 columnIndex, const ::com::sun::star::util::Date& x ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
178 : : virtual void SAL_CALL updateTime( sal_Int32 columnIndex, const ::com::sun::star::util::Time& x ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
179 : : virtual void SAL_CALL updateTimestamp( sal_Int32 columnIndex, const ::com::sun::star::util::DateTime& x ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
180 : : virtual void SAL_CALL updateBinaryStream( sal_Int32 columnIndex, const ::com::sun::star::uno::Reference< ::com::sun::star::io::XInputStream >& x, sal_Int32 length ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
181 : : virtual void SAL_CALL updateCharacterStream( sal_Int32 columnIndex, const ::com::sun::star::uno::Reference< ::com::sun::star::io::XInputStream >& x, sal_Int32 length ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
182 : : virtual void SAL_CALL updateObject( sal_Int32 columnIndex, const ::com::sun::star::uno::Any& x ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
183 : : virtual void SAL_CALL updateNumericObject( sal_Int32 columnIndex, const ::com::sun::star::uno::Any& x, sal_Int32 scale ) throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
184 : :
185 : : public: // XResultSetMetaDataSupplier
186 : : virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSetMetaData > SAL_CALL getMetaData( )
187 : : throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
188 : :
189 : :
190 : : static com::sun::star::uno::Sequence< com::sun::star::uno::Type > getStaticTypes( bool updateable )
191 : : throw( com::sun::star::uno::RuntimeException );
192 : :
193 : : };
194 : :
195 : :
196 : :
197 : : }
|