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
|
#include "FbCacheBook.h"
#include "FbColumns.h"
#include "FbGenres.h"
#include "FbConst.h"
#include "FbParams.h"
#include "FbDateTime.h"
#include "FbCollection.h"
//-----------------------------------------------------------------------------
// FbCacheBook
//-----------------------------------------------------------------------------
IMPLEMENT_CLASS(FbCacheBook, wxObject)
FbCacheBook FbCacheBook::Get(int code, wxSQLite3Database & database)
{
wxSQLite3Statement stmt = database.PrepareStatement(GetSQL());
stmt.Bind(1, code);
wxSQLite3ResultSet result = stmt.ExecuteQuery();
if (result.NextRow())
return FbCacheBook(code, result);
else return 0;
}
FbCacheBook::FbCacheBook(int code)
: m_code(code)
, m_rate(0)
, m_date(0)
, m_size(0)
, m_down(0)
, m_gray(false)
, m_dltd(false)
{
}
FbCacheBook::FbCacheBook(const FbCacheBook &book)
: m_code(book.m_code)
, m_name(book.m_name)
, m_auth(book.m_auth)
, m_genr(book.m_genr)
, m_lang(book.m_lang)
, m_type(book.m_type)
, m_md5s(book.m_md5s)
, m_rate(book.m_rate)
, m_date(book.m_date)
, m_size(book.m_size)
, m_down(book.m_down)
, m_gray(book.m_gray)
, m_dltd(book.m_dltd)
{
}
FbCacheBook & FbCacheBook::operator =(const FbCacheBook &book)
{
m_code = book.m_code;
m_name = book.m_name;
m_auth = book.m_auth;
m_genr = book.m_genr;
m_lang = book.m_lang;
m_type = book.m_type;
m_md5s = book.m_md5s;
m_rate = book.m_rate;
m_date = book.m_date;
m_size = book.m_size;
m_down = book.m_down;
m_gray = book.m_gray;
m_dltd = book.m_dltd;
return *this;
}
wxString FbCacheBook::GetSQL()
{
return wxT("\
SELECT DISTINCT \
books.title, books.file_size, books.file_type, books.lang, books.genres, \
books.md5sum, states.rating, states.download, books.created, AGGREGATE(authors.full_name) as full_name, \
CASE WHEN books.id>0 AND (download IS NULL OR download<100) THEN 1 ELSE 0 END AS gray, books.deleted \
FROM books \
LEFT JOIN authors ON books.id_author = authors.id \
LEFT JOIN states ON books.md5sum=states.md5sum \
WHERE books.id=? \
GROUP BY books.title, books.file_size, books.file_type, books.lang, states.rating, books.created \
LIMIT 1 \
");
}
FbCacheBook::FbCacheBook(int code, wxSQLite3ResultSet &result)
: m_code(code)
, m_name(result.GetString(0))
, m_auth(result.GetString(9))
, m_genr(result.GetString(4))
, m_lang(result.GetString(3))
, m_type(result.GetString(2))
, m_md5s(result.GetString(5))
, m_rate(result.GetInt( 6))
, m_date(result.GetInt( 8))
, m_size(result.GetInt( 1))
, m_down(result.GetInt( 7))
, m_gray(result.GetInt(10))
, m_dltd(result.GetInt(11))
{
}
wxString FbCacheBook::GetValue(size_t field) const
{
switch (field) {
case BF_CODE: return wxString::Format(wxT("%d"), m_code);
case BF_NAME: return m_name;
case BF_NUMB: return wxEmptyString;
case BF_AUTH: return m_auth;
case BF_GENR: return FbGenres::DecodeList(m_genr);
case BF_RATE: return m_rate ? GetRatingText(m_rate) : wxString();
case BF_LANG: return m_lang;
case BF_TYPE: return m_type;
case BF_DATE: return m_date ? FbDateTime(m_date).FormatDate() : wxString();
case BF_SIZE: return FbCollection::Format(m_size / 1024);
case BF_BITE: return FbCollection::Format(m_size);
case BF_SEQN: return wxEmptyString;
case BF_MD5S: return m_md5s;
case BF_DOWN: return m_down > 100 ? FbDateTime(m_down).FormatDate() : wxString();
default: return wxEmptyString;
}
}
bool FbCacheBook::IsDeleted() const
{
return m_dltd;
}
bool FbCacheBook::IsGray() const
{
return m_gray && FbParams(FB_GRAY_FONT);
}
#include <wx/arrimpl.cpp>
WX_DEFINE_OBJARRAY(FbCasheBookArray);
|
