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
|
/*
* Copyright (C) 2020, KylinSoft Co., Ltd.
*
* 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 3 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, see <https://www.gnu.org/licenses/>.
*/
#include "uNoteDbusServer.h"
UNoteDbusServer::UNoteDbusServer()
{
}
QVariantMap UNoteDbusServer::keywordMatch(QStringList keyList)
{
QVariantMap keyMap;
qDebug() << keyList.count();
QString sql;
if(keyList.count() >= 1) {
sql = QStringLiteral("SELECT id, md_content, full_title FROM active_notes WHERE md_content LIKE '%%1%'").arg(keyList.at(0));
for(int i = 1; i < keyList.count(); i++) {
QString tmpSql = QStringLiteral(" AND md_content LIKE '%%1%'").arg(keyList.at(i));
sql.append(tmpSql);
}
}
qDebug() << sql <<QSqlDatabase::drivers();
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(QDir::homePath() + "/.config/kylin-note/kyNotes.db");
if(!db.open()){
//如果数据库打开失败
qWarning() << "error!" << db.lastError().text();
}
QSqlQuery query;
if(query.exec(sql)) {
while(query.next()){
qDebug() << "Dat:::" << query.value(0).toString() << query.value(1).toString() << query.value(2).toString();
QVariantList content;
content << query.value(1).toString().mid(query.value(1).toString().indexOf(keyList.at(0)), 20) << query.value(2).toString();
qDebug() << "Dat###" << query.value(1).toString().mid(query.value(1).toString().indexOf(keyList.at(0)), 20);
QVariant var = QVariant::fromValue<QVariantList>(content);
keyMap.insert(query.value(0).toString(), var);
}
}
qDebug() << keyMap;
return keyMap;
}
QMap<QString, QVariant> UNoteDbusServer::loadSqlDB()
{
qDebug() << QSqlDatabase::drivers();
QVariantMap keyMap;
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(QDir::homePath() + "/.config/kylin-note/kyNotes.db");
if(!db.open()){
//如果数据库打开失败
qWarning() << "error!" << db.lastError();
}
QSqlQuery query;
if(query.exec("SELECT id, md_content FROM active_notes")) {
while(query.next()){
keyMap.insert(query.value(0).toString(), query.value(1));
qDebug() << query.value(0).toString() << query.value(1).toString();
}
}
return keyMap;
}
//增加一个读取所有的接口
bool UNoteDbusServer::exportAllNotes(QList<Note> &data)
{
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(QDir::homePath() + "/.config/kylin-note/kyNotes.db");
if(!db.open()){
//如果数据库打开失败
qWarning() << "error!" << db.lastError().text();
return false;
}
QString sql = QString("SELECT id, modification_date, md_content FROM active_notes");
QSqlQuery query;
if(query.exec(sql)) {
while(query.next()){
int id = query.value(0).toInt();
time_t modTime = query.value(1).toInt();
QString content = query.value(2).toString();
qDebug() << id << modTime << content;
Note note;
note.id = id;
note.editTime = modTime;
note.noteText = content;
data.push_back(note);
}
}
return true;
}
|
