1 /************************************************************** 2 * 3 * Licensed to the Apache Software Foundation (ASF) under one 4 * or more contributor license agreements. See the NOTICE file 5 * distributed with this work for additional information 6 * regarding copyright ownership. The ASF licenses this file 7 * to you under the Apache License, Version 2.0 (the 8 * "License"); you may not use this file except in compliance 9 * with the License. You may obtain a copy of the License at 10 * 11 * http://www.apache.org/licenses/LICENSE-2.0 12 * 13 * Unless required by applicable law or agreed to in writing, 14 * software distributed under the License is distributed on an 15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16 * KIND, either express or implied. See the License for the 17 * specific language governing permissions and limitations 18 * under the License. 19 * 20 *************************************************************/ 21 22 23 24 #ifndef _CONNECTIVITY_EVOAB_DATABASEMETADATA_HXX_ 25 #define _CONNECTIVITY_EVOAB_DATABASEMETADATA_HXX_ 26 27 #ifndef _CONNECTIVITY_EVOAB_DEBUG_HXX_ 28 #include "NDebug.hxx" 29 #endif 30 #include "NConnection.hxx" 31 #include "TDatabaseMetaDataBase.hxx" 32 #include "FDatabaseMetaDataResultSet.hxx" 33 34 35 namespace connectivity 36 { 37 namespace evoab 38 { 39 class EvoContacts; 40 41 42 //************************************************************** 43 //************ Class: OEvoabDatabaseMetaData 44 //************************************************************** 45 typedef struct{ 46 gboolean bIsSplittedValue; 47 GParamSpec *pField; 48 }ColumnProperty; 49 50 typedef enum { 51 DEFAULT_ADDR_LINE1=1,DEFAULT_ADDR_LINE2,DEFAULT_CITY,DEFAULT_STATE,DEFAULT_COUNTRY,DEFAULT_ZIP, 52 WORK_ADDR_LINE1,WORK_ADDR_LINE2,WORK_CITY,WORK_STATE,WORK_COUNTRY,WORK_ZIP, 53 HOME_ADDR_LINE1,HOME_ADDR_LINE2,HOME_CITY,HOME_STATE,HOME_COUNTRY,HOME_ZIP, 54 OTHER_ADDR_LINE1,OTHER_ADDR_LINE2,OTHER_CITY,OTHER_STATE,OTHER_COUNTRY,OTHER_ZIP 55 }ColumnNumber; 56 57 typedef struct { 58 const gchar *pColumnName; 59 ColumnNumber value; 60 }SplitEvoColumns; 61 62 const SplitEvoColumns* get_evo_addr(); 63 64 const ColumnProperty *getField(guint n); 65 guint getFieldCount() ; 66 GType getGFieldType(guint nCol) ; 67 sal_Int32 getFieldType(guint nCol) ; 68 rtl::OUString getFieldTypeName(guint nCol) ; 69 rtl::OUString getFieldName(guint nCol) ; 70 guint findEvoabField(const rtl::OUString& aColName); 71 72 void free_column_resources(); 73 74 class OEvoabDatabaseMetaData : public ODatabaseMetaDataBase 75 { 76 OEvoabConnection* m_pConnection; 77 78 ODatabaseMetaDataResultSet::ORows& getColumnRows( const ::rtl::OUString& columnNamePattern ); 79 80 protected: 81 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > impl_getTypeInfo_throw(); 82 // cached database information 83 virtual ::rtl::OUString impl_getIdentifierQuoteString_throw( ); 84 virtual sal_Bool impl_isCatalogAtStart_throw( ); 85 virtual ::rtl::OUString impl_getCatalogSeparator_throw( ); 86 virtual sal_Bool impl_supportsCatalogsInTableDefinitions_throw( ); 87 virtual sal_Bool impl_supportsSchemasInTableDefinitions_throw( ) ; 88 virtual sal_Bool impl_supportsCatalogsInDataManipulation_throw( ); 89 virtual sal_Bool impl_supportsSchemasInDataManipulation_throw( ) ; 90 virtual sal_Bool impl_supportsMixedCaseQuotedIdentifiers_throw( ) ; 91 virtual sal_Bool impl_supportsAlterTableWithAddColumn_throw( ); 92 virtual sal_Bool impl_supportsAlterTableWithDropColumn_throw( ); 93 virtual sal_Int32 impl_getMaxStatements_throw( ); 94 virtual sal_Int32 impl_getMaxTablesInSelect_throw( ); 95 virtual sal_Bool impl_storesMixedCaseQuotedIdentifiers_throw( ); 96 97 virtual ~OEvoabDatabaseMetaData(); 98 public: 99 inline OEvoabConnection* getOwnConnection() const { return m_pConnection; } 100 101 OEvoabDatabaseMetaData(OEvoabConnection* _pCon); 102 103 // as I mentioned before this interface is really BIG 104 // XDatabaseMetaData 105 virtual sal_Bool SAL_CALL allProceduresAreCallable( ); 106 virtual sal_Bool SAL_CALL allTablesAreSelectable( ); 107 virtual ::rtl::OUString SAL_CALL getURL( ); 108 virtual ::rtl::OUString SAL_CALL getUserName( ); 109 virtual sal_Bool SAL_CALL isReadOnly( ); 110 virtual sal_Bool SAL_CALL nullsAreSortedHigh( ); 111 virtual sal_Bool SAL_CALL nullsAreSortedLow( ); 112 virtual sal_Bool SAL_CALL nullsAreSortedAtStart( ); 113 virtual sal_Bool SAL_CALL nullsAreSortedAtEnd( ); 114 virtual ::rtl::OUString SAL_CALL getDatabaseProductName( ); 115 virtual ::rtl::OUString SAL_CALL getDatabaseProductVersion( ); 116 virtual ::rtl::OUString SAL_CALL getDriverName( ); 117 virtual ::rtl::OUString SAL_CALL getDriverVersion( ); 118 virtual sal_Int32 SAL_CALL getDriverMajorVersion( ); 119 virtual sal_Int32 SAL_CALL getDriverMinorVersion( ); 120 virtual sal_Bool SAL_CALL usesLocalFiles( ); 121 virtual sal_Bool SAL_CALL usesLocalFilePerTable( ); 122 virtual sal_Bool SAL_CALL supportsMixedCaseIdentifiers( ); 123 virtual sal_Bool SAL_CALL storesUpperCaseIdentifiers( ); 124 virtual sal_Bool SAL_CALL storesLowerCaseIdentifiers( ); 125 virtual sal_Bool SAL_CALL storesMixedCaseIdentifiers( ); 126 127 virtual sal_Bool SAL_CALL storesUpperCaseQuotedIdentifiers( ); 128 virtual sal_Bool SAL_CALL storesLowerCaseQuotedIdentifiers( ); 129 130 virtual ::rtl::OUString SAL_CALL getSQLKeywords( ); 131 virtual ::rtl::OUString SAL_CALL getNumericFunctions( ); 132 virtual ::rtl::OUString SAL_CALL getStringFunctions( ); 133 virtual ::rtl::OUString SAL_CALL getSystemFunctions( ); 134 virtual ::rtl::OUString SAL_CALL getTimeDateFunctions( ); 135 virtual ::rtl::OUString SAL_CALL getSearchStringEscape( ); 136 virtual ::rtl::OUString SAL_CALL getExtraNameCharacters( ); 137 virtual sal_Bool SAL_CALL supportsColumnAliasing( ); 138 virtual sal_Bool SAL_CALL nullPlusNonNullIsNull( ); 139 virtual sal_Bool SAL_CALL supportsTypeConversion( ); 140 virtual sal_Bool SAL_CALL supportsConvert( sal_Int32 fromType, sal_Int32 toType ); 141 virtual sal_Bool SAL_CALL supportsTableCorrelationNames( ); 142 virtual sal_Bool SAL_CALL supportsDifferentTableCorrelationNames( ); 143 virtual sal_Bool SAL_CALL supportsExpressionsInOrderBy( ); 144 virtual sal_Bool SAL_CALL supportsOrderByUnrelated( ); 145 virtual sal_Bool SAL_CALL supportsGroupBy( ); 146 virtual sal_Bool SAL_CALL supportsGroupByUnrelated( ); 147 virtual sal_Bool SAL_CALL supportsGroupByBeyondSelect( ); 148 virtual sal_Bool SAL_CALL supportsLikeEscapeClause( ); 149 virtual sal_Bool SAL_CALL supportsMultipleResultSets( ); 150 virtual sal_Bool SAL_CALL supportsMultipleTransactions( ); 151 virtual sal_Bool SAL_CALL supportsNonNullableColumns( ); 152 virtual sal_Bool SAL_CALL supportsMinimumSQLGrammar( ); 153 virtual sal_Bool SAL_CALL supportsCoreSQLGrammar( ); 154 virtual sal_Bool SAL_CALL supportsExtendedSQLGrammar( ); 155 virtual sal_Bool SAL_CALL supportsANSI92EntryLevelSQL( ); 156 virtual sal_Bool SAL_CALL supportsANSI92IntermediateSQL( ); 157 virtual sal_Bool SAL_CALL supportsANSI92FullSQL( ); 158 virtual sal_Bool SAL_CALL supportsIntegrityEnhancementFacility( ); 159 virtual sal_Bool SAL_CALL supportsOuterJoins( ); 160 virtual sal_Bool SAL_CALL supportsFullOuterJoins( ); 161 virtual sal_Bool SAL_CALL supportsLimitedOuterJoins( ); 162 virtual ::rtl::OUString SAL_CALL getSchemaTerm( ); 163 virtual ::rtl::OUString SAL_CALL getProcedureTerm( ); 164 virtual ::rtl::OUString SAL_CALL getCatalogTerm( ); 165 virtual sal_Bool SAL_CALL supportsSchemasInProcedureCalls( ); 166 virtual sal_Bool SAL_CALL supportsSchemasInIndexDefinitions( ); 167 virtual sal_Bool SAL_CALL supportsSchemasInPrivilegeDefinitions( ); 168 virtual sal_Bool SAL_CALL supportsCatalogsInProcedureCalls( ); 169 virtual sal_Bool SAL_CALL supportsCatalogsInIndexDefinitions( ); 170 virtual sal_Bool SAL_CALL supportsCatalogsInPrivilegeDefinitions( ); 171 virtual sal_Bool SAL_CALL supportsPositionedDelete( ); 172 virtual sal_Bool SAL_CALL supportsPositionedUpdate( ); 173 virtual sal_Bool SAL_CALL supportsSelectForUpdate( ); 174 virtual sal_Bool SAL_CALL supportsStoredProcedures( ); 175 virtual sal_Bool SAL_CALL supportsSubqueriesInComparisons( ); 176 virtual sal_Bool SAL_CALL supportsSubqueriesInExists( ); 177 virtual sal_Bool SAL_CALL supportsSubqueriesInIns( ); 178 virtual sal_Bool SAL_CALL supportsSubqueriesInQuantifieds( ); 179 virtual sal_Bool SAL_CALL supportsCorrelatedSubqueries( ); 180 virtual sal_Bool SAL_CALL supportsUnion( ); 181 virtual sal_Bool SAL_CALL supportsUnionAll( ); 182 virtual sal_Bool SAL_CALL supportsOpenCursorsAcrossCommit( ); 183 virtual sal_Bool SAL_CALL supportsOpenCursorsAcrossRollback( ); 184 virtual sal_Bool SAL_CALL supportsOpenStatementsAcrossCommit( ); 185 virtual sal_Bool SAL_CALL supportsOpenStatementsAcrossRollback( ); 186 virtual sal_Int32 SAL_CALL getMaxBinaryLiteralLength( ); 187 virtual sal_Int32 SAL_CALL getMaxCharLiteralLength( ); 188 virtual sal_Int32 SAL_CALL getMaxColumnNameLength( ); 189 virtual sal_Int32 SAL_CALL getMaxColumnsInGroupBy( ); 190 virtual sal_Int32 SAL_CALL getMaxColumnsInIndex( ); 191 virtual sal_Int32 SAL_CALL getMaxColumnsInOrderBy( ); 192 virtual sal_Int32 SAL_CALL getMaxColumnsInSelect( ); 193 virtual sal_Int32 SAL_CALL getMaxColumnsInTable( ); 194 virtual sal_Int32 SAL_CALL getMaxConnections( ); 195 virtual sal_Int32 SAL_CALL getMaxCursorNameLength( ); 196 virtual sal_Int32 SAL_CALL getMaxIndexLength( ); 197 virtual sal_Int32 SAL_CALL getMaxSchemaNameLength( ); 198 virtual sal_Int32 SAL_CALL getMaxProcedureNameLength( ); 199 virtual sal_Int32 SAL_CALL getMaxCatalogNameLength( ); 200 virtual sal_Int32 SAL_CALL getMaxRowSize( ); 201 virtual sal_Bool SAL_CALL doesMaxRowSizeIncludeBlobs( ); 202 virtual sal_Int32 SAL_CALL getMaxStatementLength( ); 203 virtual sal_Int32 SAL_CALL getMaxTableNameLength( ); 204 virtual sal_Int32 SAL_CALL getMaxUserNameLength( ); 205 virtual sal_Int32 SAL_CALL getDefaultTransactionIsolation( ); 206 virtual sal_Bool SAL_CALL supportsTransactions( ); 207 virtual sal_Bool SAL_CALL supportsTransactionIsolationLevel( sal_Int32 level ); 208 virtual sal_Bool SAL_CALL supportsDataDefinitionAndDataManipulationTransactions( ); 209 virtual sal_Bool SAL_CALL supportsDataManipulationTransactionsOnly( ); 210 virtual sal_Bool SAL_CALL dataDefinitionCausesTransactionCommit( ); 211 virtual sal_Bool SAL_CALL dataDefinitionIgnoredInTransactions( ); 212 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getTables( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schemaPattern, const ::rtl::OUString& tableNamePattern, const ::com::sun::star::uno::Sequence< ::rtl::OUString >& types ); 213 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getTableTypes( ); 214 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getColumns( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schemaPattern, const ::rtl::OUString& tableNamePattern, const ::rtl::OUString& columnNamePattern ); 215 virtual sal_Bool SAL_CALL supportsResultSetType( sal_Int32 setType ); 216 virtual sal_Bool SAL_CALL supportsResultSetConcurrency( sal_Int32 setType, sal_Int32 concurrency ); 217 virtual sal_Bool SAL_CALL ownUpdatesAreVisible( sal_Int32 setType ); 218 virtual sal_Bool SAL_CALL ownDeletesAreVisible( sal_Int32 setType ); 219 virtual sal_Bool SAL_CALL ownInsertsAreVisible( sal_Int32 setType ); 220 virtual sal_Bool SAL_CALL othersUpdatesAreVisible( sal_Int32 setType ); 221 virtual sal_Bool SAL_CALL othersDeletesAreVisible( sal_Int32 setType ); 222 virtual sal_Bool SAL_CALL othersInsertsAreVisible( sal_Int32 setType ); 223 virtual sal_Bool SAL_CALL updatesAreDetected( sal_Int32 setType ); 224 virtual sal_Bool SAL_CALL deletesAreDetected( sal_Int32 setType ); 225 virtual sal_Bool SAL_CALL insertsAreDetected( sal_Int32 setType ); 226 virtual sal_Bool SAL_CALL supportsBatchUpdates( ); 227 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getUDTs( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schemaPattern, const ::rtl::OUString& typeNamePattern, const ::com::sun::star::uno::Sequence< sal_Int32 >& types ); 228 }; 229 } 230 } 231 232 #endif // _CONNECTIVITY_EVOAB_DATABASEMETADATA_HXX_ 233