Method getRootItems

common/sqlitedb.cpp:1190–1243

}

int SQLiteDB::getRootItems(int root_ohfi, metadata_t **metadata)
{
    QSqlQuery query;
    int count = 0;

    switch(root_ohfi) {
    case VITA_OHFI_MUSIC:
        //query = QSqlQuery("SELECT * FROM music");
        break;
    case VITA_OHFI_PHOTO:
        //query = QSqlQuery("SELECT * FROM photos");
        break;
    case VITA_OHFI_VIDEO:
        //query = QSqlQuery("SELECT * FROM videos");
        break;
    case VITA_OHFI_PSPSAVE:
        //query = QSqlQuery("SELECT * FROM savedata");
        break;
    case VITA_OHFI_VITAAPP:
    case VITA_OHFI_PSPAPP:
    case VITA_OHFI_PSXAPP:
    case VITA_OHFI_PSMAPP:
    case VITA_OHFI_BACKUP:
        query = QSqlQuery("SELECT "
                          "t0.object_id as ohfi,"
                          ":app_type as parent,"
                          "t3.path as path,"
                          "t0.title as name,"
                          "t1.type as type,"
                          "t1.data_type as data_type,"
                          "t3.size as size,"
                          "t3.date_created as date_created "
                          "FROM application t0 "
                          "JOIN object_node t1 on t0.object_id = t1.object_id "
                          "JOIN sources t3 ON t3.object_id = t0.object_id "
                          "WHERE app_type = :app_type");
        query.bindValue(0, root_ohfi);
        if(query.exec()) {
            metadata_t **last = &*metadata;
            while(query.next()) {
                metadata_t *meta = new metadata_t();
                fillMetadata(query, *meta);
                *last = meta;
                last = &meta->next_metadata;
                count++;
            }
        }
        break;
    default:
        qFatal("Invalid root ohfi type");
    }

    return count;
}

bool SQLiteDB::insertVirtualEntry(int ohfi)
{