Changeset View
Changeset View
Standalone View
Standalone View
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. |