bool TeSQLite::insertTableInfo(int layerId, TeTable &table, const string& user)
{
errorMessage_ = "";
if(table.name().empty())
return false;
if(table.id() <= 0)
{
string sql = "INSERT INTO te_layer_table (";
if(layerId > 0)
{
sql += "layer_id, ";
}
sql += "attr_table, unique_id, attr_link, attr_initial_time, attr_final_time, ";
sql += "attr_time_unit, attr_table_type, user_name) VALUES(";
if(layerId > 0)
{
sql += Te2String(layerId) + ", ";
}
sql += "'" + table.name();
sql += "', '" + table.uniqueName();
sql += "', '";
sql += table.linkName();
sql += "', '";
sql += table.attInitialTime();
sql += "', '";
sql += table.attFinalTime();
sql += "', ";
sql += Te2String(table.attTimeUnit());
sql += ", ";
sql += Te2String(table.tableType());
sql += ", '";
sql += user;
sql += "')";
if(this->execute(sql))
{
//int newId = getMaxValue(this, "te_layer_table", "table_id");
int newId = getLastInsertedSerial();
if(newId >= 0)
{
table.setId(newId);
}
}
else
return false;
}
return true;
}
bool updateDB301To302(TeDatabase* db, string& errorMessage)
{
TeDatabasePortal* portal = db->getPortal();
if(!portal)
return false;
// ----- valid attribute table
TeAttrTableVector attrTableVec;
if(db->getAttrTables(attrTableVec))
{
for(unsigned int i=0; i<attrTableVec.size(); ++i)
{
TeTable fromTable = attrTableVec[i];
bool flag = false;
if(fromTable.tableType()==TeAttrMedia)
continue;
//verify if there is another table with the same name
for(unsigned int j=0; j<i; ++j)
{
if(TeConvertToUpperCase(attrTableVec[j].name())==TeConvertToUpperCase(fromTable.name()))
{
flag = true;
break;
}
}
if(flag)
continue;
if(db->validTable(fromTable)) //fromTable was modified
{
TeAttributeList newAttrList = fromTable.attributeList();
TeAttributeList oldAttrList = attrTableVec[i].attributeList();
TeAttributeList::iterator newAttIt = newAttrList.begin();
TeAttributeList::iterator oldAttIt = oldAttrList.begin();
bool change = false;
while(newAttIt!=newAttrList.end())
{
if(((*oldAttIt).rep_.name_) != ((*newAttIt).rep_.name_))
{
TeAttributeRep rep = (*newAttIt).rep_;
if(db->alterTable(fromTable.name(), rep, (*oldAttIt).rep_.name_))
change = true;
}
++newAttIt;
++oldAttIt;
}
if(change)
{
// update te_layer_table
string upd = " UPDATE te_layer_table ";
upd += " SET unique_id = '"+ fromTable.uniqueName() +"'";
upd += ", attr_link = '"+ fromTable.linkName() +"'";
upd += " WHERE attr_table = '"+ fromTable.name() +"'";
if(!db->execute (upd))
{
delete portal;
errorMessage = "Error updating te_layer_table!\n";
errorMessage += db->errorMessage();
return false;
}
}
}//if
}//for
portal->freeResult();
}
// ----- te_grouping table
string sel = " SELECT theme_id, grouping_attr, grouping_attr_type FROM te_grouping ";
if(!portal->query(sel))
{
delete portal;
return false;
}
while(portal->fetchRow())
{
string themeId, gAttr;
themeId = portal->getData(0);
gAttr = portal->getData(1);
int gTypr = portal->getInt(2);
if(((gAttr.empty()) || (gAttr=="NONE")) && (gTypr==0))
{
string del = " DELETE FROM te_grouping WHERE theme_id = "+ themeId;
db->execute(del);
}
}
// ----- te_grouping table
delete portal;
return true;
}