bool ContentNode::updateContentNode(QSqlDatabase& database,
const ContentNode & node)
{
QSqlQuery query(database);
query.prepare ("update content set "
" name = ?, location = ?, title = ?, authors = ?, "
" description = ?, last_access = ?, publisher = ?, md5 = ?, "
" size = ?, rating = ?, read_time = ?, read_count = ?, "
" progress = ?, attributes = ? "
" where id = ?");
query.addBindValue(node.name());
query.addBindValue(node.location());
query.addBindValue(node.title());
query.addBindValue(node.authors());
query.addBindValue(node.description());
query.addBindValue(node.last_access());
query.addBindValue(node.publisher());
query.addBindValue(node.md5());
query.addBindValue(node.size());
query.addBindValue(node.rating());
query.addBindValue(node.read_time());
query.addBindValue(node.read_count());
query.addBindValue(node.progress());
query.addBindValue(node.attributes());
query.addBindValue(node.id());
return query.exec();
}
bool ContentNode::createContentNode(QSqlDatabase& database,
ContentNode & node)
{
QSqlQuery query(database);
query.prepare ("insert into content "
"(name, location, title, authors, description, "
"last_access, publisher, md5, "
"size, rating, read_time, read_count, progress, attributes ) "
" values "
"(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
query.addBindValue(node.name());
query.addBindValue(node.location());
query.addBindValue(node.title());
query.addBindValue(node.authors());
query.addBindValue(node.description());
query.addBindValue(node.last_access());
query.addBindValue(node.publisher());
query.addBindValue(node.md5());
query.addBindValue(node.size());
query.addBindValue(node.rating());
query.addBindValue(node.read_time());
query.addBindValue(node.read_count());
query.addBindValue(node.progress());
query.addBindValue(node.attributes());
if (query.exec())
{
node.id_ = query.lastInsertId().toInt();
return true;
}
return false;
}