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
|
/*********************************************************************************
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.
***********************************************************************************/
#ifndef SEARCHTABLE_H
#define SEARCHTABLE_H
#include "global.h"
#include <iostream>
#include <string>
#include <stdio.h>
#include <QSqlTableModel>
#include <QtSql>
#include <QString>
#include "sql/databaseconnection.h"
using namespace std;
#define SEARCH_GUID 2000
#define SEARCH_NAME 2001
#define SEARCH_UPDATE_SEQUENCE_NUMBER 2003
#define SEARCH_ISDIRTY 2004
#define SEARCH_FORMAT 2005
#define SEARCH_QUERY 2006
#define SEARCH_ISDELETED 2007
#define SEARCH_LID_POSITION 0
#define SEARCH_NAME_POSITION 1
class SearchTable
{
private:
DatabaseConnection *db;
public:
SearchTable(DatabaseConnection *db); // Constructor
qint32 getLid(QString guid); // given a guid, return the lid
qint32 getLid(string guid); // Given a guid, return the lid
qint32 findByName(string &name); // Find a record given a name
qint32 findByName(QString &name); // Find a record given a name
qint32 getAllDirty(QList<qint32>&lids); // get all dirty lids
bool get(SavedSearch &search, qint32 lid); // Get a record given a lid
bool get(SavedSearch &search, QString guid); // get a record given a guid
bool get(SavedSearch &search, string guid); // get a record given a guid
bool isDirty(qint32 lid); // Check if a record is dirty
bool isDirty(QString guid); // Check if a record is dirty
bool isDirty(string guid); // Check if a record is dirty
bool exists(qint32 lid); // Does this record exist?
bool exists(QString guid); // Does this record exist?
bool exists(string guid); // Does this record exist?
bool isDeleted(qint32 lid); // Is this search marked for deletion?
QString getGuid(qint32 lid); // Get the GUID for a searcht
void getAll(QList<qint32> &lids); // Get a list of all search LIDs.
// DB Write Functions
void updateGuid(qint32 lid, Guid &guid); // Update a record's guid
void sync(SavedSearch &search); // Sync a record
void sync(qint32 lid, SavedSearch &search); // Sync a record
void add(qint32 lid, SavedSearch &t, bool isDirty); // Add a new record
bool update(qint32 lid, SavedSearch &s, bool isDirty); // Update an existing saved search
void deleteSearch(qint32 lid); // Mark a search as deleted
void expunge(qint32 lid); // Erase a search
void expunge(QString guid); // Erase a search
void expunge(string guid); // Erase a search
void setDirty(qint32 lid, bool dirty); // Set a search as needing to be synchronized
void setUpdateSequenceNumber(qint32 lid, qint32 usn); // Set the update sequence number for a search
};
#endif // SEARCHTABLE_H
|
