Lines Matching refs:aSql
110 ::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()
173 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("DROP "); in dropObject()
179 aSql += ::rtl::OUString::createFromAscii("VIEW "); in dropObject()
181 aSql += ::rtl::OUString::createFromAscii("TABLE "); in dropObject()
183 …aSql += m_xMetaData->getIdentifierQuoteString( ) + aSchema + m_xMetaData->getIdentifierQuoteStrin… in dropObject()
184 aSql += sDot; in dropObject()
185 …aSql += m_xMetaData->getIdentifierQuoteString( ) + aName + m_xMetaData->getIdentifierQuoteString(… in dropObject()
186 xStmt->execute(aSql); in dropObject()
200 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("CREATE TABLE "); in createTable()
207 aSql += ::dbtools::quoteName(aQuote, sSchema) + sDot; in createTable()
213 …aSql += ::dbtools::quoteName(aQuote, getString(descriptor->getPropertyValue(OMetaConnection::getPr… in createTable()
231 …aSql += aQuote + getString(xColProp->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex… in createTable()
233 aSql += ::rtl::OUString::createFromAscii(" "); in createTable()
234 aSql += OTables::getColumnSqlType(xColProp); in createTable()
235 aSql += OTables::getColumnSqlNotNullDefault(xColProp); in createTable()
236 aSql += ::rtl::OUString::createFromAscii(","); in createTable()
266 aSql += ::rtl::OUString::createFromAscii(" PRIMARY KEY ("); in createTable()
270 …aSql += aQuote + getString(xColProp->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex… in createTable()
274 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString::createFromAscii(")")); in createTable()
283 aSql += ::rtl::OUString::createFromAscii(" UNIQUE ("); in createTable()
287 …aSql += aQuote + getString(xColProp->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex… in createTable()
291 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString::createFromAscii(")")); in createTable()
302 aSql += ::rtl::OUString::createFromAscii(" FOREIGN KEY "); in createTable()
308 aSql += aQuote + aSchema + aQuote + sDot in createTable()
315 …aSql += aQuote + getString(xColProp->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex… in createTable()
319 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString::createFromAscii(")")); in createTable()
324 aSql += ::rtl::OUString::createFromAscii(" ON DELETE CASCADE "); in createTable()
327 aSql += ::rtl::OUString::createFromAscii(" ON DELETE RESTRICT "); in createTable()
330 aSql += ::rtl::OUString::createFromAscii(" ON DELETE SET NULL "); in createTable()
333 aSql += ::rtl::OUString::createFromAscii(" ON DELETE SET DEFAULT "); in createTable()
343 if(aSql.lastIndexOf(',') == (aSql.getLength()-1)) in createTable()
344 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString::createFromAscii(")")); in createTable()
346 aSql += ::rtl::OUString::createFromAscii(")"); in createTable()
350 xStmt->execute(aSql); in createTable()