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 // MARKER(update_precomp.py): autogen include statement, do not remove 25 #include "precompiled_svx.hxx" 26 27 #include "svx/ParseContext.hxx" 28 #include "stringlistresource.hxx" 29 #include "svx/fmresids.hrc" 30 31 #include <svx/dialmgr.hxx> 32 33 #include <unotools/syslocale.hxx> 34 #include <vcl/svapp.hxx> 35 #include <tools/debug.hxx> 36 #include <vos/mutex.hxx> 37 38 using namespace svxform; 39 using namespace ::connectivity; 40 //========================================================================== 41 //= OSystemParseContext 42 //========================================================================== 43 DBG_NAME(OSystemParseContext) 44 //----------------------------------------------------------------------------- 45 OSystemParseContext::OSystemParseContext() : IParseContext() 46 { 47 DBG_CTOR(OSystemParseContext,NULL); 48 vos::OGuard aGuard( Application::GetSolarMutex() ); 49 50 ::svx::StringListResource aKeywords( SVX_RES( RID_RSC_SQL_INTERNATIONAL ) ); 51 aKeywords.get( m_aLocalizedKeywords ); 52 } 53 54 //----------------------------------------------------------------------------- 55 OSystemParseContext::~OSystemParseContext() 56 { 57 DBG_DTOR(OSystemParseContext,NULL); 58 } 59 60 //----------------------------------------------------------------------------- 61 ::com::sun::star::lang::Locale OSystemParseContext::getPreferredLocale( ) const 62 { 63 return SvtSysLocale().GetLocaleData().getLocale(); 64 } 65 66 //----------------------------------------------------------------------------- 67 ::rtl::OUString OSystemParseContext::getErrorMessage(ErrorCode _eCode) const 68 { 69 String aMsg; 70 vos::OGuard aGuard( Application::GetSolarMutex() ); 71 switch (_eCode) 72 { 73 case ERROR_GENERAL: aMsg = SVX_RES(RID_STR_SVT_SQL_SYNTAX_ERROR); break; 74 case ERROR_VALUE_NO_LIKE: aMsg = SVX_RES(RID_STR_SVT_SQL_SYNTAX_VALUE_NO_LIKE); break; 75 case ERROR_FIELD_NO_LIKE: aMsg = SVX_RES(RID_STR_SVT_SQL_SYNTAX_FIELD_NO_LIKE); break; 76 case ERROR_INVALID_COMPARE: aMsg = SVX_RES(RID_STR_SVT_SQL_SYNTAX_CRIT_NO_COMPARE); break; 77 case ERROR_INVALID_INT_COMPARE: aMsg = SVX_RES(RID_STR_SVT_SQL_SYNTAX_INT_NO_VALID); break; 78 case ERROR_INVALID_DATE_COMPARE: aMsg = SVX_RES(RID_STR_SVT_SQL_SYNTAX_ACCESS_DAT_NO_VALID); break; 79 case ERROR_INVALID_REAL_COMPARE: aMsg = SVX_RES(RID_STR_SVT_SQL_SYNTAX_REAL_NO_VALID); break; 80 case ERROR_INVALID_TABLE: aMsg = SVX_RES(RID_STR_SVT_SQL_SYNTAX_TABLE); break; 81 case ERROR_INVALID_TABLE_OR_QUERY: aMsg = SVX_RES(RID_STR_SVT_SQL_SYNTAX_TABLE_OR_QUERY); break; 82 case ERROR_INVALID_COLUMN: aMsg = SVX_RES(RID_STR_SVT_SQL_SYNTAX_COLUMN); break; 83 case ERROR_INVALID_TABLE_EXIST: aMsg = SVX_RES(RID_STR_SVT_SQL_SYNTAX_TABLE_EXISTS); break; 84 case ERROR_INVALID_QUERY_EXIST: aMsg = SVX_RES(RID_STR_SVT_SQL_SYNTAX_QUERY_EXISTS); break; 85 case ERROR_NONE: break; 86 } 87 return aMsg; 88 } 89 90 //----------------------------------------------------------------------------- 91 ::rtl::OString OSystemParseContext::getIntlKeywordAscii(InternationalKeyCode _eKey) const 92 { 93 size_t nIndex = 0; 94 switch ( _eKey ) 95 { 96 case KEY_LIKE: nIndex = 0; break; 97 case KEY_NOT: nIndex = 1; break; 98 case KEY_NULL: nIndex = 2; break; 99 case KEY_TRUE: nIndex = 3; break; 100 case KEY_FALSE: nIndex = 4; break; 101 case KEY_IS: nIndex = 5; break; 102 case KEY_BETWEEN: nIndex = 6; break; 103 case KEY_OR: nIndex = 7; break; 104 case KEY_AND: nIndex = 8; break; 105 case KEY_AVG: nIndex = 9; break; 106 case KEY_COUNT: nIndex = 10; break; 107 case KEY_MAX: nIndex = 11; break; 108 case KEY_MIN: nIndex = 12; break; 109 case KEY_SUM: nIndex = 13; break; 110 case KEY_EVERY: nIndex = 14; break; 111 case KEY_ANY: nIndex = 15; break; 112 case KEY_SOME: nIndex = 16; break; 113 case KEY_STDDEV_POP: nIndex = 17; break; 114 case KEY_STDDEV_SAMP: nIndex = 18; break; 115 case KEY_VAR_SAMP: nIndex = 19; break; 116 case KEY_VAR_POP: nIndex = 20; break; 117 case KEY_COLLECT: nIndex = 21; break; 118 case KEY_FUSION: nIndex = 22; break; 119 case KEY_INTERSECTION: nIndex = 23; break; 120 case KEY_NONE: 121 DBG_ERROR( "OSystemParseContext::getIntlKeywordAscii: illegal argument!" ); 122 break; 123 } 124 125 OSL_ENSURE( nIndex < m_aLocalizedKeywords.size(), "OSystemParseContext::getIntlKeywordAscii: invalid index!" ); 126 127 ByteString sKeyword; 128 if ( nIndex < m_aLocalizedKeywords.size() ) 129 sKeyword = ByteString( m_aLocalizedKeywords[nIndex], RTL_TEXTENCODING_UTF8 ); 130 return sKeyword; 131 } 132 133 //----------------------------------------------------------------------------- 134 static sal_Unicode lcl_getSeparatorChar( const String& _rSeparator, sal_Unicode _nFallback ) 135 { 136 DBG_ASSERT( 0 < _rSeparator.Len(), "::lcl_getSeparatorChar: invalid decimal separator!" ); 137 138 sal_Unicode nReturn( _nFallback ); 139 if ( _rSeparator.Len() ) 140 nReturn = static_cast< sal_Char >( _rSeparator.GetBuffer( )[0] ); 141 return nReturn; 142 } 143 144 //----------------------------------------------------------------------------- 145 sal_Unicode OSystemParseContext::getNumDecimalSep( ) const 146 { 147 return lcl_getSeparatorChar( SvtSysLocale().GetLocaleData().getNumDecimalSep(), '.' ); 148 } 149 150 //----------------------------------------------------------------------------- 151 sal_Unicode OSystemParseContext::getNumThousandSep( ) const 152 { 153 return lcl_getSeparatorChar( SvtSysLocale().GetLocaleData().getNumThousandSep(), ',' ); 154 } 155 // ----------------------------------------------------------------------------- 156 IParseContext::InternationalKeyCode OSystemParseContext::getIntlKeyCode(const ::rtl::OString& rToken) const 157 { 158 static IParseContext::InternationalKeyCode Intl_TokenID[] = 159 { 160 KEY_LIKE, KEY_NOT, KEY_NULL, KEY_TRUE, 161 KEY_FALSE, KEY_IS, KEY_BETWEEN, KEY_OR, 162 KEY_AND, KEY_AVG, KEY_COUNT, KEY_MAX, 163 KEY_MIN, KEY_SUM, KEY_EVERY, 164 KEY_ANY, KEY_SOME, KEY_STDDEV_POP, 165 KEY_STDDEV_SAMP, KEY_VAR_SAMP, KEY_VAR_POP, 166 KEY_COLLECT, KEY_FUSION, KEY_INTERSECTION 167 }; 168 169 sal_uInt32 nCount = sizeof Intl_TokenID / sizeof Intl_TokenID[0]; 170 for (sal_uInt32 i = 0; i < nCount; i++) 171 { 172 ::rtl::OString aKey = getIntlKeywordAscii(Intl_TokenID[i]); 173 if (rToken.equalsIgnoreAsciiCase(aKey)) 174 return Intl_TokenID[i]; 175 } 176 177 return KEY_NONE; 178 } 179 180 181 // ============================================================================= 182 // ============================================================================= 183 namespace 184 { 185 // ----------------------------------------------------------------------------- 186 ::osl::Mutex& getSafteyMutex() 187 { 188 static ::osl::Mutex s_aSafety; 189 return s_aSafety; 190 } 191 // ----------------------------------------------------------------------------- 192 oslInterlockedCount& getCounter() 193 { 194 static oslInterlockedCount s_nCounter; 195 return s_nCounter; 196 } 197 // ----------------------------------------------------------------------------- 198 OSystemParseContext* getSharedContext(OSystemParseContext* _pContext = NULL,sal_Bool _bSet = sal_False) 199 { 200 static OSystemParseContext* s_pSharedContext = NULL; 201 if ( _pContext && !s_pSharedContext ) 202 { 203 s_pSharedContext = _pContext; 204 return s_pSharedContext; 205 } 206 if ( _bSet ) 207 { 208 OSystemParseContext* pReturn = _pContext ? _pContext : s_pSharedContext; 209 s_pSharedContext = _pContext; 210 return pReturn; 211 } 212 return s_pSharedContext; 213 } 214 // ----------------------------------------------------------------------------- 215 } 216 // ----------------------------------------------------------------------------- 217 OParseContextClient::OParseContextClient() 218 { 219 ::osl::MutexGuard aGuard( getSafteyMutex() ); 220 if ( 1 == osl_incrementInterlockedCount( &getCounter() ) ) 221 { // first instance 222 getSharedContext( new OSystemParseContext ); 223 } 224 } 225 226 // ----------------------------------------------------------------------------- 227 OParseContextClient::~OParseContextClient() 228 { 229 { 230 ::osl::MutexGuard aGuard( getSafteyMutex() ); 231 if ( 0 == osl_decrementInterlockedCount( &getCounter() ) ) 232 delete getSharedContext(NULL,sal_True); 233 } 234 } 235 // ----------------------------------------------------------------------------- 236 const OSystemParseContext* OParseContextClient::getParseContext() const 237 { 238 return getSharedContext(); 239 } 240 // ----------------------------------------------------------------------------- 241 242 243 244 245 246