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
|
/*********************************************************************************
NixNote - An open-source client for the Evernote service.
Copyright (C) 2013 Randy Baumgarte
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 "datastore.h"
#include <QtSql>
#include <QString>
#include <QList>
#include "configstore.h"
#include "searchtable.h"
#include "tagtable.h"
#include "notebooktable.h"
#include "global.h"
#include "sql/nsqlquery.h"
extern Global global;
#define GUID 1;
#define DIRTY_RECORD 2;
#define ORIGINAL_GID 3;
#define UPDATE_SEQUENCE_NUMBER 4;
DataStore::DataStore(DatabaseConnection *db)
{
this->db = db;
db->lockForRead();
// Check if the table exists. If not, create it.
NSqlQuery sql(db);
sql.exec("Select * from sqlite_master where type='table' and name='DataStore';");
if (!sql.next()) {
db->unlock();
this->createTable();
}
this->setTable("DataStore");
this->select();
this->setEditStrategy(QSqlTableModel::OnFieldChange);
sql.finish();
db->unlock();
}
//* Create the NoteTable table.
void DataStore::createTable() {
db->lockForWrite();
QLOG_TRACE() << "Entering DataStore::createTable()";
QLOG_DEBUG() << "Creating table DataStore";
NSqlQuery sql(db);
QString command("Create table DataStore (" +
QString("lid integer,") +
QString("key integer,") +
QString("data blob default null collate nocase)"));
if (!sql.exec(command)) {
QLOG_ERROR() << "Creation of DataStore table failed: " << sql.lastError();
}
sql.exec("CREATE INDEX DataStore_Lid on DataStore (lid)");
sql.exec("CREATE INDEX DataStore_Key on DataStore (key)");
sql.prepare("Create view SearchModel as select lid, data as name from DataStore where key=2001");
if (!sql.exec()) {
QLOG_ERROR() << "Creation of SearchModel table failed: " << sql.lastError();
}
sql.prepare("Create View TagModel as select a.lid, (select d.data from DataStore d where d.key=1000 and a.lid = d.lid) as guid, (select data from datastore b1 where b1.lid = (select b.data from DataStore b where b.key=1002 and a.lid = b.lid)) as parent_gid, (select c.data from DataStore c where c.key=1001 and a.lid = c.lid) as name, (select e.data from DataStore e where e.key=1006 and a.lid = e.lid) as account from DataStore a where a.key=1000;");
if (!sql.exec()) {
QLOG_ERROR() << "Creation of TagModel table failed: " << sql.lastError();
}
sql.prepare("Create View NotebookModel as select a.lid, (select b.data from DataStore b where b.key=3002 and a.lid = b.lid) as stack, (select c.data from DataStore c where c.key=3001 and a.lid = c.lid) as name, (select d.data from DataStore d where d.key=3201 and a.lid = d.lid) as username, (select e.data from DataStore e where e.key=3999 and a.lid = e.lid) as isClosed from DataStore a where a.key=3000;");
if (!sql.exec()) {
QLOG_ERROR() << "Creation of NotebookModel table failed: " << sql.lastError();
}
if (!sql.exec("Create virtual table SearchIndex using fts4 (lid int, weight int, source text, content text)")) {
QLOG_ERROR() << "Creation of SearchIndex table failed: " << sql.lastError();
}
sql.finish();
db->unlock();
Notebook notebook;
NotebookTable table(db);
notebook.name = "My Notebook";
notebook.defaultNotebook = true;
QUuid uuid;
notebook.guid = uuid.createUuid().toString().replace("{","").replace("}","");
table.add(0,notebook,true,false);
}
|
