Lines Matching refs:rtl
55 sdbcx::ObjectType OTables::createObject(const ::rtl::OUString& _rName) in createObject()
57 ::rtl::OUString aName,aSchema; in createObject()
62 Sequence< ::rtl::OUString > aTypes(1); in createObject()
63 aTypes[0] = ::rtl::OUString::createFromAscii("%"); in createObject()
102 sdbcx::ObjectType OTables::appendObject( const ::rtl::OUString& _rForName, const Reference< XProper… in appendObject()
110 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("CREATE TABLE "); in setComments()
111 …::rtl::OUString aQuote = static_cast<OAdabasCatalog&>(m_rParent).getConnection()->getMetaData()->g… in setComments()
112 const ::rtl::OUString& sDot = OAdabasCatalog::getDot(); in setComments()
116 aSql = ::rtl::OUString::createFromAscii("COMMENT ON TABLE "); in setComments()
117 ::rtl::OUString sSchema; in setComments()
123 + ::rtl::OUString::createFromAscii(" '") in setComments()
125 + ::rtl::OUString::createFromAscii("'"); in setComments()
133 aSql = ::rtl::OUString::createFromAscii("COMMENT ON COLUMN "); in setComments()
144 …::rtl::OUString aDescription = getString(xColProp->getPropertyValue(OMetaConnection::getPropMap().… in setComments()
147 …::rtl::OUString aCom = aSql + getString(xColProp->getPropertyValue(OMetaConnection::getPropMap().g… in setComments()
148 + ::rtl::OUString::createFromAscii(" '") in setComments()
150 + ::rtl::OUString::createFromAscii("'"); in setComments()
160 void OTables::dropObject(sal_Int32 _nPos,const ::rtl::OUString _sElementName) in dropObject()
169 ::rtl::OUString aName,aSchema; in dropObject()
173 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("DROP "); in dropObject()
174 const ::rtl::OUString& sDot = OAdabasCatalog::getDot(); in dropObject()
178 …alue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPE))) == ::rtl::OUString::createFr… in dropObject()
179 aSql += ::rtl::OUString::createFromAscii("VIEW "); in dropObject()
181 aSql += ::rtl::OUString::createFromAscii("TABLE "); in dropObject()
200 ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("CREATE TABLE "); in createTable()
201 …::rtl::OUString aQuote = static_cast<OAdabasCatalog&>(m_rParent).getConnection()->getMetaData()->g… in createTable()
202 const ::rtl::OUString& sDot = OAdabasCatalog::getDot(); in createTable()
203 ::rtl::OUString sSchema; in createTable()
214 + ::rtl::OUString::createFromAscii(" ("); in createTable()
233 aSql += ::rtl::OUString::createFromAscii(" "); in createTable()
236 aSql += ::rtl::OUString::createFromAscii(","); in createTable()
266 aSql += ::rtl::OUString::createFromAscii(" PRIMARY KEY ("); in createTable()
271 + ::rtl::OUString::createFromAscii(","); in createTable()
274 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString::createFromAscii(")")); in createTable()
283 aSql += ::rtl::OUString::createFromAscii(" UNIQUE ("); in createTable()
288 + ::rtl::OUString::createFromAscii(","); in createTable()
291 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString::createFromAscii(")")); in createTable()
302 aSql += ::rtl::OUString::createFromAscii(" FOREIGN KEY "); in createTable()
303 …::rtl::OUString aName,aSchema,aRefTable = getString(xColProp->getPropertyValue(OMetaConnection::ge… in createTable()
310 + ::rtl::OUString::createFromAscii(" ("); in createTable()
316 + ::rtl::OUString::createFromAscii(","); 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()
344 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString::createFromAscii(")")); in createTable()
346 aSql += ::rtl::OUString::createFromAscii(")"); in createTable()
357 void OTables::appendNew(const ::rtl::OUString& _rsNewTable) in appendNew()
368 ::rtl::OUString OTables::getColumnSqlType(const Reference<XPropertySet>& _rxColProp) in getColumnSqlType()
370 ::rtl::OUString sSql; in getColumnSqlType()
376 sSql += ::rtl::OUString::createFromAscii("VAR"); in getColumnSqlType()
379 sSql += ::rtl::OUString::createFromAscii("CHAR"); in getColumnSqlType()
387 sSql += OTables::getTypeString(_rxColProp) + ::rtl::OUString::createFromAscii(" "); in getColumnSqlType()
397 sSql += ::rtl::OUString::createFromAscii("(") in getColumnSqlType()
398 …+ ::rtl::OUString::valueOf(getINT32(_rxColProp->getPropertyValue(OMetaConnection::getPropMap().get… in getColumnSqlType()
399 + ::rtl::OUString::createFromAscii(")"); in getColumnSqlType()
404 sSql += ::rtl::OUString::createFromAscii("(") in getColumnSqlType()
405 …+ ::rtl::OUString::valueOf(getINT32(_rxColProp->getPropertyValue(OMetaConnection::getPropMap().get… in getColumnSqlType()
406 + ::rtl::OUString::createFromAscii(",") in getColumnSqlType()
407 …+ ::rtl::OUString::valueOf(getINT32(_rxColProp->getPropertyValue(OMetaConnection::getPropMap().get… in getColumnSqlType()
408 + ::rtl::OUString::createFromAscii(")"); in getColumnSqlType()
412 sSql += ::rtl::OUString::createFromAscii("(") in getColumnSqlType()
413 …+ ::rtl::OUString::valueOf(getINT32(_rxColProp->getPropertyValue(OMetaConnection::getPropMap().get… in getColumnSqlType()
414 + ::rtl::OUString::createFromAscii(") BYTE"); in getColumnSqlType()
420 ::rtl::OUString OTables::getColumnSqlNotNullDefault(const Reference<XPropertySet>& _rxColProp) in getColumnSqlNotNullDefault()
423 ::rtl::OUString sSql; in getColumnSqlNotNullDefault()
424 …::rtl::OUString aDefault = getString(_rxColProp->getPropertyValue(OMetaConnection::getPropMap().ge… in getColumnSqlNotNullDefault()
427 sSql += ::rtl::OUString::createFromAscii(" NOT NULL"); in getColumnSqlNotNullDefault()
429 sSql += ::rtl::OUString::createFromAscii(" WITH DEFAULT"); in getColumnSqlNotNullDefault()
433 sSql +=::rtl::OUString::createFromAscii(" DEFAULT '") + aDefault; in getColumnSqlNotNullDefault()
434 sSql += ::rtl::OUString::createFromAscii("'"); in getColumnSqlNotNullDefault()
439 ::rtl::OUString OTables::getTypeString(const Reference< XPropertySet >& _rxColProp) in getTypeString()
441 ::rtl::OUString aValue; in getTypeString()
445 aValue = ::rtl::OUString::createFromAscii("BOOLEAN"); in getTypeString()
448 aValue = ::rtl::OUString::createFromAscii("SMALLINT"); in getTypeString()
451 aValue = ::rtl::OUString::createFromAscii("SMALLINT"); in getTypeString()
454 aValue = ::rtl::OUString::createFromAscii("INT"); in getTypeString()
457 aValue = ::rtl::OUString::createFromAscii("FLOAT"); in getTypeString()
460 aValue = ::rtl::OUString::createFromAscii("REAL"); in getTypeString()
463 aValue = ::rtl::OUString::createFromAscii("DOUBLE"); in getTypeString()
466 aValue = ::rtl::OUString::createFromAscii("DECIMAL"); in getTypeString()
469 aValue = ::rtl::OUString::createFromAscii("DECIMAL"); in getTypeString()
472 aValue = ::rtl::OUString::createFromAscii("CHAR"); in getTypeString()
475 aValue = ::rtl::OUString::createFromAscii("VARCHAR"); in getTypeString()
478 aValue = ::rtl::OUString::createFromAscii("LONG VARCHAR"); in getTypeString()
481 aValue = ::rtl::OUString::createFromAscii("DATE"); in getTypeString()
484 aValue = ::rtl::OUString::createFromAscii("TIME"); in getTypeString()
487 aValue = ::rtl::OUString::createFromAscii("TIMESTAMP"); in getTypeString()
490 aValue = ::rtl::OUString::createFromAscii("CHAR () BYTE"); in getTypeString()
493 aValue = ::rtl::OUString::createFromAscii("VARCHAR () BYTE"); in getTypeString()
496 aValue = ::rtl::OUString::createFromAscii("LONG BYTE"); in getTypeString()
502 ::rtl::OUString OTables::getNameForObject(const sdbcx::ObjectType& _xObject) in getNameForObject()
505 ::rtl::OUString sName,sTemp; in getNameForObject()
509 const ::rtl::OUString& sDot = OAdabasCatalog::getDot(); in getNameForObject()