| 169 | } |
| 170 | |
| 171 | QString DBHelper::getFolderName(qulonglong libraryId, qulonglong id) |
| 172 | { |
| 173 | QString libraryPath = DBHelper::getLibraries().getPath(libraryId); |
| 174 | |
| 175 | QString name = ""; |
| 176 | QString connectionName = ""; |
| 177 | |
| 178 | { |
| 179 | QSqlDatabase db = DataBaseManagement::loadDatabase(LibraryPaths::libraryDataPath(libraryPath)); |
| 180 | QSqlQuery selectQuery(db); // TODO check |
| 181 | selectQuery.prepare("SELECT name FROM folder WHERE id = :id"); |
| 182 | selectQuery.bindValue(":id", id); |
| 183 | selectQuery.exec(); |
| 184 | |
| 185 | if (selectQuery.next()) { |
| 186 | name = selectQuery.value(0).toString(); |
| 187 | } |
| 188 | connectionName = db.connectionName(); |
| 189 | } |
| 190 | |
| 191 | QSqlDatabase::removeDatabase(connectionName); |
| 192 | return name; |
| 193 | } |
| 194 | |
| 195 | Folder DBHelper::getFolder(qulonglong libraryId, qulonglong id) |
| 196 | { |