-
Notifications
You must be signed in to change notification settings - Fork 0
/
Account.cpp
191 lines (163 loc) · 5.46 KB
/
Account.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
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
#include <QDebug>
#include <QMap>
#include <QSqlQuery>
#include <QUrlQuery>
#include "Account.h"
QString Account::AUTHORIZE_URL = "https://oauth.vk.com/authorize";
QString Account::CALLBACK_URL = "https://oauth.vk.com/blank.html";
QString Account::METHOD_URL = "https://api.vk.com/method";
QMap<QString, QString> Account::extractFragments(const QUrl &url) {
QStringList fragmentsList = url.fragment().split("&");
QMap<QString, QString> fragmentsMap;
for (int i = 0; i < fragmentsList.size(); ++i) {
QStringList fragment = fragmentsList[i].split("=");
fragmentsMap.insert(fragment.first(), fragment.last());
}
return fragmentsMap;
}
QUrl Account::authorizeUrl(const QString &appId, const QString &permissions) {
QUrlQuery params;
params.addQueryItem("client_id", appId);
params.addQueryItem("scope", permissions);
params.addQueryItem("redirect_uri", CALLBACK_URL);
params.addQueryItem("display", "page");
params.addQueryItem("response_type", "token");
QUrl url(AUTHORIZE_URL);
url.setQuery(params);
return url;
}
QUrl Account::authorizeUrl(const QString &appId, const QStringList &permissions) {
return authorizeUrl(appId, permissions.join(","));
}
QUrl Account::methodUrl(const QString& methodName) {
return QString("%1/%2").arg(METHOD_URL).arg(methodName);
}
bool Account::isCallbackUrl(const QUrl &url) {
QUrl callbackUrl(CALLBACK_URL);
return url.host() == callbackUrl.host() && url.path() == callbackUrl.path();
}
bool Account::isErrorCallback(const QUrl &url) {
return extractFragments(url).contains("error");
}
QString Account::extractErrorMessage(const QUrl& url) {
return extractFragments(url).value("error_description");
}
QString Account::extractToken(const QUrl &url) {
return extractFragments(url).value("access_token");
}
Account Account::create(const QString &accessToken, const QString &uid, int expirationPeriod) {
Account account(accessToken, uid, expirationPeriod);
if (!account.save()) {
// TODO I think exception will look pretty nice here, but Qt is against it... =(
}
return account;
}
Account Account::create(const QUrl &url) {
QMap<QString, QString> fragments = Account::extractFragments(url);
return create(fragments["access_token"], fragments["user_id"], fragments["expires_in"].toInt());
}
QList<Account> Account::list() {
QList<Account> accounts;
QSqlQuery query("SELECT id, access_token, uid, expiration_period FROM accounts");
while (query.next()) {
Account account = Account(query.value(0).toInt(), query.value(1).toString(), query.value(2).toString(), query.value(3).toInt());
accounts.append(account);
}
return accounts;
}
int Account::count() {
QSqlQuery query("SELECT count(*) FROM accounts");
if (query.next()) {
return query.value(0).toInt();
}
return 0; // just in case of some errors
}
int Account::lastId() {
QSqlQuery query;
query.prepare("SELECT seq FROM sqlite_sequence WHERE name = :table");
query.bindValue(":table", "accounts");
if (query.exec() && query.next()) {
return query.value(0).toInt();
}
return -1; // just in case of some errors
}
Account Account::find(int id) {
QSqlQuery query;
query.prepare("SELECT id, access_token, uid, expiration_period FROM accounts WHERE id = :id");
query.bindValue(":id", id);
if (query.exec() && query.next()) {
return Account(query.value(0).toInt(), query.value(1).toString(), query.value(2).toString(), query.value(3).toInt());
}
return Account(); // just in case of some errors
}
Account::Account(QObject *parent) : QObject(parent) {
this->id = -1;
this->accessToken = QString();
this->uid = QString();
this->expirationPeriod = -1;
}
Account::Account(const Account &account) : QObject(account.parent()) {
this->id = account.id;
this->accessToken = account.accessToken;
this->uid = account.uid;
this->expirationPeriod = account.expirationPeriod;
}
Account::Account(const QString &accessToken, const QString &uid, int expirationPeriod, QObject *parent) : QObject(parent) {
this->id = -1;
this->accessToken = accessToken;
this->uid = uid;
this->expirationPeriod = expirationPeriod;
}
Account::Account(int id, const QString &accessToken, const QString &uid, int expirationPeriod, QObject *parent) : QObject(parent) {
this->id = id;
this->accessToken = accessToken;
this->uid = uid;
this->expirationPeriod = expirationPeriod;
}
Account& Account::operator=(const Account &account) {
this->id = account.id;
this->accessToken = account.accessToken;
this->uid = account.uid;
this->expirationPeriod = account.expirationPeriod;
return *this;
}
bool Account::operator ==(const Account &account) const {
return id == account.id;
}
bool Account::save() {
QSqlQuery query;
query.prepare("INSERT INTO accounts(access_token, uid, expiration_period) VALUES (:access_token, :uid, :expiration_period)");
query.bindValue(":access_token", accessToken);
query.bindValue(":uid", uid);
query.bindValue(":expiration_period", expirationPeriod);
if (query.exec()) {
this->id = Account::lastId();
return true;
}
return false;
}
bool Account::destroy() {
QSqlQuery query;
query.prepare("DELETE FROM accounts WHERE id = :id");
query.bindValue(":id", id);
if (query.exec()) {
this->id = -1;
return true;
}
return false;
}
bool Account::isSaved() const {
return id > 0;
}
int Account::getId() const {
return id;
}
QString Account::getUid() const {
return uid;
}
void Account::setUid(const QString &uid) {
this->uid = uid;
}
QString Account::getAccessToken() const {
return accessToken;
}