song.cpp

    #include "song.h"

Song::Song()
    :_like(false),
    _history(false)
{}

Song::Song(const QUrl &url)
    :_like(false),
    _history(false),
    _musicurl(url)
{
    //通过uuid来确保id的唯一性
    _musicid=QUuid::createUuid().toString();
    ParseMediaData();
}

void Song::IsLike(bool flag)
{
    _like=flag;
}

void Song::IsHistory(bool flag)
{
    _history=flag;
}

void Song::SetMusicName(const QString &name)
{
    _musicname=name;
}

void Song::SetSinger(const QString &singer)
{
    _singer=singer;
}

void Song::SetAblum(const QString &ablum)
{
    _album=ablum;
}

void Song::SetDuration(const qint64 &sec)
{
    _duration=sec;
}

void Song::SetMusicId(const QString &id)
{
    _musicid=id;
}

void Song::SetMusicUrl(const QUrl &url)
{
    _musicurl=url;
}


bool Song::Like()
{
    return _like;
}

bool Song::History()
{
    return _history;
}

QString Song::GetMusicName()
{
    return _musicname;
}

QString Song::GetSinger()
{
    return _singer;
}

QString Song::GetAblum()
{
    return _album;
}

qint64 Song::GetDuration()
{
    return _duration;
}

QString Song::GetMusicId()
{
    return _musicid;
}

QUrl Song::GetMusicUlr()
{
    return _musicurl;
}

QString Song::GetLrcFile()
{
    QString path=_musicurl.toLocalFile();
    path.replace(".mp3", ".lrc");
    path.replace(".wav", ".lrc");
    path.replace(".flac", ".lrc");
    path.replace(".mpga", ".lrc");
    path.replace(".m4a", ".lrc");
    return path;
}

void Song::insertMuiscToDB()
{
    QSqlQuery query;
    query.prepare("select exists (select 1 from musicInfo where musicid=?)");
    query.addBindValue(_musicid);
    if(query.exec()==false)
    {
        qDebug()<<"select false"<<query.lastError().text();
        return;
    }
    if(query.next())
    {
        bool isexists=query.value(0).toBool();
        if(isexists)
        {
            // 修正参数顺序：set 子句3个?，where 子句1个?
            query.prepare("update musicInfo set islike=?,ishistory=?,musicname=? where musicid=?");
            query.addBindValue(_like?1:0);
            query.addBindValue(_history?1:0);
            query.addBindValue(_musicname);   // 对应第3个? (musicname)
            query.addBindValue(_musicid);     // 对应 where 条件的 ? (musicid)
            if(query.exec()==false)
            {
                qDebug()<<"update false";
            }
            qDebug()<<"update success"<<_musicname<<_musicid;
        }else
        {
            query.prepare("insert into musicInfo(musicid,musicname,singer,album,musicurl,duration,islike,ishistory)values(?,?,?,?,?,?,?,?)");
            query.addBindValue(_musicid);
            query.addBindValue(_musicname);
            query.addBindValue(_singer);
            query.addBindValue(_album);
            query.addBindValue(_musicurl.toLocalFile());
            query.addBindValue(_duration);
            query.addBindValue(_like?1:0);
            query.addBindValue(_history?1:0);

            if(query.exec()==false)
            {
                qDebug()<<"insert false";
            }
            qDebug()<<"insert success"<<_musicname<<_musicid;
        }
    }
}

void Song::ParseMediaData()
{
    QMediaPlayer player;
    QEventLoop loop;
    QObject::connect(&player,&QMediaPlayer::mediaStatusChanged,&loop,&QEventLoop::quit);
    QObject::connect(&player,&QMediaPlayer::errorOccurred,&loop,[&loop](QMediaPlayer::Error,const  QString&errorString){
        qDebug()<<"解析失败"<<errorString;
        loop.quit();
    });
    player.setSource(_musicurl);

    QTimer::singleShot(2000,&loop,&QEventLoop::quit);
    loop.exec();

        _musicname=player.metaData().value(QMediaMetaData::Title).toString();
        _singer=player.metaData().value(QMediaMetaData::Author).toString();
        _album=player.metaData().value(QMediaMetaData::AlbumTitle).toString();
        _duration=player.duration();

        // 直接用 QUrl::fileName() 避免 Windows 本地路径的 GBK 编码问题
        QString filename = _musicurl.fileName();
        // 去掉扩展名，方便后续截取
        QString baseName = filename;
        int dotIndex = baseName.lastIndexOf('.');
        if (dotIndex != -1) {
            baseName = baseName.mid(0, dotIndex);
        }
        // 尝试按 "歌手 - 歌名" 格式解析
        int sepIndex = baseName.indexOf('-');
        if (_musicname.isEmpty()) {
            if (sepIndex != -1) {
                _musicname = baseName.mid(0, sepIndex).trimmed();
            } else {
                _musicname = baseName;   // 无法解析时才用完整文件名
            }
        }
        if (_singer.isEmpty()) {
            if (sepIndex != -1) {
                _singer = baseName.mid(sepIndex + 1).trimmed();
            } else {
                _singer = "未知歌手";
            }
        }
        if(_album.isEmpty())
        {
            _album="未知专辑";
        }
        qDebug()<<_musicname<<_singer<<_album;
}