Document::Ptr SQLiteDocumentDAO::findById(qulonglong id) const
{
if(repository()->publications()->contains(id)) {
return repository()->publications()->find(id);
}
QueryExecutor executor(database());
QSqlQuery query = executor.select("document", QStringList(), makeQueryParameters("id", id));
if(query.next()) {
QSqlRecord record = query.record();
qulonglong id = record.value("id").toULongLong();
Document::Ptr pub = Document::Ptr(new Document());
pub->setId(id);
pub->setTitle(record.value("title").toString());
pub->setAbstract(record.value("abstract").toString());
pub->setYear(record.value("year").toInt());
pub->setMonth(record.value("month").toInt());
pub->setConference(record.value("conference").toString());
pub->setPublisher(record.value("publisher").toString());
pub->setVolume(record.value("volume").toInt());
pub->setNumber(record.value("number").toInt());
pub->setUrl(record.value("url").toString());
pub->setDoi(record.value("doi").toString());
pub->setIsbn(record.value("isbn").toString());
pub->setLocalUrl(record.value("localURL").toString());
pub->setType(static_cast<DocumentType>(record.value("type").toUInt()));
pub->setPublished(record.value("isPublished").toBool());
pub->setPeerReviewed(record.value("isPeerReviewed").toBool());
pub->setKeywords(QStringList());
pub->setSeries(record.value("series").toString());
pub->setSubTitle(record.value("subTitle").toString());
pub->setPages(PageRange::fromString(record.value("pages").toString()));
pub->setCiteKey(record.value("citeKey").toString());
repository()->publications()->insert(id, pub);
QString authors = record.value("authors").toString();
pub->setAuthors(StringUtils::deserialize(authors));
QString editors = record.value("editors").toString();
pub->setEditors(StringUtils::deserialize(editors));
qulonglong jid = record.value("journalId").toULongLong();
if(jid != 0) {
pub->setJournal(repository()->journalDAO()->findById(jid));
}
emit dataChanged();
return pub;
}
return Document::Ptr();
}
bool SQLiteDocumentDAO::save(Document::Ptr pub)
{
if(!pub) {
return false;
}
QueryExecutor executor(database());
QueryParameters params;
if(pub->journal()) {
Journal::Ptr realJournal = repository()->journalDAO()->findByName(pub->journal()->name(), true);
if(realJournal != pub->journal()) {
Journal::Ptr old = pub->journal();
pub->setJournal(realJournal);
delete old;
}
}
params.insert("title", pub->title());
params.insert("abstract", pub->abstract());
params.insert("year", pub->year());
params.insert("month", pub->month());
params.insert("conference", pub->conference());
params.insert("publisher", pub->publisher());
params.insert("volume", pub->volume());
params.insert("number", pub->number());
params.insert("url", pub->url());
params.insert("doi", pub->doi());
params.insert("isbn", pub->isbn());
params.insert("localURL", pub->localUrl());
params.insert("type", static_cast<uint>(pub->type()));
params.insert("isPublished", pub->isPublished());
params.insert("isPeerReviewed", pub->isPeerReviewed());
//params.insert("keywords", pub->keywords());
params.insert("series", pub->series());
params.insert("subTitle", pub->subTitle());
params.insert("pages", pub->pages().toString());
params.insert("authors", StringUtils::serialize(pub->authors()));
params.insert("editors", StringUtils::serialize(pub->editors()));
params.insert("citeKey", pub->citeKey());
if(pub->journal()) {
params.insert("journalId", pub->journal()->id());
} else {
params.insert("journalId", QVariant());
}
bool ok = executor.insert("document", params);
if(ok) {
qulonglong id = executor.lastInsertID();
pub->setId(id);
repository()->publications()->insert(id, pub);
emit dataChanged();
}
return ok;
}