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
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
|
/*
* Copyright (C) 2005-2018 Team Kodi
* This file is part of Kodi - https://kodi.tv
*
* SPDX-License-Identifier: GPL-2.0-or-later
* See LICENSES/README.md for more information.
*/
#include "ViewDatabase.h"
#include <utility>
#include "dbwrappers/dataset.h"
#include "SortFileItem.h"
#include "utils/LegacyPathTranslation.h"
#include "utils/log.h"
#include "utils/SortUtils.h"
#include "utils/StringUtils.h"
#include "utils/URIUtils.h"
#include "view/ViewState.h"
#ifdef TARGET_POSIX
#include "platform/posix/ConvUtils.h"
#endif
CViewDatabase::CViewDatabase(void) = default;
CViewDatabase::~CViewDatabase(void) = default;
bool CViewDatabase::Open()
{
return CDatabase::Open();
}
void CViewDatabase::CreateTables()
{
CLog::Log(LOGINFO, "create view table");
m_pDS->exec("CREATE TABLE view ("
"idView integer primary key,"
"window integer,"
"path text,"
"viewMode integer,"
"sortMethod integer,"
"sortOrder integer,"
"sortAttributes integer,"
"skin text)");
}
void CViewDatabase::CreateAnalytics()
{
CLog::Log(LOGINFO, "{} - creating indices", __FUNCTION__);
m_pDS->exec("CREATE INDEX idxViews ON view(path)");
m_pDS->exec("CREATE INDEX idxViewsWindow ON view(window)");
}
void CViewDatabase::UpdateTables(int version)
{
if (version < 4)
m_pDS->exec("alter table view add skin text");
if (version < 5)
{
// translate legacy videodb:// and musicdb:// paths
std::vector< std::pair<int, std::string> > paths;
if (m_pDS->query("SELECT idView, path FROM view"))
{
while (!m_pDS->eof())
{
std::string originalPath = m_pDS->fv(1).get_asString();
std::string path = originalPath;
if (StringUtils::StartsWithNoCase(path, "musicdb://"))
path = CLegacyPathTranslation::TranslateMusicDbPath(path);
else if (StringUtils::StartsWithNoCase(path, "videodb://"))
path = CLegacyPathTranslation::TranslateVideoDbPath(path);
if (!StringUtils::EqualsNoCase(path, originalPath))
paths.emplace_back(m_pDS->fv(0).get_asInt(), path);
m_pDS->next();
}
m_pDS->close();
for (std::vector< std::pair<int, std::string> >::const_iterator it = paths.begin(); it != paths.end(); ++it)
m_pDS->exec(PrepareSQL("UPDATE view SET path='%s' WHERE idView=%d", it->second.c_str(), it->first));
}
}
if (version < 6)
{
// convert the "path" table
m_pDS->exec("ALTER TABLE view RENAME TO tmp_view");
m_pDS->exec("CREATE TABLE view ("
"idView integer primary key,"
"window integer,"
"path text,"
"viewMode integer,"
"sortMethod integer,"
"sortOrder integer,"
"sortAttributes integer,"
"skin text)\n");
m_pDS->query("SELECT * FROM tmp_view");
while (!m_pDS->eof())
{
SortDescription sorting = SortUtils::TranslateOldSortMethod((SORT_METHOD)m_pDS->fv(4).get_asInt());
std::string sql = PrepareSQL("INSERT INTO view (idView, window, path, viewMode, sortMethod, sortOrder, sortAttributes, skin) VALUES (%i, %i, '%s', %i, %i, %i, %i, '%s')",
m_pDS->fv(0).get_asInt(), m_pDS->fv(1).get_asInt(), m_pDS->fv(2).get_asString().c_str(), m_pDS->fv(3).get_asInt(),
(int)sorting.sortBy, m_pDS->fv(5).get_asInt(), (int)sorting.sortAttributes, m_pDS->fv(6).get_asString().c_str());
m_pDS2->exec(sql);
m_pDS->next();
}
m_pDS->exec("DROP TABLE tmp_view");
}
}
bool CViewDatabase::GetViewState(const std::string &path, int window, CViewState &state, const std::string &skin)
{
try
{
if (nullptr == m_pDB)
return false;
if (nullptr == m_pDS)
return false;
std::string path1(path);
URIUtils::AddSlashAtEnd(path1);
if (path1.empty()) path1 = "root://";
std::string sql;
if (skin.empty())
sql = PrepareSQL("select * from view where window = %i and path='%s'", window, path1.c_str());
else
sql = PrepareSQL("select * from view where window = %i and path='%s' and skin='%s'", window, path1.c_str(), skin.c_str());
m_pDS->query(sql);
if (!m_pDS->eof())
{ // have some information
state.m_viewMode = m_pDS->fv("viewMode").get_asInt();
state.m_sortDescription.sortBy = (SortBy)m_pDS->fv("sortMethod").get_asInt();
state.m_sortDescription.sortOrder = (SortOrder)m_pDS->fv("sortOrder").get_asInt();
state.m_sortDescription.sortAttributes = (SortAttribute)m_pDS->fv("sortAttributes").get_asInt();
m_pDS->close();
return true;
}
m_pDS->close();
}
catch (...)
{
CLog::Log(LOGERROR, "{}, failed on path '{}'", __FUNCTION__, path);
}
return false;
}
bool CViewDatabase::SetViewState(const std::string &path, int window, const CViewState &state, const std::string &skin)
{
try
{
if (nullptr == m_pDB)
return false;
if (nullptr == m_pDS)
return false;
std::string path1(path);
URIUtils::AddSlashAtEnd(path1);
if (path1.empty()) path1 = "root://";
std::string sql = PrepareSQL("select idView from view where window = %i and path='%s' and skin='%s'", window, path1.c_str(), skin.c_str());
m_pDS->query(sql);
if (!m_pDS->eof())
{ // update the view
int idView = m_pDS->fv("idView").get_asInt();
m_pDS->close();
sql = PrepareSQL("update view set viewMode=%i,sortMethod=%i,sortOrder=%i,sortAttributes=%i where idView=%i",
state.m_viewMode, (int)state.m_sortDescription.sortBy, (int)state.m_sortDescription.sortOrder, (int)state.m_sortDescription.sortAttributes, idView);
m_pDS->exec(sql);
}
else
{ // add the view
m_pDS->close();
sql = PrepareSQL("insert into view (idView, path, window, viewMode, sortMethod, sortOrder, sortAttributes, skin) values(NULL, '%s', %i, %i, %i, %i, %i, '%s')",
path1.c_str(), window, state.m_viewMode, (int)state.m_sortDescription.sortBy, (int)state.m_sortDescription.sortOrder, (int)state.m_sortDescription.sortAttributes, skin.c_str());
m_pDS->exec(sql);
}
}
catch (...)
{
CLog::Log(LOGERROR, "{} failed on path '{}'", __FUNCTION__, path);
}
return true;
}
bool CViewDatabase::ClearViewStates(int windowID)
{
try
{
if (nullptr == m_pDB)
return false;
if (nullptr == m_pDS)
return false;
std::string sql = PrepareSQL("delete from view where window = %i", windowID);
m_pDS->exec(sql);
}
catch (...)
{
CLog::Log(LOGERROR, "{} failed on window '{}'", __FUNCTION__, windowID);
}
return true;
}
|
