sql 语句的拼接

std::string CDBTable::getCreateTableSQL(std::string tableName)
{
if (tableName.empty())
{
BOMB_IF(_TableNames.empty(), "table is empty", return "")
tableName = _TableNames[0];
}
BOMB_IF(!containsTable(tableName), "we don't have such a table" + tableName, return "")
std::string SQL= "CREATE TABLE IF NOT EXISTS ";
SQL += tableName;
SQL += " (";
bool needComma = false;
TFiels::iterator iter = _Fields.begin();
for (; iter != _Fields.end(); ++iter)
{
if (needComma == true)
{
SQL += ", ";
}
else
{
needComma = true;
}
SQL += iter->_Name;
SQL += " ";
SQL += iter->_Extra;
}
TRepeatFields::iterator iterRepeat = _RepeatFields.begin();
for (; iterRepeat != _RepeatFields.end(); ++iterRepeat)
{
std::vector<std::string>::iterator itRepeat = iterRepeat->_Fields.begin();
for (; itRepeat != iterRepeat->_Fields.end();++itRepeat)
{
if (needComma == true)
{
SQL +=", ";
}
else
{
needComma = true;
}
SQL += *itRepeat;
SQL += " ";
SQL += iterRepeat->_Extra;
}
}
SQL += ", PRIMARY KEY (";
for (uint32 i = 0; i < _KeyNames.size(); i++)
{
if (i > 0)
{
SQL += ",";
}
SQL += _KeyNames[i];
}
SQL += ")";
if ( !_ForeignKey.empty() && !_ForeignKeyReferences.empty())
{
SQL += ", FOREIGN KEY (";
SQL += _ForeignKey;
SQL += ")";
SQL += "REFERENCES ";
SQL += _ForeignKeyReferences;
}
for (uint32 i = 0; i < _Indexes.size(); i++)
{
SQL += ",INDEX (";
SQL += _Indexes[i];
SQL += ")";
}
SQL += ") ENGINE=INNODB" ;


nlinfo(" create Table sql: %s", SQL.c_str());
return SQL;
}