collectionwebradioview.cpp


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

#include <QSqlDatabase>
#include <QSqlQuery>
#include <QStandardItem>

#include "collectionwebradioview.h"

CollectionWebradioView::CollectionWebradioView(QWidget *parent) : CollectionWidget(parent){
}

void CollectionWebradioView::populate(){
    disableSorting();
    model()->clear();
    model()->setHorizontalHeaderLabels(headers());
    QSqlDatabase db = QSqlDatabase::database("beetplayerdb");
    QStandardItem *root = model()->invisibleRootItem();
    QIcon wrIcon(":/dog_hood.png");
    QSqlQuery wrQ = QSqlQuery("SELECT tdescription, turl FROM webradio ORDER BY tdescription DESC", db);
    while(wrQ.next()){
        QStandardItem *curWr = new QStandardItem;
        curWr->setEditable(false);
        curWr->setFont(QFont("courier"));
        curWr->setText(wrQ.value(0).toString());
        curWr->setIcon(wrIcon);
        curWr->setData(wrQ.value(1), UrlRole);
        root->appendRow(curWr);
    }
    enableSorting();
}