Lines Matching refs:aSql
82 …::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()
164 aSql.append(sTypeName); // simply add the type name in createStandardColumnPart()
169 aSql.append(::rtl::OUString::createFromAscii(" DEFAULT ")); in createStandardColumnPart()
170 aSql.append(sPreFix); in createStandardColumnPart()
171 aSql.append(aDefault); in createStandardColumnPart()
172 aSql.append(sPostFix); in createStandardColumnPart()
176 aSql.append(::rtl::OUString::createFromAscii(" NOT NULL")); in createStandardColumnPart()
180 aSql.appendAscii(" "); in createStandardColumnPart()
181 aSql.append(sAutoIncrementValue); in createStandardColumnPart()
185 _pHelper->addComment(xColProp,aSql); in createStandardColumnPart()
187 return aSql.makeStringAndClear(); in createStandardColumnPart()
193 ::rtl::OUStringBuffer aSql = ::rtl::OUString::createFromAscii("CREATE TABLE "); in createStandardCreateStatement()
207 aSql.append(sComposedName); in createStandardCreateStatement()
208 aSql.append(::rtl::OUString::createFromAscii(" (")); in createStandardCreateStatement()
224 aSql.append(createStandardColumnPart(xColProp,_xConnection,_pHelper,_sCreatePattern)); in createStandardCreateStatement()
225 aSql.appendAscii(","); in createStandardCreateStatement()
228 return aSql.makeStringAndClear(); in createStandardCreateStatement()
260 ::rtl::OUStringBuffer aSql; in createStandardKeyStatement()
290 aSql.append(::rtl::OUString::createFromAscii(" PRIMARY KEY ")); in createStandardKeyStatement()
291 aSql.append(generateColumnNames(xColumns,xMetaData)); in createStandardKeyStatement()
301 aSql.append(::rtl::OUString::createFromAscii(" UNIQUE ")); in createStandardKeyStatement()
302 aSql.append(generateColumnNames(xColumns,xMetaData)); in createStandardKeyStatement()
313 aSql.append(::rtl::OUString::createFromAscii(" FOREIGN KEY ")); in createStandardKeyStatement()
327 aSql.append(generateColumnNames(xColumns,xMetaData)); in createStandardKeyStatement()
332 aSql.append(::rtl::OUString::createFromAscii(" ON DELETE CASCADE ")); in createStandardKeyStatement()
335 aSql.append(::rtl::OUString::createFromAscii(" ON DELETE RESTRICT ")); in createStandardKeyStatement()
338 aSql.append(::rtl::OUString::createFromAscii(" ON DELETE SET NULL ")); in createStandardKeyStatement()
341 aSql.append(::rtl::OUString::createFromAscii(" ON DELETE SET DEFAULT ")); in createStandardKeyStatement()
351 if ( aSql.getLength() ) in createStandardKeyStatement()
353 if ( aSql.charAt(aSql.getLength()-1) == ',' ) in createStandardKeyStatement()
354 aSql.setCharAt(aSql.getLength()-1,')'); in createStandardKeyStatement()
356 aSql.appendAscii(")"); in createStandardKeyStatement()
359 return aSql.makeStringAndClear(); in createStandardKeyStatement()
368 …::rtl::OUString aSql = ::dbtools::createStandardCreateStatement(descriptor,_xConnection,_pHelper,_… in createSqlCreateTableStatement()
371 aSql += sKeyStmt; in createSqlCreateTableStatement()
374 if ( aSql.lastIndexOf(',') == (aSql.getLength()-1) ) in createSqlCreateTableStatement()
375 aSql = aSql.replaceAt(aSql.getLength()-1,1,::rtl::OUString::createFromAscii(")")); in createSqlCreateTableStatement()
377 aSql += ::rtl::OUString::createFromAscii(")"); in createSqlCreateTableStatement()
379 return aSql; in createSqlCreateTableStatement()