Home
last modified time | relevance | path

Searched refs:aSql (Results 1 – 25 of 33) sorted by relevance

12

/AOO41X/main/connectivity/source/drivers/adabas/
H A DBTables.cxx110 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("CREATE TABLE "); in setComments()
116 aSql = ::rtl::OUString::createFromAscii("COMMENT ON TABLE "); in setComments()
120 aSql += ::dbtools::quoteName(aQuote, sSchema) + sDot; in setComments()
122 …aSql += aQuote + getString(descriptor->getPropertyValue(OMetaConnection::getPropMap().getNameByInd… in setComments()
126 xStmt->execute(aSql); in setComments()
133 aSql = ::rtl::OUString::createFromAscii("COMMENT ON COLUMN "); in setComments()
135 aSql += ::dbtools::quoteName(aQuote, sSchema) + sDot; in setComments()
136 …aSql += aQuote + getString(descriptor->getPropertyValue(OMetaConnection::getPropMap().getNameByInd… in setComments()
147 …::rtl::OUString aCom = aSql + getString(xColProp->getPropertyValue(OMetaConnection::getPropMap().g… in setComments()
151 xStmt->execute(aSql); in setComments()
[all …]
H A DBIndexes.cxx103 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("CREATE "); in appendObject()
108 aSql = aSql + ::rtl::OUString::createFromAscii("UNIQUE "); in appendObject()
109 aSql = aSql + ::rtl::OUString::createFromAscii("INDEX "); in appendObject()
114 aSql = aSql + aQuote + _rForName + aQuote in appendObject()
127 …aSql = aSql + aQuote + getString(xColProp->getPropertyValue(OMetaConnection::getPropMap().getNameB… in appendObject()
128 …aSql = aSql + (getBOOL(xColProp->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(P… in appendObject()
135 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString::createFromAscii(")")); in appendObject()
139 …aSql = aSql + aQuote + m_pTable->getSchema() + aQuote + sDot + aQuote + m_pTable->getTableName() +… in appendObject()
149 …aSql = aSql + sDot + aQuote + getString(xColProp->getPropertyValue(OMetaConnection::getPropMap().g… in appendObject()
153 xStmt->execute(aSql); in appendObject()
[all …]
H A DBKeys.cxx63 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("ALTER TABLE "); in appendObject()
67 …aSql += composeTableName( getTable()->getConnection()->getMetaData(), getTable(), ::dbtools::eInTa… in appendObject()
71 aSql = aSql + ::rtl::OUString::createFromAscii(" ALTER PRIMARY KEY ("); in appendObject()
75 aSql = aSql + ::rtl::OUString::createFromAscii(" FOREIGN KEY ("); in appendObject()
87 …aSql = aSql + aQuote + getString(xColProp->getPropertyValue(OMetaConnection::getPropMap().getNameB… in appendObject()
90 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString::createFromAscii(")")); in appendObject()
104 aSql += ::rtl::OUString::createFromAscii(" REFERENCES ") in appendObject()
106 aSql += ::rtl::OUString::createFromAscii(" ("); in appendObject()
112 …aSql = aSql + aQuote + getString(xColProp->getPropertyValue(OMetaConnection::getPropMap().getNameB… in appendObject()
115 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString::createFromAscii(")")); in appendObject()
[all …]
H A DBColumns.cxx128 ::rtl::OUString aSql(RTL_CONSTASCII_USTRINGPARAM("ALTER TABLE ")); in appendObject()
135 …aSql += ::dbtools::quoteName(sQuote,m_pTable->getSchema()) + sDot + ::dbtools::quoteName(sQuote,m_… in appendObject()
136 aSql += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(" ADD (")); in appendObject()
137 aSql += ::dbtools::quoteName(sQuote,_rForName); in appendObject()
138 aSql += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(" ")); in appendObject()
139 aSql += OTables::getColumnSqlType(descriptor); in appendObject()
140 aSql += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(" )")); in appendObject()
143 xStmt->execute(aSql); in appendObject()
164 ::rtl::OUString aSql(RTL_CONSTASCII_USTRINGPARAM("ALTER TABLE ")); in dropObject()
168 …aSql += ::dbtools::quoteName(sQuote,m_pTable->getSchema()) + sDot + ::dbtools::quoteName(sQuote,m_… in dropObject()
[all …]
H A DBViews.cxx140 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("DROP VIEW"); in dropObject()
143 …aSql = aSql + m_xMetaData->getIdentifierQuoteString( ) + aSchema + m_xMetaData->getIdentifierQuot… in dropObject()
144 aSql = aSql + sDot; in dropObject()
145 …aSql = aSql + m_xMetaData->getIdentifierQuoteString( ) + aName + m_xMetaData->getIdentifierQuoteS… in dropObject()
146 xStmt->execute(aSql); in dropObject()
160 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("CREATE VIEW "); in createView()
167 aSql += ::dbtools::quoteName(aQuote, sSchema) + sDot; in createView()
171 …aSql += ::dbtools::quoteName(aQuote, getString(descriptor->getPropertyValue(OMetaConnection::getPr… in createView()
174 aSql += sCommand; in createView()
178 xStmt->execute(aSql); in createView()
H A DBGroups.cxx63 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("CREATE USERGROUP "); in appendObject()
66 aSql = aSql + aQuote + _rForName + aQuote; in appendObject()
69 xStmt->execute(aSql); in appendObject()
78 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("DROP USERGROUP "); in dropObject()
81 aSql = aSql + aQuote + _sElementName + aQuote; in dropObject()
84 xStmt->execute(aSql); in dropObject()
H A DBUsers.cxx67 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("CREATE USER "); in appendObject()
73 aSql += ::dbtools::quoteName(aQuote,sUserName) in appendObject()
76 aSql += ::rtl::OUString::createFromAscii(" RESOURCE NOT EXCLUSIVE"); in appendObject()
80 xStmt->execute(aSql); in appendObject()
113 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("DROP USER "); in dropObject()
115 aSql += ::dbtools::quoteName(aQuote,_sElementName); in dropObject()
119 xStmt->execute(aSql); in dropObject()
H A DBGroup.cxx70 …::rtl::OUString aSql = ::rtl::OUString::createFromAscii("SELECT DISTINCT USERNAME FROM DOMAIN.USER… in refreshUsers()
71 aSql += getName( ); in refreshUsers()
72 aSql += ::rtl::OUString::createFromAscii("'"); in refreshUsers()
74 Reference< XResultSet > xResult = xStmt->executeQuery(aSql); in refreshUsers()
H A DBUser.cxx67 …::rtl::OUString aSql = ::rtl::OUString::createFromAscii("SELECT DISTINCT GROUPNAME FROM DOMAIN.USE… in refreshGroups()
68 aSql += getName( ); in refreshGroups()
69 aSql += ::rtl::OUString::createFromAscii("'"); in refreshGroups()
71 Reference< XResultSet > xResult = xStmt->executeQuery(aSql); in refreshGroups()
/AOO41X/main/connectivity/source/commontools/
H A Ddbtools2.cxx82 …::rtl::OUStringBuffer aSql = ::dbtools::quoteName(sQuoteString,::comphelper::getString(xColProp->g… in createStandardColumnPart()
84 aSql.appendAscii(" "); in createStandardColumnPart()
138 aSql.append(sTypeName); in createStandardColumnPart()
139 aSql.appendAscii("("); in createStandardColumnPart()
143 aSql.append(sTypeName.copy(0,++nParenPos)); in createStandardColumnPart()
148 aSql.append(nPrecision); in createStandardColumnPart()
150 aSql.appendAscii(","); in createStandardColumnPart()
153 aSql.append(nScale); in createStandardColumnPart()
156 aSql.appendAscii(")"); in createStandardColumnPart()
160 aSql.append(sTypeName.copy(nParenPos)); in createStandardColumnPart()
[all …]
H A DTKeys.cxx166 ::rtl::OUStringBuffer aSql; in appendObject()
167 aSql.appendAscii("ALTER TABLE "); in appendObject()
171 …aSql.append(composeTableName( m_pTable->getConnection()->getMetaData(), m_pTable, ::dbtools::eInTa… in appendObject()
172 aSql.appendAscii(" ADD "); in appendObject()
176 aSql.appendAscii(" PRIMARY KEY ("); in appendObject()
180 aSql.appendAscii(" FOREIGN KEY ("); in appendObject()
191 aSql.appendAscii(","); in appendObject()
193 …aSql.append( ::dbtools::quoteName( aQuote,getString(xColProp->getPropertyValue(rPropMap.getNameByI… in appendObject()
196 aSql.appendAscii(")"); in appendObject()
200 aSql.appendAscii(" REFERENCES "); in appendObject()
[all …]
H A DTIndexes.cxx146 ::rtl::OUStringBuffer aSql( ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("CREATE "))); in appendObject()
151 aSql.appendAscii("UNIQUE "); in appendObject()
152 aSql.appendAscii("INDEX "); in appendObject()
162 aSql.append( ::dbtools::quoteName( aQuote, _rForName ) ); in appendObject()
163 aSql.appendAscii(" ON "); in appendObject()
164 aSql.append(aComposedName); in appendObject()
165 aSql.appendAscii(" ( "); in appendObject()
175 …aSql.append(::dbtools::quoteName( aQuote,comphelper::getString(xColProp->getPropertyValue(rPropMap… in appendObject()
180 …aSql.appendAscii(any2bool(xColProp->getPropertyValue(rPropMap.getNameByIndex(PROPERTY_ID_ISASCENDI… in appendObject()
186 aSql.appendAscii(","); in appendObject()
[all …]
H A DTColumnsHelper.cxx180 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("ALTER TABLE "); in appendObject()
183 …aSql += ::dbtools::composeTableName( xMetaData, m_pTable, ::dbtools::eInTableDefinitions, false, f… in appendObject()
184 aSql += ::rtl::OUString::createFromAscii(" ADD "); in appendObject()
185 …aSql += ::dbtools::createStandardColumnPart(descriptor,m_pTable->getConnection(),NULL,m_pTable->ge… in appendObject()
190 xStmt->execute(aSql); in appendObject()
202 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("ALTER TABLE "); in dropObject()
206 …aSql += ::dbtools::composeTableName( xMetaData, m_pTable, ::dbtools::eInTableDefinitions, false, f… in dropObject()
207 aSql += ::rtl::OUString::createFromAscii(" DROP "); in dropObject()
208 aSql += ::dbtools::quoteName( aQuote,_sElementName); in dropObject()
213 xStmt->execute(aSql); in dropObject()
/AOO41X/main/dbaccess/source/core/api/
H A DCacheSet.cxx203 ::rtl::OUStringBuffer aSql(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("INSERT INTO "))); in insertRow()
207 aSql.append(m_aComposedTableName); in insertRow()
208 aSql.append(::rtl::OUString::createFromAscii(" ( ")); in insertRow()
219 aSql.append(::dbtools::quoteName( aQuote,m_xSetMetaData->getColumnName(i++))); in insertRow()
220 aSql.append(aComma); in insertRow()
224 aSql.setCharAt(aSql.getLength()-1,')'); in insertRow()
227 aSql.append(aValues.makeStringAndClear()); in insertRow()
230 … Reference< XPreparedStatement > xPrep(m_xConnection->prepareStatement(aSql.makeStringAndClear())); in insertRow()
354 ::rtl::OUStringBuffer aSql = ::rtl::OUString::createFromAscii("UPDATE "); in updateRow()
355 aSql.append(m_aComposedTableName); in updateRow()
[all …]
H A DKeySet.cxx449 ::rtl::OUStringBuffer aSql = ::rtl::OUString::createFromAscii("DELETE FROM "); in deleteRows()
450 aSql.append(m_aComposedTableName); in deleteRows()
451 aSql.append(::rtl::OUString::createFromAscii(" WHERE ")); in deleteRows()
483 aSql.append(sCon); in deleteRows()
484 aSql.append(aOr); in deleteRows()
486 aSql.setLength(aSql.getLength()-3); in deleteRows()
490 … Reference< XPreparedStatement > xPrep(m_xConnection->prepareStatement(aSql.makeStringAndClear())); in deleteRows()
537 ::rtl::OUStringBuffer aSql = ::rtl::OUString::createFromAscii("UPDATE "); in updateRow()
538 aSql.append(m_aComposedTableName); in updateRow()
539 aSql.append(::rtl::OUString::createFromAscii(" SET ")); in updateRow()
[all …]
H A DOptimisticSet.cxx195 TSQLStatements aSql; in updateRow() local
221 ::rtl::OUStringBuffer& rPart = aSql[aIter->second.sTableName]; in updateRow()
229 if( aSql.empty() ) in updateRow()
240 TSQLStatements::iterator aSqlIter = aSql.begin(); in updateRow()
241 TSQLStatements::iterator aSqlEnd = aSql.end(); in updateRow()
269 TSQLStatements aSql; in insertRow() local
299 ::rtl::OUStringBuffer& rPart = aSql[aIter->second.sTableName]; in insertRow()
315 TSQLStatements::iterator aSqlIter = aSql.begin(); in insertRow()
316 TSQLStatements::iterator aSqlEnd = aSql.end(); in insertRow()
388 TSQLStatements aSql; in deleteRow() local
[all …]
H A Dtablecontainer.cxx321 … ::rtl::OUString aSql = ::dbtools::createSqlCreateTableStatement(descriptor,m_xConnection); in appendObject()
329 xStmt->execute(aSql); in appendObject()
416 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("DROP "); in dropObject()
420 aSql += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("VIEW ")); in dropObject()
422 aSql += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("TABLE ")); in dropObject()
423 aSql += sComposedName; in dropObject()
430 xStmt->execute(aSql); in dropObject()
H A DSingleSelectQueryComposer.cxx596 ::rtl::OUStringBuffer aSql( m_aPureSelectSQL ); in composeStatementFromParts()
600 aSql.append( getKeyword( eLoopParts ) ); in composeStatementFromParts()
601 aSql.append( _rParts[ eLoopParts ] ); in composeStatementFromParts()
604 return aSql.makeStringAndClear(); in composeStatementFromParts()
692 ::rtl::OUStringBuffer aSql(m_aPureSelectSQL); in setSingleAdditiveClause()
694 aSql.append(aClauses[ eLoopParts ]); in setSingleAdditiveClause()
697 setQuery_Impl(aSql.makeStringAndClear()); in setSingleAdditiveClause()
707 aSql = m_aPureSelectSQL; in setSingleAdditiveClause()
715 aSql.append(aClauses[ eLoopParts ]); in setSingleAdditiveClause()
718 … parseAndCheck_throwError( m_aSqlParser, aSql.makeStringAndClear(), m_aAdditiveIterator, *this ); in setSingleAdditiveClause()
[all …]
/AOO41X/main/connectivity/source/drivers/mysql/
H A DYUsers.cxx79 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("GRANT USAGE ON * TO "); in appendObject()
82 aSql += ::dbtools::quoteName(aQuote,sUserName) in appendObject()
88 aSql += ::rtl::OUString::createFromAscii(" IDENTIFIED BY '"); in appendObject()
89 aSql += sPassword; in appendObject()
90 aSql += ::rtl::OUString::createFromAscii("'"); in appendObject()
95 xStmt->execute(aSql); in appendObject()
104 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("REVOKE ALL ON * FROM "); in dropObject()
106 aSql += ::dbtools::quoteName(aQuote,_sElementName); in dropObject()
110 xStmt->execute(aSql); in dropObject()
H A DYViews.cxx111 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("DROP VIEW"); in dropObject()
114 …aSql += ::dbtools::composeTableName( m_xMetaData, xProp, ::dbtools::eInTableDefinitions, false, fa… in dropObject()
118 xStmt->execute(aSql); in dropObject()
134 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("CREATE VIEW "); in createView()
138 …aSql += ::dbtools::composeTableName( m_xMetaData, descriptor, ::dbtools::eInTableDefinitions, fals… in createView()
140 aSql += ::rtl::OUString::createFromAscii(" AS "); in createView()
142 aSql += sCommand; in createView()
147 xStmt->execute(aSql); in createView()
H A DYTables.cxx155 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("DROP "); in dropObject()
160 aSql += ::rtl::OUString::createFromAscii("VIEW "); in dropObject()
162 aSql += ::rtl::OUString::createFromAscii("TABLE "); in dropObject()
166 aSql += sComposedName; in dropObject()
170 xStmt->execute(aSql); in dropObject()
203 …const ::rtl::OUString aSql = adjustSQL(::dbtools::createSqlCreateTableStatement(descriptor,xConnec… in createTable() local
207 xStmt->execute(aSql); in createTable()
/AOO41X/main/connectivity/source/drivers/hsqldb/
H A DHUsers.cxx79 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("GRANT USAGE ON * TO "); in appendObject()
82 aSql += ::dbtools::quoteName(aQuote,sUserName) in appendObject()
88 aSql += ::rtl::OUString::createFromAscii(" IDENTIFIED BY '"); in appendObject()
89 aSql += sPassword; in appendObject()
90 aSql += ::rtl::OUString::createFromAscii("'"); in appendObject()
95 xStmt->execute(aSql); in appendObject()
105 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("REVOKE ALL ON * FROM "); in dropObject()
107 aSql += ::dbtools::quoteName(aQuote,_sElementName); in dropObject()
111 xStmt->execute(aSql); in dropObject()
H A DHViews.cxx117 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("DROP VIEW"); in dropObject()
120 …aSql += ::dbtools::composeTableName( m_xMetaData, xProp, ::dbtools::eInTableDefinitions, false, fa… in dropObject()
124 xStmt->execute(aSql); in dropObject()
140 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("CREATE VIEW "); in createView()
144 …aSql += ::dbtools::composeTableName( m_xMetaData, descriptor, ::dbtools::eInTableDefinitions, fals… in createView()
146 aSql += ::rtl::OUString::createFromAscii(" AS "); in createView()
148 aSql += sCommand; in createView()
153 xStmt->execute(aSql); in createView()
H A DHTables.cxx138 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("DROP "); in dropObject()
143 aSql += ::rtl::OUString::createFromAscii("VIEW "); in dropObject()
145 aSql += ::rtl::OUString::createFromAscii("TABLE "); in dropObject()
149 aSql += sComposedName; in dropObject()
153 xStmt->execute(aSql); in dropObject()
169 ::rtl::OUString aSql = ::dbtools::createSqlCreateTableStatement(descriptor,xConnection); in createTable()
174 xStmt->execute(aSql); in createTable()
/AOO41X/main/dbaccess/source/ui/misc/
H A DDExport.cxx842 ::rtl::OUString aSql(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("INSERT INTO "))); in createPreparedStatment()
845 aSql += sComposedTableName; in createPreparedStatment()
846 aSql += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(" ( ")); in createPreparedStatment()
886 aSql += *aInsertIter; in createPreparedStatment()
887 aSql += aComma; in createPreparedStatment()
892 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(")"))); in createPreparedStatment()
895 aSql += aValues; in createPreparedStatment()
897 return Reference< XPreparedStatement >(_xMetaData->getConnection()->prepareStatement(aSql)); in createPreparedStatment()

12