Differential D15713 Diff 42193 src/qtquick/BookDatabase.cpp

Changeset View

Standalone View

View Options

src/qtquick/BookDatabase.cpp

Context not available.
89 } 89​ }
90 90​
91 QList<BookEntry*> entries; 91​ QList<BookEntry*> entries;
92 QSqlQuery allEntries("SELECT filename, filetitle, title, series, author, publisher, created, lastOpenedTime, totalPages, currentPage, thumbnail FROM books"); 92​ QSqlQuery allEntries("SELECT filename, filetitle, title, series, author, publisher, created, lastOpenedTime, totalPages, currentPage, thumbnail, description FROM books");
93 while(allEntries.next()) 93​ while(allEntries.next())
94 { 94​ {
95 BookEntry* entry = new BookEntry(); 95​ BookEntry* entry = new BookEntry();
96 entry->filename = allEntries.value(0).toString(); 96​ entry->filename = allEntries.value(0).toString();
97 entry->filetitle = allEntries.value(1).toString(); 97​ entry->filetitle = allEntries.value(1).toString();
98 entry->title = allEntries.value(2).toString(); 98​ entry->title = allEntries.value(2).toString();
99 entry->series = allEntries.value(3).toString(); 99​ entry->series = allEntries.value(3).toStringList();
100 entry->author = allEntries.value(4).toString(); 100​ entry->author = allEntries.value(4).toStringList();
101 entry->publisher = allEntries.value(5).toString(); 101​ entry->publisher = allEntries.value(5).toString();
102 entry->created = allEntries.value(6).toDateTime(); 102​ entry->created = allEntries.value(6).toDateTime();
103 entry->lastOpenedTime = allEntries.value(7).toDateTime(); 103​ entry->lastOpenedTime = allEntries.value(7).toDateTime();
104 entry->totalPages = allEntries.value(8).toInt(); 104​ entry->totalPages = allEntries.value(8).toInt();
105 entry->currentPage = allEntries.value(9).toInt(); 105​ entry->currentPage = allEntries.value(9).toInt();
106 entry->thumbnail = allEntries.value(10).toString(); 106​ entry->thumbnail = allEntries.value(10).toString();
107​ entry->description = allEntries.value(11).toStringList();
107 entries.append(entry); 108​ entries.append(entry);
108 } 109​ }
109 110​
Context not available.
119 qDebug() << "Adding newly discovered book to the database" << entry->filename; 120​ qDebug() << "Adding newly discovered book to the database" << entry->filename;
120 121​
121 QSqlQuery newEntry; 122​ QSqlQuery newEntry;
122 newEntry.prepare("INSERT INTO books (filename, filetitle, title, series, author, publisher, created, lastOpenedTime, totalPages, currentPage, thumbnail) " 123​ newEntry.prepare("INSERT INTO books (filename, filetitle, title, series, author, publisher, created, lastOpenedTime, totalPages, currentPage, thumbnail, description) "
123 "VALUES (:filename, :filetitle, :title, :series, :author, :publisher, :created, :lastOpenedTime, :totalPages, :currentPage, :thumbnail)"); 124​ "VALUES (:filename, :filetitle, :title, :series, :author, :publisher, :created, :lastOpenedTime, :totalPages, :currentPage, :thumbnail, :description)");
124 newEntry.bindValue(":filename", entry->filename); 125​ newEntry.bindValue(":filename", entry->filename);
125 newEntry.bindValue(":filetitle", entry->filetitle); 126​ newEntry.bindValue(":filetitle", entry->filetitle);
126 newEntry.bindValue(":title", entry->title); 127​ newEntry.bindValue(":title", entry->title);
Context not available.
133 newEntry.bindValue(":totalPages", entry->totalPages); 134​ newEntry.bindValue(":totalPages", entry->totalPages);
134 newEntry.bindValue(":currentPage", entry->currentPage); 135​ newEntry.bindValue(":currentPage", entry->currentPage);
135 newEntry.bindValue(":thumbnail", entry->thumbnail); 136​ newEntry.bindValue(":thumbnail", entry->thumbnail);
137​ newEntry.bindValue(":description", entry->description);
136 newEntry.exec(); 138​ newEntry.exec();
137 139​
138 d->closeDb(); 140​ d->closeDb();
Context not available.