/*!
Proporciona una claúsula where para la el campo. Útil para updates y deletes
*/
QString DBFieldMetadata::sqlWhere(const QString &op, const QVariant &value)
{
QString result;
result = QString("%1 %2 %3").arg(dbFieldName()).
arg(op).arg(sqlValue(value));
return result;
}
void YunClient::setUpdateList(QJsonObject json)
{
if(json.isEmpty()){
qDebug() << " "
" json is empty of set version info.";
return;
}
rowList.clear();
QStringList rowValue;
if (json.contains("meidis")){
QJsonArray mediaArr = json.take("meidis").toArray();
for (int i=0; i<mediaArr.size(); i++)
{
rowValue.clear();
QString mvPath = "", lyricPath = "", sql = "";
QJsonObject vjson = mediaArr.at(i).toObject();
rowValue.append(QString::number(i+1));
if(vjson.contains("type")){
QJsonValue value = vjson.take("type");
rowValue.append(value.toString());
}
if(vjson.contains("mname")){
QJsonValue value = vjson.take("mname");
rowValue.append(value.toString());
}
if(vjson.contains("serialId")){
QJsonValue value = vjson.take("serialId");
rowValue.append(QString::number(value.toInt()));
}
if(vjson.contains("mediaFilePath")){
QJsonValue value = vjson.take("mediaFilePath");
mvPath = value.toString();
rowValue.append(mvPath.isEmpty() ? "无" : "有");
}
if(vjson.contains("lyric")){
QJsonValue value = vjson.take("lyric");
lyricPath = value.toString();
rowValue.append(lyricPath.isEmpty() ? "无" : "有");
}
if(vjson.contains("sql")){
QJsonValue value = vjson.take("sql");
rowValue.insert(1, getOptType(value.toString()));
sql = value.toString();
}
rowValue.append(mvPath);
rowValue.append(lyricPath);
rowValue.append(sql);
rowList.append(rowValue);
}
}
if (json.contains("actors")){
QJsonArray actorArr = json.take("actors").toArray();
for (int i=0; i<actorArr.size(); i++)
{
rowValue.clear();
QString imagePath, sql;
QJsonObject vjson = actorArr.at(i).toObject();
rowValue.append(QString::number(rowList.size() + 1));
rowValue.append("ACTOR");
if(vjson.contains("name")){
QJsonValue value = vjson.take("name");
rowValue.append(value.toString());
}
if(vjson.contains("serialId")){
QJsonValue value = vjson.take("serialId");
rowValue.append(QString::number(value.toInt()));
}
rowValue.append("无");
if(vjson.contains("imgFilePath")){
QJsonValue value = vjson.take("imgFilePath");
imagePath = value.toString();
rowValue.append(imagePath.isEmpty() ? "无" : "有");
}
if(vjson.contains("sql")){
QJsonValue value = vjson.take("sql");
rowValue.insert(1, getOptType(value.toString()));
sql = value.toString();
}
rowValue.append("");
rowValue.append(imagePath);
rowValue.append(sql);
rowList.append(rowValue);
}
}
qDebug() << "request version record : " << rowList.size();
emit sqlValue(rowList);
}
