Differential D15748 Diff 42308 src/qtquick/BookDatabase.cpp

Changeset View

Standalone View

View Options

src/qtquick/BookDatabase.cpp

Show First 20 Lines • Show All 143 Lines • ▼ Show 20 Line(s)121{
144 newEntry.bindValue(":tags", entry->tags.join(",")); 144​ newEntry.bindValue(":tags", entry->tags.join(","));
145 newEntry.bindValue(":rating", entry->rating); 145​ newEntry.bindValue(":rating", entry->rating);
146 newEntry.bindValue(":seriesNumbers", entry->seriesNumbers.join(",")); 146​ newEntry.bindValue(":seriesNumbers", entry->seriesNumbers.join(","));
147 newEntry.bindValue(":seriesVolumes", entry->seriesVolumes.join(",")); 147​ newEntry.bindValue(":seriesVolumes", entry->seriesVolumes.join(","));
148 newEntry.exec(); 148​ newEntry.exec();
149 149​
150 d->closeDb(); 150​ d->closeDb();
151} 151​}
152​
153​void BookDatabase::removeEntry(BookEntry* entry)
154​{
155​ if(!d->prepareDb()) {
156​ return;
157​ }
158​ qDebug() << "Removing book from the database" << entry->filename;
159​
160​ QSqlQuery removeEntry;
161​ removeEntry.prepare("DELETE FROM books WHERE filename='"+entry->filename+"';");
162​ removeEntry.exec();
163​
164​ d->closeDb();
165​}