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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
|
/***************************************************************************
* Copyright (C) 2017-2020 by Ilya Kotov *
* forkotov02@ya.ru *
* *
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
* the Free Software Foundation; either version 2 of the License, or *
* (at your option) any later version. *
* *
* This program is distributed in the hope that it will be useful, *
* but WITHOUT ANY WARRANTY; without even the implied warranty of *
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
* GNU General Public License for more details. *
* *
* You should have received a copy of the GNU General Public License *
* along with this program; if not, write to the *
* Free Software Foundation, Inc., *
* 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. *
***************************************************************************/
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QSqlError>
#include <QVariant>
#include <QAction>
#include <QApplication>
#include <qmmpui/uihelper.h>
#include <qmmp/soundcore.h>
//#include "historywindow.h"
#include "library.h"
Library::Library(QObject *parent) : QObject(parent)
{
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE", CONNECTION_NAME);
if(db.isValid() && !db.isOpen())
{
db.setDatabaseName(Qmmp::configDir() + "/" + "library.sqlite");
db.open();
if(createTables())
{
QSqlQuery query(db);
query.exec("PRAGMA journal_mode = WAL");
query.exec("PRAGMA synchronous = NORMAL");
qDebug("Library: database initialization finished");
}
else
{
db.close();
qWarning("Library: plugin is disabled");
}
}
// QAction *action = new QAction(tr("History"), this);
// action->setIcon(QIcon::fromTheme("text-x-generic"));
// UiHelper::instance()->addAction(action, UiHelper::TOOLS_MENU);
// connect(action, SIGNAL(triggered()), SLOT(showHistoryWindow()));
}
Library::~Library()
{
if(QSqlDatabase::contains(CONNECTION_NAME))
{
QSqlDatabase::database(CONNECTION_NAME).close();
QSqlDatabase::removeDatabase(CONNECTION_NAME);
}
}
void Library::showLibraryWindow()
{
/*if(!m_historyWindow)
m_historyWindow = new HistoryWindow(QSqlDatabase::database(CONNECTION_NAME), qApp->activeWindow());
m_historyWindow->show();
m_historyWindow->activateWindow();*/
}
bool Library::createTables()
{
QSqlDatabase db = QSqlDatabase::database(CONNECTION_NAME);
if(!db.isOpen())
return false;
QSqlQuery query(db);
bool ok = query.exec("CREATE TABLE IF NOT EXISTS track_library("
"ID INTEGER PRIMARY KEY AUTOINCREMENT,"
"Timestamp TIMESTAMP NOT NULL,"
"Title TEXT, Artist TEXT, AlbumArtist TEXT, Album TEXT, Comment TEXT, Genre TEXT, Composer TEXT,"
"Year INTEGER, Track INTEGER, DiscNumer INTEGER, Duration INTEGER, "
"AudioInfo BLOB, URL BLOB, FilePath BLOB)");
if(!ok)
qWarning("Library: unable to create table, error: %s", qPrintable(query.lastError().text()));
return ok;
}
/*void Library::saveTrack()
{
QSqlDatabase db = QSqlDatabase::database(CONNECTION_NAME);
if(!db.isOpen() || m_trackInfo.isEmpty())
return;
QSqlQuery query(db);
query.prepare("INSERT INTO track_library VALUES(NULL, CURRENT_TIMESTAMP, :title, :artist, :albumartist, :album, :comment,"
":genre, :composer, :year, :track, :discnumber, :duration, :url);");
query.bindValue(":title", m_trackInfo.value(Qmmp::TITLE));
query.bindValue(":artist", m_trackInfo.value(Qmmp::ARTIST));
query.bindValue(":albumartist", m_trackInfo.value(Qmmp::ALBUMARTIST));
query.bindValue(":album", m_trackInfo.value(Qmmp::ALBUM));
query.bindValue(":comment", m_trackInfo.value(Qmmp::COMMENT));
query.bindValue(":genre", m_trackInfo.value(Qmmp::GENRE));
query.bindValue(":composer", m_trackInfo.value(Qmmp::COMPOSER));
query.bindValue(":year", m_trackInfo.value(Qmmp::YEAR));
query.bindValue(":track", m_trackInfo.value(Qmmp::TRACK));
query.bindValue(":discnumber", m_trackInfo.value(Qmmp::DISCNUMBER));
query.bindValue(":duration", m_trackInfo.duration());
query.bindValue(":url", m_trackInfo.path());
bool ok = query.exec();
if(!ok)
qWarning("Library: unable to save track, error: %s", qPrintable(query.lastError().text()));
else
qDebug("Library: track '%s' has been added to history",
qPrintable(m_trackInfo.value(Qmmp::ARTIST) + " - " + m_trackInfo.value(Qmmp::TITLE)));
}*/
|
